CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema resultadoescrutinio
LINE 1: SELECT * FROM "resultadoescrutinio"."votos_por_mesa" "t" WHE...
^. The SQL statement executed was: SELECT * FROM "resultadoescrutinio"."votos_por_mesa" "t" WHERE id_circuito=1 LIMIT 1

/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/db/CDbCommand.php(541)

529         {
530             if($this->_connection->enableProfiling)
531                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
532 
533             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
534             $message=$e->getMessage();
535             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
536                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
537 
538             if(YII_DEBUG)
539                 $message.='. The SQL statement executed was: '.$this->getText().$par;
540 
541             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
542                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
543         }
544     }
545 
546     /**
547      * Builds a SQL SELECT statement from the given query specification.
548      * @param array $query the query specification in name-value pairs. The following
549      * query options are supported: {@link select}, {@link distinct}, {@link from},
550      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
551      * {@link limit}, {@link offset} and {@link union}.
552      * @return string the SQL statement
553      * @since 1.1.6

Stack Trace

#3
+
 /home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php(53): CActiveRecord->find("id_circuito=1")
48     private function nroMesa($id_circuito,$id_mesa){
49         return VotosPorMesa::model()->find("id_circuito=$id_circuito and id_mesa=$id_mesa")->nro_mesa;
50     }
51 
52     private function nombreCircuito($id_circuito) {
53         $circuito = VotosPorMesa::model()->find("id_circuito=$id_circuito");
54         if (isset($circuito->cicuito)) {
55             return $circuito->cicuito;
56         }
57         return '';
58 //         return VotosPorMesa::model()->find("id_circuito=$id_circuito")->circuito;
#4
+
 /home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php(74): SiteController->nombreCircuito(1)
69         $criteria->select = 'id_partido_politico,partido_politico,sum(votos) as votos';
70 
71         if (empty($id_mesa)){
72             $modo = 'circuito';
73                 
74             $circuito_des = $this->nombreCircuito($id_circuito);
75             $descripcion = 'Resultado Circuito '.$circuito_des;
76             $condition = "id_circuito=$id_circuito";
77 
78         }
79         else {
#5
+
 /home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php(22): SiteController->actionResultadoProvisorio("1")
17                 12 => '#f9e200',  /*ALIANZA SOMOS VILLA REGINA*/                    //AZUL
18                 13 => '#C0C0C0',  /*ALIANZA FRENTE NUEVA CIUDAD*/                    //FUXIA
19         );
20 
21     public function actionViewAll($circuito) {
22         $this->actionResultadoProvisorio($circuito);
23     }
24     
25     public function actionIndex() {
26         return $this->redirect('index.php?r=site/viewall&circuito=1');
27     }
2020-10-21 02:14:51 Apache Yii Framework/1.1.13
Application Log
Timestamp Level Category Message
02:14:51.708534 error system.db.CDbCommand
CDbCommand::fetch() failed: SQLSTATE[42501]: Insufficient privilege: 7
ERROR:  permission denied for schema resultadoescrutinio
LINE 1: SELECT * FROM "resultadoescrutinio"."votos_por_mesa" "t" WHE...
                      ^. The SQL statement executed was: SELECT * FROM
"resultadoescrutinio"."votos_por_mesa" "t" WHERE id_circuito=1 LIMIT 1.
in
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php
(53)
in
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php
(74)
in
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php
(22)
02:14:51.734950 error exception.CDbException
exception 'CDbException' with message 'CDbCommand failed to execute the SQL
statement: SQLSTATE[42501]: Insufficient privilege: 7 ERROR:  permission
denied for schema resultadoescrutinio
LINE 1: SELECT * FROM "resultadoescrutinio"."votos_por_mesa" "t" WHE...
                      ^. The SQL statement executed was: SELECT * FROM
"resultadoescrutinio"."votos_por_mesa" "t" WHERE id_circuito=1 LIMIT 1' in
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/db/CDbCommand.php:541
Stack trace:
#0
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/db/CDbCommand.php(414):
CDbCommand->queryInternal('fetch', Array, Array)
#1
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/db/ar/CActiveRecord.php(1297):
CDbCommand->queryRow()
#2
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/db/ar/CActiveRecord.php(1402):
CActiveRecord->query(Object(CDbCriteria))
#3
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php(53):
CActiveRecord->find('id_circuito=1')
#4
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php(74):
SiteController->nombreCircuito(1)
#5
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/protected/controllers/SiteController.php(22):
SiteController->actionResultadoProvisorio('1')
#6 [internal function]: SiteController->actionViewAll('1')
#7
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/web/actions/CAction.php(108):
ReflectionMethod->invokeArgs(Object(SiteController), Array)
#8
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/web/actions/CInlineAction.php(47):
CAction->runWithParamsInternal(Object(SiteController),
Object(ReflectionMethod), Array)
#9
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/web/CController.php(308):
CInlineAction->runWithParams(Array)
#10
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/web/CController.php(286):
CController->runAction(Object(CInlineAction))
#11
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/web/CController.php(265):
CController->runActionWithFilters(Object(CInlineAction), Array)
#12
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/web/CWebApplication.php(282):
CController->run('viewall')
#13
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/web/CWebApplication.php(141):
CWebApplication->runController('site/viewall')
#14
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/yii/framework/base/CApplication.php(169):
CWebApplication->processRequest()
#15
/home/jusrione/public_html/mail.jusrionegro.gov.ar/inicio/escrutinioprovisorio/index.php(13):
CApplication->run()
#16 {main}
REQUEST_URI=/inicio/escrutinioprovisorio/index.php?r=site/viewall&circuito=1
---