Thread: UK Counties sql

Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: UK Counties sql

    Yes. Look at the .sql you loaded. And for every line in that .sql file, note the table it's inserting into. Find that table, and remove the specified record. Be sure to delete the newest record ONLY. Because if you delete the older (smaller id number) record then you'll break customer/order records that link to that older record, causing you messes all over the place.
    This is the sort of thing a skilled db administrator should do.

    ALWAYS MAKE COMPLETE TESTED BACKUPS BEFORE DOING ANY DIRECT DATABASE MANIPULATION!!!!!!!!!

    ... You DO make backups, right?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  2. #12
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default Re: UK Counties sql

    Quote Originally Posted by DrByte View Post
    ALWAYS MAKE COMPLETE TESTED BACKUPS BEFORE DOING ANY DIRECT DATABASE MANIPULATION!!!!!!!!!

    ... You DO make backups, right?
    OHHHHHHH yyyyyyeeeeeessssss

  3. #13
    Join Date
    Sep 2008
    Posts
    46
    Plugin Contributions
    0

    Default Re: UK Counties sql

    When installing this on 1.5.3 I get
    "WARNING: An Error occurred, please refresh the page and try again."
    And when I go back to the main admin, my zone's no longer work at all.

    How can I uninstall the sql :\

  4. #14
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: UK Counties sql

    Quote Originally Posted by kezerb View Post
    When installing this on 1.5.3 I get
    "WARNING: An Error occurred, please refresh the page and try again."
    And when I go back to the main admin, my zone's no longer work at all.

    How can I uninstall the sql :\
    The way to "uninstall" something like that is to use the backup you made of your database before running the script in the first place.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Nevada/Tax/Counties?
    By Sellerz in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 5
    Last Post: 7 Nov 2012, 07:42 PM
  2. Uk Counties sql script for RoyalMail
    By discoverytdi in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 1 May 2012, 01:12 PM
  3. UK counties and US States
    By blackwolf in forum General Questions
    Replies: 6
    Last Post: 14 Apr 2010, 11:21 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