Jump to content

 

ramon-r

Member Since 25 Sep 2017
Offline Last Active Feb 15 2019 10:41 AM
-----

Posts I've Made

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

14 November 2017 - 09:36 PM

It looks like upgrade was not completed correctly. It is required to examine issue on your server. Try to contact support team


I downloaded the website v4.3.9 . I placed the files in localhost and modified config.local.php and .htaccess files and connected database also setting correctly. After that running in localhost, BUT ...


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

09 November 2017 - 11:04 PM

Site and the admin panel working, but unfortunately, again the error occurred

 

This message is seen in the admin panel​:

PHP Warning
Message
substr_compare(): The start position cannot exceed initial string length
Error at
H:\OSPanel\domains\cscartv439.ross\app\Tygh\Less.php, line: 317

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

09 November 2017 - 10:17 PM

 

Run

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

 

Some problem occurs after perform this query

Tygh\Exceptions\AException
Message
Unknown column 'cscart_categories.is_trash' in 'order clause' (1054)

In my case I 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 this command, the site and the admin panel started working correctly

 

Special Thank's to team eComLabs 


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

08 November 2017 - 10:07 PM

Hi,

I downloaded the website v4.3.9 . I placed the files in localhost and modified config.local.php and .htaccess files and connected database also setting correctly. After that running in localhost, BUT the front end is not displayed and the backend (adminpanel) doesn't open.The message shows "service unavailable".

 

Then I opened the source code of the error page (Ctrl + U) and check the error message

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 = 'ru' WHERE 1 AND cscart_statuses.type = 'O'

Error at

H:\OSPanel\domains\cscartv439.ross\app\Tygh\Database\Connection.php, line: 863
Backtrace

File:	H:\OSPanel\domains\cscartv439.ross\app\Tygh\Database\Connection.php
Line:	458
Function:	error
File:	H:\OSPanel\domains\cscartv439.ross\app\Tygh\Database\Connection.php
Line:	262
Function:	query
File:	H:\OSPanel\domains\cscartv439.ross\app\functions\fn.database.php
Line:	41
Function:	getHash
File:	H:\OSPanel\domains\cscartv439.ross\app\functions\fn.common.php
Line:	3659
Function:	db_get_hash_array
File:	H:\OSPanel\domains\cscartv439.ross\var\cache\templates\backend\c258cb7f61ffdf17ba6f188f2f36fa2ce1f5c905.tygh.styles.tpl.php
Line:	30
Function:	fn_get_statuses
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
Line:	188
Function:	content_5a034712a74bf1_13374851
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_template.php
Line:	304
Function:	fetch
File:	H:\OSPanel\domains\cscartv439.ross\var\cache\templates\backend\6b2addbd8386bf3e753c9ac8ddcf3cce82914e7f.tygh.styles.tpl.php
Line:	42
Function:	getSubTemplate
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
Line:	188
Function:	content_5a0347120c7e98_84050224
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_template.php
Line:	304
Function:	fetch
File:	H:\OSPanel\domains\cscartv439.ross\var\cache\templates\backend\7d05a84c036846308eb42aa1e01f405ed1800c7b.tygh.index.tpl.php
Line:	57
Function:	getSubTemplate
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
Line:	188
Function:	content_5a03471193f2a4_08910341
File:	H:\OSPanel\domains\cscartv439.ross\app\Tygh\SmartyEngine\Core.php
Line:	73
Function:	fetch
File:	H:\OSPanel\domains\cscartv439.ross\app\functions\fn.control.php
Line:	615
Function:	fetch
File:	H:\OSPanel\domains\cscartv439.ross\admin.php
Line:	27
Function:	fn_dispatch

This error means that the status_id field is missed in the cscart_status_descriptions table in my database for some reason (Thanks CS-Cart team)

Run the following SQL query in my phpMyAdmin tool on my server:

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

Same problem is faced after running this Query.

Tygh\Exceptions\AException

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, 17, 18, 19, 20)

Error at

H:\OSPanel\domains\cscartv439.ross\app\Tygh\Database\Connection.php, line: 863
Backtrace

File:	H:\OSPanel\domains\cscartv439.ross\app\Tygh\Database\Connection.php
Line:	458
Function:	error
File:	H:\OSPanel\domains\cscartv439.ross\app\Tygh\Database\Connection.php
Line:	353
Function:	query
File:	H:\OSPanel\domains\cscartv439.ross\app\functions\fn.database.php
Line:	90
Function:	getMultiHash
File:	H:\OSPanel\domains\cscartv439.ross\app\functions\fn.common.php
Line:	3667
Function:	db_get_hash_multi_array
File:	H:\OSPanel\domains\cscartv439.ross\var\cache\templates\backend\c258cb7f61ffdf17ba6f188f2f36fa2ce1f5c905.tygh.styles.tpl.php
Line:	30
Function:	fn_get_statuses
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
Line:	188
Function:	content_5a034712a74bf1_13374851
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_template.php
Line:	304
Function:	fetch
File:	H:\OSPanel\domains\cscartv439.ross\var\cache\templates\backend\6b2addbd8386bf3e753c9ac8ddcf3cce82914e7f.tygh.styles.tpl.php
Line:	42
Function:	getSubTemplate
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
Line:	188
Function:	content_5a0347120c7e98_84050224
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_template.php
Line:	304
Function:	fetch
File:	H:\OSPanel\domains\cscartv439.ross\var\cache\templates\backend\7d05a84c036846308eb42aa1e01f405ed1800c7b.tygh.index.tpl.php
Line:	57
Function:	getSubTemplate
File:	H:\OSPanel\domains\cscartv439.ross\app\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_templatebase.php
Line:	188
Function:	content_5a03471193f2a4_08910341
File:	H:\OSPanel\domains\cscartv439.ross\app\Tygh\SmartyEngine\Core.php
Line:	73
Function:	fetch
File:	H:\OSPanel\domains\cscartv439.ross\app\functions\fn.control.php
Line:	615
Function:	fetch
File:	H:\OSPanel\domains\cscartv439.ross\admin.php
Line:	27
Function:	fn_dispatch

The same field is missed in the cscart_status_data table in database (Thanks CS-Cart team)

Run the following SQL query to fix the issue:

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

Some problem occurs after perform this query

Tygh\Exceptions\AException

Message

Unknown column 'status_id' in 'field list' (1054)
SELECT status_id, email_subj, email_header FROM cscart_ult_status_descriptions WHERE status_id IN ('') AND company_id = 1 AND lang_code = 'ru'

Error at

H:\OSPanel\domains\cscartv439.ross\app\Tygh\Database\Connection.php, line: 863

​​

 

How to resolve these issues? Please help^^.

 

Regards,

 

 

 


In Topic: Установка И/или Перенос На Openserver

08 November 2017 - 04:40 PM

:confused:  :confused:  :confused:  :confused:

Имеются локалки - Denwer, OpenServer, XAMPP

Ставлю поочередно на каждую из локалок чистый cscart v. 4.3.9 - работает успешно как сайт так и админка.

 

Далее удаляю папку cash

и через Notepad ++
1. поиском по БД MySQL (скачанную с работающего сайта) нахожу и меняю ВСЕ значения старого (хостового) домена на новый (локальный) домен, 

2. поиском по файлам сайта значений старого (хостовго) домена не находит

 

Накатываю свою БД на БД ранее установленного чистого cscart v. 4.3.9  - сайт так и админка перестают работать  :-(  (ошибки на скрине)