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\AExceptionMessage
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: 748Backtrace
File:C:\wamp\www\dealmaarlive\app\Tygh\Database.php
Line:359
Function:errorFile:C:\wamp\www\dealmaarlive\app\Tygh\Database.php
Line:208
Function:queryFile:C:\wamp\www\dealmaarlive\app\functions\fn.database.php
Line:66
Function:getFieldFile:C:\wamp\www\dealmaarlive\app\addons\zone\controllers\backend\products.pre.php
Line:34
Function:db_get_fieldFile:C:\wamp\www\dealmaarlive\app\functions\fn.control.php
Line:685
Function:includeFile:C:\wamp\www\dealmaarlive\app\functions\fn.control.php
Line:456
Function:fn_run_controllerFile:C:\wamp\www\dealmaarlive\dmadmin.php
Line:27
Function:fn_dispatch
I find this error
Tygh\Exceptions\AExceptionMessage
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: 748Backtrace
File:C:\wamp\www\dealmaarlive\app\Tygh\Database.php
Line:359
Function:errorFile:C:\wamp\www\dealmaarlive\app\Tygh\Database.php
Line:208
Function:queryFile:C:\wamp\www\dealmaarlive\app\functions\fn.database.php
Line:66
Function:getFieldFile:C:\wamp\www\dealmaarlive\app\addons\zone\controllers\backend\products.pre.php
Line:34
Function:db_get_fieldFile:C:\wamp\www\dealmaarlive\app\functions\fn.control.php
Line:685
Function:includeFile:C:\wamp\www\dealmaarlive\app\functions\fn.control.php
Line:456
Function:fn_run_controllerFile: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)
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