Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Jun 2006
    Posts
    440
    Plugin Contributions
    0

    Default Errors upgrading from v1.3.0.2 (due to bad db import)

    Hi Dr. Byte

    I had the exact same problem as this, [select admin_id, admin_name, admin_pass from admin where admin_name = 'admin'] and proceeeded to update the database 1 version at the time. I got from 132 to 137 and then I got the following error.

    Can you please assist.

    Thanks

    Renz

    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,363
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1.2 Database with 1.38 New Install

    You'll have to manually run this database query before you can proceed:
    Code:
    delete from query_builder where query_name = 'Customers who have never completed a purchase';
    .

    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
    Jun 2006
    Posts
    440
    Plugin Contributions
    0

    Default Re: 1.2 Database with 1.38 New Install

    Hi there,

    I have done that which allowed me to proceed to patch lever 138.

    I got the following errors and I am still unable to see clients orders or anything relevant in the db.

    Thanks for your help

    Regards

    Renz

    SKIPPED: Cannot insert configuration_key "SHOW_SHOPPING_CART_COMBINED" because it already exists
    SKIPPED: Cannot insert configuration_key "ORDER_COMMENTS_INVOICE" because it already exists
    SKIPPED: Cannot insert configuration_key "ORDER_COMMENTS_PACKING_SLIP" because it already exists
    SKIPPED: Cannot insert configuration_key "ORDER_COMMENTS_PACKING_SLIP" because it already exists
    SKIPPED: Cannot ADD column module_name because it already exists.
    SKIPPED: Cannot ADD column module_mode because it already exists.
    SKIPPED: Cannot ADD column module_name because it already exists.
    SKIPPED: Cannot ADD column module_mode because it already exists.
    SKIPPED: Cannot create table nochex_apc_transactions because it already exists
    SKIPPED: Cannot create table nochex_sessions because it already exists
    SKIPPED: Cannot create table nochex_sessions because it already exists
    SKIPPED: Cannot create table nochex_sessions because it already exists
    SKIPPED: Cannot create table nochex_sessions because it already exists
    SKIPPED: Cannot CHANGE column zen_order_id because it does not exist.
    SKIPPED: Cannot CHANGE column zen_order_id because it does not exist.
    SKIPPED: Cannot ALTER or INSERT/REPLACE into table linkpoint_api because it does not exist. CHECK PREFIXES!

  4. #4
    Join Date
    Jun 2006
    Posts
    440
    Plugin Contributions
    0

    Default Re: 1.2 Database with 1.38 New Install

    Hi Dr.

    any ideas on the last 3 issues or should I start a new thread...

    These are my steps so far.

    Zen Cart 1.3.8a
    Patch: 1::
    Database Patch Level: 1.3.8
    v1.3.8 [2010-06-16 09:42:49] (Version Update 1.3.7->1.3.8)
    v1.3.8 [2010-06-16 08:23:26] (Version Update 1.3.7->1.3.8)
    v1.3.7 [2010-06-15 16:21:45] (Version Update 1.3.6->1.3.7)
    v1.3.6 [2010-06-15 16:20:57] (Version Update 1.3.5->1.3.6)
    v1.3.5 [2010-06-15 16:10:23] (Version Update 1.3.0.2->1.3.5)
    v1.3.8 [2010-06-11 15:46:50] (Fresh Installation)

    Thanks

    RR

    Errors...and there is nothing visible in the store

    SKIPPED: Cannot CHANGE column zen_order_id because it does not exist.
    SKIPPED: Cannot CHANGE column zen_order_id because it does not exist.
    SKIPPED: Cannot ALTER or INSERT/REPLACE into table linkpoint_api because it does not exist. CHECK PREFIXES!

  5. #5
    Join Date
    Jan 2004
    Posts
    66,363
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Errors upgrading from v1.3.0.2

    I'm not bothered much by those warnings, since they're almost all likely related to having done partial upgrades previously, and they're simply reporting that things are already done, as they should.
    Quote Originally Posted by Renz View Post
    I am still unable to see clients orders or anything relevant in the db.
    Quote Originally Posted by Renz View Post
    ...and there is nothing visible in the store
    Is the data actually *there*?
    I'm guessing it *is* there, but maybe in a different set of tables due to DB_PREFIX mismatches between old and new? How many tables are in your database?
    .

    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.

  6. #6
    Join Date
    Jun 2006
    Posts
    440
    Plugin Contributions
    0

    Default Re: Errors upgrading from v1.3.0.2

    Hi Dr.

    I think the data is there as well as for instance there are 509 entries in the address book (looking at the DB tables)

    There are 95 entries in the DB

    Thanks

    RR

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

    Default Re: Errors upgrading from v1.3.0.2

    Hmm ... puzzling that you say nothing's visible in the store then.
    How many records are in your products table? and your products_description table? and your products_to_categories table? and your categories table?
    .

    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.

  8. #8
    Join Date
    Jun 2006
    Posts
    440
    Plugin Contributions
    0

    Default Re: Errors upgrading from v1.3.0.2

    Uhmm

    Yes perhaps you are onto something....all those values are 0 thats weird because they are all in the import of the db I am using..Exported from one site and imported to another for upgrading.

    Not sure why they are not showing...
    Thanks
    RR

  9. #9
    Join Date
    Jan 2004
    Posts
    66,363
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Errors upgrading from v1.3.0.2

    That sounds like your import isn't working properly.
    .

    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.

  10. #10
    Join Date
    Jun 2006
    Posts
    440
    Plugin Contributions
    0

    Default Re: Errors upgrading from v1.3.0.2

    Yup BAD BAD..import...just did it again and lots more numbers in the db. Just about to run the ZC_Install DB upgrade..

    Should be good though

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v153 Getting Quantity Units errors at checkout after upgrading from V138
    By inklingsolutions in forum Upgrading to 1.5.x
    Replies: 3
    Last Post: 26 Aug 2014, 06:19 PM
  2. v151 Upgrading v151 to v152 due to php upgrade
    By pazdar in forum Upgrading to 1.5.x
    Replies: 2
    Last Post: 4 Mar 2014, 10:53 PM
  3. Replies: 4
    Last Post: 23 Aug 2013, 06:17 PM
  4. paypal 15008 error due to bad math
    By tomarriola in forum PayPal Website Payments Pro support
    Replies: 1
    Last Post: 10 Jun 2012, 12:11 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