<div dir="ltr"><div><div>HI All,<br><br></div>  Iam using syslog-ng3.2.5  rpm in centos x86_64 environment.Past days it is  working well.Suddenly iam seeing a problem in writing to mysql<br><br>Error running SQL query; type=&#39;mysql&#39;, host=&#39;192.168.9.68&#39;, port=&#39;3306&#39;, user=&#39;cygnet&#39;, database=&#39;CygNetDB&#39;, error=&#39;1072: Key column \&#39;date\&#39; doesn\&#39;t exist in table&#39;, query=&#39;CREATE INDEX SYSLOGS_20131130_date_idx ON SYSLOGS_20131130 (date)&#39;<br>
<br>Error adding missing index; table=&#39;SYSLOGS_20131130&#39;, column=&#39;date&#39;<br><br>Error running SQL query; type=&#39;mysql&#39;, host=&#39;192.168.9.68&#39;, port=&#39;3306&#39;, user=&#39;cygnet&#39;, database=&#39;CygNetDB&#39;, error=&#39;1170: BLOB/TEXT column \&#39;facility\&#39; used in key specification without a key length&#39;, query=&#39;CREATE INDEX SYSLOGS_20131130_facility_idx ON SYSLOGS_20131130 (facility)&#39;<br>
<br>Error adding missing index; table=&#39;SYSLOGS_20131130&#39;, column=&#39;facility&#39;<br><br></div>                                                                                     vijay<br></div>