I just bought the commercial version of qbi and it appears to have made a mess of my database.
After installing qbi my attributes no longer work right. When adding an attribute to a product I get this error message:
1136 Column count doesn't match value count at row 1
in:
[insert into products_attributes values (0, '356', '82', '540', '1', '', '0', '0', '1', '+', '0', '0', '1', '', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0')]
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.
I expect this is due to the additions to my products_attributes table which has these new entries
`products_attributes_products_id` int(11) NOT NULL default '0',
`products_attributes_products_quantity` smallint(6) NOT NULL default '0',
`products_attributes_type` tinyint(4) NOT NULL default '0',
Unfortunately this problem wasn't discovered until after the upgrade was placed on my live store. Any help is appreciated and needed urgently
Thanks
Tom
Bookmarks