AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: cibalibeb on July 05, 2015, 03:50:23 PM

Title: error after manual update 1.1.9 to 1.2.0
Post by: cibalibeb 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>

Title: Re: error after manual update 1.1.9 to 1.2.0
Post by: abolabo on July 06, 2015, 04:13:46 AM

did you ran upgrade.sql in phpmyadmin?
There a lot of changes in database structure.

Title: Re: error after manual update 1.1.9 to 1.2.0
Post by: cibalibeb 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