Hesk reply

[Jonaed123]

Script URL:
Version of script:
Hosting company: local host
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below: I am facing trouble while replying my customer in the Hesk. it is showing:
Error
Can't execute SQL

Please notify webmaster at: myemail@gmail.com
it was fine before.

[Klemen]

Go to Admin > Settings > Help desk and under Features turn Debug mode on then save changes.

What does the error message say then?

[Jonaed123]

this message is showing:

Error
Can't execute SQL: INSERT INTO `hesk_replies` (`replyto`,`name`,`message`,`message_html`,`dt`,`attachments`,`staffid`) VALUES ('62','Md Jonaed','working on it','working on it',NOW(),'','1')

MySQL said:
Index for table 'hesk_replies' is corrupt; try to repair it


WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.

[Klemen]

As the error says, your MySQL table hesk_replies is corrupt.

This can happen for various reasons, perhaps a random error or perhaps your server is too busy and can't handle everything (this happens more often on shared hosts that host many websites on the same server).

You will need to repair the table:
1. login to your web hosting control panel (not Hesk)
2. find a tool called phpMyAdmin
3. find your hesk database and the hesk_replies table
4. on the "Operations" tab find the "Repair table" link and use it

[Jonaed123]

I tried to repair it but still no working. That particular data table is showing " in use". would you please, help me on this though it is not a hesk problem.

[Klemen]

A few things you can try (at your own risk):

1. try the myisamchk utlitiy in command line, it should be in your mysql "bin" folder

Code: Select all

myisamchk --safe-recover hesk_replies

Before running it you will need to change directory to your MySQL "data/HESK_DATABASE_NAME" folder. Not sure what you use, but for example on Windows (change path to your own specific path of course):

Code: Select all

cd C:\wamp\bin\mysql\mysql8.0.3\data\hesk

2. another thing to try is in phpMyAdmin:
- export hesk_replies table in SQL
- confirm that export is OK
- delete the hesk_replies table
- create the table back by importing the SQL

3. you can also try restarting mysql or the entire server

4. last but not least, I hope you have backups?

[Jonaed123]

Thank you. Problem is solved. I have installed the hesk in another server and export the hesk_replies from it then replaced it in my existing database. now it is working perfectly.