AbanteCart Community

Shopping Cart Operations => Support => Topic started by: madwoolf on April 22, 2015, 09:01:48 AM

Title: Error after upgrading
Post by: madwoolf on April 22, 2015, 09:01:48 AM

Hi,

I have installed AbanteCart 1.1.7 on one of my domains and i tried to make today an upgrade to 1.1.8, but it returned an error an now every time i try to view a product it shows me a n error:

"
There has been an error processing your request
Please check error log for more info. You can check error log in the control panel if it is functional. Otherwise, refer to error log located in your web server
Go to main page
"

In logs the error is as  below:


2015-04-22 12:32:54 - database error:  AbanteCart core v.1.1.7 Error: Unknown column 'd.activate' in 'where clause'<br />Error No: 1054<br />SELECT d.*, dd.*, ptd.*
                           FROM downloads d
                           RIGHT JOIN products_to_downloads ptd ON ptd.download_id = d.download_id
                           LEFT JOIN download_descriptions dd ON d.download_id = dd.download_id AND dd.language_id = '1'
                           WHERE ptd.product_id='118' AND d.activate='before_order' in <b>/home/elenyfashion/public_html/core/database/mysql.php</b> on line <b>114</b>
2015-04-22 12:37:13 - database error:  AbanteCart core v.1.1.7 Error: Unknown column 'd.activate' in 'where clause'<br />Error No: 1054<br />SELECT d.*, dd.*, ptd.*
                           FROM downloads d
                           RIGHT JOIN products_to_downloads ptd ON ptd.download_id = d.download_id
                           LEFT JOIN download_descriptions dd ON d.download_id = dd.download_id AN2015-04-22 12:32:54 - database error:  AbanteCart core v.1.1.7 Error: Unknown column 'd.activate' in 'where clause'<br />Error No: 1054<br />SELECT d.*, dd.*, ptd.*
                           FROM downloads d
                           RIGHT JOIN products_to_downloads ptd ON ptd.download_id = d.download_id
                           LEFT JOIN download_descriptions dd ON d.download_id = dd.download_id AND dd.language_id = '1'
                           WHERE ptd.product_id='118' AND d.activate='before_order' in <b>/home/elenyfashion/public_html/core/database/mysql.php</b> on line <b>114</b>
2015-04-22 12:37:13 - database error:  AbanteCart core v.1.1.7 Error: Unknown column 'd.activate' in 'where clause'<br />Error No: 1054<br />SELECT d.*, dd.*, ptd.*
                           FROM downloads d
                           RIGHT JOIN products_to_downloads ptd ON ptd.download_id = d.dD dd.language_id = '1'
                           WHERE ptd.product_id='121' AND d.activate='before_order' in <b>/home/elenyfashion/public_html/core/database/mysql.php</b> on line <b>114</b>
2015-04-22 12:38:14 - database error:  AbanteCart core v.1.1.7 Error: Unknown column 'd.activate' in 'where clause'<br />Error No: 1054<br />SELECT d.*, dd.*, ptd.*
                           FROM downloads d
                           RIGHT JOIN products_to_downloads ptd ON ptd.download_id = d.download_id
                           LEFT JOIN download_descriptions dd ON d.download_id = dd.download_id AND dd.language_id = '1'
                           WHERE ptd.product_id='111' AND d.activate='before_order' in <b>/home/elenyfashion/public_html/core/database/mysql.php</b> on line <b>114</b>
2015-04-22 12:38:18 - database error:  AbanteCart core v.1.1.7 Error: Unknown column 'd.activate' in 'where clause'<br />Error No: 1054<br />SELECT d.*, dd.*, ptd.*
                           FROM downloads d
                           RIGHT JOIN products_to_downloads ptd ON ptd.download_id = d.download_id

Can you please help me with a solution?

Title: Re: Error after upgrading
Post by: Basara on April 24, 2015, 02:58:18 AM

Restore backup and try manual upgrade http://www.abantecart.com/ecommerce-documentation/user-manual/installation/core-upgrade#Install_manually