Results 1 to 8 of 8
  1. #1
    Join Date
    May 2006
    Posts
    6
    Plugin Contributions
    0

    Default Error upgrade 1.3.7 to 1.3.8a

    After downloading all my files and backing up my DB, I uploaded all the new 1.3.8a files and started with the install, making sure that the option of 1.3.7 to 1.3.8 was checked and entered in my credentials as admin and proceeded with the upgrade, I then got the following error. What now, any suggestions?

    1062 Duplicate entry 'Customers who have never completed a purchase' for key 2
    in:
    [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');]

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

    Default Re: Error upgrade 1.3.7 to 1.3.8a

    .

    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.

  3. #3
    Join Date
    May 2006
    Posts
    6
    Plugin Contributions
    0

    Default Re: Error upgrade 1.3.7 to 1.3.8a

    I figured instead of cross threading other peoples issues I would continue my own with reference points from your reference post answer in the previous post.

    Quote Originally Posted by DrByte View Post
    http://www.zen-cart.com/forum/showthread.php?t=82998
    It's trying to insert a record that apparently already exists.
    Did you run the database upgrade twice for some reason?
    The answer is no, I did not try running it again.

    Run this using the SQL Patch tool in the Admin->Tools menu:
    Code:

    DELETE from query_builder where query_name = 'Customers who have never completed a purchase';

    Then you should be able to redo the database upgrade ... again.
    I can't do that if I have no access to the admin panel in the application, there is just a blank screen when I try to access the admin or the client side. HOWEVER I believe I can do this from my phpMyAdmin access, should I do that?

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

    Default Re: Error upgrade 1.3.7 to 1.3.8a

    You can use phpMyAdmin.
    You may need to add your DB_PREFIX value to the beginning of the table name if you are using prefixes in your site.
    .

    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.

  5. #5
    Join Date
    May 2006
    Posts
    6
    Plugin Contributions
    0

    Default Re: Error upgrade 1.3.7 to 1.3.8a

    hmmm small problem, that query does not exist in the database. I have the following queries.

    1) All customers
    2) All Newsletter Subscribers
    3) Dormant Customers (>3month Subscribers)
    4) Active Customers in past 3 months (Subscribers)
    5) Active Customers in past 3 months (Regardless of S...)
    6) Administrator
    I also did a look up for it and got this
    MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 sec)
    SQL query:
    SELECT *
    FROM `zen_query_builder`
    WHERE `query_name` LIKE CONVERT( _utf8 'Customers who have never completed a purchase'
    USING latin1 )
    COLLATE latin1_swedish_ci
    LIMIT 0 , 30
    Any other ideas?

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

    Default Re: Error upgrade 1.3.7 to 1.3.8a

    Your first post says the table name is "query_builder" but your last post talks about "zen_query_builder".
    Sounds like you're running things on different sets of tables.
    .

    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.

  7. #7
    Join Date
    May 2006
    Posts
    6
    Plugin Contributions
    0

    Default Re: Error upgrade 1.3.7 to 1.3.8a

    HOLY C#$* Some how I installed it all over again but using ZEN at the forefront....okay I found it and was able to do the command
    DELETE from query_builder where query_name = 'Customers who have never completed a purchase';
    Question now is how do I drop all those tables that start with "ZEN_" ???

    AND
    Going to http://domainname.com/zc_install/index.php shows nothing but a blank page now.

    Should I re-upload all the 1.3.8 files?

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

    Default Re: Error upgrade 1.3.7 to 1.3.8a

    You'll have to manually remove the extra files using your phpMyAdmin console.

    As for the blank screen ... I suppose that's likely a result of a bad edit to a file or incomplete uploads.
    .

    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
    By dannyd in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 28 Jan 2008, 07:53 AM
  2. 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
  3. 1.3.7 to 1.3.8a Upgrade error
    By coucho in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 11 Jan 2008, 09:30 AM
  4. Error on upgrade 1.3.0.2 to 1.3.7
    By bobdog in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 8 Apr 2007, 03:25 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