Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default DB Upgrade error

    Trying to upgrade a 1.2.6 cart to 1.5.1
    Performing upgrades manually one at a time
    During the DB upgrade steps I get to 1.3.7 to 1.3.8 and I receive this message
    Code:
    WARNING: An Error occurred, please refresh the page and try again.
    Have not a clue as to what to try next
    Zen-Venom Get Bitten

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: DB Upgrade error

    Are there any log files in the /logs folder? Did you change the collation of the database for the upgrade?
    Last edited by lat9; 14 Dec 2012 at 10:15 PM. Reason: Added second question.

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

    Default Re: DB Upgrade error

    That message means a fatal database error occurred, ie: a SQL error.
    http://www.zen-cart.com/content.php?...-and-try-again
    .

    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.

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

    Default Re: DB Upgrade error

    Log has this in it
    Code:
    PHP Fatal error:  1062:Duplicate entry 'Customers who have never completed a purchase' for key 'query_name' :: INSERT INTO query_builder (query_category, query_name, query_description , query_string) VALUES ('email,newsletters', 'Customers who have never completed a purchase', 'For sending newsletter to all customers who registered but have never completed a purchase', 'SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN  TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL'); in /home/armorhea/public_html/includes/classes/db/mysql/query_factory.php on line 120
    Off to search for 1062uplicate entry
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: DB Upgrade error

    Just skipped 1.3.7 to 1.3.8
    excecuted form 1.3.8 to 1.3.9 and all others
    Not positive what impact this will have
    Zen-Venom Get Bitten

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

    Default Re: DB Upgrade error

    That error is telling you that the SQL is attempting to insert a record that already exists.
    Chances are that's because the storeowner has applied small fixes from the forum and has created a clash.
    Simplest solution is to delete that record from the database. The error message tells you which record and which table.
    Alternatively you could comment out that particular INSERT statement from the upgrade SQL file.
    .

    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.

 

 

Similar Threads

  1. Upgrade error 1.3.7->1.3.8a
    By quentinjs in forum Upgrading from 1.3.x to 1.3.9
    Replies: 33
    Last Post: 25 Jan 2008, 10:23 AM
  2. Upgrade error???
    By BDCreations in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 8 Jan 2008, 01:23 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