List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 26 1999 5:11pm
Subject:Re: MySQL "Invalid SQL" error - (with PHP)
View as plain text  
Shawn Bernard wrote:
> 
> I am using PHPLIB v6.1 with MySQL and sometimes when I am on my site,
> I get the following error:
> 
> --------------------------------------
> Database error: Invalid SQL: delete from active_sessions where changed <
> '19990722212812'
> and name = 'CF_Session'
> MySQL Error: 1034 (Wrong key file for table: 'active_sessions'. Try to
> repair it)
> Session halted.
> --------------------------------------
> 
> When you refresh the page, the error disappears and the page comes up
> just fine.
> 
> Has anyone seen this before?  I thought that it might have been a
> proxy error, but I am getting it at home through my dialup account,
> too, and several other people have reported the same error to me.
> 
> Any ideas?
> 
> Shawn
> 

Run isamchk -r  on your table.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
MySQL "Invalid SQL" error - (with PHP)Shawn Bernard25 Jul
  • Re: MySQL "Invalid SQL" error - (with PHP)Sasha Pachev26 Jul