HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Event Viewer Error


This error is popping up pretty much all day every day… I just noticed:

Event Type: Error
Event Source: MySQL
Event Category: None
Event ID: 100
Date: 8/29/2008
Time: 3:43:25 AM
User: N/A
Computer: DATA
C:\Program Files\helpspot\mysql\bin\mysqld-nt.exe: Table ‘.\helpspot_db\hs_errors’ is marked as crashed and should be repaired

For more information, see Help and Support Center at


HELP?! New tickets are not coming in via email, all of the sudden… is this related to my error noted above?


Hi Chad,

It looks like the HS_errors table has crashed. Perhaps other tables have crashed as well and need repair. In HelpSpot go to Admin->Tools->System Information.

Near the bottom is a list of all the tables in the database. Post back which ones do not say myisam in front of them. HS_Errors won’t, let me know if others don’t.

What version of HelpSpot are you running? The emails coming in could also be a stuck email. Check for any very large file attachments on any of the emails in the box.


HS_errors is the only one.

And wow, I just manually added the exchange box for the Support Ticket email and I’ve been missing emails since early August. Wow. Bummer. :wink:


No super large attachments found.


By manually added do you mean manually ran? If so perhaps it’s a problem with the rules that run tasks.php?

If you’re on windows check the scheduled tasks to make sure the HelpSpot ones are running.


tasks.php was not running until now. but now it is running, and i still have the problem with emails not turning into tickets. ugh, this is bad… what do you recommend?

i am on windows 2003 server, helpspot latest build.


i mean manually added to my outlook profile… just opened up the exchange mailbox on my local machine.


So, the smtp virtual server on my Exchange box was turned off.

That’ll do it. Unreal. Maybe an applied update turned it off when I ran Microsoft updates or something. Silly. Just silly.


so, how do we repair that table? :open_mouth:


Ah, nice detective work!

OK I’ll get the command to fix the table and post it back here in a bit.


To repair you need to go to the dos prompt

Next CD to the mysql/bin directory of HelpSpot

You need to login to mysql with: mysql.exe -u -p <your_mysql_password>

You can find the user and password in config.php which is in helpspot/helpspot/

Once logged in do:

use ;

Again you can find the db name in config.php

Finally run this command:


That should fix it.


Ah, after a few errors, I found a chink in the armor of your command line.


Mysql.exe –u -p

The command prompts for a password… I kept getting access denied, and I was confused… then upon closer inspection, the access had been denied to database <your_mysql_password>… so that first command line should be user and database name… then enter password when prompted…

Anyway, another error after I got that figured out. After entering
Use <helpspot_db>, then
It just hung at command prompt with a - type of prompt

Table still messed up. :slight_smile:


Hmm, I think the problem with my login was that the -p needs to actually touch the password. Like: -pPassword

Try REPAIR TABLE hs_errors and try REPAIR TABLE hs_errors


still hangs after entering as just
repair table hs_errors
repair table ‘hs_errors’

I let it sit there and think about it for a bit, still just looks like this
mysql> REPAIR TABLE ‘hs_errors’
– > _ (cursor)


Oh, duh. You need a ; at the end of the statement. Like this:

REPAIR TABLE hs_errors;


| Table | Op | Msg_type | Msg_text |
| helpspot_db.hs_errors | repair | status | OK |
1 row in set (2.28 sec)