Quote Originally Posted by soxophoneplayer View Post
I'm playing with this mod on my WAMP test site, zc 1.5.5a with Responsive Sheffiled Blue and many mods.

On the install.sql - the big chunk at the beginning of this file installs via phpMyAdmin. But I get error on the last bit for zencart 1.5 mods.

Specifically, the values for main_page_parms and sort order.

Code:
DELETE FROM zen_admin_pages WHERE page_key='configDynamicFilter';
INSERT INTO zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configDynamicFilter','BOX_CONFIGURATION_DYNAMIC_FILTER','FILENAME_CONFIGURATION',CONCAT('gID=',@cid), 'configuration', 'Y', @cid);
My zen_config_group installed from the first part of sql has config group id and sort order of 2828. I tried substituting those values in place of the @cid, to no avail.

There are no extra columns in my zen_admin_pages.

Initial error msg was those values (as in install.sql) can't be null. Attempt to insert the 2828 gives syntax error.
Got this more or less sorted...in the page_params I changed CONCAT('gID=',@cid) to gID=2828 instead of just 2828 and that worked.

So I got this mod fired up in zc 1.5.5a to the extent that everything shows up in the admin page but I'm not functional with it yet which I think is more related to how I've got my categories and attributes (lack of) set up - not directly related to this forum so I'll pursue that aspect elsewhere.