Adding the admin configuration switch via phpMyAdmin

[ZZZZZeeeennn]

Hello,

I've updated from 1.301 to 1.35 (09042006) successfully and even applied all the patches necessary described under "Re: Confirmed bugs and workarounds in v1.3.5", except one. It's the solution number 13, "Adding the admin configuration switch via phpMyAdmin". I don't exactly know what to do with this one.

Please someone explain to me what I need to do in phpMyAdmin. Where and how am I gonna put the code? I found that configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, and set_function are already listed.

BTW, I was able to apply the SQL to my database using phpMyAdmin for the solution number 6 to Manufacturers error problem.

Thank You In Advance,
Zzzzzeeeennn

[ZZZZZeeeennn]

Anyone!?

I've updated my database as well, and I have all the backups.

Help is much appreciated,
Zzzzzeeeennn

[kuroi]

Take a deep breath and follow exactly the same procedure as you did for #6.

Yes the columns such as configuration_title are already there (that's a good thing) - all you're doing for #13 is adding an extra row of data to each of those columns.

[ZZZZZeeeennn]

Thank You Kuroi Sensei for your reply!

I already don't remember what exactly I did for the number 6, and I was trying to trace back what I did in phpMyAdmin but I can no longer find the code I entered. It fixed the manufacturers problem but the trace of the added code isn't kept there apparently.

I also don't know whether I should put the entire text as the code or the part of it is just an explanation. I believe I'm editing each of those listed field, but am I to replace the existing code or to append?

Help!

[kuroi]

All you need do is:

1. Fire up phpMyAdmin and select the database you use for your Zen Cart in the left hand column

2. This will result in a list of the tables in both left and right columns - find the configuration table and check whether you have used a prefix e.g. "zen_" as in zen_configuration.

3. Click the SQL button or SQL tab and in the big white box, cut and paste the entire boxed line that starts "insert into configuration ..." from fix #13.

4. If you have used a prefix edit the third word to add it (e.g. "insert into zen_configuration ...")

5. Press Go

[ZZZZZeeeennn]

Thank You So Very Much!