HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Event Viewer Error


#1

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
Description:
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 http://www.mysql.com.


#2

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


#3

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.


#4

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:


#5

No super large attachments found.


#6

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.


#7

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.


#8

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


#9

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.


#10

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


#11

Ah, nice detective work!

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


#12

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:

REPAIR TABLE “HS_Errors”;

That should fix it.


#13

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

It SHOULD be:

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
REPAIR TABLE HS_Errors
It just hung at command prompt with a - type of prompt

Table still messed up. :slight_smile:


#14

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


#15

still hangs after entering as just
repair table hs_errors
OR
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)


#16

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

REPAIR TABLE hs_errors;


#17

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

:wink: