500 | Internal Server Error | Doctrine_Query_Exception
Cannot define NULL as part of query when defining 'offset'.
stack trace
- at ()
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php line 2054 ...
- {
- // We should prevent nullable query parts
- if ($queryPart === null) {
- throw new Doctrine_Query_Exception('Cannot define NULL as part of query when defining \'' . $queryPartName . '\'.');
- }
- if ($append) {
- at Doctrine_Query_Abstract->_addDqlQueryPart('offset', null)
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php line 1770 ...
- */
- public function offset($offset)
- {
- return $this->_addDqlQueryPart('offset', $offset);
- }
- /**
- at Doctrine_Query_Abstract->offset(null)
in SF_ROOT_DIR/apps/frontend/modules/publicacao/templates/_producaoAcademica.php line 4 ...
-
- <?php
- $i = 0;
- $producaoAcademica = Doctrine_Query::create()->select()->from('Trabalhos tr')->where('tr.ativo = ?', 1)->andWhere('tr.tipo_id = ?', 2)->orderBy('tr.data_trabalho DESC')->offset($index)->limit(1)->execute();
- foreach ($producaoAcademica as $producao):
- $i++;
- ?>
- at require('/var/www/php72/puc-econ-2019/apps/frontend/modules/publicacao/templates/_producaoAcademica.php')
in SF_ROOT_DIR/lib/vendor/symfony/lib/view/sfPHPView.class.php line 75 ...
- try
- {
- require($_sfFile);
- }
- catch (Exception $e)
- {
- at sfPHPView->renderFile('/var/www/php72/puc-econ-2019/apps/frontend/modules/publicacao/templates/_producaoAcademica.php')
in SF_ROOT_DIR/lib/vendor/symfony/lib/view/sfPartialView.class.php line 124 ...
- $this->getAttributeHolder()->set('sf_type', 'partial');
- // render template
- $retval = $this->renderFile($this->getDirectory().'/'.$this->getTemplate());
- }
- catch (Exception $e)
- {
- at sfPartialView->render()
in SF_ROOT_DIR/lib/vendor/symfony/lib/helper/PartialHelper.php line 218 ...
- $view = new $class($context, $moduleName, $actionName, '');
- $view->setPartialVars(true === sfConfig::get('sf_escaping_strategy') ? sfOutputEscaper::unescape($vars) : $vars);
- return $view->render();
- }
- /**
- at get_partial('producaoAcademica', array('producaoAcademica' => null))
in SF_ROOT_DIR/lib/vendor/symfony/lib/helper/PartialHelper.php line 180 ...
- */
- function include_partial($templateName, $vars = array())
- {
- echo get_partial($templateName, $vars);
- }
- /**
- at include_partial('producaoAcademica', array('producaoAcademica' => null))
in SF_ROOT_DIR/apps/frontend/modules/publicacao/templates/indexSuccess.php line 14 ...
- <!-- <a href="#" title="Leia mais" class="bt-leiamaisbusca">Leia mais</a> -->
- </div>
- <div class="clear"></div>
- <?php include_partial('producaoAcademica', array('producaoAcademica' => $producaoAcademica)); ?>
- </div><!-- .right box-width2 -->
- <div class="full">
- at require('/var/www/php72/puc-econ-2019/apps/frontend/modules/publicacao/templates/indexSuccess.php')
in SF_ROOT_DIR/lib/vendor/symfony/lib/view/sfPHPView.class.php line 75 ...
- try
- {
- require($_sfFile);
- }
- catch (Exception $e)
- {
- at sfPHPView->renderFile('/var/www/php72/puc-econ-2019/apps/frontend/modules/publicacao/templates/indexSuccess.php')
in SF_ROOT_DIR/lib/vendor/symfony/lib/view/sfPHPView.class.php line 185 ...
- $this->attributeHolder->set('sf_type', 'action');
- // render template file
- $content = $this->renderFile($this->getDirectory().'/'.$this->getTemplate());
- if (sfConfig::get('sf_cache') && null !== $uri)
- {
- at sfPHPView->render()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 155 ...
- break;
- case sfView::RENDER_CLIENT:
- $viewData = $view->render();
- $this->context->getResponse()->setContent($viewData);
- break;
- at sfExecutionFilter->executeView('publicacao', 'index', 'Success', array('publicacoes' => object('sfDoctrinePager')))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 116 ...
- return;
- }
- $this->executeView($actionInstance->getModuleName(), $actionInstance->getActionName(), $viewName, $actionInstance->getVarHolder()->getAll());
- }
- /**
- at sfExecutionFilter->handleView(object('sfFilterChain'), object('publicacaoActions'), 'Success')
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 54 ...
- else
- {
- $viewName = $this->handleAction($filterChain, $actionInstance);
- $this->handleView($filterChain, $actionInstance, $viewName);
- }
- }
- at sfExecutionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
- }
- // execute the next filter
- $this->chain[$this->index]->execute($this);
- }
- }
- at sfFilterChain->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfRenderingFilter.class.php line 33 ...
- public function execute($filterChain)
- {
- // execute next filter
- $filterChain->execute();
- // get response object
- $response = $this->context->getResponse();
- at sfRenderingFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
- }
- // execute the next filter
- $this->chain[$this->index]->execute($this);
- }
- }
- at sfFilterChain->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfController.class.php line 238 ...
- }
- // process the filter chain
- $filterChain->execute();
- }
- else
- {
- at sfController->forward('publicacao', 'index')
in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfFrontWebController.class.php line 48 ...
- }
- // make the first request
- $this->forward($moduleName, $actionName);
- }
- catch (sfException $e)
- {
- at sfFrontWebController->dispatch()
in SF_ROOT_DIR/lib/vendor/symfony/lib/util/sfContext.class.php line 170 ...
- */
- public function dispatch()
- {
- $this->getController()->dispatch();
- }
- /**
- at sfContext->dispatch()
in SF_ROOT_DIR/web/index.php line 7 ...
- require_once(dirname(__FILE__) . '/../config/ProjectConfiguration.class.php');
-
- $configuration = ProjectConfiguration::getApplicationConfiguration('frontend', 'prod', true);
- sfContext::createInstance($configuration)->dispatch();
-
symfony settings ...
app_max_results_per_page: 5
mod_publicacao_enabled: true
mod_publicacao_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /var/www/php72/puc-econ-2019/cache/frontend
sf_app_cache_dir: /var/www/php72/puc-econ-2019/cache/frontend/prod
sf_app_config_dir: /var/www/php72/puc-econ-2019/apps/frontend/config
sf_app_dir: /var/www/php72/puc-econ-2019/apps/frontend
sf_app_i18n_dir: /var/www/php72/puc-econ-2019/apps/frontend/i18n
sf_app_lib_dir: /var/www/php72/puc-econ-2019/apps/frontend/lib
sf_app_module_dir: /var/www/php72/puc-econ-2019/apps/frontend/modules
sf_app_template_dir: /var/www/php72/puc-econ-2019/apps/frontend/templates
sf_apps_dir: /var/www/php72/puc-econ-2019/apps
sf_cache: false
sf_cache_dir: /var/www/php72/puc-econ-2019/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /var/www/php72/puc-econ-2019/cache/frontend/prod/config
sf_config_dir: /var/www/php72/puc-econ-2019/config
sf_csrf_secret: UniqueSecret
sf_data_dir: /var/www/php72/puc-econ-2019/data
sf_debug: true
sf_default_culture: en
sf_enable_modules:
- gallery
- photos
sf_enabled_modules:
- default
sf_environment: prod
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 341
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: true
sf_file_link_format: null
sf_i18n: false
sf_i18n_cache_dir: /var/www/php72/puc-econ-2019/cache/frontend/prod/i18n
sf_lib_dir: /var/www/php72/puc-econ-2019/lib
sf_log_dir: /var/www/php72/puc-econ-2019/log
sf_logging_enabled: false
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: /var/www/php72/puc-econ-2019/cache/frontend/prod/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: true
sf_orm: doctrine
sf_plugins_dir: /var/www/php72/puc-econ-2019/plugins
sf_root_dir: /var/www/php72/puc-econ-2019
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
- Partial
- Cache
- I18N
- Date
- Menu
- String
sf_symfony_lib_dir: /var/www/php72/puc-econ-2019/lib/vendor/symfony/lib
sf_template_cache_dir: /var/www/php72/puc-econ-2019/cache/frontend/prod/template
sf_test_cache_dir: /var/www/php72/puc-econ-2019/cache/frontend/prod/test
sf_test_dir: /var/www/php72/puc-econ-2019/test
sf_upload_dir: /var/www/php72/puc-econ-2019/web/uploads
sf_use_database: true
sf_web_debug: false
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/php72/puc-econ-2019/web
uf:
'': Selecione...
AC: Acre
AL: Alagoas
AM: Amazonas
AP: Amapá
BA: Bahia
CE: Ceará
DF: 'Distrito Federal'
ES: 'Espírito Santo'
GO: Goiás
MA: Maranhão
MT: 'Mato Grosso'
MS: 'Mato Grosso do Sul'
MG: 'Minas Gerais'
PA: Pará
PB: Paraíba
PR: Paraná
PE: Pernambuco
PI: Piauí
RJ: 'Rio de Janeiro'
RN: 'Rio Grande do Norte'
RO: Rondônia
RS: 'Rio Grande do Sul'
RR: Roraima
SC: 'Santa Catarina'
SP: 'São Paulo'
SE: Sergipe
TO: Tocantins
request ...
options:
path_info_key: PATH_INFO
path_info_array: SERVER
http_port: null
https_port: null
default_format: null
logging: ''
relative_url_root: null
formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml }
no_script_name: true
parameterHolder:
action: index
module: publicacao
page: busca
pagina: '1'
tipo: '7'
attributeHolder:
sf_route: 'sfRoute Object()'
response ...
status:
code: 500
text: 'Internal Server Error'
options:
http_protocol: HTTP/1.1
logging: ''
charset: utf-8
send_http_headers: true
content_type: 'text/html; charset=utf-8'
cookies: { }
httpHeaders:
Content-Type: 'text/html; charset=utf-8'
javascripts:
jquery-3.3.1.min.js: { }
jquery-1.9.1.min.js: { }
jquery.colorbox.js: { }
script.js: { }
bootstrap.js: { }
owl.carousel.js: { }
stylesheets:
estilos.css: { }
colorbox.css: { }
app.css: { }
metas: { }
httpMetas: { }
options:
auto_shutdown: false
culture: null
default_culture: en
use_flash: true
logging: ''
timeout: 1800
attributeHolder: { }
culture: en
authenticated: false
credentials: { }
lastRequest: 1711679798
global vars ...
cookie: { }
env: { }
files: { }
get:
pagina: '1'
tipo: '7'
post: { }
server:
CONTEXT_DOCUMENT_ROOT: /var/www/php72/puc-econ-2019/web
CONTEXT_PREFIX: ''
DOCUMENT_ROOT: /var/www/php72/puc-econ-2019/web
GATEWAY_INTERFACE: CGI/1.1
HTTPS: on
HTTP_ACCEPT: '*/*'
HTTP_HOST: www.econ.puc-rio.br
HTTP_REFERER: 'https://www.econ.puc-rio.br/index.php/publicacao/busca?tipo=7&pagina=1'
HTTP_USER_AGENT: claudebot
PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
PATH_INFO: /publicacao/busca
PATH_TRANSLATED: 'redirect:/index.php/publicacao/busca/busca'
PHP_SELF: /index.php/publicacao/busca
QUERY_STRING: 'tipo=7&pagina=1'
REDIRECT_HTTPS: on
REDIRECT_QUERY_STRING: 'tipo=7&pagina=1'
REDIRECT_SSL_TLS_SNI: www.econ.puc-rio.br
REDIRECT_STATUS: '200'
REDIRECT_URL: /publicacao/busca
REMOTE_ADDR: 54.173.221.132
REMOTE_PORT: '60628'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1711679798
REQUEST_TIME_FLOAT: 1711679798.848
REQUEST_URI: '/publicacao/busca?tipo=7&pagina=1'
SCRIPT_FILENAME: /var/www/php72/puc-econ-2019/web/index.php
SCRIPT_NAME: /index.php
SERVER_ADDR: 139.82.198.58
SERVER_ADMIN: webmaster@localhost
SERVER_NAME: www.econ.puc-rio.br
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: "<address>Apache/2.4.52 (Ubuntu) Server at www.econ.puc-rio.br Port 443</address>\n"
SERVER_SOFTWARE: 'Apache/2.4.52 (Ubuntu)'
SSL_TLS_SNI: www.econ.puc-rio.br
session: { }