Re: Got error 124 from storage engine

[Colleen Dick]

I am having similar:

This query works:

SELECT users.id, loginName FROM users, ga WHERE users.id=ga.userId and ga.gId IN (3,4,5,6,7,8,9) ORDER BY dateJoined DESC;

When I put a subselect instead of the hardcoded set,

SELECT DISTINCT gId FROM ga WHERE userId=9

I get error 124

Windoze XP MySQL 5.0.3