Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2006
    Location
    My family and I live in Brighton, England
    Posts
    982
    Plugin Contributions
    0

    Default install sql patch using phpMyAdmin

    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

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,762
    Plugin Contributions
    9

    Default Re: install sql patch using phpMyAdmin

    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.
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jun 2006
    Location
    My family and I live in Brighton, England
    Posts
    982
    Plugin Contributions
    0

    Default Re: install sql patch using phpMyAdmin

    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?

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,762
    Plugin Contributions
    9

    Default Re: install sql patch using phpMyAdmin

    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
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. v139h Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch ????
    By shags38 in forum Customization from the Admin
    Replies: 11
    Last Post: 20 Aug 2012, 04:19 AM
  2. v139h DB/SQL Error when using SQL Patch for Add Pages More Info Sidebox addon
    By maperr55 in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 5 Mar 2012, 09:32 PM
  3. how do install a sql patch?
    By zmtak in forum General Questions
    Replies: 2
    Last Post: 9 Dec 2011, 10:36 AM
  4. How do i install sql patch?
    By humbll in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 26 May 2007, 06:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR