install sql patch using phpMyAdmin

[MeltDown]

My User_Tracker module is one of my favorite tools even though it's been out-of-whack (but usable) since upgrading. After seeing an updated version in the download section, I decided to update. The problem? My Zen SQL Query Executor won't accept the sql. The readme says that would probably happen and to install sql patch using phpMyAdmin. However, I don't know how to do this. I've searched online for tutorials and seem to be able to find out how to do everything But install the patch.

Anyone have a tutorial link or a quick how-to?

Thanks - Tim

[kobra]

Some of this is phpmyadmin version specific but will try to be generic enough:

open phpmyadmin

Left panel select the DB
at the top in the right pane after it loads select export
a nav window opens with the tables - select the current table that you will be replacing and export this to a file (backup)

Now reload the DB - left panel select the DB
after it loads in the right panel scroll down to the table select check box
scroll to bottom and there should be a "with selected" drop box
select "drop" and answer the tests like are you sure or??

Now in the leftt panel reselect the DB
when loaded in the right panel at the top is import and/or SQL
If you have import select this if not select SQL

Now you can select the file to import or if SQL a file to run or you can paste the sql contents into this window and with either select "GO" and the sql code with be run

Assuming that this mod creates the table you should see this in the success message.

That is the quick primer for this.

[MeltDown]

Thanks Kobra for replying. Unfortunetly I've run into a snag. All seemed to be going well but when I attempted to import the sql this is the error I received:

Error
SQL query:

DELETE FROM configuration WHERE configuration_group_id = '999';



MySQL said:

#1146 - Table 'example1000_zencart.configuration' doesn't exist

Any idea why this would occur?

[kobra]

I would first check in phpmyadmin what your table are named - specifically if the have a prefix like zen_???

If they do - you will need to edit the module sql to reflect this