SEVERE RDB::query() query error
Array
(
[query] =>
SELECT table_name, column_name, data_type, column_default,
CASE is_nullable WHEN 'YES' THEN 1 ELSE 0 END AS is_nullable,
substring(column_default FROM '^nextval\\(\'(.*)\'::regclass\\)') AS sequence_name
FROM information_schema.columns
WHERE table_schema = 'public'
[0] => 42601
[1] => syntax error at or near "("
)
$r
$tpl
$_SESSION
$_POST
$_GET
$_FILES
Array
(
[path] => Array
(
[root] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web
[src] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/src
[tpl] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/tpl
[gfx] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/gfx
[data] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/data
[app] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/app
[lib] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/lib
[rain] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/lib/rain
[smarty] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/lib/smarty
[modules] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules
[module] => Array
(
[root] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/News
[src] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/News/src
[tpl] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/News/tpl
[gfx] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/News/gfx
[data] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/data/News
)
)
[webpath] => Array
(
[root] =>
[server] => http://www.stuscientific.sk
[index] => index.php
[REQUEST_URI] => /news/view/vyskum-a-spolupraca-pre-inovativnu-prax?sessid5df2c01a18efdfa951a52c3425817706=4412e121494d1d7b01e5bd7f93d79617
[src] => /src
[tpl] => /tpl
[gfx] => /gfx
[data] => /data
[app] => /app
[lib] => /lib
[rain] => /lib/rain
[smarty] => /lib/smarty
[modules] => /modules
[page] => news/view/vyskum-a-spolupraca-pre-inovativnu-prax
[module] => Array
(
[root] => /modules/News
[src] => /modules/News/src
[tpl] => /modules/News/tpl
[gfx] => /modules/News/gfx
[data] => /data/News
)
)
[arg] => Array
(
[0] => news
[1] => view
[2] => vyskum-a-spolupraca-pre-inovativnu-prax
)
[ref] => Array
(
[0] => news
[1] => view
[2] => vyskum-a-spolupraca-pre-inovativnu-prax
)
)
RSmarty Object
(
[conf] => Array
(
[global] => Array
(
[email_name] => STU Scientific
[email_address] => info@stuscientific.sk
[reservation_email_name] => Nora Lovászová
[reservation_email] => lovaszova@stuscientific.sk
[info_phone] => +421 907 732 952
[info_email] => info@stuscientific.sk
[google_analytics] => UA-442521-41
[watch_unload] => 0
[blocks_to_load] => Content,Categories
[menu_popup] => 1
[menu_block_hide] => 0
[jpg_quality] => 100
[rl_project] => simpleweb
[pager_otherPagesCount] => 3
[default_timezone] => Europe/Bratislava
[cms_table_width] => 545
)
[Blocks] => Array
(
[positions] => pre_firmy, pre_vedcov, pre_studentov,o_nas,system_zhodnocovania
[styles] =>
[protected_blocks] =>
)
[Categories] => Array
(
)
[Content] => Array
(
[default_article] => 1
[protected_content] =>
[menu] => main,bottom
[menu_main_depth] => 0
[menu_bottom_depth] => 1
[revisions] => 8
[admin_content_pp] => 50
[image_size] => 520
[thumb_size] => 120
[images_pp] => 16
)
[Intro] => Array
(
)
[Lecturers] => Array
(
)
[MediaLibrary] => Array
(
[upload_chunk_size] => 100000
[maximum_total_upload] => -1
[maximum_upload] => -1
[maximum_concurrent_upload] => 1
[maximum_number_to_upload] => -1
[filter_all] => All Files|*.*
[filter_jpeg] => JPEG|*.jpg;*.jpeg
[filter_pdf] => PDF|*.pdf
[filter_zip] => ZIP|*.zip
[filter_doc] => Microsoft Word (DOC, DOCX)|*.doc;*.docx
)
[News] => Array
(
[news_pp] => 8
)
[Seminars] => Array
(
[seminars_pp] => 4
[all_seminars_pp] => 8;
[hladame_lektora_link] =>
)
[User] => Array
(
[forgotten_password] => 1
[timeout] => 3600
[users_pp] => 25
[new_password_expiration] => 24
)
[Stats] => Array
(
[ua_code] => UA-442521-41
[profile] => 35447200
[login] => adwords@triad.sk
[password] => pass4Adwords
)
)
[head] => Array
(
)
[breadcrumbs] => Array
(
)
[displayAlreadyCalled] =>
[templateAlreadyPrepared:RSmarty:private] =>
[template_dir] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/
[compile_dir] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/data/RSmarty/compiled/
[config_dir] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/
[plugins_dir] => Array
(
[0] => plugins
[1] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Blocks/tpl/plugins
[2] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Categories/tpl/plugins
[3] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Content/tpl/plugins
[4] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Intro/tpl/plugins
[5] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Lecturers/tpl/plugins
[6] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/MediaLibrary/tpl/plugins
[7] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/News/tpl/plugins
[8] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Seminars/tpl/plugins
[9] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Tools/tpl/plugins
[10] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/User/tpl/plugins
[11] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Stats/tpl/plugins
[12] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Babel/tpl/plugins
[13] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/modules/Setup/tpl/plugins
[14] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/lib/smarty/rain_plugins
)
[debugging] =>
[error_reporting] =>
[debug_tpl] =>
[debugging_ctrl] => NONE
[compile_check] => 1
[force_compile] => 1
[caching] => 0
[cache_dir] => /data/1/a/1a2cca36-a1ac-47b6-b3a5-a107926c5c06/stuscientific.sk/web/data/RSmarty/cached/
[cache_lifetime] => 3600
[cache_modified_check] =>
[php_handling] => 0
[security] =>
[secure_dir] => Array
(
)
[security_settings] => Array
(
[PHP_HANDLING] =>
[IF_FUNCS] => Array
(
[0] => array
[1] => list
[2] => isset
[3] => empty
[4] => count
[5] => sizeof
[6] => in_array
[7] => is_array
[8] => true
[9] => false
[10] => null
)
[INCLUDE_ANY] =>
[PHP_TAGS] =>
[MODIFIER_FUNCS] => Array
(
[0] => count
)
[ALLOW_CONSTANTS] =>
)
[trusted_dir] => Array
(
)
[left_delimiter] => {
[right_delimiter] => }
[request_vars_order] => EGPCS
[request_use_auto_globals] => 1
[compile_id] =>
[use_sub_dirs] =>
[default_modifiers] => Array
(
)
[default_resource_type] => file
[cache_handler_func] =>
[autoload_filters] => Array
(
)
[config_overwrite] => 1
[config_booleanize] =>
[config_read_hidden] =>
[config_fix_newlines] => 1
[default_template_handler_func] =>
[compiler_file] => Smarty_Compiler.class.php
[compiler_class] => Smarty_Compiler
[config_class] => Config_File
[_tpl_vars] => Array
(
[SCRIPT_NAME] => /index.php
)
[_smarty_vars] =>
[_sections] => Array
(
)
[_foreach] => Array
(
)
[_tag_stack] => Array
(
)
[_conf_obj] => Config_File Object
(
[overwrite] => 1
[booleanize] =>
[read_hidden] =>
[fix_newlines] => 1
[_config_path] =>
[_config_data] => Array
(
[conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
[email_name] => STU Scientific
[email_address] => info@stuscientific.sk
[reservation_email_name] => Nora Lovászová
[reservation_email] => lovaszova@stuscientific.sk
[info_phone] => +421 907 732 952
[info_email] => info@stuscientific.sk
[google_analytics] => UA-442521-41
[watch_unload] => 0
[blocks_to_load] => Content,Categories
[menu_popup] => 1
[menu_block_hide] => 0
[jpg_quality] => 100
[rl_project] => simpleweb
[pager_otherPagesCount] => 3
[default_timezone] => Europe/Bratislava
[cms_table_width] => 545
)
)
[modules/Blocks/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
[positions] => pre_firmy, pre_vedcov, pre_studentov,o_nas,system_zhodnocovania
[styles] =>
[protected_blocks] =>
)
)
[modules/Categories/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
)
)
[modules/Content/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
[default_article] => 1
[protected_content] =>
[menu] => main,bottom
[menu_main_depth] => 0
[menu_bottom_depth] => 1
[revisions] => 8
[admin_content_pp] => 50
[image_size] => 520
[thumb_size] => 120
[images_pp] => 16
)
)
[modules/Intro/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
)
)
[modules/Lecturers/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
)
)
[modules/MediaLibrary/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
[upload_chunk_size] => 100000
[maximum_total_upload] => -1
[maximum_upload] => -1
[maximum_concurrent_upload] => 1
[maximum_number_to_upload] => -1
[filter_all] => All Files|*.*
[filter_jpeg] => JPEG|*.jpg;*.jpeg
[filter_pdf] => PDF|*.pdf
[filter_zip] => ZIP|*.zip
[filter_doc] => Microsoft Word (DOC, DOCX)|*.doc;*.docx
)
)
[modules/News/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
[news_pp] => 8
)
)
[modules/Seminars/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
[seminars_pp] => 4
[all_seminars_pp] => 8;
[hladame_lektora_link] =>
)
)
[modules/User/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
[forgotten_password] => 1
[timeout] => 3600
[users_pp] => 25
[new_password_expiration] => 24
)
)
[modules/Stats/conf/setup.php] => Array
(
[sections] => Array
(
)
[vars] => Array
(
[ua_code] => UA-442521-41
[profile] => 35447200
[login] => adwords@triad.sk
[password] => pass4Adwords
)
)
)
)
[_config] => Array
(
[0] => Array
(
[vars] => Array
(
)
[files] => Array
(
)
)
)
[_smarty_md5] => f8d698aea36fcbead2b9d5359ffca76f
[_version] => 2.6.22
[_inclusion_depth] => 0
[_compile_id] =>
[_smarty_debug_id] => SMARTY_DEBUG
[_smarty_debug_info] => Array
(
)
[_cache_info] => Array
(
)
[_file_perms] => 420
[_dir_perms] => 505
[_reg_objects] => Array
(
)
[_plugins] => Array
(
[modifier] => Array
(
)
[function] => Array
(
)
[block] => Array
(
)
[compiler] => Array
(
)
[prefilter] => Array
(
)
[postfilter] => Array
(
)
[outputfilter] => Array
(
)
[resource] => Array
(
)
[insert] => Array
(
)
)
[_cache_serials] => Array
(
)
[_cache_include] =>
[_cache_including] =>
)
Array
(
[rain] => Array
(
[arg] => Array
(
[0] => news
[1] => view
[2] => vyskum-a-spolupraca-pre-inovativnu-prax
)
)
[user] => Array
(
[user_id] => 0
[user_group_id] => 1
[type] => anonym
)
)
Array
(
)
Array
(
[rain] => news/view/vyskum-a-spolupraca-pre-inovativnu-prax
[mr] => 1
[sessid5df2c01a18efdfa951a52c3425817706] => 4412e121494d1d7b01e5bd7f93d79617
)
Array
(
)
/lib/rain/RDB.php:775, RDB::getArray(...)Array
(
[0] =>
SELECT table_name, column_name, data_type, column_default,
CASE is_nullable WHEN 'YES' THEN 1 ELSE 0 END AS is_nullable,
substring(column_default FROM '^nextval\\(\'(.*)\'::regclass\\)') AS sequence_name
FROM information_schema.columns
WHERE table_schema = 'public'
[1] =>
)
ERROR: syntax error at or near "("
LINE 4: ... substring(column_default FROM '^nextval\\(\'(.*)\'::re...
^
SELECT table_name, column_name, data_type, column_default,
CASE is_nullable WHEN 'YES' THEN 1 ELSE 0 END AS is_nullable,
substring(column_default FROM '^nextval\\(\'(.*)\'::regclass\\)') AS sequence_name
FROM information_schema.columns
WHERE table_schema = 'public'
768
769
770 $this->queryType = "getArray:$associateBy:$groupBy";
771
772 if ($groupBy == null) $groups[0] = array();
773 else $groups = array();
774
775 if ($this->query($query, $showOnly)) {
776
777 if ($this->proxyRole == "client") {
778 return $this->response["data"];
779
780 } else {
781 if (is_array($pager)) {
782 // Pocet vsetkych zaznamov
/lib/rain/RDB.php:1305, RDB::getTableStructure()
1298 if (!$this->tableStructures) {
1299 $this->tableStructures = $this->getArray("
1300 SELECT table_name, column_name, data_type, column_default,
1301 CASE is_nullable WHEN 'YES' THEN 1 ELSE 0 END AS is_nullable,
1302 substring(column_default FROM '^nextval\\\(\'(.*)\'::regclass\\\)') AS sequence_name
1303 FROM information_schema.columns
1304 WHERE table_schema = 'public'
1305 ", false, "column_name", "table_name");
1306
1307 if (R::isProductionMode()) RSession::setAppVar("RDB", "tableStructures",$this->tableStructures);
1308 }
1309
1310 if (!$this->tableStructures[$tableName]) {
1311 throw new RException("[Rain::RDB] Cannot get table structure for table '$tableName'.");
1312 // return array();
/lib/rain/RDataObject.php:311, RDataObject::generateStructure()
304 private function generateStructure() {
305 global $db, $r, $tpl;
306
307 $slnt = RI18N::$silent;
308 RI18N::$silent = true;
309
310 $weight = 0;
311 $tableStructure = $db->getTableStructure($this->tableName);
312
313 $setAlias = false;
314
315 foreach ($tableStructure as $dbColumn) {
316 if (!$this->idColumn) {
317 $this->idColumn = $dbColumn["column_name"];
318 }
/lib/rain/RDataObject.php:183, RDataObject::__construct()
176
177 $this->className = get_class($this);
178 $this->moduleName = substr($this->className, 0, strpos($this->className, "_"));
179 $this->tableName = $this->getTableName();
180
181 $this->beforeInit();
182
183 $this->generateStructure();
184
185 $this->afterInit();
186
187 // ak pouzivame aliasy skontrolujeme ci je zadany platny stlpec
188 if($this->usesAlias && !$this->hasAliasColumn()){
189 throw new RException("You must specify alias source column or remove 'alias' column from your table.");
190 }
/modules/News/src/News.php:53, News::view()
46 $tpl->assign("data", $data);
47 }
48
49
50 protected function view() {
51 global $tpl;
52
53 $dataObject = new News_news();
54 $dataObject->loadByAlias(R::getArg("alias"));
55
56 if ($dataObject->getId()) {
57 $tpl->assign('data', $dataObject);
58 } else {
59 $tpl->showError404();
60 }
/lib/rain/RModule.php:335, RModule::bindMethod()
328 // Ak pouzivame Simple Access Policy, potrebujeme overit, ci ma uzivatel pravo "admin"
329 // pre metody zacinajuce sa na admin*
330 if (($this->simpleAccessPolicy) && (preg_match('/^admin/', R::getMethodName()))) {
331 if (!User::access(R::getModuleName() . ":admin", "message")) return;
332 }
333
334 // Konecne zavolame hladanu metodu a uchovame jej navratovu hodnotu
335 $returnValue = $this->$methodName();
336
337 // Ak nam metoda nevratila explicitne false, skusime najst prislusnu sablonu a zobrazit ju
338 if (($returnValue !== false) && (!$tpl->displayAlreadyCalled)) {
339 $template = R::getPath("modules") . "/" . R::getModuleName() . "/tpl/" . R::getMethodName() . ".tpl";
340 if (file_exists($template)) {
341 $tpl->display($template);
342 }
/modules/News/src/News.php:21, News::show()
14 public function show() {
15 global $db, $tpl;
16
17 Content::$selectedNode = 17;
18
19 $this->setDefaultMethod('listNews');
20 $this->useSimpleAccessPolicy(true);
21 $this->bindMethod();
22 }
23
24
25 public static function registerAliases(){
26 R::registerHiddenArg(__CLASS__, "view", "alias", 0);
27 }
28
/lib/rain/R.php:1463, R::run()
1456
1457 date_default_timezone_set(RConf::get("global",'default_timezone'));
1458
1459 $activeModuleName = R::getModuleName();
1460
1461 if ($activeModuleName) {
1462 self::$moduleInstances[$activeModuleName] = new $activeModuleName();
1463 self::$moduleInstances[$activeModuleName]->show();
1464 }
1465
1466 RModule::raiseEvent('exit');
1467 }
1468
1469
1470 /**
/index.php:132
125 * objekt (triedy R::getModuleName()), ktory je dostupny cez R::getModuleInstance().
126 * Na zaver sa zavola jeho metoda show().
127 */
128
129 R::prepareArgs();
130 R::bindModule();
131
132 R::run();
133
134
135 /*
136 * Statistiky
137 *
138 * Cas generovania stranky, pocet dopytov, spotrebovana pamat
139 */