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

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

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

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

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