Page 1 of 1

[Solved] Fatal error

Posted: Thu Aug 04, 2016 8:05 pm
by jwu
I got error while access my website, please advise how to fix.... tq

Code: Select all

Fatal error: Uncaught exception 'ErrorException' with message 'Error: Table 'oc_customer_online' is marked as crashed and should be repaired<br />Error No: 1194<br />DELETE FROM `oc_customer_online` WHERE (UNIX_TIMESTAMP(`date_added`) + 3600) < UNIX_TIMESTAMP(NOW())' in /home/centuryp/public_html/system/database/mysqli.php:41 Stack trace: #0 /home/centuryp/public_html/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('DELETE FROM `oc...') #1 /home/centuryp/public_html/catalog/model/tool/online.php(4): DB->query('DELETE FROM `oc...') #2 /home/centuryp/public_html/vqmod/vqcache/vq2-catalog_controller_common_footer.php(318): ModelToolOnline->whosonline('113.212.126.108', NULL, 'http://centuryp...', '') #3 /home/centuryp/public_html/vqmod/vqcache/vq2-system_engine_controller.php(43): ControllerCommonFooter->index(Array) #4 /home/centuryp/public_html/vqmod/vqcache/vq2-system_engine_controller.php(169): Controller->getChild('common/footer') #5 /home/centuryp/public_html/catalog/controller/error/not_found.php(69): Con in /home/centuryp/public_html/system/database/mysqli.php on line 41

Re: Fatal error

Posted: Thu Aug 04, 2016 8:19 pm
by straightlight
Followed are instructions from Stackoverflow on how to repair a table: http://stackoverflow.com/questions/2296 ... phpmyadmin . Take note that repairing a table can also be done via PHPMyAdmin:
To repair MySQL database tables, follow these steps:
Log in to cPanel. ...
In the Databases section of the cPanel home screen, click phpMyAdmin. ...
In the left pane, click the name of the database that you want to work on. ...
In the right pane, select the check boxes for the tables in the database that you want to repair.
Source: Google

Re: Fatal error

Posted: Fri Aug 05, 2016 3:48 pm
by jwu
it works, the website work fine now... many thanks for your advise and guideline... very appreciated, thank you ;D