search

rsyslog / loganalyzer

Adiscon LogAnalyzer, a web frontend to log data from the same folks the created rsyslog
Other
76 stars 39 forks source link

mysql error: Field 'Trunscate' doesn't have a default value #53

Closed vsc55 closed 4 years ago

vsc55 commented 4 years ago

Hi, When trying to create a new field this error occurs:

Database error: Invalid SQL: INSERT INTO logcon_fields (FieldID, FieldCaption, FieldDefine, SearchField, FieldAlign, DefaultWidth, FieldType, SearchOnline) VALUES ( 'Prueba', 'Nombre', 'SYSLOG_', 'FiltroBusqueda', 'center', 50, 0, false )
mysql error: Field 'Trunscate' doesn't have a default value
mysql error number: 1364
Date: 07.05.2020 @ 16:18
Script: /admin/fields.php
Referer: http://www/admin/fields.php?op=add
vsc55 commented 4 years ago

Other related errors:

Database error: Invalid SQL: INSERT INTO logcon_fields (FieldID, FieldCaption, FieldDefine, SearchField, FieldAlign, DefaultWidth, FieldType, SearchOnline) VALUES ( 'net_host', 'Hostname', 'SYSLOG_NET_HOST', 'net_host', 'left', 100, 0, 0 )
mysql error: Field 'Trunscate' doesn't have a default value
mysql error number: 1364
Date: 07.05.2020 @ 18:47
Script: /admin/parsers.php?op=initparser&id=wireless
Referer: http://www/admin/parsers.php

It is repeated several times.

Fix in pull #54