Invalid SQL: INSERT INTO `swauditlogs` ERROR

[kevintufts]

When ever someone creates a support ticket, there is an error that appears at the bottom of the page.

Invalid SQL: INSERT INTO `swauditlogs` (`ticketid`, `staffid`, `departmentid`, `userid`, `dateline`, `logtype`, `actiontype`, `actionmsg`) VALUES ('910', '', '5', '375', '1174073315', '5', '14','Setting Due Time To: Mar 17 2007 11:28 AM'),('910', '', '5', '375', '1174073315', '3', '11','New Ticket Created By test'); (Table 'swauditlogs' is marked as crashed and should be repaired)

However, there are no issues with creating the tickets, they seem to go through fine. But what can be done to eliminate this issue or what exactly is it?

Thank you

[dotboost]

go in admin panel, database --> repair/optimize , click on repair button from swauditlogs table, or better click on bottom 'repair all' button.

[lak]

i am getting a similar same error when people create new tickets and I did the dbase repair BUT that did not FIX the issue.

Can someone please help out with this issue and actually give a resolution?

here is the error I get:

Invalid SQL: INSERT INTO `swauditlogs` (`ticketid`, `staffid`, `departmentid`, `userid`, `dateline`, `logtype`, `actiontype`, `actionmsg`) VALUES ('11', '', '1', '1', '1201136956', '5', '14','Setting due time to: 24 Jan 2008 03:09 PM'),('11', '', '1', '1', '1201136956', '3', '11','New ticket created by John Doe'); (Incorrect integer value: '' for column 'staffid' at row 1)

[craigbrass]

What version are you running?

[lak]

3.11.01 Stable

[supportskins]

Open your MySQL config file - my.cnf and set:

sql-mode = ""

Once that is done, restart your MySQL server and it should fix the issue.