Ok, quick update
I tried to remove the mod so I could re-install it.
I used the sql statement supplied
delete from configuration where configuration_key in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');
which seemed to work.
Now, I went to install the mod again. copied over files via ftp, imported the SQL statement to phpmyadmin and got this error message..
SQL query: Documentation
INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES (
'Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows', 'Select the layout style:<br />Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)', '8', '40', NULL , now( ) , NULL , 'zen_cfg_select_option(array("rows", "columns"),'
);
MySQL said: Documentation
#1146 - Table 'lingerie_zc1.configuration' doesn't exist
So now im left not being able to have column layout at all.
Any help and beers are on me!