Hesk Upgrade Issue

[Steviebdotnet]

Hi,

I'm just upgrading my copy of hesk, and when I confirm my database info I get the following error:

Code: Select all

Can't execute SQL

Please notify webmaster at support@domain.com

I know 100% that the DB info is correct. Feel free to drop me an e-mail and I will send the url and details to you for investigation.

Cheers

Steve

[Klemen]

What version are you upgrading from?

Enable debug mode in your hesk before upgrading and see what error you get then.

[Steviebdotnet]

I have no idea what version I'm afraid. I know it was the latest one before v2 was released.

The error message now reads:

Code: Select all

Can't execute SQL: CREATE TABLE `hesk_attachments` ( `att_id` mediumint(8) unsigned NOT NULL auto_increment, `ticket_id` varchar(10) NOT NULL default '', `saved_name` varchar(255) NOT NULL default '', `real_name` varchar(255) NOT NULL default '', `size` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`att_id`), KEY `ticket_id` (`ticket_id`) ) ENGINE=MyISAM

MySQL said:
Table 'hesk_attachments' already exists

Please notify webmaster at support@domain.com

[Klemen]

Seems like a problem because previously version wasn't upgraded properly.

Try opening your hesk_settings.inc.php file (the on on your server!) and change
$hesk_settings['hesk_version']='0.94';
to
$hesk_settings['hesk_version']='0.94.1';

Then see if it works

[Steviebdotnet]

That did the trick, thanks.

[hansiii]

Hi,
I just tried to update from version 0941 to 2.0,
and I got two problems:

1) When I came to step 4, removed the install-folder,
and clicked the continue-button I got this:
- - - - -
Code:
Can't execute SQL
Please notify webmaster at:
- - - - -

2) I tried to log in to the admin area,
but the password (that I know is correct) was not accepted!

How to fix this???

Thanks in advance!

[Klemen]

You did check the setting mentioned above?

Password didn't work because a new way of storing passwords is used in 2.0 and you still have the old one if upgrade didn't work.

Post a link to your phpinfo file (you will find it in the "READ THIS BEFORE POSTING A QUESTION" topic) and to your Hesk script so we can have a look. Also double-check that the hesk_settings.inc.php file is writable by PHP.

[hansiii]

Hi,
Thank you for the prompt reply. Impressive!

Yes - I checked and tried the above setting, didn't work.

Well, since I couldn't get it to work - I've reinstalled version 0941.
It's been so long since I've installed this - and had it customized to fit
the template I amusing on the site, that I couldn't have it 'non-working'.

I've got it installed here:
http://www.hansfredrik.no/helpdesk
and it has been working perfectly! Couldn't be more satisfied with it,
and the feedback I've gotten from those of my customers that has used it, has been nothing BUT positive!

But I simply cannot pay for another customisation of it...
Nor do I remember which files I had to edit...

[Klemen]

Since I don't know what has been customized it's possible the database has been customized as well and that is causing the problems?

[hansiii]

I don't think so. If I remember it correctly, it was just customisation so that it was fitted and was displayed right with the current template.

I need to ask the one who did the work, if he can remember if he made any changes to the DB, but like I said, I don't think so...

UPDATE:
He hadn't made any changes to the database

[Poi]

Hi,

I'm upgrading Hesk 0.94 to hesk 2.0,

everything is going well until step 4.

I keep getting the "Can't execute SQL " message.

I've tried the steps above and i even tried upgrading my Hesk 0.94 to hesk 0.94.1 and that evens gives me the message: Can't execute SQL.

Any other things i can try??

[Poi]

I'm now getting this:

Can't execute SQL: CREATE TABLE `hesk_attachments` ( `att_id` mediumint( 8 ) unsigned NOT NULL auto_increment, `ticket_id` varchar(10) NOT NULL default '', `saved_name` varchar(255) NOT NULL default '', `real_name` varchar(255) NOT NULL default '', `size` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`att_id`), KEY `ticket_id` (`ticket_id`) ) ENGINE=MyISAM

MySQL said:
Table 'hesk_attachments' already exists

I've tried change this settings:
$hesk_settings['hesk_version']='0.94';
to
$hesk_settings['hesk_version']='0.94.1';

But it still doesn't want to work.

I Need help....

[Poi]

I think I've found my problem.

What version of mySQL does Hesk 2.0 need?

i'm running version 4.

[Klemen]

Poi: you're getting an error because (like the error says) you already have a "hesk_attachments" table in your database. This is probably because the update script thinks you are upgrading from 0.94 where in fact your old version is 0.94.1.

Are you sure you were using the "Upgrade existing install" option and not the "New install" one?

To avoid complications you can try opening install/update.php file in a text editor and deleting lines 279 - 414. That is everything from

Code: Select all

if ($hesk_settings['hesk_version'] != '0.94.1')

to including

Code: Select all

} // END if version NOT 0.94.1

then close all browser windows and run the update script again.

[Poi]

HI,

I solved my problem by installing it onto a new database, it didn't want to work on the old database.

thanx for your help.