error 127 #1030 select from subquery

[dtra]

hi all, i'm getting this strange error
doesn't seem to be a lot on google in english about it

#1030 got error 127 from storage engine

running mysql 4.1.7 with php 4.3.9, on apache 2

the query looks pretty straighforward to me

  SELECT user_ID FROM urban_userlog 
  		WHERE (TO_DAYS(NOW()) - TO_DAYS(user_SignUpDate)) > 30 
  		AND user_ID IN (SELECT sessiontrack_UserID FROM trackuser_sessiontrack 
  		WHERE DATE(sessiontrack_StartDateTime) = '2005-01-05')

it's actually just this one table, trackuser_sessiontrack
that seems to be having problems now, it was fine before
but joins, and subqueries don't seem to be working anymore

any help
thanks
dave

[r937]

have you checked the table?

http://dev.mysql.com/doc/mysql/en/Check.html

[dtra]

i'll have a go in phpmyadmin
thanks