SQL error that is weird...

HI Guys,

I got the following error after I installed the Tillmagic product......Any ideas??

Notice: Undefined index: store_id in /home/austra99/public_html/american-bbq.com.au/pos/classes/pos.php on line 1140

Notice: Undefined index: store_id in /home/austra99/public_html/american-bbq.com.au/pos/classes/pos.php on line 1141

Fatal error: Uncaught exception 'Exception' with message 'Error: 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 ' 0,0,1)' at line 1<br />Error No: 1064<br />INSERT INTO oc_product_squantity_to_store (product_id, store_id, quantity, reserved, active) VALUES (1,, 0,0,1)' in /home/austra99/public_html/american-bbq.com.au/system/storage/modification/system/library/db/mysqli.php:40 Stack trace: #0 /home/austra99/public_html/american-bbq.com.au/system/library/db.php(16): DB\MySQLi->query('INSERT INTO oc_...', Array) #1 /home/austra99/public_html/american-bbq.com.au/pos/classes/installer.php(162): DB->query('INSERT INTO oc_...') #2 /home/austra99/public_html/american-bbq.com.au/pos/classes/installer.php(50): install_pos->coordina_stock_online() #3 /home/austra99/public_html/american-bbq.com.au/pos/classes/installer.php(26): install_pos->create_table_product_quantity_to_store() #4 /home/austra99/public_html/american-bbq.com.au/pos/classes/ins in /home/austra99/public_html/american-bbq.com.au/system/storage/modification/system/library/db/mysqli.php on line 40

Note the VALUES part:

INSERT INTO oc_product_squantity_to_store (product_id, store_id, quantity, reserved, active) VALUES (1,, 0,0,1)

Second value (store_id) is missing and this is why you later have undefined index error.

hello

look the query : INSERT INTO oc_product_squantity_to_store (product_id, store_id, quantity, reserved, active) VALUES (1,, 0,0,1)

the store_id value is missing, by default store id is 0, so you can set like this :

INSERT INTO oc_product_squantity_to_store (product_id, store_id, quantity, reserved, active) VALUES (1,0, 0,0,1)

opencarttools

Hi Guys,

Ok I went and changed the value as mentioned


INSERT INTO oc_product_squantity_to_store (product_id, store_id, quantity, reserved, active) VALUES (1,0, 0,0,1)

But this hasn't made any difference at all

Any ideas??

Why don't you ask author of pos/classes/pos.php extension? Not sure what it is, but definitely not default OpenCart file.

hello

yes you are right, its not a default opencart file, if you will contact to those extension developer then you will save your time.

Hello

In your query INSERT INTO oc_product_squantity_to_store (product_id, store_id, quantity, reserved, active) VALUES (1,, 0,0,1)

the store_id value is missing, by default store id is 1, but is not working for you so you need to find store id for your store and add it to below query config_store_id from config)

INSERT INTO oc_product_squantity_to_store (product_id, store_id, quantity, reserved, active) VALUES (1,YOUR_VALUE, 0,0,1)

Thanks