DB Error: syntax errordb_error Object
(
[error_message_prefix] =>
[mode] => 16
[level] => 1024
[code] => -2
[message] => DB Error: syntax error
[userinfo] => select c1.name, c1.id from bo_category as c1, bo_category as c2 where c1.lft <= c2.lft AND c1.rgt >= c2.rgt AND c2.id = AND c1.parent_id != 0 ORDER BY c1.lft [nativecode=1064 ** 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 'AND c1.parent_id != 0 ORDER BY c1.lft' at line 1]
[backtrace] => Array
(
[0] => Array
(
[file] => /home/caspry/lib/DB.php
[line] => 888
[function] => pear_error
[class] => db_error
[type] => ->
[args] => Array
(
[0] => DB Error: syntax error
[1] => -2
[2] => 16
[3] => errhndl
[4] => select c1.name, c1.id from bo_category as c1, bo_category as c2 where c1.lft <= c2.lft AND c1.rgt >= c2.rgt AND c2.id = AND c1.parent_id != 0 ORDER BY c1.lft [nativecode=1064 ** 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 'AND c1.parent_id != 0 ORDER BY c1.lft' at line 1]
)
)
[1] => Array
(
[file] => /home/caspry/lib/PEAR.php
[line] => 569
[function] => db_error
[class] => db_error
[type] => ->
[args] => Array
(
[0] => -2
[1] => 16
[2] => errhndl
[3] => select c1.name, c1.id from bo_category as c1, bo_category as c2 where c1.lft <= c2.lft AND c1.rgt >= c2.rgt AND c2.id = AND c1.parent_id != 0 ORDER BY c1.lft [nativecode=1064 ** 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 'AND c1.parent_id != 0 ORDER BY c1.lft' at line 1]
)
)
[2] => Array
(
[file] => /home/caspry/lib/DB/common.php
[line] => 1849
[function] => raiseerror
[class] => pear
[type] => ::
[args] => Array
(
[0] =>
[1] => -2
[2] =>
[3] =>
[4] => select c1.name, c1.id from bo_category as c1, bo_category as c2 where c1.lft <= c2.lft AND c1.rgt >= c2.rgt AND c2.id = AND c1.parent_id != 0 ORDER BY c1.lft [nativecode=1064 ** 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 'AND c1.parent_id != 0 ORDER BY c1.lft' at line 1]
[5] => DB_Error
[6] => 1
)
)
[3] => Array
(
[file] => /home/caspry/lib/DB/mysql.php
[line] => 894
[function] => raiseerror
[class] => db_mysql
[type] => ->
[args] => Array
(
[0] => -2
[1] =>
[2] =>
[3] =>
[4] => 1064 ** 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 'AND c1.parent_id != 0 ORDER BY c1.lft' at line 1
)
)
[4] => Array
(
[file] => /home/caspry/lib/DB/mysql.php
[line] => 324
[function] => mysqlraiseerror
[class] => db_mysql
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /home/caspry/lib/DB/common.php
[line] => 1162
[function] => simplequery
[class] => db_mysql
[type] => ->
[args] => Array
(
[0] => select c1.name, c1.id from bo_category as c1, bo_category as c2 where c1.lft <= c2.lft AND c1.rgt >= c2.rgt AND c2.id = AND c1.parent_id != 0 ORDER BY c1.lft
)
)
[6] => Array
(
[file] => /home/caspry/lib/DB/common.php
[line] => 1609
[function] => query
[class] => db_mysql
[type] => ->
[args] => Array
(
[0] => select c1.name, c1.id from bo_category as c1, bo_category as c2 where c1.lft <= c2.lft AND c1.rgt >= c2.rgt AND c2.id = AND c1.parent_id != 0 ORDER BY c1.lft
)
)
[7] => Array
(
[file] => /home/caspry/include/site/set_smarty.php
[line] => 103
[function] => getall
[class] => db_mysql
[type] => ->
[args] => Array
(
[0] => select c1.name, c1.id from bo_category as c1, bo_category as c2 where c1.lft <= c2.lft AND c1.rgt >= c2.rgt AND c2.id = AND c1.parent_id != 0 ORDER BY c1.lft
)
)
[8] => Array
(
[file] => /home/caspry/public_html/index.php
[line] => 24
[function] => get_page_data
[args] => Array
(
[0] => myapp_smarty Object
(
[template_dir] => /home/caspry/templates/
[compile_dir] => /home/caspry/other/compile/
[config_dir] => /home/caspry/conf/
[plugins_dir] => Array
(
[0] => /home/caspry//include/site/smarty_plugins
[1] => /home/caspry//include/general/smarty_plugins
[2] => /home/caspry//lib/smarty/plugins
)
[debugging] =>
[error_reporting] =>
[debug_tpl] =>
[debugging_ctrl] => NONE
[compile_check] => 1
[force_compile] =>
[caching] =>
[cache_dir] => /home/caspry/other/cache/
[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
)
[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] => 1
[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
[site_url] => http://www.castle-pryor.co.uk/
[page_path] => images/flash/available/images/
[page_file] => index
[style_tag] =>
[style_gen_tag] =>
[header_template] => /home/caspry/templates/whole_tpl/header.tpl
[footer_template] => /home/caspry/templates/whole_tpl/footer.tpl
[info_utili] => /home/caspry/templates/whole_tpl/info_utili.tpl
[menu] => /home/caspry/templates/whole_tpl/menu.tpl
[wholesite_images_dir] => /whole_img/
[section_images_dir] => /images/flash/available/images/img/
[wholesite_pages_dir] => /wholesite_pages/
[base_url] => /
[js_dir] => /js/
[query_string] => d=images/flash/available/images/&
[whole_images_dir] => /whole_img/
)
[_smarty_vars] =>
[_sections] => Array
(
)
[_foreach] => Array
(
)
[_tag_stack] => Array
(
)
[_conf_obj] =>
[_config] => Array
(
[0] => Array
(
[vars] => Array
(
)
[files] => Array
(
)
)
)
[_smarty_md5] => f8d698aea36fcbead2b9d5359ffca76f
[_version] => 2.6.7
[_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
(
[info_storage] => Array
(
[0] => infostorage Object
(
[page_path] => images/flash/available/images/
[page_file] => index
[generic_page] =>
)
[1] => Array
(
[0] => getTemplateFile
)
[2] => 1
[3] => 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] =>
)
[1] => db_mysql Object
(
[phptype] => mysql
[dbsyntax] => mysql
[features] => Array
(
[limit] => alter
[new_link] => 4.2.0
[numrows] => 1
[pconnect] => 1
[prepare] =>
[ssl] =>
[transactions] => 1
)
[errorcode_map] => Array
(
[1004] => -15
[1005] => -15
[1006] => -15
[1007] => -5
[1008] => -17
[1022] => -5
[1044] => -26
[1046] => -14
[1048] => -3
[1049] => -27
[1050] => -5
[1051] => -18
[1054] => -19
[1061] => -5
[1062] => -5
[1064] => -2
[1091] => -4
[1100] => -21
[1136] => -22
[1142] => -26
[1146] => -18
[1216] => -3
[1217] => -3
)
[connection] => Resource id #10
[dsn] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => caspry_db
[password] => d1am0nd
[protocol] =>
[hostspec] => localhost
[port] =>
[socket] =>
[database] => caspry_new
)
[autocommit] => 1
[transaction_opcount] => 0
[_db] => caspry_new
[_debug] =>
[_default_error_mode] =>
[_default_error_options] =>
[_default_error_handler] =>
[_error_class] => DB_Error
[_expected_errors] => Array
(
)
[fetchmode] => 2
[fetchmode_object_class] => stdClass
[was_connected] =>
[last_query] => select c1.name, c1.id from bo_category as c1, bo_category as c2 where c1.lft <= c2.lft AND c1.rgt >= c2.rgt AND c2.id = AND c1.parent_id != 0 ORDER BY c1.lft
[options] => Array
(
[result_buffering] => 500
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 4
[optimize] => portability
)
[last_parameters] => Array
(
)
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[prepared_queries] => Array
(
)
)
)
)
)
[callback] => errhndl
)