14
« on: August 02, 2015, 03:29:35 AM »
It's a long story, but after trying an upgrade, I have zero luck importing backups and mysql dumps etc, so I ended up doing a fresh install of 1.1.9, which seems to work better for me than 1.2. The new install worked okay, and after that I copied my old SQL database into the new database (I had to drop tables in the new database to do this, or it stopped with NULL errors). After copying all old info over into new database, the new install no longer loads, neither website or backend. There is some kind of database error which is in the log file pasted below. Any suggestions on how to at least get my site up with most of my data would be greatly appreciated. Thanks!
2015-08-02 7:14:59 - 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 ab_extensions e
LEFT JOIN ab_settings s ON ( TRIM(s.`group`) = TRIM(e.`key`) AND TRIM(s.`key`) = CONCAT(TRIM(e.`key`),'_status') )
LEFT JOIN ab_stores st ON st.store_id = s.store_id
WHERE e.`type` IN ('extensions', 'payment', 'shipping', 'template', 'language') in <b>/home/user/public_html/core/database/mysql.php</b> on line <b>114</b>