Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default WARNING: An Error occurred, please refresh the page and try again.

    I was upgrading a 1.5.1 install to 1.5.4
    Imported the DB
    Did the DB upgrade fine

    Store page displays this text at the bottom
    WARNING: An Error occurred, please refresh the page and try again.
    Trying to access the admin area I get this
    WARNING: An Error occurred, please refresh the page and try again.
    The resulting debug file contents are
    [14-Mar-2016 21:18:35 America/Chicago] PHP Fatal error: 1062uplicate entry '0' for key 'PRIMARY' :: insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address, gzpost, flagged, attention, severity, logmessage) values (now(), '0', 'login.php ', 'camefrom=index.php', 'my_ip_address', '‹Ž\0', '0', '', 'info', 'Accessed page [login.php]') ==> (as called by) /home/kobrawd/public_html/demo154/mt_admin/includes/functions/database.php on line 53 <== in /home/kobrawd/public_html/demo154/includes/classes/db/mysql/query_factory.php on line 155
    Php V = 5.5.31
    mysql = 5.5.48
    Zen-Venom Get Bitten

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

    Default Re: Can not access admin area

    In a normal configuration, the admin_activity_log table has its primary key set to be the log_id field, which is an auto-incrementing integer field.
    It seems yours is not properly set to be auto-incrementing, for whatever reason.
    .

    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
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Can not access admin area

    DrByte,
    Thank You
    I ran this and can now access
    Code:
    ALTER TABLE admin_activity_log CHANGE COLUMN   log_id  log_id int(15) NOT NULL auto_increment;
    Zen-Venom Get Bitten

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

    Default Re: Can not access admin area

    My bad. I should have said big-integer field.

    The upgrade SQL (since v150) is:

    Code:
    ALTER TABLE admin_activity_log CHANGE COLUMN log_id log_id bigint(15) NOT NULL auto_increment;
    .

    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.

 

 

Similar Threads

  1. v155 WARNING: An Error occurred, please refresh the page and try again
    By riomaha in forum General Questions
    Replies: 3
    Last Post: 16 Aug 2016, 07:31 PM
  2. v151 WARNING: An Error occurred, please refresh the page and try again
    By pramitha in forum General Questions
    Replies: 5
    Last Post: 12 Jul 2016, 10:25 AM
  3. v150 WARNING: An Error occurred, please refresh the page and try again.
    By l3ackdraft in forum Upgrading to 1.5.x
    Replies: 13
    Last Post: 13 Jun 2016, 10:13 PM
  4. v150 WARNING: An Error occurred, please refresh the page and try again.
    By dochsa in forum General Questions
    Replies: 2
    Last Post: 6 Sep 2012, 08:10 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