RE: [Phpgroupware-users] sessions erno error

[The Emilsons]

Thank you as well for your much kinder response that my post allowed,
for a brief time you are a better man than me , sorry to be a pain, and
thank you for the tremendous support you a=have tried to offer me over
the last few months

Viking NetWerkz
Unix Web Hosting and Design Services
Viking NetWerkz Your Next Site!
http://www.vikingnetwerkz.com
 

-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Dave Hall
Sent: August 22, 2003 5:20 PM
To: address@hidden
Subject: Re: [Phpgroupware-users] sessions erno error

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
> 

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 14/08/2003
 
    

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 14/08/2003