500 | Internal Server Error | Exception
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by s.id limit 5' at line 1:select p.id,k.price_uah,s.title as seria_title,m.title as model_title,s.slug as seria_slug,m.slug as model_slug from product p join product_key pk on pk.product_id=p.id join seria s on p.seria_id=s.id join model m on p.model_id=m.id join keytab k on pk.key_id=k.id where p.category_id=2 and pk.product_id in () group by s.id limit 5
stack trace
- at ()
in SF_ROOT_DIR/lib/store.php line 25 ...
- $sql = trim($sql);
- if (empty($sql)) throw new Exception('empty sql');
- $res = parent::query($sql);
- if ($this->errno) throw new Exception($this->error.':'.$sql);
- return $res;
- }
- }
- at Store->query('select p.id,k.price_uah,s.title as seria_title,m.title as model_title,s.slug as seria_slug,m.slug as model_slug from product p join product_key pk on pk.product_id=p.id join seria s on p.seria_id=s.id join model m on p.model_id=m.id join keytab k on pk.key_id=k.id where p.category_id=2 and pk.product_id in () group by s.id limit 5')
in SF_ROOT_DIR/apps/front/modules/product/actions/actions.class.php line 668 ...
- }
- }
- }
- $resp = $this->db->query("select p.id,k.price_uah,s.title as seria_title,m.title as model_title,s.slug as seria_slug,m.slug as model_slug from product p join product_key pk on pk.product_id=p.id join seria s on p.seria_id=s.id join model m on p.model_id=m.id join keytab k on pk.key_id=k.id where p.category_id={$this->category['id']} and pk.product_id in (" . implode(',', $products) . ") group by s.id limit 5");
- if ($resp->num_rows) {
- while ($r = $resp->fetch_assoc()) {
- $key = array();
- at productActions->getTableProducts()
in SF_ROOT_DIR/apps/front/modules/product/actions/actions.class.php line 59 ...
- }
- $this->getTableProducts();
- $breadcrumbs = array(
- at productActions->executeShow(object('dmWebRequest'))
in SF_ROOT_DIR/diem/symfony/lib/action/sfActions.class.php line 60 ...
- }
- // run action
- return $this->$actionToRun($request);
- }
- }
-
- at sfActions->execute(object('dmWebRequest'))
in SF_ROOT_DIR/diem/symfony/lib/filter/sfExecutionFilter.class.php line 92 ...
- {
- // execute the action
- $actionInstance->preExecute();
- $viewName = $actionInstance->execute($this->context->getRequest());
- $actionInstance->postExecute();
- return null === $viewName ? sfView::SUCCESS : $viewName;
- at sfExecutionFilter->executeAction(object('productActions'))
in SF_ROOT_DIR/diem/symfony/lib/filter/sfExecutionFilter.class.php line 78 ...
- }
- }
- return $this->executeAction($actionInstance);
- }
- /**
- at sfExecutionFilter->handleAction(object('sfFilterChain'), object('productActions'))
in SF_ROOT_DIR/diem/symfony/lib/filter/sfExecutionFilter.class.php line 53 ...
- }
- else
- {
- $viewName = $this->handleAction($filterChain, $actionInstance);
- $this->handleView($filterChain, $actionInstance, $viewName);
- }
- }
- at sfExecutionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/diem/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/diem/dmFrontPlugin/lib/filter/dmFrontInitFilter.php line 34 ...
- }
- }
- $filterChain->execute();
- if(!sfConfig::get('dm_internal_page_cached'))
- {
- at dmFrontInitFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/diem/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/diem/dmCorePlugin/plugins/dmUserPlugin/lib/dmRememberMeFilter.class.php line 56 ...
- }
- }
- $filterChain->execute();
- }
- }
-
- at dmRememberMeFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/diem/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/diem/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/diem/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/diem/symfony/lib/controller/sfController.class.php line 232 ...
- }
- // process the filter chain
- $filterChain->execute();
- }
- else
- {
- at sfController->forward('product', 'show')
in SF_ROOT_DIR/diem/symfony/lib/controller/sfFrontWebController.class.php line 50 ...
- // make the first request
- if($actionName!='versionCheck'){
- $this->forward($moduleName, $actionName);
- }
- }
- at sfFrontWebController->dispatch()
in SF_ROOT_DIR/diem/dmCorePlugin/lib/context/dmContext.php line 280 ...
- */
- public function dispatch()
- {
- $this->getController()->dispatch();
- $this->dispatcher->notify(new sfEvent($this, 'dm.context.end'));
- }
- at dmContext->dispatch()
in SF_ROOT_DIR/index.php line 9 ...
- require_once(dirname(__FILE__).'/plugins/cart-zeto/CartZeto.php');
- $configuration = ProjectConfiguration::getApplicationConfiguration('front', 'prod', true);
- date_default_timezone_set('Europe/Kyiv');
- dm::createContext($configuration)->dispatch();
-
symfony settings ...
app_brand: Dell
app_domen: dellparts
app_fb: 'https://www.facebook.com/groups/acerpartscomua/'
app_new_order_email_from: [email protected]
app_new_order_email_to: [email protected]
app_private_key: 6pjmxl4pniyOF3UqJNn4I7PuyuSux4HszVT84Nu5
app_product_per_page: 50
app_public_key: i13428676513
app_search_per_page: 21
app_sfImageTransformPlugin_default_adapter: GD
app_sfImageTransformPlugin_default_image:
mime_type: image/png
filename: Untitled.png
width: 100
height: 100
color: '#FFFFFF'
app_sfImageTransformPlugin_font_dir: /usr/share/fonts/truetype/msttcorefonts
app_sfImageTransformPlugin_mime_type:
auto_detect: false
library: gd_mime_type
app_vk: 'https://vk.com/acer_parts'
app_zeto_private_key: n6QoUyJsjPeQYKwafa82FzieOmsgQgalEdF0a3rH
app_zeto_public_key: i3135315532
dm_accessibility_image_empty_alts: true
dm_admin_asset: dmAdminPlugin
dm_backup_enabled: true
dm_cache_apc: true
dm_cache_dir: /var/domains/dellparts.com.ua/www/cache/dm
dm_context_type: front
dm_core_asset: dmCorePlugin
dm_core_dir: /var/domains/dellparts.com.ua/www/diem/dmCorePlugin
dm_css_compress: true
dm_data_dir: /var/domains/dellparts.com.ua/www/data/dm
dm_debug: false
dm_front_asset: dmFrontPlugin
dm_front_dir: /var/domains/dellparts.com.ua/www/diem/dmFrontPlugin
dm_html_doctype:
name: html
version: 5
compliance: transitional
dm_i18n_catalogue: front
dm_i18n_cultures:
- ru
dm_js_cdn:
enabled: false
lib.jquery: 'http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js'
dm_js_compress: true
dm_js_head_inclusion: { }
dm_locks_enabled: false
dm_locks_timeout: 10
dm_mediaBar_enabled: true
dm_media_default: false
dm_orm_cache_enabled: true
dm_orm_identifier_fields:
- name
- title
- subject
- author
- id
dm_pageBar_enabled: true
dm_performance_enable_mailer: true
dm_performance_page_cache:
enabled: false
life_time: 86400
dm_security_remember_cookie_name: null
dm_security_remember_key_expiration_age: null
dm_seo_truncate:
slug: 255
name: 255
title: 80
h1: 255
description: 160
keywords: 255
dm_seo_use_keywords: true
dm_service_container_base_class: dmFrontBaseServiceContainer
dm_string_transliteration:
¥: Y
µ: u
À: A
Á: A
Â: A
Ã: A
Ä: A
Å: A
Æ: A
Ç: C
È: E
É: E
Ê: E
Ë: E
Ì: I
Í: I
Î: I
Ï: I
Ð: D
Ñ: N
Ò: O
Ó: O
Ô: O
Õ: O
Ö: O
Ø: O
Ù: U
Ú: U
Û: U
Ü: U
Ý: Y
ß: ss
à: a
á: a
â: a
ã: a
ä: a
å: a
æ: a
ç: c
è: e
é: e
ê: e
ë: e
ì: i
í: i
î: i
ï: i
ð: o
ñ: n
ò: o
ó: o
ô: o
õ: o
ö: o
ø: o
ù: u
ú: u
û: u
ü: u
ý: y
ÿ: y
œ: oe
Г: G
Ё: YO
Е: E
Й: Y
И: I
и: i
г: g
ё: yo
№: '#'
е: e
й: y
А: A
Б: B
В: V
Д: D
Ж: ZH
З: Z
К: K
Л: L
М: M
Н: N
О: O
П: P
Р: R
С: S
Т: T
У: U
Ф: F
Х: H
Ц: TS
Ч: CH
Ш: SH
Щ: SCH
Ъ: ''
Ы: YI
Ь: ''
Э: E
Ю: YU
Я: YA
а: a
б: b
в: v
д: d
ж: zh
з: z
к: k
л: l
м: m
н: n
о: o
п: p
р: r
с: s
т: t
у: u
ф: f
х: h
ц: ts
ч: ch
ш: sh
щ: sch
ъ: ''
ы: yi
ь: ''
э: e
ю: yu
я: ya
dm_theming_themes:
Default: { dir: theme, enabled: true }
dm_toolBar_flavour: blue
dm_web_debug_config_fast_dump: true
dm_web_debug_only_html_response: true
dm_web_services_report_anonymous_data: false
dm_web_services_version_check: true
doctrine_model_builder_options:
generateTableClasses: true
baseClassName: myDoctrineRecord
baseTableClassName: myDoctrineTable
suffix: .class.php
mod_product_enabled: true
mod_product_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: front
sf_app_base_cache_dir: /var/domains/dellparts.com.ua/www/cache/front
sf_app_cache_dir: /var/domains/dellparts.com.ua/www/cache/front/prod
sf_app_config_dir: /var/domains/dellparts.com.ua/www/apps/front/config
sf_app_dir: /var/domains/dellparts.com.ua/www/apps/front
sf_app_i18n_dir: /var/domains/dellparts.com.ua/www/apps/front/i18n
sf_app_lib_dir: /var/domains/dellparts.com.ua/www/apps/front/lib
sf_app_module_dir: /var/domains/dellparts.com.ua/www/apps/front/modules
sf_app_template_dir: /var/domains/dellparts.com.ua/www/apps/front/templates
sf_apps_dir: /var/domains/dellparts.com.ua/www/apps
sf_cache: false
sf_cache_dir: /var/domains/dellparts.com.ua/www/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /var/domains/dellparts.com.ua/www/cache/front/prod/config
sf_config_dir: /var/domains/dellparts.com.ua/www/config
sf_csrf_secret: c72e74e674ceeec2ed027933f11b9f984e9be22d
sf_data_dir: /var/domains/dellparts.com.ua/www/data
sf_debug: true
sf_default_culture: ru
sf_enabled_modules:
- dmCodeEditor
- dmFront
- dmInterface
- dmPage
- dmWidget
- dmZone
- dmUser
- dmCore
- dmAuth
sf_environment: prod
sf_error_404_action: 404
sf_error_404_module: error
sf_error_reporting: 4
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: false
sf_etag: true
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: /var/domains/dellparts.com.ua/www/cache/front/prod/i18n
sf_lib_dir: /var/domains/dellparts.com.ua/www/lib
sf_log_dir: /var/domains/dellparts.com.ua/www/log
sf_logging_enabled: false
sf_login_action: signin
sf_login_module: dmUser
sf_module_cache_dir: /var/domains/dellparts.com.ua/www/cache/front/prod/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: true
sf_orm: doctrine
sf_plugins_dir: /var/domains/dellparts.com.ua/www/plugins
sf_root_dir: /var/domains/dellparts.com.ua/www
sf_secure_action: secure
sf_secure_module: dmUser
sf_standard_helpers:
0: Dm
1: DmFront
2: Partial
3: I18N
5: Cache
sf_symfony_lib_dir: /var/domains/dellparts.com.ua/www/diem/symfony/lib
sf_template_cache_dir: /var/domains/dellparts.com.ua/www/cache/front/prod/template
sf_test_cache_dir: /var/domains/dellparts.com.ua/www/cache/front/prod/test
sf_test_dir: /var/domains/dellparts.com.ua/www/test
sf_upload_dir: /var/domains/dellparts.com.ua/www/web/uploads
sf_upload_dir_name: uploads
sf_use_database: true
sf_web_debug: false
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/domains/dellparts.com.ua/www/web
sf_web_images_dir_name: /web
sf_web_images_dir_name_full: 'https://4lenovo.com.ua/web'
sf_web_js_dir_name: web/js
sf_web_uploads_dir_name: /web/uploads/
request ...
options:
path_info_key: PATH_INFO
path_info_array: SERVER
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: show
category: blok-pitaniya
model: x15l-3571els
module: product
seria: xps
sf_culture: uk
attributeHolder:
sf_route: 'sfRequestRoute Object()'
response ...
status:
code: 500
text: 'Internal Server Error'
options:
http_protocol: HTTP/2.0
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: { }
stylesheets: { }
metas: { }
httpMetas: { }
options:
auto_shutdown: false
culture: uk
default_culture: ru
use_flash: true
logging: ''
timeout: 1800
attributeHolder:
symfony/user/sfUser/attributes: { dm_theme: Default }
culture: ru
global vars ...
cookie: { }
env:
CONTENT_LENGTH: ''
CONTENT_TYPE: ''
DOCUMENT_ROOT: /var/domains/dellparts.com.ua/www
DOCUMENT_URI: /index.php
FCGI_ROLE: RESPONDER
GATEWAY_INTERFACE: CGI/1.1
GPG_KEYS: '0BD78B5F97500D450838F95DFE857D9A90D90EC1 6E4F6AB321FDC07F2C332E3AC2BF0BC433CFC8B3'
HOME: /var/www
HOSTNAME: eff0a0f5707b
HTTPS: on
HTTP_ACCEPT: '*/*'
HTTP_ACCEPT_ENCODING: 'gzip, br'
HTTP_CDN_LOOP: cloudflare
HTTP_CF_CONNECTING_IP: 54.224.100.102
HTTP_CF_IPCOUNTRY: US
HTTP_CF_RAY: 86bf7b5b8df31783-IAD
HTTP_CF_VISITOR: '{"scheme":"https"}'
HTTP_HOST: dellparts.com.ua
HTTP_USER_AGENT: claudebot
HTTP_X_FORWARDED_FOR: 54.224.100.102
HTTP_X_FORWARDED_PROTO: https
PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
PATH_INFO: ''
PHPIZE_DEPS: 'autoconf dpkg-dev file g++ gcc libc-dev make pkg-config re2c'
PHP_ASC_URL: 'https://secure.php.net/get/php-5.6.40.tar.xz.asc/from/this/mirror'
PHP_CFLAGS: '-fstack-protector-strong -fpic -fpie -O2'
PHP_CPPFLAGS: '-fstack-protector-strong -fpic -fpie -O2'
PHP_EXTRA_CONFIGURE_ARGS: '--enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data --disable-cgi'
PHP_INI_DIR: /usr/local/etc/php
PHP_LDFLAGS: '-Wl,-O1 -Wl,--hash-style=both -pie'
PHP_MD5: ''
PHP_SELF: /index.php
PHP_SHA256: 1369a51eee3995d7fbd1c5342e5cc917760e276d561595b6052b21ace2656d1c
PHP_URL: 'https://secure.php.net/get/php-5.6.40.tar.xz/from/this/mirror'
PHP_VERSION: 5.6.40
PWD: /var/www/html
QUERY_STRING: ''
REDIRECT_STATUS: '200'
REMOTE_ADDR: 172.70.35.121
REMOTE_PORT: '29646'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1711711344
REQUEST_TIME_FLOAT: 1711711344.1906
REQUEST_URI: /uk/blok-pitaniya/dell/xps/x15l-3571els
SCRIPT_FILENAME: /var/domains/dellparts.com.ua/www//index.php
SCRIPT_NAME: /index.php
SERVER_ADDR: 172.24.2.2
SERVER_NAME: dellparts.com.ua
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/2.0
SERVER_SOFTWARE: nginx/1.21.6
USER: www-data
argc: 0
argv: { }
files: { }
get: { }
post: { }
server:
CONTENT_LENGTH: ''
CONTENT_TYPE: ''
DOCUMENT_ROOT: /var/domains/dellparts.com.ua/www
DOCUMENT_URI: /index.php
FCGI_ROLE: RESPONDER
GATEWAY_INTERFACE: CGI/1.1
GPG_KEYS: '0BD78B5F97500D450838F95DFE857D9A90D90EC1 6E4F6AB321FDC07F2C332E3AC2BF0BC433CFC8B3'
HOME: /var/www
HOSTNAME: eff0a0f5707b
HTTPS: on
HTTP_ACCEPT: '*/*'
HTTP_ACCEPT_ENCODING: 'gzip, br'
HTTP_CDN_LOOP: cloudflare
HTTP_CF_CONNECTING_IP: 54.224.100.102
HTTP_CF_IPCOUNTRY: US
HTTP_CF_RAY: 86bf7b5b8df31783-IAD
HTTP_CF_VISITOR: '{"scheme":"https"}'
HTTP_HOST: dellparts.com.ua
HTTP_USER_AGENT: claudebot
HTTP_X_FORWARDED_FOR: 54.224.100.102
HTTP_X_FORWARDED_PROTO: https
PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
PATH_INFO: ''
PHPIZE_DEPS: 'autoconf dpkg-dev file g++ gcc libc-dev make pkg-config re2c'
PHP_ASC_URL: 'https://secure.php.net/get/php-5.6.40.tar.xz.asc/from/this/mirror'
PHP_CFLAGS: '-fstack-protector-strong -fpic -fpie -O2'
PHP_CPPFLAGS: '-fstack-protector-strong -fpic -fpie -O2'
PHP_EXTRA_CONFIGURE_ARGS: '--enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data --disable-cgi'
PHP_INI_DIR: /usr/local/etc/php
PHP_LDFLAGS: '-Wl,-O1 -Wl,--hash-style=both -pie'
PHP_MD5: ''
PHP_SELF: /index.php
PHP_SHA256: 1369a51eee3995d7fbd1c5342e5cc917760e276d561595b6052b21ace2656d1c
PHP_URL: 'https://secure.php.net/get/php-5.6.40.tar.xz/from/this/mirror'
PHP_VERSION: 5.6.40
PWD: /var/www/html
QUERY_STRING: ''
REDIRECT_STATUS: '200'
REMOTE_ADDR: 172.70.35.121
REMOTE_PORT: '29646'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1711711344
REQUEST_TIME_FLOAT: 1711711344.1906
REQUEST_URI: /uk/blok-pitaniya/dell/xps/x15l-3571els
SCRIPT_FILENAME: /var/domains/dellparts.com.ua/www//index.php
SCRIPT_NAME: /index.php
SERVER_ADDR: 172.24.2.2
SERVER_NAME: dellparts.com.ua
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/2.0
SERVER_SOFTWARE: nginx/1.21.6
USER: www-data
argc: 0
argv: { }
session: { }