Failing to create staff

jp.ogorman · 04:56 PM

Hello,

I am just after installing and everything when good. I have created new departments but when I create "Insert Staff" it acts like the staff is created but the "Dashboard" >> Staff >> Manage page only shows up one Administrator account which is me. The newly created staff member is nowhere to be found. There are no errors appearing.

Have I missed something?
Thanks,
JP

supportskins · 04-07-2007, 11:29 PM

Which version of PHP are you using?

jp.ogorman · 05-07-2007, 07:44 AM

Hi,

I'm using ...

PHP Version 4.4.7

System Windows NT DINADAN 5.2 build 3790
Build Date May 4 2007 13:29:21
Server API ISAPI
Virtual Directory Support enabled
Configuration File (php.ini)
Path C:\WINDOWS\php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20050606
Debug Build no
Zend Memory Manager enabled
Thread Safety enabled
Registered PHP Streams php, http, ftp, compress.zlib

jp.ogorman · 05-07-2007, 08:41 AM

Also, when I logout and enter choose "Support Center" >> "Submit a ticket" I get the following error...

Invalid SQL: INSERT INTO `swauditlogs` (`ticketid`, `staffid`, `departmentid`, `userid`, `dateline`, `logtype`, `actiontype`, `actionmsg`) VALUES ('2', '', '3', '3', '1183617424', '5', '14','Setting Due Time To: 06 Jul 2007 08:37 AM'),('2', '', '3', '3', '1183617424', '3', '11','New Ticket Created By JP'); (Out of range value adjusted for column 'staffid' at row 1)

I need to figure out what is going wrong urgently. We are going live shortly.

craigbrass · 05-07-2007, 10:46 AM

Whats your eSupport version and also your MySQL version?

jp.ogorman · 05-07-2007, 11:47 AM

Product: eSupport
Version: 3.10.02
Build Date: 05 Mar 2007 01:15:24 AM
Build Type: STABLE
PHP Version: 4.4.7
Max Upload Size: 2M
Safe Mode: No
MySQL Version: 3.23.49
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4
Server Software: Microsoft-IIS/6.0
Operating System: WINNT

craigbrass · 05-07-2007, 12:19 PM

I think it may be to do with your MySQL being on v3 but may be wrong.

My advice would be to submit a ticket at http://support.kayako.com linking to this thread and detailing FTP details and admin area details so they can trace this issue.

supportskins · 05-07-2007, 01:37 PM

It is a MySQL issue. You can fix the issue by editing your /etc/my.cnf file and change sql-mode to something like:

sql-mode=""

OR

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Once changed, it should fix the issue.

jp.ogorman · 11-07-2007, 02:46 PM

I upgraded MySQL. Thanks.JP

supportskins · 11-07-2007, 03:00 PM

Glad to know the issue is fixed

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
Create a "Tools" dropdown in Staff area	richm	Wont Implement / Already Implemented	1	12-05-2007 03:03 AM
Filter department list when create new ticket in staff cp	Gigaflesh	SupportSuite, eSupport and LiveResponse	1	13-02-2007 09:32 AM
DUE TIME not getting if we create a send email ticket in staff even in trial!!!!!!!!	vineethshyam	SupportSuite, eSupport and LiveResponse	1	28-11-2006 04:26 AM
Create ticket views specifically for STAFF	NC Software	Wont Implement / Already Implemented	5	15-06-2006 12:32 AM

supportskins Offline Senior Member Posts: 3,851 Join Date: Aug 2006 Location: Mumbai, India	04-07-2007, 11:29 PM Which version of PHP are you using? 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/

craigbrass Offline Senior Member Posts: 5,748 Join Date: Jun 2005 Location: Cumbria, UK	05-07-2007, 10:46 AM Whats your eSupport version and also your MySQL version? Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

jp.ogorman Offline New Member Posts: 7 Join Date: Jul 2007	05-07-2007, 11:47 AM Product: eSupport Version: 3.10.02 Build Date: 05 Mar 2007 01:15:24 AM Build Type: STABLE PHP Version: 4.4.7 Max Upload Size: 2M Safe Mode: No MySQL Version: 3.23.49 User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4 Server Software: Microsoft-IIS/6.0 Operating System: WINNT

craigbrass Offline Senior Member Posts: 5,748 Join Date: Jun 2005 Location: Cumbria, UK	05-07-2007, 12:19 PM I think it may be to do with your MySQL being on v3 but may be wrong. My advice would be to submit a ticket at http://support.kayako.com linking to this thread and detailing FTP details and admin area details so they can trace this issue. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

jp.ogorman Offline New Member Posts: 7 Join Date: Jul 2007	11-07-2007, 02:46 PM I upgraded MySQL. Thanks.JP

supportskins Offline Senior Member Posts: 3,851 Join Date: Aug 2006 Location: Mumbai, India	11-07-2007, 03:00 PM Glad to know the issue is fixed 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/