|MySQL error 1267 when adding a linux system
|Page 1 of 1|
|Author:||aylnews [ Wed Jun 15, 2011 6:54 pm ]|
|Post subject:||MySQL error 1267 when adding a linux system|
I have installed beta 1.1 on a windows 7 machine and successfully audited my domain, brilliant. However when I try to audit a linux machine it does not appear. When I manually copy the audit_linux generated xml .txt file into the add system form I come up with a 1267 collation error; see attached for system information and a screen shot of the error.
the sql statement is:-
SELECT sys_hw_bios.bios_id FROM sys_hw_bios, system WHERE sys_hw_bios.system_id = system.system_id AND '1042' = system.system_id AND system.man_status = 'production' AND 'VirtualBox' = bios_description AND 'innotek GmbH' = bios_manufacturer AND '0' = bios_serial AND '1.2' = bios_smversion AND 'VirtualBox' = bios_version AND ( '0000-00-00 00:00:00' = sys_hw_bios.timestamp OR '' = sys_hw_bios.timestamp) LIMIT 1
It appears to be falling over on the empty datetime string at the end of the sql statement. If I manually run the query and change round the last statement e.g. sys_hw_bios.timestamp = '' or alternatively change it to be _latin1'' = sys_hw_bios.timestamp the query then works. I have tried changing the collation on the table but does not seem to make a difference.
I am running Windows 7 SP1 using IIS and PHP 5.3.6 and MySQL 5.5.13.
Any help would be greatly appreciated.
|Page 1 of 1||All times are UTC + 10 hours|
|Powered by phpBB® Forum Software © phpBB Group