Page 1 of 1

Error when Upgrading from 0.94 to 2.0 - Can't execute SQL

Posted: Sun Jul 05, 2009 10:05 pm
by TechJammer
Script URL: http://www.hansfredrik.no/helpdesk
Version of script: 2.0
Hosting company: GoDaddy
URL of phpinfo.php: http://www.articlesonline.ws/phpinfo.php
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
- Can't execute SQL
- php 5.2.5
- mysql 5.0.18

Write your message below:

When I try tp upgrade the script, I get all the way to step 4 and then receive the error "Can't execute SQL". All previous steps pass testing.

I verified DEBUG is active in the hdesk script, but I don't see any detailed information about the error. I'm sure the DB access information is correct, because the site was working at version 0.94 with the same settings.

Are there any compatibility issues with the PHP or MySQL versions I am using (listed above), or possibly a compatibility problem which is unique to GoDaddy hosting?

Thanks!

Posted: Mon Jul 06, 2009 6:16 am
by Klemen
The problem is most likely that you actually have version 0.94.1 and not 0.94. Download your hesk_settings.inc.php file and change

Code: Select all

$hesk_settings['hesk_version']='0.94';
to

Code: Select all

$hesk_settings['hesk_version']='0.94.1';
Then upload the modified settings file, close all browser windows and try to upgrade again.

SQL Error

Posted: Mon Jul 06, 2009 10:34 pm
by TechJammer
Thanks Klemen,

I'll try this out and let you know how it works...

Fixed

Posted: Sat Jul 25, 2009 11:16 pm
by TechJammer
I changed the setting above, and the upgrade completed successfully! Sorry it took so long to get this completed!

Best Wishes, and Thanks!