1
Support / Error after upgrading
« 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?
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?