Fatal error: ERROR: Could not insert all templates. - Page 2

virtualp · 19-02-2007, 04:00 PM

I fully understand the issues with ftp. Although I'm a newbie with kayako. I've been a Unix/Linux administrator for 22 years. The files were uploaded to the server using sftp with no conversion -- as binary files. Once on the server they were tar -xvzf.

Tar is not perfect but it does report issues with a corrupt tar formatted file.

There has to be another explanation for this issue. I've been running kayako for 6 months for 3 different domains with different backends -- on the same system. Never had any issues other than the usual bugs. The reason for my upgrade.

Xeserve · **Fatal error: ERROR: Could not insert all templates. -** 01-03-2007, 08:59 PM

Fatal error: ERROR: Could not insert all templates. - in /home/yaho2/public_html/support/setup/steps/upgrade_step3.php on line 38

I receive that error when attempting to upgrade from 3.04 to 3.10

supportskins · 01-03-2007, 09:02 PM

Try re-uploading all the files and re-running the upgrade script. Should work.

Xeserve · 01-03-2007, 09:20 PM

I've re-uploaded all the files several times and I've re-ran the upgrade script several times as well except I continue to receive the error

Xeserve · 01-03-2007, 09:26 PM

This is what displays at first:

Altering table customfields: (# Of Queries: 1) FAILED
Reason: Duplicate column name 'description'
Altering table chatobjects: (# Of Queries: 1) FAILED
Altering table ticketstatus: (# Of Queries: 1) FAILED
Updating data in ticketstatus: (# Of Queries: 1) FAILED
Version: 3.04.50 (Page 1 of 1)

Trevor · 01-03-2007, 10:18 PM

Have you looked at the database to see if it is correct about there being a Duplicate column, If there is i would advise you delete one and see if that reloves your issue.

Xeserve · 01-03-2007, 10:34 PM

Well, there are 133 tables. I did a search for 'description' but thats like finding a needle in a haystack.

**bear** · 01-03-2007, 10:45 PM

Quote:

Altering table customfields: (# Of Queries: 1) FAILED
Reason: Duplicate column name 'description'

That would be the name of the table right there, I believe.

Xeserve · 01-03-2007, 10:58 PM

Well this is what I found,

http://img114.imageshack.us/img114/9933/screen01eo9.jpg

What do you think?

Xeserve · 01-03-2007, 11:02 PM

That picture was for 4 match(es) inside table swtemplatedata

However there is 1 match(es) inside table swtemplates

The name of the table is 'customfields' so I don't believe there are multiple tables.

Trevor · 01-03-2007, 11:05 PM

I dont think your looking in the correct place. If you want to provide me with your login information i can take a look for you. My information is in my profile, if not then i suggest you send a ticket to kayako and they will be able to help.

**bear** · 01-03-2007, 11:29 PM

Not to cast any aspersions here, but you really shouldn't give out your cpanel information to just anyone that asks. Up to the member, but it's not a great idea, typically. Kayako staff, your own support people, no worries. Someone who is not Kayako staff is probably not the best idea.
(moderators, testers and skinners are mostly not staff)

Demo92 · **SupportSuite Installation Problems -** 03-03-2007, 06:50 PM

I successfully installed SupportSuite V. 3.10.00 on my OS X machine. However, once I get to the "License Agreement" setup step I cannot see the "I Agree" button I am supposed to click on in order to go forward with the process. Why can't I see the "I Agree" button?

supportskins · 03-03-2007, 07:46 PM

Check your server error_log for any reported errors.

Demo92 · 03-03-2007, 08:01 PM

This was in my error log:

[Sat Mar 3 12:14:32 2007] [error] PHP Parse error: syntax error, unexpected '}' in /Library/WebServer/Documents/SupportSuite/setup/includes/footer.php on line 118

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

Xeserve Offline Member Posts: 53 Join Date: Apr 2006	Fatal error: ERROR: Could not insert all templates. - 01-03-2007, 08:59 PM Fatal error: ERROR: Could not insert all templates. - in /home/yaho2/public_html/support/setup/steps/upgrade_step3.php on line 38 I receive that error when attempting to upgrade from 3.04 to 3.10

supportskins Offline Senior Member Posts: 5,232 Join Date: Aug 2006 Location: Mumbai, India	01-03-2007, 09:02 PM Try re-uploading all the files and re-running the upgrade script. Should work. Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support Our Skins and Services - http://www.supportskins.com/store/ - NEW SKIN ADDED!! SupportSkins.com - http://www.supportskins.com/

Xeserve Offline Member Posts: 53 Join Date: Apr 2006	01-03-2007, 09:20 PM I've re-uploaded all the files several times and I've re-ran the upgrade script several times as well except I continue to receive the error

Xeserve Offline Member Posts: 53 Join Date: Apr 2006	01-03-2007, 09:26 PM This is what displays at first: Altering table customfields: (# Of Queries: 1) FAILED Reason: Duplicate column name 'description' Altering table chatobjects: (# Of Queries: 1) FAILED Altering table ticketstatus: (# Of Queries: 1) FAILED Updating data in ticketstatus: (# Of Queries: 1) FAILED Version: 3.04.50 (Page 1 of 1)

Trevor Offline Member Posts: 34 Join Date: Nov 2006 Location: England, UK	01-03-2007, 10:18 PM Have you looked at the database to see if it is correct about there being a Duplicate column, If there is i would advise you delete one and see if that reloves your issue. Trevor Robinson Key4ce

Xeserve Offline Member Posts: 53 Join Date: Apr 2006	01-03-2007, 10:34 PM Well, there are 133 tables. I did a search for 'description' but thats like finding a needle in a haystack.

Xeserve Offline Member Posts: 53 Join Date: Apr 2006	01-03-2007, 10:58 PM Well this is what I found, http://img114.imageshack.us/img114/9933/screen01eo9.jpg What do you think?

Xeserve Offline Member Posts: 53 Join Date: Apr 2006	01-03-2007, 11:02 PM That picture was for 4 match(es) inside table swtemplatedata However there is 1 match(es) inside table swtemplates The name of the table is 'customfields' so I don't believe there are multiple tables.

Trevor Offline Member Posts: 34 Join Date: Nov 2006 Location: England, UK	01-03-2007, 11:05 PM I dont think your looking in the correct place. If you want to provide me with your login information i can take a look for you. My information is in my profile, if not then i suggest you send a ticket to kayako and they will be able to help. Trevor Robinson Key4ce

bear Offline Community Moderator Posts: 730 Join Date: Jan 2005	01-03-2007, 11:29 PM Not to cast any aspersions here, but you really shouldn't give out your cpanel information to just anyone that asks. Up to the member, but it's not a great idea, typically. Kayako staff, your own support people, no worries. Someone who is not Kayako staff is probably not the best idea. (moderators, testers and skinners are mostly not staff) ...read me...

Demo92 Offline New Member Posts: 8 Join Date: Mar 2007	SupportSuite Installation Problems - 03-03-2007, 06:50 PM I successfully installed SupportSuite V. 3.10.00 on my OS X machine. However, once I get to the "License Agreement" setup step I cannot see the "I Agree" button I am supposed to click on in order to go forward with the process. Why can't I see the "I Agree" button?

supportskins Offline Senior Member Posts: 5,232 Join Date: Aug 2006 Location: Mumbai, India	03-03-2007, 07:46 PM Check your server error_log for any reported errors. Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support Our Skins and Services - http://www.supportskins.com/store/ - NEW SKIN ADDED!! SupportSkins.com - http://www.supportskins.com/

Demo92 Offline New Member Posts: 8 Join Date: Mar 2007	03-03-2007, 08:01 PM This was in my error log: [Sat Mar 3 12:14:32 2007] [error] PHP Parse error: syntax error, unexpected '}' in /Library/WebServer/Documents/SupportSuite/setup/includes/footer.php on line 118