Error_occured when opening admin panel After upgrade to CSC-P 3.0.2

Today I tried to update my cscart proffesional version 3.0.1 to version 3.0.2 in the adminpanel section under upgrade center. At first the a few add ons didn't work so I attempted to restore with the link given.



[url=“http://telefoongarage.nl/var/upgrade/upgrade_3.0.1_professional-3.0.2_professional.tgz/restore.php?uak=14e947beadfffafe2d1e55b497ce3b99”]http://telefoongarage.nl/var/upgrade/upgrade_3.0.1_professional-3.0.2_professional.tgz/restore.php?secret[/url]



After this restore, my whole site crashed and I'm unable to acces the adminpanel. The restore says it was succesfully. But still gives me the error_occured error when logged into adminpanel.



I think it is an database error but, I cant fix the tables because I can't see which tables are corrupted. How can I fix this? Any help would be much apreciated!



I hope this issue can be fixed because the only thing I tried to do was updating to version 3.0.2 on the normal way. It's might an idea to fix this issue so other people won't get this issue.



Regards and thanks in advance,



Michiel

I solved this problem with restoring a database backup, I could restore this with een alternative link then the domain.com/admin.php link

I was able to restore when going to following link: domain.com/admin.php?dispatch=database.manage and this fixed the error_occured database error

Hi,

I have downloaded live website. I placed files in localhost and modified config.local.php and htpacess files and connected db also setting correctly. After that running in localhost, Front end is displayed But backend (adminpanel) is not opening.The message shows are "SERVICE ENABLE". How to fix it problem and Please help them.

Regards,

naga maehesh bondada,

maheshbondada2@gmail.com,

Hi,

I have downloaded live website. I placed files in localhost and modified config.local.php and htpacess files and connected db also setting correctly. After that running in localhost, Front end is displayed But backend (adminpanel) is not opening.The message shows are "SERVICE ENABLE". How to fix it problem and Please help them.

Regards,

naga maehesh bondada,

maheshbondada2@gmail.com,

Open the source code of the error page (Ctrl+U) and check the error message.

Hi,

I have downloaded live website. I placed files in localhost and modified config.local.php and htpacess files and connected db also setting correctly. After that running in localhost, Front end is displayed But backend (adminpanel) is not opening.The message shows are "SERVICE ENABLE". How to fix it problem and Please help them.

Regards,

naga maehesh bondada,

maheshbondada2@gmail.com,

Most possibly you will see the No store-fronts defined error. It means that there are incorrect website URLs defined for the store-front. Please log in the phpMyAdmin and correct the cscart_companies table

In config.local.php you should have

// Host and directory where software is installed on no-secure server
$config['http_host'] = 'localhost';
$config['http_path'] = '';

// Host and directory where software is installed on secure server
$config[‘https_host’] = ‘localhost’;
$config[‘https_path’] = ‘’;

Delete all in var / cache

Hi,

I have downloaded live website. I placed files in localhost and modified config.local.php and htpacess files and connected db also setting correctly. After that running in localhost, Front end is displayed But backend (adminpanel) is not opening.The message shows are "SERVICE ENABLE". How to fix it problem and Please help them.

Regards,

naga maehesh bondada,

maheshbondada2@gmail.com,

Open the source code of the error page (Ctrl+U) and check the error message.

Hi,

I find this error. Please check the below.

			Tygh\Exceptions\AException 
	
			 
		
			 
	
			 
		
			Message 
	
			 
		
			Unknown column 'cscart_status_descriptions.status_id' in 'on clause' (1054)SELECT cscart_statuses.*, cscart_status_descriptions.* FROM cscart_statuses LEFT JOIN cscart_status_descriptions ON cscart_status_descriptions.status_id = cscart_statuses.status_id AND cscart_status_descriptions.lang_code = 'en' WHERE 1 AND cscart_statuses.type = 'O' 
	
			 
		
			 
	
			 
		
			Error at 
	
			 
		
			C:\wamp\www\kramssmart\app\Tygh\Database\Connection.php, line: 855 
	
			 
		
			 
	
			 
		
			Backtrace 
	
			 
		
			File:C:\wamp\www\kramssmart\app\Tygh\Database\Connection.php
	
			 
		
			Line:454
	
			 
		
			Function:error
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\Tygh\Database\Connection.php
	
			 
		
			Line:259
	
			 
		
			Function:query
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\functions\fn.database.php
	
			 
		
			Line:41
	
			 
		
			Function:getHash
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\functions\fn.common.php
	
			 
		
			Line:3659
	
			 
		
			Function:db_get_hash_array
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\var\cache\templates\backend\4d330c77c4350421cfbf4b99684b983985f554a5.tygh.styles.tpl.php
	
			 
		
			Line:32
	
			 
		
			Function:fn_get_statuses
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
	
			 
		
			Line:375
	
			 
		
			Function:content_5743d9fd6944e7_46775205
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_template.php
	
			 
		
			Line:304
	
			 
		
			Function:fetch
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\var\cache\templates\backend\3ca97f957dfc6a9da52f9c10a06761d682e55402.tygh.styles.tpl.php
	
			 
		
			Line:42
	
			 
		
			Function:getSubTemplate
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
	
			 
		
			Line:375
	
			 
		
			Function:content_5743d9fcd6b299_86192683
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_template.php
	
			 
		
			Line:304
	
			 
		
			Function:fetch
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\var\cache\templates\backend\c3ffcec46eca44532f767d0a15b4b10fba6cd0df.tygh.index.tpl.php
	
			 
		
			Line:56
	
			 
		
			Function:getSubTemplate
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
	
			 
		
			Line:375
	
			 
		
			Function:content_5743d9fcd16362_18297997
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\Tygh\SmartyEngine\Core.php
	
			 
		
			Line:73
	
			 
		
			Function:fetch
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
	
			 
		
			Line:787
	
			 
		
			Function:fetch
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\Tygh\SmartyEngine\Core.php
	
			 
		
			Line:57
	
			 
		
			Function:display
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\app\functions\fn.control.php
	
			 
		
			Line:630
	
			 
		
			Function:display
	
			 
		
			 
	
			 
		
			File:C:\wamp\www\kramssmart\dmadmin.php
	
			 
		
			Line:27
	
			 
		
			Function:fn_dispatch

Hi,

I find this error. Please check the below.

Tygh\Exceptions\AException Message Unknown column 'cscart_status_descriptions.status_id' in 'on clause' (1054)SELECT cscart_statuses.*, cscart_status_descriptions.* FROM cscart_statuses LEFT JOIN cscart_status_descriptions ON cscart_status_descriptions.status_id = cscart_statuses.status_id AND cscart_status_descriptions.lang_code = 'en' WHERE 1 AND cscart_statuses.type = 'O' Error at C:\wamp\www\kramssmart\app\Tygh\Database\Connection.php, line: 855 Backtrace File:C:\wamp\www\kramssmart\app\Tygh\Database\Connection.php Line:454 Function:error File:C:\wamp\www\kramssmart\app\Tygh\Database\Connection.php Line:259 Function:query File:C:\wamp\www\kramssmart\app\functions\fn.database.php Line:41 Function:getHash File:C:\wamp\www\kramssmart\app\functions\fn.common.php Line:3659 Function:db_get_hash_array File:C:\wamp\www\kramssmart\var\cache\templates\backend\4d330c77c4350421cfbf4b99684b983985f554a5.tygh.styles.tpl.php Line:32 Function:fn_get_statuses File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php Line:375 Function:content_5743d9fd6944e7_46775205 File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_template.php Line:304 Function:fetch File:C:\wamp\www\kramssmart\var\cache\templates\backend\3ca97f957dfc6a9da52f9c10a06761d682e55402.tygh.styles.tpl.php Line:42 Function:getSubTemplate File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php Line:375 Function:content_5743d9fcd6b299_86192683 File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_template.php Line:304 Function:fetch File:C:\wamp\www\kramssmart\var\cache\templates\backend\c3ffcec46eca44532f767d0a15b4b10fba6cd0df.tygh.index.tpl.php Line:56 Function:getSubTemplate File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php Line:375 Function:content_5743d9fcd16362_18297997 File:C:\wamp\www\kramssmart\app\Tygh\SmartyEngine\Core.php Line:73 Function:fetch File:C:\wamp\www\kramssmart\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php Line:787 Function:fetch File:C:\wamp\www\kramssmart\app\Tygh\SmartyEngine\Core.php Line:57 Function:display File:C:\wamp\www\kramssmart\app\functions\fn.control.php Line:630 Function:display File:C:\wamp\www\kramssmart\dmadmin.php Line:27 Function:fn_dispatch

This error means that the status_id

field is missed in the cscart_status_descriptions table in your database for some reason. Run the following SQL query in your phpMyAdmin tool on your server:

ALTER TABLE `cscart_status_descriptions` ADD `status_id` MEDIUMINT(8) NOT NULL;

Please make full backup of your store database before executing this SQL query.

This error means that the status_id field is missed in the cscart_status_descriptions table in your database for some reason. Run the following SQL query in your phpMyAdmin tool on your server:

ALTER TABLE `cscart_status_descriptions` ADD `status_id` MEDIUMINT(8) NOT NULL;

Please make full backup of your store database before executing this SQL query.

Same problem is faced after running this Query.

Error message:

			Message 
	
			 
		
			

Unknown column 'status_id' in 'field list' (1054)SELECT status_id, param, value FROM cscart_status_data WHERE status_id IN (1, 2, 3, 4, 5, 6, 7, 16)

Message Unknown column 'status_id' in 'field list' (1054)SELECT status_id, param, value FROM cscart_status_data WHERE status_id IN (1, 2, 3, 4, 5, 6, 7, 16)

Same problem is faced after running this Query.

Error message:

Message

Unknown column 'status_id' in 'field list' (1054)SELECT status_id, param, value FROM cscart_status_data WHERE status_id IN (1, 2, 3, 4, 5, 6, 7, 16)

Message Unknown column 'status_id' in 'field list' (1054)SELECT status_id, param, value FROM cscart_status_data WHERE status_id IN (1, 2, 3, 4, 5, 6, 7, 16)

The same field is missed in the cscart_status_data table in your database. Run the following SQL query to fix the issue:

ALTER TABLE `cscart_status_data` ADD `status_id` MEDIUMINT(8) NOT NULL;

Thank u so much its working.

The same field is missed in the cscart_status_data table in your database. Run the following SQL query to fix the issue:

ALTER TABLE `cscart_status_data` ADD `status_id` MEDIUMINT(8) NOT NULL;

Thank u so much for helping me.its working.

I want to change logo. I am opening theme editor should display error message"Service enable". How to fix it problem.

I want to change logo. I am opening theme editor should display error message"Service enable". How to fix it problem.

I find this error.

			Message 
	
			 
		
			Unknown column 'cscart_shipping_descriptions.description' in 'field list' (1054)SELECT cscart_shippings.shipping_id, cscart_shipping_descriptions.shipping, cscart_shipping_descriptions.delivery_time, cscart_shipping_descriptions.description, cscart_shippings.rate_calculation, cscart_shippings.service_params, cscart_shippings.destination, cscart_shippings.min_weight, cscart_shippings.max_weight, cscart_shippings.service_id, cscart_shippings.free_shipping, cscart_shipping_services.module, cscart_shipping_services.code as service_code FROM cscart_shippings LEFT JOIN cscart_shipping_descriptions ON cscart_shippings.shipping_id = cscart_shipping_descriptions.shipping_id LEFT JOIN cscart_shipping_services ON cscart_shipping_services.service_id = cscart_shippings.service_id WHERE cscart_shippings.status = 'A' AND cscart_shippings.shipping_id IN (1) AND (cscart_shippings.min_weight = 129 OR cscart_shippings.max_weight = 0.00)) AND cscart_shipping_descriptions.lang_code = 'en' ORDER BY cscart_shippings.position 

