Database Error to update MFH 3.0.7 to 3.1.1

Forum dedicated to Mods for HESK created by Mike Koch

Moderator: mkoch227

Post Reply
hrian
Posts: 5
Joined: Wed Oct 25, 2017 4:44 pm

Database Error to update MFH 3.0.7 to 3.1.1

Post by hrian »

Hi,
I'm trying to update mod for hesk, I correctly upated the last version of hesk, and trying to run update process,
but when installaer start, I have this mesage:
Could not execute query: ALTER TABLE `hesk_logging` ADD COLUMN `stack_trace` TEXT. MySQL said: Table 'support_db.hesk_logging' doesn't exist

I tryed to do something, But can't understand which change have to do in hesk after update to activate this table.

Pls can you help me
mkoch227
Posts: 666
Joined: Wed Jul 04, 2012 3:37 pm

Re: Database Error to update MFH 3.0.7 to 3.1.1

Post by mkoch227 »

The hesk_logging table was introduced back in Mods for HESK 2.6.0, so it sounds like you're missing at least one table.

Go to http(s)://<path to your helpdesk>/install/mods-for-hesk/modsForHesk.php and then click the "Validate Database" button. Report the results of the validator here.
Mike, Lead Developer of Image HESK: A surprisingly simple, user-friendly and FREE help desk software with integrated knowledgebase.
hrian
Posts: 5
Joined: Wed Oct 25, 2017 4:44 pm

Re: Database Error to update MFH 3.0.7 to 3.1.1

Post by hrian »

Hi,
I tryed to validate the database like your counsil, but don't closed the procedure, and now I have:
Error:

Can't execute SQL

Actually also if restore old files, databse is corrupt, I have to retore backup.
https://ibb.co/iXmXi6
https://ibb.co/jnkgbR
mkoch227
Posts: 666
Joined: Wed Jul 04, 2012 3:37 pm

Re: Database Error to update MFH 3.0.7 to 3.1.1

Post by mkoch227 »

Is 2.6.0 the only section that fails? I didn't see any screenshots showing everything after that.
Mike, Lead Developer of Image HESK: A surprisingly simple, user-friendly and FREE help desk software with integrated knowledgebase.
hrian
Posts: 5
Joined: Wed Oct 25, 2017 4:44 pm

Re: Database Error to update MFH 3.0.7 to 3.1.1

Post by hrian »

From 2.6 to the end is all ko
mkoch227
Posts: 666
Joined: Wed Jul 04, 2012 3:37 pm

Re: Database Error to update MFH 3.0.7 to 3.1.1

Post by mkoch227 »

Try selecting "2.5.5" as your current Mods for HESK version and then click "Upgrade". Of course have a backup on hand if things don't work properly ;)
Mike, Lead Developer of Image HESK: A surprisingly simple, user-friendly and FREE help desk software with integrated knowledgebase.
hrian
Posts: 5
Joined: Wed Oct 25, 2017 4:44 pm

Re: Database Error to update MFH 3.0.7 to 3.1.1

Post by hrian »

Hi, it didn't working,
I sente by private message link of installation, you can try I having backups.
It strage sometime I can close to 2.6.4, sometime no.
hrian
Posts: 5
Joined: Wed Oct 25, 2017 4:44 pm

Re: Database Error to update MFH 3.0.7 to 3.1.1

Post by hrian »

Hi I sent private message,
please help me, I have aproduction support site down from monday.
They are devils....
Post Reply