X-Cart forums

[chiaze]

Hi - I have been working on my XCart site armed with basic HTML knowledge, but am still new to this Ecommerce/Database thing.

So I just got the Zoomify mod, and I can handle every installation aspect except for this:

"1) Patch your database with the following SQL...

ALTER TABLE `xcart_products` ADD `zoomified1` CHAR( 1 ) NOT NULL DEFAULT 'N';

ALTER TABLE `xcart_products` ADD `zoomified2` CHAR( 1 ) NOT NULL DEFAULT 'N';

ALTER TABLE `xcart_products` ADD `zoomified3` CHAR( 1 ) NOT NULL DEFAULT 'N';

ALTER TABLE `xcart_products` ADD `zoomified4` CHAR( 1 ) NOT NULL DEFAULT 'N';"

What does it mean to patch your database? Does this refer to MySQL? Would appreciate if someone could provide some step-by-step instructions to complete those actions.

[PhilJ]

Why not ask me?

In admin click patch/upgrade

Paste the SQL above in the SQL query(ies): box and press Apply

[chiaze]

Haha thanks! I didn't think you'd still be working as I know it's quite late over there!

[PhilJ]

no probs