help please

[Yusif]

Script URL: http://icq-chat.com/helpdesk
Version of script: 2.7.1

Hi all, one of my friends tried to do updated the hesk, its seems ok now but somehow the table of hesk_reply_drafts not found and we can't reply to any ticket, what we should do now to get that table back in DB ?

please help with full details how to do it step-by-step, thanks all

[Klemen]

Update instructions are in the docs, a copy is here
https://www.hesk.com/demo/docs/step-by- ... ml#upgrade

If database wasn't updated then probably the install/update script wasn't run?

My recommendation would be to:
1. restore backup before update (you do have it, right?)
2. perform the update again and make 100% sure you follow instructions precisely.

[Yusif]

thanks klemen for reply

this problem fixed by creating table

but now i got another one ,, when users try to submit ticket they ger error :
ERROR: Can't execute SQL
Please notify webmaster at admin@email

how to fix this ??

[Klemen]

You didn't fix the problem. Your database isn't upgraded and modified to 2.7.1 version, you probably have version 2.5.x or older. This means a lot of things in your database are probably wrong.

The only supported way of upgrading is to use the steps in the documentation. Restore from backup and upgrade as instructed, then should work fine.

[Klemen]

You can also try:

1. delete/revert any changes you did manually to the database, like manually creating hesk_reply_drafts
2. try uploading the "install" folder again and running the update script from the browser (yourhelpdesk/install)

If that doesn't work, you will need to proceed as suggested before.

[mkoch227]

Klemen, it also looks like OP is running Mods for HESK 3.0.0 RC 1, looking at the version tags on some of the CSS files (I append the Mods for HESK build number at the end of the stylesheets using a basic query string (?v=33 in this case)).

Yusif, follow Klemen's instructions on updating to HESK 2.7.1 from your latest backup, and then install Mods for HESK 3.0.0 RC 1 via the Mods for HESK installation instructions at https://mods-for-hesk.mkochcs.com. If you continue to receive errors, enable debug mode in your helpdesk settings so the failing SQL query is displayed.