So I've managed to get everything installed, merged, and working mostly happily, the only issue I'm getting now is when I try to put in my second attribute variant, the page crashes and I get:
Code:
WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Logs are showing:
Code:
[15-Feb-2020 12:21:32 America/Phoenix] Request URI: /********/products_with_attributes_stock.php?products_id=2804&quantity=3&customid=23523V2&skuTitle=Burl%20Wallet%20Double&attributes=4399,,,&add_edit=add&action=execute, IP address: 47.46.139.205
#1 trigger_error() called at [/home/********/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/********/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/********/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/********/public_html/********/includes/classes/products_with_attributes_stock.php:674]
#5 products_with_attributes_stock->insertNewAttribQty() called at [/home/********/public_html/********/products_with_attributes_stock.php:557]
--> PHP Fatal error: 1054:Unknown column '23523V2' in 'where clause' :: SELECT count(*) AS total FROM zen_products_with_attributes_stock WHERE (products_id = 2804 AND stock_attributes = 4399) OR product_attribute_combo = '2804-4399' OR customid = 23523V2 ==> (as called by) /home/********/public_html/********/includes/classes/products_with_attributes_stock.php on line 674 <== in /home/********/public_html/includes/classes/db/mysql/query_factory.php on line 171.
I've checked the Install.php page, run file check, made sure the database updates were run, and everything on that end says there aren't any errors.
Bookmarks