Zen Cart Logo
Forums / All Other Contributions/Addons / Changing Table Prefix's

Changing Table Prefix's

Locked

Views: 1,432

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
30 Nov 2006, 8:09 AM
#1
brimsjewelry avatar

brimsjewelry

Zen Follower

Join Date:
May 2006
Posts:
188
Plugin Contributions:
0

Changing Table Prefix's

I bought a mod to send a data feed to yahoo product submit. It comes with an sql patch that says:

Review file zencart_yahoo_export.sqlincluded into this release: you may have to change prefix for store tables.
Then execute those SQL instrutions (you can use such tool like phpMyAdmin to do this).

Being an ignoramus i'm not sure what this is telling me to do. Here is part of the first entry of the sql patch:

/* YAHOO SQL */ INSERT INTO zen_configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES (
NULL , 'Export Delimeter', 'M1_YAHOO_EXPORT_DELIMITER', 'tab', 'Export Delimeter', 6, 1, NULL , '0000-00-00 00:00:00', NULL , NULL
);

Am I correct in thinking that zen_configuration is the table header? I see no table named that in PhpMyAdmin. Should I create a table for this?

Any thoughts would be appreciated.

Thanks,

Jason

30 Nov 2006, 8:54 AM
#2
samad64 avatar

samad64

Totally Zenned

Join Date:
May 2006
Location:
Texas
Posts:
554
Plugin Contributions:
2

Re: Changing Table Prefix's

If you didn't use custom prefixes.. you should be OK. The file already seems to have the default prefixes on it (zen_)

If you used custom prefixes.. then you would put PREFIX_configuration instead of zen_configuration.. that should work then