Error 500

CDbCommand не удалось исполнить SQL-запрос: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
X
Application Log
Timestamp Level Category Message
10:14:14.551752 error system.db.CDbCommand
Не удалось выполнить CDbCommand::(): SQLSTATE[21000]:
Cardinality violation: 1242 Subquery returns more than 1 row.
Выполнявшийся SQL-запрос: SELECT Autocredit.*,
MIN(Autocredit_tab.Rate) AS Rate, IF(LENGTH(Autocredit.Oformit)>0, 0, 1) AS
SortOformit FROM Autocredit, Autocredit_tab WHERE Autocredit.Id =
Autocredit_tab.Autocredit_Id AND Bank_Id = (SELECT Id FROM Bank WHERE
Translit='moneyman') AND (Bank_Id=79 OR Bank_Id IN (SELECT DISTINCT Bank_Id
FROM Office WHERE Office.City_Id = (SELECT Id FROM City WHERE
Translit='zaim-ot-moneyman') AND (Office.Type='Отделение' OR
Office.Type='Головной офис'))) GROUP BY
Autocredit_tab.Autocredit_Id ORDER BY SortOformit, Rate.
10:14:14.551947 error exception.CDbException
CDbException: CDbCommand не удалось исполнить
SQL-запрос: SQLSTATE[21000]: Cardinality violation: 1242 Subquery
returns more than 1 row in /var/www/bai.old/framework/db/CDbCommand.php:528
Stack trace:
#0 /var/www/bai.old/framework/db/CDbCommand.php(372):
CDbCommand->queryInternal()
#1
/var/www/bai.old/protected/modules/avtokredity/controllers/DefaultController.php(941):
CDbCommand->query()
#2
/var/www/bai.old/protected/modules/avtokredity/controllers/DefaultController.php(338):
DefaultController->cList()
#3 [internal function]: DefaultController->actionIndex()
#4 /var/www/bai.old/framework/web/actions/CAction.php(107):
ReflectionMethod->invokeArgs()
#5 /var/www/bai.old/framework/web/actions/CInlineAction.php(48):
CAction->runWithParamsInternal()
#6 /var/www/bai.old/framework/web/CController.php(309):
CInlineAction->runWithParams()
#7 /var/www/bai.old/framework/web/CController.php(287):
CController->runAction()
#8 /var/www/bai.old/framework/web/CController.php(266):
CController->runActionWithFilters()
#9 /var/www/bai.old/framework/web/CWebApplication.php(276):
CController->run()
#10 /var/www/bai.old/framework/web/CWebApplication.php(135):
CWebApplication->runController()
#11 /var/www/bai.old/framework/base/CApplication.php(162):
CWebApplication->processRequest()
#12 /var/www/bai.old/index.php(21): CApplication->run()
#13 {main}
REQUEST_URI=/avtokredity/moneyman/zaim-ot-moneyman/
---