Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
 All Forums
 Technical
 WordPress for Ecommerce Templates
 FIXED ... Fatal error on my site
Author « Topic »  

sharonchinn
Advanced Member

USA
303 Posts

Posted - 07/08/2022 :  10:49:33  
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?






Edited by - sharonchinn on 07/08/2022 11:11:00

sharonchinn
Advanced Member

USA
303 Posts

Posted - 07/08/2022 :  11:00:12  
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.

sharonchinn
Advanced Member

USA
303 Posts

Posted - 07/08/2022 :  11:10:17  
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.

Vince
Administrator

41825 Posts

Posted - 07/08/2022 :  12:01:10  
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

sharonchinn
Advanced Member

USA
303 Posts

Posted - 07/08/2022 :  12:09:15  
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.
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.02 seconds. Snitz Forums 2000