Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

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

 
  • Michiel117
  • Junior Member
  • Trial users
  • Join Date: 11-Jun 11
  • 26 posts

Posted 02 August 2012 - 08:53 AM #1

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.

http://telefoongarag...tore.php?secret

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

 
  • Michiel117
  • Junior Member
  • Trial users
  • Join Date: 11-Jun 11
  • 26 posts

Posted 02 August 2012 - 02:10 PM #2

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

 
  • Michiel117
  • Junior Member
  • Trial users
  • Join Date: 11-Jun 11
  • 26 posts

Posted 06 August 2012 - 10:44 PM #3

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

 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 23 May 2016 - 10:15 AM #4

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,



 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3810 posts

Posted 23 May 2016 - 11:19 AM #5

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.


Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20934 posts

Posted 23 May 2016 - 01:47 PM #6

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3365 posts

Posted 23 May 2016 - 01:54 PM #7

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,



 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 24 May 2016 - 04:56 AM #8

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  

 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3810 posts

Posted 24 May 2016 - 05:16 AM #9

 

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.


Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 24 May 2016 - 05:48 AM #10

 

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) 

 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3810 posts

Posted 24 May 2016 - 05:59 AM #11

 

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;

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 24 May 2016 - 06:19 AM #12

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.



 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 24 May 2016 - 10:03 AM #13

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



 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 24 May 2016 - 10:28 AM #14

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 

 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3810 posts

Posted 24 May 2016 - 11:44 AM #15

 

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;

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 06 September 2016 - 07:34 AM #16

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


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20934 posts

Posted 06 September 2016 - 08:00 AM #17

 

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 08 September 2016 - 12:29 PM #18

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.



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20934 posts

Posted 08 September 2016 - 02:13 PM #19

Thank u so much. its working.

 

We are glad to help you


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • nagamahesh22
  • Advanced Member
  • Trial users
  • Join Date: 26-Mar 16
  • 50 posts

Posted 12 September 2016 - 11:30 AM #20

Database (error)
Error: Table 'kramssmart.cscart_category_vendor_product_count' doesn't exist <b>(1146)</b>
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