New Table Error

Author	« Topic »
Marshall Ecommerce Template Guru USA 1875 Posts	Posted - 12/12/2019 : 13:58:26 This just started happening. Any help would be appreciated. PHP v7.0.7 The error is appearing even though there is no increcentview include. www[dot]grabbarspecialists[dot]com/proddetail.php?prod=LIBERTY-5616 Table './grabbars_new/recentlyviewed' is marked as crashed and should be repairedTable './grabbars_new/recentlyviewed' is marked as crashed and should be repaired Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/grabbars/public_html/vsadmin/inc/incfunctions.php on line 1803 Table './grabbars_new/recentlyviewed' is marked as crashed and should be repaired Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/grabbars/public_html/vsadmin/inc/incfunctions.php on line 1812 Table './grabbars_new/recentlyviewed' is marked as crashed and should be repaired Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/grabbars/public_html/vsadmin/inc/incfunctions.php on line 1803 Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/grabbars/public_html/vsadmin/inc/incfunctions.php on line 1812 Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com Edited by - Marshall on 12/12/2019 14:48:49
Vince Administrator 42474 Posts	Posted - 12/12/2019 : 15:11:11 Hi Marshall You can sort this in phpMyAdmin by clicking on the table then go to operations -> operations and choose the repair table option. Or ask your host if not. The incproddetail.php script will write to that table if the parameter $recentlyviewed is set. Maybe in the meantime remove that parameter from the includes.php file. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
Marshall Ecommerce Template Guru USA 1875 Posts	Posted - 12/12/2019 : 16:45:18 Thanks Vince. I will check into that. Any idea why this happened without warning? First time in all my years I have seen this. FOLLOW UP It is not giving me the repair table option. It shows this error Notice in ./tbl_operations.php#463 Undefined offset: 0 Backtrace Thoughts? Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com Edited by - Marshall on 12/12/2019 19:31:07
Vince Administrator 42474 Posts	Posted - 12/13/2019 : 00:53:39 Hi Marshall Then I would just DROP the table in phpMyAdmin and run the updatestore.php script again from the latest updater. That table just holds products that were recently viewed by a customer so it won't be that big a deal to start again with a new empty one. I really don't know the cause of the problem but in case it was a problem with the hard drive I would run this by the host so they can check it. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
Marshall Ecommerce Template Guru USA 1875 Posts	Posted - 12/13/2019 : 05:24:40 You know I never claimed to be a SQL expert, but I did notice that when you expand the recentviewed menu, it only shows 'columns' where all the others show 'columns' and 'indexes'. I will take you advice to fix it. Thanks Vince. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
	« Topic »