Thread: DB update error

Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Location
    Manitou Beach, Michigan
    Posts
    324
    Plugin Contributions
    0

    Default DB update error

    Hi,
    I am working to upgrade my carts.
    I installed 1.5 then pointed it to the DB I had copied the old DB into. Ran the DB update process and I get this error:

    SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
    SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
    SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
    SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.

    How will this affect my cart upgrade?
    Thanks
    Mark

  2. #2
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: DB update error

    The errors are actually self explanatory..

    • The upgrade attempted to add two indexes, but they already exist. So this part of the upgrade script was skipped. (doesn't need to do this - it's already done)
    • Then the upgrade attempted to drop (delete) two indexes, but they DON'T exist. So this part of the upgrade script was skipped. (doesn't need to do this - it's already done)





    Quote Originally Posted by maperr55 View Post
    Hi,
    I am working to upgrade my carts.
    I installed 1.5 then pointed it to the DB I had copied the old DB into. Ran the DB update process and I get this error:

    SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
    SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
    SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
    SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.

    How will this affect my cart upgrade?
    Thanks
    Mark
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  3. #3
    Join Date
    Aug 2007
    Location
    Manitou Beach, Michigan
    Posts
    324
    Plugin Contributions
    0

    Default Re: DB update error

    HI,
    Thank you for the reply,
    I was not sure if this meant I had to do some editing of the DB to resolve this error or to leave it because it would not harm the programs functionality.
    Thanks you,
    Mark

  4. #4
    Join Date
    Aug 2007
    Location
    Manitou Beach, Michigan
    Posts
    324
    Plugin Contributions
    0

    Default Re: DB update error

    Hi,
    Tried to add this but time ran out before I posted it. If you are familiar with the coding I have a post up for the add pages to side box Add on. It was working fine until my hosting Co. upgraded the PHP version on the server now everything works but this addon. Just live blank pages.
    Thanks again,
    Mark

 

 

Similar Threads

  1. product updATE ERROR WHEN PRVIEW new_product_preview.php error
    By d1rage5 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 27 Sep 2010, 02:37 PM
  2. Currency Update Error v1.38
    By anshii in forum General Questions
    Replies: 3
    Last Post: 26 Jun 2010, 08:55 PM

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