Cannot export to MySQL db the results

Dec 12, 2014 at 12:57 PM
Edited Dec 12, 2014 at 12:58 PM
> A database operation failed.

________________________________________________

Application:    WinAudit Freeware v3.0.11
Error Type: Application
Error Number:   0x20000007
Location:   Odbc::ExecDirect
Details:    SQLExecDirect

[MySQL][ODBC 5.3(w) Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Table 'winaudit.COMPUTER_MASTER' doesn't exist
SQL State: 42S02
Native Error: 1146

________________________________

Error Number: -1 [SQL_ERROR].

SQL:
SELECT Computer_ID FROM COMPUTER_MASTER WHERE (MAC_ADDRESS) = ('00:1d:60:1f:7c:0b')
I made the database with the program itself. The queries are fine.
For example:
Date:   2014.12.12. 14:56:10
Rows:   0
SQL:
SELECT Computer_Master.Computer_Name, Audit_Data.Item_12 AS Processor, Audit_Data.Item_13 AS Memory_MB, Audit_Data.Item_14 AS Size_Bytes, Audit_Data.Item_15 AS Display FROM Computer_Master INNER JOIN Audit_Data ON Computer_Master.Last_Audit_ID = Audit_Data.Audit_ID WHERE Audit_Data.Category_ID = 300 ORDER BY ( Computer_Master.Computer_Name )
It seems at export it want to use full capitalized letters, even from command prompt.
Coordinator
Dec 12, 2014 at 2:41 PM
Hi Kaoraku,

On Ubuntu identifier names are case sensitive unlike on Windows which is the focus of WinAudit. See:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

For a solution see:
http://stackoverflow.com/questions/6134006/are-table-names-in-mysql-case-sensitive

Basically you need to set lower_case_table_names = 1 in the ini file, restart the server and try again.
Marked as answer by Kaoraku on 12/12/2014 at 11:44 PM
Dec 13, 2014 at 6:44 AM
Thank you for the fast answer, and the problem is solved.