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

[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!

[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.

[TechJammer]

Thanks Klemen,

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

[TechJammer]

I changed the setting above, and the upgrade completed successfully! Sorry it took so long to get this completed!

Best Wishes, and Thanks!