Phpmyadmin Database Import

General Installation & Upgrade
1

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

Uncaught --> Smarty: Unable to load template tygh 'index.tpl' <-- thrown

Error at

app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php, line: 129

Backtrace

The url is vintageair.net

2

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.

3

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

Uncaught --> Smarty: Unable to load template tygh 'index.tpl' <-- thrown

Error at

app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php, line: 129

Backtrace

The url is vintageair.net

Go to he PHPMyAdmin and checkt the "cscart_categories" table structure.

In your case you should add a new field "is_trash" and it will be:

ALTER TABLE cscart_categories ADD `is_trash` char(1) NOT NULL DEFAULT 'N';

After you run this command this page probably will work, but probably you will face other similar mysql errors.

So the best solution is to compare DB structure between your current version and 4.3.6

4

Is there a way to find out what version cs-cart from the database? I believe it is from 4.3.3 but not totally sure. Can I re-download 4.3.3??

5

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' -->

Anything I can do to correct this?

6

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:

design/themes/YOUR_THEME/templates/index.tpl