I find this error.

Message Unknown column 'cscart_shipping_descriptions.description' in 'field list' (1054)SELECT cscart_shippings.shipping_id, cscart_shipping_descriptions.shipping, cscart_shipping_descriptions.delivery_time, cscart_shipping_descriptions.description, cscart_shippings.rate_calculation, cscart_shippings.service_params, cscart_shippings.destination, cscart_shippings.min_weight, cscart_shippings.max_weight, cscart_shippings.service_id, cscart_shippings.free_shipping, cscart_shipping_services.module, cscart_shipping_services.code as service_code FROM cscart_shippings LEFT JOIN cscart_shipping_descriptions ON cscart_shippings.shipping_id = cscart_shipping_descriptions.shipping_id LEFT JOIN cscart_shipping_services ON cscart_shipping_services.service_id = cscart_shippings.service_id WHERE cscart_shippings.status = 'A' AND cscart_shippings.shipping_id IN (1) AND (cscart_shippings.min_weight = 129 OR cscart_shippings.max_weight = 0.00)) AND cscart_shipping_descriptions.lang_code = 'en' ORDER BY cscart_shippings.position

The description

field is missed in the cscart_shipping_descriptions table in your database. Run the following SQL query to fix the issue:

ALTER TABLE `cscart_shipping_descriptions` ADD `description` MEDIUMTEXT NOT NULL;

