Author Topic: error after manual update 1.1.9 to 1.2.0  (Read 4261 times)

Offline cibalibeb

  • Newbie
  • *
  • Posts: 21
  • Karma: +1/-0
    • View Profile
error after manual update 1.1.9 to 1.2.0
« on: July 05, 2015, 03:50:23 PM »
I just tried to manually update my site from 1.1.9 to 1.2.0 and I am receiving the following error and cannot access my store front end or admin area;

2015-07-05 19:20:33 - database error:  AbanteCart core v.1.1.9 Error: Unknown column 'e.update_date' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT
                    e.extension_id,
                      e.type,
                      e.key,
                      e.category,
                      e.priority,
                      e.version,
                      e.license_key,
                      e.date_installed,
                      e.update_date,
                      e.create_date,
                    s.store_id,
                    st.alias as store_name,
                    s.value as status
            FROM x0h_extensions e
            LEFT JOIN x0h_settings s ON ( TRIM(s.`group`) = TRIM(e.`key`) AND TRIM(s.`key`) = CONCAT(TRIM(e.`key`),'_status') )
            LEFT JOIN x0h_stores st ON st.store_id = s.store_id
            WHERE e.`type`  IN ('extensions', 'payment', 'shipping', 'template', 'language') in <b>/home/teammac2/public_html/cellplatinum.com/core/database/mysql.php</b> on line <b>114</b>

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: error after manual update 1.1.9 to 1.2.0
« Reply #1 on: July 06, 2015, 04:13:46 AM »
did you ran upgrade.sql in phpmyadmin?
There a lot of changes in database structure.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline cibalibeb

  • Newbie
  • *
  • Posts: 21
  • Karma: +1/-0
    • View Profile
Re: error after manual update 1.1.9 to 1.2.0
« Reply #2 on: July 07, 2015, 01:29:01 AM »
yes I modified the upgrade.sql to match my header prefix, it was after this that the issues started

 

Database Error

Please try again. If you come back to this error screen, report the error to an administrator.