Hi everyone, i got a problem when deleting an album, gallery3 keeping holding on it, and the system crashed: some modules stop working.
the error log:
2012-05-29 13:57:36 +08:00 --- error: Database_Exception [ 44 ]: #1194: Table 'items' is marked as crashed and should be repaired [ SELECT `items`.*
FROM `items`
WHERE `parent_id` = '1528'
ORDER BY `created` ASC, `id` ASC ]
/home/wwwroot/shareboxer/public_html/system/libraries/Database_Mysqli_Result.php [ 27 ]
#0 /home/wwwroot/shareboxer/public_html/system/libraries/Database_Mysqli.php(79): Database_Mysqli_Result_Core->__construct(false, 'SELECT `items`....', Object(mysqli), true)
#1 /home/wwwroot/shareboxer/public_html/system/libraries/Database.php(272): Database_Mysqli_Core->query_execute('SELECT `items`....')
#2 /home/wwwroot/shareboxer/public_html/modules/gallery/libraries/MY_Database.php(45): Database_Core->query('SELECT `items`....')
#3 /home/wwwroot/shareboxer/public_html/system/libraries/Database_Builder.php(973): Database->query('SELECT `items`....')
#4 /home/wwwroot/shareboxer/public_html/system/libraries/ORM.php(1471): Database_Builder_Core->execute(Object(Database_Mysqli))
#5 /home/wwwroot/shareboxer/public_html/system/libraries/ORM.php(690): ORM_Core->load_result(true)
#6 /home/wwwroot/shareboxer/public_html/modules/gallery/libraries/ORM_MPTT.php(179): ORM_Core->find_all(NULL, NULL)
#7 /home/wwwroot/shareboxer/public_html/modules/gallery/models/item.php(712): ORM_MPTT_Core->children(NULL, NULL, Array, Array)
#8 /home/wwwroot/shareboxer/public_html/modules/gallery/libraries/ORM_MPTT.php(89): Item_Model_Core->children()
#9 /home/wwwroot/shareboxer/public_html/modules/gallery/models/item.php(97): ORM_MPTT_Core->delete()
#10 /home/wwwroot/shareboxer/public_html/modules/gallery/controllers/quick.php(105): Item_Model_Core->delete()
#11 [internal function]: Quick_Controller->delete('1528')
#12 /home/wwwroot/shareboxer/public_html/system/core/Kohana.php(331): ReflectionMethod->invokeArgs(Object(Quick_Controller), Array)
#13 /home/wwwroot/shareboxer/public_html/system/core/Event.php(208): Kohana_Core::instance(NULL)
#14 /home/wwwroot/shareboxer/public_html/application/Bootstrap.php(67): Event_Core::run(Array, Array)
#15 /home/wwwroot/shareboxer/public_html/index.php(103): require('/home/wwwroot/s...')
#16 {main}
Can anybody help? 
Posted: Tue, 2012-05-29 07:09
Posts: 17
The error information:
Database_Exception [ Database Error ]:
#1194: Table 'items' is marked as crashed and should be repaired [ SELECT `items`.* FROM `items` WHERE `type` = 'photo' ORDER BY `created` DESC LIMIT 10 ]
SYSPATH/libraries/Database_Mysqli_Result.php[ 27 ]
22 }
23 elseif (is_bool($result))
24 {
25 if ($result == FALSE)
26 {
27 throw new Database_Exception('#:errno: :error [ :query ]',
28 array(':error' => $link->error,
29 ':query' => $sql,
30 ':errno' => $link->errno));
31 }
32 else
Posts: 17
I've just click repair button in phpadmin, fortunately gallery3 is now working again.