Post by jwu » Thu Aug 04, 2016 8:05 pm

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
Last edited by straightlight on Sat May 30, 2020 8:21 am, edited 3 times in total.
Reason: Added code tags.

jwu
Newbie

Posts

Joined
Thu Aug 04, 2016 8:01 pm

Post by straightlight » Thu Aug 04, 2016 8:19 pm

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

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by jwu » Fri Aug 05, 2016 3:48 pm

it works, the website work fine now... many thanks for your advise and guideline... very appreciated, thank you ;D

jwu
Newbie

Posts

Joined
Thu Aug 04, 2016 8:01 pm
Who is online

Users browsing this forum: No registered users and 67 guests