Page 1 of 3 123 LastLast
Results 1 to 10 of 27
  1. #1
    Join Date
    Oct 2010
    Location
    Tamworth, Staffs. UK
    Posts
    6
    Plugin Contributions
    0

    Default Skipped:cannot .... because it already exists

    Hi there. I wonder if anyone can help me as I seem to be stuck on the same thing. The site is brand new so no need to upgrade a database (its new too). I have downloaded all the new version files so the zc_install are the current version. When I accessed the admin area after install######## I received the "your database appears to need patching to a higher level" message. I have gone back and run upgrade DB from 1.3.8 to 1.3.9 but get the message "Skipped:cannot add index idx_prod_id_orders_id_zen to table orders_products because it already exists" "Skipped: cannot add index idx_cust_id_zen to table orders because it already exists and Skipped:cannot insert configeration key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists (many times for this one).

    I have read some posts and already changed the zc_install installer_params.php from latin to utf8 as this is my database.

    Im sure that I am doing something very simple wrong so would appreciate any help that can be offered. Many thanks : Dom

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Skipped:cannot .... because it already exists

    Go to Admin->Tools->Server Info
    What does it say about "Zen Cart Version" and "Database Version" and history?
    .

    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
    Oct 2010
    Location
    Tamworth, Staffs. UK
    Posts
    6
    Plugin Contributions
    0

    Default Re: Skipped:cannot .... because it already exists

    Hello Dr Byte,
    Hope this is the info you need. Best wishes : Dom
    PROJECT_VERSION_NAME PROJECT_VERSION_MAJOR.PROJECT_VERSION_MINOR
    Patch: PROJECT_VERSION_PATCH1:ROJECT_VERSION_PATCH1_SOURCE
    Patch: PROJECT_VERSION_PATCH2:ROJECT_VERSION_PATCH2_SOURCE
    Database Patch Level: 1.3.9h
    v1.3.9h [2010-11-02 17:59:09] (Version Update 1.3.8->1.3.9h)
    v1.3.9h [2010-11-02 17:46:30] (Fresh Installation)

  4. #4
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Skipped:cannot .... because it already exists

    That tells me you're missing one or more files from your /includes/ folder, presumably a result of an incomplete FTP upload.
    .

    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
    Oct 2010
    Location
    Tamworth, Staffs. UK
    Posts
    6
    Plugin Contributions
    0

    Default Re: Skipped:cannot .... because it already exists

    Hi there Dr Byte,
    Of course, you are totally correct... I went through file by file and just 1 was missing... on a fresh go this of course solved everything. Thank you so much for your kind assistance, im off to eat drink and be merry thanks totally to you :). Thanks again : Dom

  6. #6
    Join Date
    Sep 2009
    Posts
    136
    Plugin Contributions
    0

    Default Re: Skipped:cannot .... because it already exists

    I am getting similar error messages ("Skipped:cannot add index idx_prod_id_orders_id_zen to table orders_products because it already exists" "Skipped: cannot add index idx_cust_id_zen to table orders because it already exists and Skipped:cannot insert configeration key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists), but when I go into my Admin it still says Version 1.3.8

    I can't for the life of me get the upgrade to 1.3.9h to work!! I keep getting directed back to the Upgrade Database page with the same error messages. It is never actually upgrading.

  7. #7
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: Skipped:cannot .... because it already exists

    You've already got two threads open about this, so I suggest you stay out of this one.

    Vger
    Quote Originally Posted by cactusrunning View Post
    I am getting similar error messages ("Skipped:cannot add index idx_prod_id_orders_id_zen to table orders_products because it already exists" "Skipped: cannot add index idx_cust_id_zen to table orders because it already exists and Skipped:cannot insert configeration key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists), but when I go into my Admin it still says Version 1.3.8

    I can't for the life of me get the upgrade to 1.3.9h to work!! I keep getting directed back to the Upgrade Database page with the same error messages. It is never actually upgrading.

  8. #8
    Join Date
    May 2010
    Location
    UK
    Posts
    85
    Plugin Contributions
    0

    Default Re: Skipped:cannot .... because it already exists

    Question for all those upgrading from 1.3.8 to 1.3.9h.
    Im trying to do that but on the install it says
    Ready to Install? (This will wipe any existing data. You are NOT in Upgrade mode!!!)
    Did you have the same thing? Did you install ok? Any tips?

  9. #9
    Join Date
    Sep 2009
    Posts
    136
    Plugin Contributions
    0

    Default Re: Skipped:cannot .... because it already exists

    Sorry Vger I was just hoping to get someone other than Black Kobra answering my questions. He hasn't been very helpful...


    Pookie Hair: To get the Upgrade Database option to come up, I had to add in the text into my configure.php files in the zc full file set. Once they were no longer empty I got the Upgrade option.

  10. #10
    Join Date
    May 2010
    Location
    UK
    Posts
    85
    Plugin Contributions
    0

    Default Re: Skipped:cannot .... because it already exists

    Pookie Hair: To get the Upgrade Database option to come up, I had to add in the text into my configure.php files in the zc full file set. Once they were no longer empty I got the Upgrade option.[/QUOTE]

    Thanks for replying cactusrunning?
    Add in what text?
    Where might I find the configure.php files in the zc full file set?
    Did you upgrade from 1.3.8 to 1.3.9h?
    Im finding it a complete nightmare

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Replies: 5
    Last Post: 14 Mar 2015, 12:28 AM
  2. v139h Cannot insert configuration_key "" because it already exists
    By RixStix in forum Upgrading to 1.5.x
    Replies: 24
    Last Post: 13 Mar 2015, 11:34 AM
  3. Website exists already. Interested in integrating with ZC
    By Bob4786 in forum General Questions
    Replies: 3
    Last Post: 20 Oct 2011, 03:38 PM
  4. 1050 Table 'upgrade_exceptions' already exists
    By lioncity in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 18 Aug 2008, 04:57 AM

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