By srlinuxx on

I got hacked last week and had to restore a backup. Everything seemed to be back to normal except I've discovered my referrers isn't logging (being stored in database - the apache logging still works). I reckon it's cuz the rows and columns for those entries probably didn't get restored (correctly). I never got the syntax for dump and restore, and just used cp of a backup tarball.

My (many) errors read as follows:

user error: Got error 127 from table handler query: SELECT url, MAX(timestamp) AS last_hit, COUNT(url) AS hits FROM accesslog WHERE url LIKE '%www.tuxmachines.org%' GROUP BY url ORDER BY hits DESC LIMIT 0, 50 in /usr/local/apache2/htdocs/includes/database.mysql.inc on line 125.

and:

warning: mysql_query(): Unable to save result set in /usr/local/apache2/htdocs/includes/database.mysql.inc on line 108.

I can barely do anything in mysql, I can barely SHOW DATABASES;. I find the docs hard to follow and understand. So, could someone please help me like I was a 5 year old? I imagine these particular entries are fairly standard across the 4.5.2 installs. I'd sure appeciate it.

tia,
-susan

Comments

ezheidtmann’s picture

ezheidtmann commented

Google search for 'mysql error 127' seems to show that you should use the REPAIR TABLE command.

srlinuxx’s picture

srlinuxx commented

Thanks so much. I feel so silly not having searched google first, but I thought it was something drupal specific. Thanks, REPAIR TABLE did it. woo hoo. :D

Thanks again.

--You talk the talk, but do you waddle the waddle?

kbahey’s picture

kbahey commented

If your host uses Cpanel, there may be an option to repair the database from there.
--
Consulting: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba