Kayako logo
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  (#1) Old
kevintufts Offline
New Member
 
kevintufts's Avatar
 
Posts: 4
Join Date: Jan 2007
Location: Cleveland, Ohio
Invalid SQL: INSERT INTO `swauditlogs` ERROR - 16-03-2007, 04:26 PM

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
   
Reply With Quote
  (#2) Old
dotboost Offline
New Member
 
Posts: 18
Join Date: Apr 2006
16-03-2007, 09:54 PM

go in admin panel, database --> repair/optimize , click on repair button from swauditlogs table, or better click on bottom 'repair all' button.
   
Reply With Quote
  (#3) Old
lak Offline
New Member
 
Posts: 29
Join Date: Mar 2007
i am getting same error - 23-01-2008, 08:16 PM

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)

Last edited by lak; 23-01-2008 at 08:36 PM.
   
Reply With Quote
  (#4) Old
craigbrass Offline
Senior Member
 
Posts: 5,325
Join Date: Jun 2005
Location: Cumbria, UK
23-01-2008, 08:56 PM

What version are you running?


Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member)

Icon Headquarters - Its Elixir - Web2Messenger
   
Reply With Quote
  (#5) Old
lak Offline
New Member
 
Posts: 29
Join Date: Mar 2007
version - 23-01-2008, 09:09 PM

3.11.01 Stable
   
Reply With Quote
  (#6) Old
supportskins Offline
Senior Member
 
supportskins's Avatar
 
Posts: 3,533
Join Date: Aug 2006
Location: Mumbai, India
24-01-2008, 08:30 AM

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.



Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support
Our Skins and Services - http://www.supportskins.com/store/
SupportSkins.com - http://www.supportskins.com/
   
Reply With Quote
Reply

Tags
insert, invalid, sql, `swauditlogs`

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vBulletin Skin developed by: vBStyles.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46