ќшибка в SQL запросе!
«апрос:
	Select
						
						data.*,
						documents.parent as _parent,
						documents.sort as sort
						
						
					From
						prefix_documents documents,prefix_ddata_bank data WHERE documents.template = '160' AND 
documents.id = data.id AND 
documents.visible = '1' AND 
documents.parent = '3155' AND 
name LIKE '–Ш%' ORDER BY  documents.sort 

ќтвет сервера:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation 'like'
backtrace:
#0  sql::error(	Select
						
						data.*,
						documents.parent as _parent,
						documents.sort as sort
						
						
					From
						prefix_documents documents,prefix_ddata_bank data WHERE documents.template = '160' AND 
documents.id = data.id AND 
documents.visible = '1' AND 
documents.parent = '3155' AND 
name LIKE '–Ш%' ORDER BY  documents.sort ) called at [/home/u22696/u22696.netangels.ru/www/cms/includes/system/sql.inc.php:108]
#1  sql::query(	Select
						
						data.*,
						documents.parent as _parent,
						documents.sort as sort
						
						
					From
						prname_documents documents,prname_ddata_bank data WHERE documents.template = '160' AND 
documents.id = data.id AND 
documents.visible = '1' AND 
documents.parent = '3155' AND 
name LIKE '–Ш%' ORDER BY  documents.sort ) called at [/home/u22696/u22696.netangels.ru/www/cms/includes/system/sql.inc.php:137]
#2  sql::getRows(	Select
						
						data.*,
						documents.parent as _parent,
						documents.sort as sort
						
						
					From
						prname_documents documents,prname_ddata_bank data WHERE documents.template = '160' AND 
documents.id = data.id AND 
documents.visible = '1' AND 
documents.parent = '3155' AND 
name LIKE '–Ш%' ORDER BY  documents.sort , 1, ) called at [/home/u22696/u22696.netangels.ru/www/cms/includes/utils/DocumentList.inc.php:168]
#3  DocumentList->getDocuments() called at [/home/u22696/u22696.netangels.ru/www/site/plugins/bank/classess/bank.inc.php:107]
#4  bank->showList() called at [/home/u22696/u22696.netangels.ru/www/site/plugins/bank/classess/bank.inc.php:63]
#5  bank->doit() called at [/home/u22696/u22696.netangels.ru/www/site/plugins/bank/classess/bank.inc.php:27]
#6  bank->__construct(start) called at [/home/u22696/u22696.netangels.ru/www/site/components/PluginLauncher.inc.php:27]
#7  PluginLauncher->launchPlugin(Array ([id] => 84,[key] => bank,[name] => Ѕанк,[description] => —правочник банков,[priority] => 0,[launch_templates] => 161,[launch_keys] => )) called at [/home/u22696/u22696.netangels.ru/www/site/components/PluginLauncher.inc.php:14]
#8  PluginLauncher->doit() called at [/home/u22696/u22696.netangels.ru/www/site/Site.inc.php:248]
#9  Site->launchPlugins() called at [/home/u22696/u22696.netangels.ru/www/site/Site.inc.php:66]
#10 Site->__construct() called at [/home/u22696/u22696.netangels.ru/www/index.php:20]

ќшибка в SQL запросе!
«апрос:
	Select
						count(*)
					From
						prefix_documents documents,prefix_ddata_bank data WHERE documents.template = '160' AND 
documents.id = data.id AND 
documents.visible = '1' AND 
documents.parent = '3155' AND 
name LIKE '–Ш%' ORDER BY  documents.sort 

ќтвет сервера:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation 'like'
backtrace:
#0  sql::error(	Select
						count(*)
					From
						prefix_documents documents,prefix_ddata_bank data WHERE documents.template = '160' AND 
documents.id = data.id AND 
documents.visible = '1' AND 
documents.parent = '3155' AND 
name LIKE '–Ш%' ORDER BY  documents.sort ) called at [/home/u22696/u22696.netangels.ru/www/cms/includes/system/sql.inc.php:108]
#1  sql::query(	Select
						count(*)
					From
						prname_documents documents,prname_ddata_bank data WHERE documents.template = '160' AND 
documents.id = data.id AND 
documents.visible = '1' AND 
documents.parent = '3155' AND 
name LIKE '–Ш%' ORDER BY  documents.sort , , , ) called at [/home/u22696/u22696.netangels.ru/www/cms/includes/system/sql.inc.php:55]
#2  sql::result(	Select
						count(*)
					From
						prname_documents documents,prname_ddata_bank data WHERE documents.template = '160' AND 
documents.id = data.id AND 
documents.visible = '1' AND 
documents.parent = '3155' AND 
name LIKE '–Ш%' ORDER BY  documents.sort ) called at [/home/u22696/u22696.netangels.ru/www/cms/includes/utils/DocumentList.inc.php:199]
#3  DocumentList->count() called at [/home/u22696/u22696.netangels.ru/www/site/plugins/bank/classess/bank.inc.php:109]
#4  bank->showList() called at [/home/u22696/u22696.netangels.ru/www/site/plugins/bank/classess/bank.inc.php:63]
#5  bank->doit() called at [/home/u22696/u22696.netangels.ru/www/site/plugins/bank/classess/bank.inc.php:27]
#6  bank->__construct(start) called at [/home/u22696/u22696.netangels.ru/www/site/components/PluginLauncher.inc.php:27]
#7  PluginLauncher->launchPlugin(Array ([id] => 84,[key] => bank,[name] => Ѕанк,[description] => —правочник банков,[priority] => 0,[launch_templates] => 161,[launch_keys] => )) called at [/home/u22696/u22696.netangels.ru/www/site/components/PluginLauncher.inc.php:14]
#8  PluginLauncher->doit() called at [/home/u22696/u22696.netangels.ru/www/site/Site.inc.php:248]
#9  Site->launchPlugins() called at [/home/u22696/u22696.netangels.ru/www/site/Site.inc.php:66]
#10 Site->__construct() called at [/home/u22696/u22696.netangels.ru/www/index.php:20]
—правочник банков - —айт компании ё—  √рупп
+7(343) 290-90-57
г. ≈катеринбург, ул. √орького 39, оф. 100
”слуги —правочна€ информаци€ ќ компании
√лавна€ / —правка /

—правочник банков

√ород
«адайте вопрос
ќтправить
—истема Orphus