News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

error after manual update 1.1.9 to 1.2.0

Started by cibalibeb, July 05, 2015, 03:50:23 PM

Previous topic - Next topic

cibalibeb

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>

abolabo

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

cibalibeb

yes I modified the upgrade.sql to match my header prefix, it was after this that the issues started

Forum Rules Code of conduct
AbanteCart.com 2010 -