I was adding some products with options and suddenly I'm getting a fatal error that seems to be affecting two categories in my store. I have no idea what I could have done or what to do to fix it.

Categories that are affected...
https://www.decorativepaintingstore.com/products.php?cat=Sharon+Chinn
https://www.decorativepaintingstore.com/products.php?cat=Patterns+By+Mail-Sharon+Chinn

---------------------
Error Message 1...
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SC21001','SC21002','SC21003','SC22002','SC22001','SC17018MAIL','SC15963MAIL',...' at line 1

Error Message 2...
Fatal error: Uncaught Error: Call to a member function free_result() on boolean in /var/www/vhosts/decorativepaintingstore.com/httpdocs/vsadmin/inc/incfunctions.php:1893 Stack trace: #0 /var/www/vhosts/decorativepaintingstore.com/httpdocs/vsadmin/inc/incproducts.php(591): ect_free_result(false) #1 /var/www/vhosts/decorativepaintingstore.com/httpdocs/products.php(12): include('/var/www/vhosts...') #2 {main} thrown in /var/www/vhosts/decorativepaintingstore.com/httpdocs/vsadmin/inc/incfunctions.php on line 1893
There has been a critical error on this website.
--------------------

At the time this started, I had created some product options to give the customer the option of downloading a product file or receiving it by mail. I already had the Download and By Mail products set up, then I added the base product to display with the option, and changed the other two products to not displayed. This seemed to be working like it should until I got to product SC19002 and the errors started.

Also for these 2 categories, Product Admin window in the store admin looks like this and all the links have been replaced by '-', so I can't even go back into the last product I was changing to see if something needs changed.

Any idea what I could have done?

[img]https://www.decorativepaintingstore.com/wp-content/uploads/2022/07/Screen-Shot-2022-07-08-at-1.22.11-PM.png[/img]

I'm still looking at this issue and it seems to only be affecting page 1 of the category, if I go to the next page it looks normal.

I think I found the problem, although it doesn't make sense to me. I went into the database and found the product I last added and it was in the database twice and one ID had a / at the end of it. I deleted that product from the database and things seem to be back to normal.

Hi Sharonchinn
I'm glad you have found the problem already and good catch there. I'll see if I can investigate why this happened.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Thanks Vince. The only thing I can guess is the '/' in the product id. I accidentally had it as 'SC19002/' Once I got rid of that, things went back to normal.