Code: Select all
Error: Unknown column 'product_id' in 'field list'
Error No: 1054
INSERT INTO order_product SET order_id = '10', product_id = '43', name = 'MacBook', model = 'Product 16', price = '500', discount = '0', total = '500', tax = '0', quantity = '1'OpenCart®
Project Owner & Developer.
no because it makes the whole system insecure!ksjones wrote: Adding the field worked fine, will you be creating a new package of the installer for this?
Quick suggestion for future development and bug fixes to the DB, could you add a SQL extension where the DB can have SQL commands executed to it? That way you can supply upgrade scripts that alter the DB structure and users would only need to upload new files.
Cheers K
OpenCart®
Project Owner & Developer.
Code: Select all
Error: Unknown column 'product_id' in 'field list'
Error No: 1054
INSERT INTO order_product SET order_id = '4', product_id = '49', name = 'Fireball Tim's "HOLLYWOOD MOVIE CAR" Design Book ', model = 'fbb001', price = '2.5', discount = '0', total = '2.5', tax = '0', quantity = '1'Code: Select all
ALTER TABLE `order_product` ADD `product_id` INT( 11 ) NOT NULL default '0' AFTER `order_id`;
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Users browsing this forum: Amazon [Bot], Google [Bot] and 10 guests
