vdgcine.com.br

Não foi possível exibir a página solicitada... por favor tente novamente!

SQLSTATE[42601]: Syntax error: 7 ERROR: EXIT cannot be used outside a loop, unless it has a label LINE 14: EXIT; ^ QUERY: DECLARE R CATEGORY%rowtype; FIELDS RECORD; V_ID INTEGER; I_OP ALIAS FOR $1; I_AUX ALIAS FOR $2; I_AUX2 ALIAS FOR $3; I_AUX3 ALIAS FOR $4; BEGIN IF(I_OP = 1) THEN IF(I_AUX2 IS NULL) THEN RETURN; EXIT; ELSE IF(I_AUX2 = 0) THEN IF(I_AUX IS NOT NULL) THEN FOR FIELDS IN SELECT * FROM CATEGORY CAT WHERE CAT.CAT_FK_TYPE = I_AUX AND CAT.CAT_FATHER_ID IS NULL ORDER BY CAT.CAT_ORDER, CAT.CAT_NAME LOOP R = FIELDS; V_ID = FIELDS.CAT_ID; RETURN NEXT R; FOR FIELDS IN SELECT * FROM SP_LIST_CATEGORY(1, I_AUX, V_ID, R.CAT_NAME || ' / ') SP LOOP R = FIELDS; RETURN NEXT R; END LOOP; END LOOP; ELSE FOR FIELDS IN SELECT * FROM CATEGORY CAT WHERE CAT.CAT_FATHER_ID IS NULL ORDER BY CAT.CAT_ORDER, CAT.CAT_NAME LOOP R = FIELDS; V_ID = FIELDS.CAT_ID; RETURN NEXT R; FOR FIELDS IN SELECT * FROM SP_LIST_CATEGORY(1, I_AUX, V_ID, R.CAT_NAME || ' / ') SP LOOP R = FIELDS; RETURN NEXT R; END LOOP; END LOOP; END IF; RETURN; ELSE IF(I_AUX IS NOT NULL) THEN FOR FIELDS IN SELECT * FROM CATEGORY CAT WHERE CAT.CAT_FK_TYPE = I_AUX AND CAT.CAT_FATHER_ID = I_AUX2 ORDER BY CAT.CAT_ORDER, CAT.CAT_NAME LOOP R = FIELDS; R.CAT_NAME = I_AUX3 || FIELDS.CAT_NAME; V_ID = FIELDS.CAT_ID; RETURN NEXT R; FOR FIELDS IN SELECT * FROM SP_LIST_CATEGORY(1, I_AUX, V_ID, R.CAT_NAME || ' / ') SP LOOP R = FIELDS; RETURN NEXT R; END LOOP; END LOOP; ELSE FOR FIELDS IN SELECT * FROM CATEGORY CAT WHERE CAT.CAT_FATHER_ID = I_AUX2 ORDER BY CAT.CAT_ORDER, CAT.CAT_NAME LOOP R = FIELDS; R.CAT_NAME = I_AUX3 || FIELDS.CAT_NAME; V_ID = FIELDS.CAT_ID; RETURN NEXT R; FOR FIELDS IN SELECT * FROM SP_LIST_CATEGORY(1, I_AUX, V_ID, R.CAT_NAME || ' / ') SP LOOP R = FIELDS; RETURN NEXT R; END LOOP; END LOOP; END IF; RETURN; END IF; END IF; END IF; END; CONTEXT: compilation of PL/pgSQL function "sp_list_category" near line 14

Rits_Application::run() /home/storage/8/87/7b/vdgcine/public_html/index.php [34]


28     if(!$session->ok) {        

29         exit;

30     }*/

31     

32     // run application

33     Rits_Application::getInstance()->run();

34 } catch (Exception $e) {            

35     Rits_Exception_Handler::handle($e);

Rits_Application::dispatch() /home/storage/8/87/7b/vdgcine/rits/_library/Rits/Application.php [105]


99      * @return void
100      */
101     public function run ()
102     {
103         // dispatch
104         $this->dispatch();
105     }
106 
107     /**
108      * Dispatches the front controller
109      *

Zend_Controller_Front::dispatch() /home/storage/8/87/7b/vdgcine/rits/_library/Rits/Application.php [139]


133         $front->registerPlugin(new Rits_Controller_Plugin_Settings());
134         $front->registerPlugin(new Rits_Controller_Plugin_Stylesheet());
135         $front->registerPlugin(new Rits_Controller_Plugin_Request());
136 
137         // dispatch
138         $front->dispatch();
139     }
140 
141     /**
142      * Returns the front controller
143      *

Zend_Controller_Dispatcher_Standard::dispatch(object, object) /home/storage/8/87/7b/vdgcine/rits/_library/Zend/Controller/Front.php [954]


948 
949                 /**
950                  * Dispatch request
951                  */
952                 try {
953                     $dispatcher->dispatch($this->_request, $this->_response);
954                 } catch (Exception $e) {
955                     if ($this->throwExceptions()) {
956                         throw $e;
957                     }
958                     $this->_response->setException($e);

Zend_Controller_Action::dispatch(string) /home/storage/8/87/7b/vdgcine/rits/_library/Zend/Controller/Dispatcher/Standard.php [289]


283         if (empty($disableOb)) {
284             ob_start();
285         }
286 
287         try {
288             $controller->dispatch($action);
289         } catch (Exception $e) {
290             // Clean output buffer on error
291             $curObLevel = ob_get_level();
292             if ($curObLevel > $obLevel) {
293                 do {

Blog_DefaultController::listAction() /home/storage/8/87/7b/vdgcine/rits/_library/Zend/Controller/Action.php [513]


507             // preDispatch() didn't change the action, so we can continue
508             if ($this->getInvokeArg('useCaseSensitiveActions') || in_array($action, $this->_classMethods)) {
509                 if ($this->getInvokeArg('useCaseSensitiveActions')) {
510                     trigger_error('Using case sensitive actions without word separators is deprecated; please do not rely on this "feature"');
511                 }
512                 $this->$action();
513             } else {
514                 $this->__call($action, array());
515             }
516             $this->postDispatch();
517         }

Blog_DefaultController::getListCategory() /home/storage/8/87/7b/vdgcine/rits/modules/blog/controllers/DefaultController.php [47]


41     /**
42       * List action
43      */
44     public function listAction ()
45     {
46         $this->getListCategory();
47         $this->getList();
48         $this->content = $this->displayList();
49     }
50     
51     /**

Rits_Database_PreparedStatement::query() /home/storage/8/87/7b/vdgcine/rits/modules/blog/controllers/DefaultController.php [197]


191     
192         $stmt->setString(':CAT_FK_TYPE', $form->getPK());
193         
194         $stmt->setString(':CAT_LANGUAGE', Rits_Locale::getInstance()->toString());
195     
196         $rs = $stmt->query();
197     
198         if($rs->getCount()) {
199             $a_category = array();
200             while($rs->next()) {
201                 $a_category[] = $rs->getRow();

PDOStatement::execute(array) /home/storage/8/87/7b/vdgcine/rits/_library/Rits/Database/PreparedStatement.php [128]


122                 $this->_stmt->bindValue($k, $v);

123             }

124         }

125         

126         // execute

127         if (! $this->_stmt->execute($bind)) {

128             throw new Rits_Database_Exception('Prepared statement error');

129         }

130         

131         return $this->getResultSet($this->_stmt);

132     }