Forums / Upgrading to 1.5.x / DB update error

DB update error

Started by maperr55 on 17 May 2012, 8:00 PM · Views: 1,049

Results 1 to 4 of 4
17 May 2012, 8:00 PM
#1
maperr55 avatar

maperr55

Zen Follower

Join Date:
Aug 2007
Location:
Manitou Beach, Michigan
Posts:
357
Plugin Contributions:
0

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 :smile:
Mark

17 May 2012, 8:20 PM
#2
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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)

maperr55:

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 :smile:
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.

17 May 2012, 9:11 PM
#3
maperr55 avatar

maperr55

Zen Follower

Join Date:
Aug 2007
Location:
Manitou Beach, Michigan
Posts:
357
Plugin Contributions:
0

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, :smile:
Mark

17 May 2012, 9:25 PM
#4
maperr55 avatar

maperr55

Zen Follower

Join Date:
Aug 2007
Location:
Manitou Beach, Michigan
Posts:
357
Plugin Contributions:
0

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