Dynamic Filter [Support Thread]

[Design75]

I just happened to see in post 507 of this thread the following SQL:

SELECT @cid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Dynamic Filter';
DELETE FROM configuration WHERE configuration_group_id = @cid;
DELETE FROM configuration_group WHERE configuration_group_id = @cid;

This can cause a problem if the mod has not been installed before, as configuration_group_title= 'Dynamic Filter' does not exist and thus configuration_group_id will be null (can be expressed as "0"). There is a configuration_group_id of 0 in the stock Zen Cart db, and this will be deleted by this code.

There is a recommended alteration to this kind of SQL for all mod authors to use, given in this sticky thread:
http://www.zen-cart.com/showthread.p...tall-sql-files

This is taken care of in the upcoming release