referers stopped working

nevermind, i didn't have log refferers enabled, not sure what happened there

referers stopped working

this doesn't seem to have worked, i ran the query in phpmyadmin's query window.

is the is there anything else i can try?

referers stopped working

In this case you need ask your webhost to restart the MySQL server. I don't know if this works on any Linux version, but at least under Debian the server is checking all InnoDB tables after every restart.

Another workaround is recreating the tables by running the following two SQL queries:

DROP TABLE esselbach_st_referer;

CREATE TABLE esselbach_st_referer (

                referer_id int(11) NOT NULL auto_increment,

                referer_website int(2) default '1',

                referer_ref varchar(200) default '',

                referer_date datetime default NULL,

                referer_hits int(11) default '0',

                PRIMARY KEY (referer_id)

                );

However, the will delete all existing referrers.

referers stopped working

both (?) is that not meant to happen?

the refferer table is innoDB.

referers stopped working

That means that the table definitely crashed. Are your tables using MyISAM or InnoDB?

referers stopped working

no, i can't access the data

referers stopped working

Sounds like a crashed esselbach_st_referer table. Can you access the data in this table in phpMyAdmin?