Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: error after manual update 1.1.9 to 1.2.0  (Read 3679 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: 2046
  • Karma: +318/-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

 

Powered by SMFPacks Social Login Mod