I find this error

Tygh\Exceptions\AException

Message
Table ‘dealmaarprod.cscart_orderfullfill_by’ doesn’t exist (1146) select ofb.orderfullfill_by from cscart_orderfullfill_by as ofb where ofb.company_id = ‘0’

Error at
C:\wamp\www\dealmaarlive\app\Tygh\Database.php, line: 748

Backtrace
File:C:\wamp\www\dealmaarlive\app\Tygh\Database.php
Line:359
Function:error

File:C:\wamp\www\dealmaarlive\app\Tygh\Database.php
Line:208
Function:query

File:C:\wamp\www\dealmaarlive\app\functions\fn.database.php
Line:66
Function:getField

File:C:\wamp\www\dealmaarlive\app\addons\zone\controllers\backend\products.pre.php
Line:34
Function:db_get_field

File:C:\wamp\www\dealmaarlive\app\functions\fn.control.php
Line:685
Function:include

File:C:\wamp\www\dealmaarlive\app\functions\fn.control.php
Line:456
Function:fn_run_controller

File:C:\wamp\www\dealmaarlive\dmadmin.php
Line:27
Function:fn_dispatch

I find this error

Tygh\Exceptions\AException

Message
Table ‘dealmaarprod.cscart_orderfullfill_by’ doesn’t exist (1146) select ofb.orderfullfill_by from cscart_orderfullfill_by as ofb where ofb.company_id = ‘0’

