Forums / Upgrading to 1.5.x / zcInstallDEBUG-xx.log Can't DROP 'page_accessed'; check that column/key exists

zcInstallDEBUG-xx.log Can't DROP 'page_accessed'; check that column/key exists

Views: 994

Results 1 to 4 of 4
28 Mar 2016, 6:48 PM
#1
vdecals avatar

vdecals

Zen Follower

Join Date:
Jun 2009
Location:
Sparta, TN
Posts:
166
Plugin Contributions:
0

zcInstallDEBUG-xx.log Can't DROP 'page_accessed'; check that column/key exists

I'm in testing mode, in a sub-directory, with plan to upgrade my Zen-Cart from 1.3.9h to 1.5.5 (03-24-2016 zip).

I checked my logs and found only this throughout testing:

[27-Mar-2016 14:59:50 America/New_York] MySQL error 1091 encountered during zc_install:
Can't DROP 'page_accessed'; check that column/key exists
ALTER TABLE admin_activity_log DROP INDEX page_accessed;
---------------


[27-Mar-2016 14:59:50 America/New_York] MySQL error 1091 encountered during zc_install:
Can't DROP 'access_date'; check that column/key exists
ALTER TABLE admin_activity_log DROP INDEX access_date;
---------------


[27-Mar-2016 14:59:50 America/New_York] MySQL error 1061 encountered during zc_install:
Duplicate key name 'idx_page_accessed_zen'
ALTER TABLE admin_activity_log ADD INDEX idx_page_accessed_zen (page_accessed);
---------------


[27-Mar-2016 14:59:50 America/New_York] MySQL error 1061 encountered during zc_install:
Duplicate key name 'idx_access_date_zen'
ALTER TABLE admin_activity_log ADD INDEX idx_access_date_zen (access_date);
---------------

mc12345678 posted the same install error on page 42 #412 in forum FEEDBACK ON BETA of v1.5.5, but I could not find further information.
Can someone tell me what, if anything, I need to/should do?

Thank you so very much!

My store - closed 12/05/2023
1.5.7d (upgraded from 1.5.7b), clone a template (cloned Responsive Classic Template), Sitemap XML v4.0, Square WebPay, PayPal Express Checkout, PHP Version: 7.4.29 (Zend: 3.4.0)

28 Mar 2016, 6:52 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: zcInstallDEBUG-xx.log Can't DROP 'page_accessed'; check that column/key exists

You can ignore these for sure as it is just information that the key already exists

[27-Mar-2016 14:59:50 America/New_York] MySQL error 1091 encountered during zc_install:
Can't DROP 'page_accessed'; check that column/key exists
ALTER TABLE admin_activity_log DROP INDEX page_accessed;
---------------

[27-Mar-2016 14:59:50 America/New_York] MySQL error 1091 encountered during zc_install:
Can't DROP 'access_date'; check that column/key exists
ALTER TABLE admin_activity_log DROP INDEX access_date;

I am not so sure about the other 2???
But it appears that it was allowed and just reporting the initial error due to the last statements

ALTER TABLE admin_activity_log ADD INDEX idx_page_accessed_zen (page_accessed);

ALTER TABLE admin_activity_log ADD INDEX idx_access_date_zen (access_date);

Zen-Venom Get Bitten

28 Mar 2016, 6:58 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: zcInstallDEBUG-xx.log Can't DROP 'page_accessed'; check that column/key exists

Those 4 particular statements are just cleanups to get old schemas in sync with the new.
Nothing to worry about.

If you want, you can go into your tables and double-check that things it was trying to add or drop are already added or dropped.

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

28 Mar 2016, 8:45 PM
#4
vdecals avatar

vdecals

Zen Follower

Join Date:
Jun 2009
Location:
Sparta, TN
Posts:
166
Plugin Contributions:
0

Re: zcInstallDEBUG-xx.log Can't DROP 'page_accessed'; check that column/key exists

Thank you Kobra & DrByte.
I'm understanding more everyday!

My store - closed 12/05/2023
1.5.7d (upgraded from 1.5.7b), clone a template (cloned Responsive Classic Template), Sitemap XML v4.0, Square WebPay, PayPal Express Checkout, PHP Version: 7.4.29 (Zend: 3.4.0)