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

I got error while access my website, please advise how to fix.... tq
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 Fri Aug 05, 2016 6:56 pm, edited 2 times in total.
Reason: Added quote 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

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer


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 1 guest