Re: [Phpgroupware-users] sessions erno error

[R B]

G'day,
   YOu need you learn to use the database tool that
you have (I assume MySQL). You can export the table
structure out to a file using sqldump or similar. That
will give you a file (SQL code) to recreate the table.
   There are at least 3 levels which errors can occur:
1. hardware (disk, memory, etc)
2. database 
3. applications

   From the look at this, my suspect is in the
database (MYSQL), not PhpGrouwpare (read the links
below).

Check this out:
http://forums.devshed.com/t10604/s.html
http://faq.ozoneasylum.com/896/rating/


      
 --- Chris Weiss <address@hidden> wrote: > you
should consider running some hardware tests on
> memory and harddisk.  It's not
> possible for any app to create an SQL statement that
> an corrupt a table, that has to
> happen at the system level.
> 
> 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 rebuild
> >this 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))
> >
> >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 each
> >time, 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
> >
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
>
http://mail.gnu.org/mailman/listinfo/phpgroupware-users 

http://search.yahoo.com.au - Yahoo! Search
- Looking for more? Try the new Yahoo! Search