Error at
C:\wamp\www\dealmaarlive\app\Tygh\Database.php, line: 748

Backtrace
File:C:\wamp\www\dealmaarlive\app\Tygh\Database.php
Line:359
Function:error

File:C:\wamp\www\dealmaarlive\app\Tygh\Database.php
Line:208
Function:query

File:C:\wamp\www\dealmaarlive\app\functions\fn.database.php
Line:66
Function:getField

File:C:\wamp\www\dealmaarlive\app\addons\zone\controllers\backend\products.pre.php
Line:34
Function:db_get_field

File:C:\wamp\www\dealmaarlive\app\functions\fn.control.php
Line:685
Function:include

File:C:\wamp\www\dealmaarlive\app\functions\fn.control.php
Line:456
Function:fn_run_controller

File:C:\wamp\www\dealmaarlive\dmadmin.php
Line:27
Function:fn_dispatch

Please disable the module which is called similar to "Zone". It uses non-standard table cscart_orderfullfill_by, which does not exist now

Please disable the module which is called similar to "Zone". It uses non-standard table cscart_orderfullfill_by, which does not exist now

Thank u so much. its working.

Thank u so much. its working.

We are glad to help you

Database (error)
Error: Table 'kramssmart.cscart_category_vendor_product_count' doesn't exist (1146)
Query: DELETE FROM cscart_category_vendor_product_count WHERE category_id IN(2095)

Backtrace››

C:\wamp\www\kramssmart\dmadmin.php (fn_dispatch): 27
C:\wamp\www\kramssmart\app\functions\fn.control.php (fn_run_controller): 453
C:\wamp\www\kramssmart\app\functions\fn.control.php (include): 699
C:\wamp\www\kramssmart\app\controllers\backend\products.php (fn_update_product): 70
C:\wamp\www\kramssmart\app\functions\fn.catalog.php (fn_update_product_categories): 2509
C:\wamp\www\kramssmart\app\functions\fn.catalog.php (fn_update_product_count): 9550
C:\wamp\www\kramssmart\app\functions\fn.catalog.php (fn_set_hook): 2695
C:\wamp\www\kramssmart\app\functions\fn.control.php (call_user_func_array): 127
C:\wamp\www\kramssmart\app\functions\fn.multivendor.php (fn_mve_update_product_count_post): 163
C:\wamp\www\kramssmart\app\functions\fn.database.php (call_user_func_array): 129
C:\wamp\www\kramssmart\app\Tygh\Database\Connection.php (query): 454