
Originally Posted by
Pompidompie
Hello there.
I just downloaded this addon and did the best I could to merge the files. Hope I did everything right.
Then after putting the files where they belong, the readme says, go to...../stock_by_attr_install.php and select full/upgrate and run script....
I do see the /stock_by_attr_install.php page, but clicking on run script doesn't work.
It removes everything under the dropdown - run script. The readme says I need to get a message. I don't get one either.
Then, looking at the catalog, I do see my website, but when I click on a categorie that should had some products in there, I get an error.
WARNING: An Error occurred, please refresh the page and try again.
Looking in de logs, it says
[13-Apr-2015 14:32:05 Europe/Berlin] PHP Fatal error: 1146:Table 'nameofmydatabse.products_with_attributes_stock' doesn't exist :: SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(180,181,182), 1, 0)) as flag FROM products_attributes p2a JOIN products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 JOIN products_with_attributes_stock p2as ON p2a.products_id = p2as.products_id AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%') WHERE p2a.products_id IN (180,181,182) AND p2as.quantity > 0 GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_name, pov.products_options_values_sort_order ==> (as called by) C:\xampp\htdocs\zencart\includes\templates\westminster_new\sideboxes\tpl_dynamic _filter.php on line 402 <== in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 155
I don't have enough experience for all of this, but I can see that it says that a table does not exist.
The problem could be that i have some other add ons build in, so everything has to move over in the database.
What must i do to get the install done?
zencart 1.5.4
fast and easy checkout
css js loader
dynamic filter
flexible footer
westminster new template
second language
Bookmarks