I am working on setting up a fresh install and want to import the database that I exported from a different install. the issue is I am not sure what the older version was as all the files are gone. I believe it was in the 4.2.x or 4.3.x range. I goth the install all up and running and then did the import and things broke. When I try and go to Products in the back end I get the following:
Tygh\Exceptions\AException
Message
Unknown column 'cscart_categories.is_trash' in 'order clause' (1054)
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.product_count,cscart_categories.company_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE 1 AND cscart_categories.company_id = 1 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
Error at
app/Tygh/Database.php, line: 748
When I try to load the front page I get the following:
PHP Fatal Error
Message
In most cases, you cannot import data bases from older versions to a newer version without experiencing issues because there are various changes made to the data base with each upgrade.
I would suggest either doing the incremental upgrades or using the store import addon.
I am working on setting up a fresh install and want to import the database that I exported from a different install. the issue is I am not sure what the older version was as all the files are gone. I believe it was in the 4.2.x or 4.3.x range. I goth the install all up and running and then did the import and things broke. When I try and go to Products in the back end I get the following:
Tygh\Exceptions\AException Message
Unknown column 'cscart_categories.is_trash' in 'order clause' (1054)
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.product_count,cscart_categories.company_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE 1 AND cscart_categories.company_id = 1 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
Error at
app/Tygh/Database.php, line: 748
When I try to load the front page I get the following: PHP Fatal Error Message
imac, thanks for the help. I was able to get the 4.3.3 re-installed and all the admin functions seem to be working. The only issue I seem to have at this point is the store front end is giving the the following error.
Sorry, service is temporarily unavailable.
Smarty: Unable to load template tygh 'index.tpl' -->
Looks like the theme was not installed correctly. Please make sure that there is active theme on the Design -> Themes page and the following file on the place: