Hi Qhome,

Thankyou for this. It is people like zen cart and you that make dreams possible.

Thankyou for sharing, maybe one day I can do the same.

I solved the problem by adding the prefix in the proper place of the sql:

SELECT @gid := configuration_group_id FROM `configuration_group` where `configuration_group_title` LIKE 'Tabbed Products Config';

`xxx.configuration_group` <- this needs to be changed.
where of course XXX is your prefix of database tables.

I know this was posted before, but it was not clear to me as it was posted, so I added the prefix to all tables in the select statement(which was wrong). After examining the SQL logic for a while, the previous posts made sense.


Thank you,
Metauniverse