New ticket error

aliensx · **New ticket error -** 30-03-2008, 03:59 PM

Hello,

I am getting this error when trying to post a new ticket:

Invalid SQL: INSERT INTO `swusers` (`usergroupid`, `fullname`, `userpassword`, `userpasswordtxt`, `dateline`, `lastvisit`, `lastactivity`, `enabled`, `loginapi_moduleid`, `loginapi_userid`, `languageid`, `timezoneoffset`, `enabledst`, `useremailcount`, `allowemail`, `ismanager`) VALUES ('2', 'test testy', '8e6d85aa6d4128cd681b2056a3ac2e3e', '8519a391', '1206903303', '0', '0', '1', '1', '0', '0', '', '0', '1', '1', '0'); (Unknown column 'ismanager' in 'field list')

Anyone any idea on how to fix this?

Thank you

craigbrass · 30-03-2008, 04:16 PM

Is this after you upgraded? If so, did you run the upgrade script afterwards (/setup/ -> Upgrade)?

aliensx · 30-03-2008, 06:07 PM

Nope... not after an upgrade. I migrated to a different server and everything else seems to be working fine except for NEW TICKETS.

aliensx · 05-04-2008, 01:57 PM

Any idea anyone?

supportskins · 05-04-2008, 03:05 PM

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.

aliensx · 05-04-2008, 05:23 PM

I am on a shared server and have not access to do that and the hosting company doesn't want to do it either.

Any other way this could be solved?

supportskins · 05-04-2008, 07:30 PM

Not that I know of. Create a ticket with Kayako Support, their developers can provide you with a fix. You can create a ticket from the Members Area at https://members.kayako.net

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
unexpected error	nadia	LiveResponse Desktop Application	3	21-06-2007 06:04 PM
New Build: 3.10.02 STABLE	Ryan Lederman	News and Announcements	0	05-03-2007 09:53 PM
connection problem	inteltechs	InstaAlert	5	27-04-2006 01:23 AM

craigbrass Offline Senior Member Posts: 5,753 Join Date: Jun 2005 Location: Cumbria, UK	30-03-2008, 04:16 PM Is this after you upgraded? If so, did you run the upgrade script afterwards (/setup/ -> Upgrade)? Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

aliensx Offline Member Posts: 58 Join Date: Aug 2003	30-03-2008, 06:07 PM Nope... not after an upgrade. I migrated to a different server and everything else seems to be working fine except for NEW TICKETS.

aliensx Offline Member Posts: 58 Join Date: Aug 2003	05-04-2008, 01:57 PM Any idea anyone?

supportskins Offline Senior Member Posts: 3,852 Join Date: Aug 2006 Location: Mumbai, India	05-04-2008, 03:05 PM 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/

aliensx Offline Member Posts: 58 Join Date: Aug 2003	05-04-2008, 05:23 PM I am on a shared server and have not access to do that and the hosting company doesn't want to do it either. Any other way this could be solved?