Re: [Phpgroupware-users] sessions erno error

[Dave Hall]

The Emilsons <address@hidden> wrote:

> 
> 
> Ok this is the third time I have had this, and I am frustrated for it
> dletes the entire sessions table, I have no knowledge of how to 
> rebuildthis table without losing everything,
> Please help me with this one
> 
> Database error: Invalid SQL: select content from phpgw_app_sessions
> where sessionid = '0' and loginid = '0' and app = 'phpgwapi' and
> location = 'config'
> MySQL Error: 1016 (Can't open file: 'phpgw_app_sessions.MYI'. (errno:
> 145))

Looks like your database is corrupt.  Try to remove that table, and
recreate it ... dump the structure in phpmyadmin or using DESCRIBE
TABLE.  This may point to more serious problems with the database.  Make
regular back ups, which are named differently, you may need them.



> 
> File: /home/viking/public_html/office/phpgwapi/inc/functions.inc.php
> Line: 656
> Session halted.
> Fatal error: Call to a member function on a non-object in
> /home/viking/public_html/office/phpgwapi/inc/class.db_mysql.inc.php on
> line 568
> 
> 
> 
> When I view phpmyadmin on that table I see this:
> 
> Can't open file: 'phpgw_app_sessions.MYI'. (errno: 145) 
> 
> Error
> 
> SQL-query :  
> 
> SHOW KEYS FROM `phpgw_app_sessions` 
> 
> MySQL said: 
> 
> 
> Can't open file: 'phpgw_app_sessions.MYI'. (errno: 145)
> Back
> 
> 
> 
> This is like ive said the third times it happened, ive reinstalled 
> eachtime, but I cant keep doing this, what is causing this major 
> error?Anyone please? How do I get back that table??
> 
> 
> Regards:(
> 
> 
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>