: 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 'order by idproduct' at line 1
In dbw.query() in
select idproduct from product where deleted=0 and idproduct_category = order by idproduct
file: 165 - /home/tomris/public_html/include/lib/error_handler.run.php
call: render_backtrace()
file: -
call: php_error_handler(256, "You have an error in your SQL syntax; check the manual that corr...", "/home/tomris/public_html/include/lib/dbw.class.php", 23, Array(6))
file: 23 - /home/tomris/public_html/include/lib/dbw.class.php
call: trigger_error("You have an error in your SQL syntax; check the manual that corr...", 256)
file: 39 - /home/tomris/public_html/include/lib/dbw.class.php
call: dbw->error_handler("You have an error in your SQL syntax; check the manual that corr...", "select idproduct from product where deleted=0 and idproduct_cate...", Object(dbw))
file: 80 - /home/tomris/public_html/include/lib/dbw.class.php
call: dbw->error_check(False, "query", 1780971859.9385)
file: 191 - /home/tomris/public_html/include/lib/dbw.class.php
call: dbw->query("select idproduct from product where deleted=0 and idproduct_cate...")
file: 186 - /home/tomris/public_html/include/lib/dbw.class.php
call: dbw->fetch_all_array(False, "select idproduct from product where deleted=0 and idproduct_cate...")
file: 170 - /home/tomris/public_html/include/classes/product.class.php
call: dbw->qfetch_all_array("select idproduct from product where deleted=0 and idproduct_cate...")
file: 67 - /home/tomris/public_html/product.php
call: Product->FetchPreviousAndNextIds()
(array) GLOBALS:
*** Avoiding Recursive GLOBALS ***
(array) _POST:
(empty)
(array) _GET:
(string) do = view
(string) id = 164
end.
(array) _COOKIE:
(empty)
(array) _FILES:
(empty)
(array) _SERVER:
(string) HTTP_HOST = www.tomrisleyartist.com
(string) DOCUMENT_ROOT = /home/tomris/public_html
(string) PATH = /usr/local/bin:/usr/bin:/bin
(string) TEMP = /tmp
(string) TMP = /tmp
(string) TMPDIR = /tmp
(string) PWD = /
(string) HTTP_ACCEPT = */*
(string) HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
(string) HTTP_CONNECTION = keep-alive
(string) CONTENT_LENGTH = (none)
(string) HTTP_USER_AGENT = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
(string) HTTP_CACHE_CONTROL = max-age=259200
(string) HTTP_X_FORWARDED_FOR = 10.1.134.55
(string) HTTP_VIA = 1.1 squid-proxy-5b96dc6d46-pggbt (squid/6.13)
(string) REDIRECT_UNIQUE_ID = aid5U7EN28pJsOptlCu_cQAAAkU
(string) REDIRECT_SCRIPT_URL = /product.view.164
(string) REDIRECT_SCRIPT_URI = http://www.tomrisleyartist.com/product.view.164
(string) REDIRECT_STATUS = 200
(string) UNIQUE_ID = aid5U7EN28pJsOptlCu_cQAAAkU
(string) SCRIPT_URL = /product.view.164
(string) SCRIPT_URI = http://www.tomrisleyartist.com/product.view.164
(string) SERVER_SIGNATURE = (none)
(string) SERVER_SOFTWARE = Apache
(string) SERVER_NAME = www.tomrisleyartist.com
(string) SERVER_ADDR = 172.31.40.203
(string) SERVER_PORT = 80
(string) REMOTE_ADDR = 216.73.217.55
(string) REQUEST_SCHEME = http
(string) CONTEXT_PREFIX = (none)
(string) CONTEXT_DOCUMENT_ROOT = /home/tomris/public_html
(string) SERVER_ADMIN = webmaster@tomrisleyartist.com
(string) SCRIPT_FILENAME = /home/tomris/public_html/product.php
(string) REMOTE_PORT = 13153
(string) REDIRECT_URL = /product.view.164
(string) REDIRECT_QUERY_STRING = do=view&id=164
(string) SERVER_PROTOCOL = HTTP/1.1
(string) REQUEST_METHOD = GET
(string) QUERY_STRING = do=view&id=164
(string) REQUEST_URI = /product.view.164
(string) SCRIPT_NAME = /product.php
(string) PHP_SELF = /product.php
(integer) REQUEST_TIME = 1780971859
end.
(array) _REQUEST:
(string) do = view
(string) id = 164
end.
(array) _ENV:
(string) HTTP_HOST = tomrisleyartist.com
(string) DOCUMENT_ROOT = /home/tomris/public_html
(string) PATH = /usr/local/bin:/usr/bin:/bin
(string) TEMP = /tmp
(string) TMP = /tmp
(string) TMPDIR = /tmp
(string) PWD = /
end.
(string) server = live
(NULL) old_error_handler = (none)
(array) _SESSION:
(array) msg:
(array) messages:
(empty)
(array) errors:
(string) 0 = Sorry, that product could not be found.
end.
(array) form_errors:
(empty)
end.
(object) auth:
(object) dbObj:
(resource) dbconn = Resource id #18
(boolean) result = (none)
(string) sql = select idproduct from product where deleted=0 and idproduct_category = order by idproduct
(string) error_string = 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 'order by idproduct' at line 1
In dbw.query()
(string) db_url = mysql://tomris_dbuser:tabkek4@localhost/tomris_db
(array) db_vars:
(string) scheme = mysql
(string) host = localhost
(string) user = tomris_dbuser
(string) pass = tabkek4
(string) path = /tomris_db
(string) database = tomris_db
end.
end.
(object) msgObj:
end.
(array) user:
(boolean) idusr = (none)
(string) username = (none)
(string) passwd = (none)
(string) level = (none)
(string) deleted = (none)
(string) last_login = 0000-00-00 00:00:00
(string) last_ip = (none)
end.
end.
end.
(object) Project:
(object) Db:
end.
(object) Msg:
end.
(object) Auth:
end.
(object) Page:
(string) template_dir = /home/tomris/www/include/templates/
(string) compile_dir = /home/tomris/www/include/templates_c/
(string) config_dir = /home/tomris/www/include/configs/
(array) plugins_dir:
(string) 0 = plugins
end.
(boolean) debugging = (none)
(string) debug_tpl = (none)
(string) debugging_ctrl = NONE
(boolean) compile_check = 1
(boolean) force_compile = (none)
(integer) caching = (none)
(string) cache_dir = /home/tomris/www/include/cache/
(integer) cache_lifetime = 3600
(boolean) cache_modified_check = (none)
(integer) php_handling = (none)
(boolean) security = (none)
(array) secure_dir:
(empty)
(array) security_settings:
(boolean) PHP_HANDLING = (none)
(array) IF_FUNCS:
(string) 0 = array
(string) 1 = list
(string) 2 = isset
(string) 3 = empty
(string) 4 = count
(string) 5 = sizeof
(string) 6 = in_array
(string) 7 = is_array
(string) 8 = true
(string) 9 = false
end.
(boolean) INCLUDE_ANY = (none)
(boolean) PHP_TAGS = (none)
(array) MODIFIER_FUNCS:
(string) 0 = count
end.
(boolean) ALLOW_CONSTANTS = (none)
end.
(array) trusted_dir:
(empty)
(string) left_delimiter = {
(string) right_delimiter = }
(string) request_vars_order = EGPCS
(boolean) request_use_auto_globals = (none)
(NULL) compile_id = (none)
(boolean) use_sub_dirs = 1
(array) default_modifiers:
(empty)
(string) default_resource_type = file
(NULL) cache_handler_func = (none)
(array) global_assign:
(array) HTTP_SERVER_VARS:
(string) 0 = SCRIPT_NAME
end.
end.
(NULL) undefined = (none)
(array) autoload_filters:
(empty)
(boolean) config_overwrite = 1
(boolean) config_booleanize = 1
(boolean) config_read_hidden = (none)
(boolean) config_fix_newlines = 1
(string) default_template_handler_func = (none)
(string) compiler_file = Smarty_Compiler.class.php
(string) compiler_class = Smarty_Compiler
(string) config_class = Config_File
(boolean) _error_msg = (none)
(array) _tpl_vars:
(NULL) SCRIPT_NAME = (none)
(array) includes:
(empty)
(array) includes_script:
(empty)
(array) includes_css:
(empty)
(string) title = (none)
(string) heading = (none)
(object) Project:
end.
(array) product_category_names:
(string) 23 = New Works
(string) 24 = Recent Works
(string) 25 = Sculpture
(string) 26 = Stock Room
end.
(string) base_url = https://www.tomrisleyartist.com/
(string) section = public
(string) gallery_url = /gallery/
(string) thumbs_url = /gallery/thumbs/
end.
(NULL) _smarty_vars = (none)
(array) _sections:
(empty)
(array) _foreach:
(empty)
(array) _tag_stack:
(empty)
(NULL) _conf_obj = (none)
(array) _config:
(array) 0:
*** Avoiding Recursive GLOBALS ***
end.
(string) _smarty_md5 = f8d698aea36fcbead2b9d5359ffca76f
(string) _version = 2.6.0
(integer) _inclusion_depth = (none)
(NULL) _compile_id = (none)
(string) _smarty_debug_id = SMARTY_DEBUG
(array) _smarty_debug_info:
(empty)
(array) _cache_info:
(empty)
(integer) _file_perms = 420
(integer) _dir_perms = 505
(array) _reg_objects:
(empty)
(array) _plugins:
(array) modifier:
(empty)
(array) function:
(empty)
(array) block:
(empty)
(array) compiler:
(empty)
(array) prefilter:
(empty)
(array) postfilter:
(empty)
(array) outputfilter:
(empty)
(array) resource:
(empty)
(array) insert:
(empty)
end.
(array) _cache_serials:
(empty)
(NULL) _cache_include = (none)
(boolean) _cache_including = (none)
end.
end.
(NULL) PHP_SELF = (none)
(object) productCategory:
(object) Project:
end.
(string) Tbl = product_category
(string) TblKey = idproduct_category
(string) Name = product category
(string) NamePl = product categories
(string) NameIA = a
(boolean) NameField = (none)
(string) NameCap = Product category
(boolean) HasAuditFields = (none)
(boolean) Id = (none)
(boolean) Record = (none)
(boolean) Records = (none)
(array) FormFields:
(string) 0 = idparent
(string) 1 = name
end.
(boolean) FormFieldPrefix = (none)
end.
(array) productCategoryNames:
(string) 23 = New Works
(string) 24 = Recent Works
(string) 25 = Sculpture
(string) 26 = Stock Room
end.
(object) product:
(object) Project:
end.
(string) Tbl = product
(string) TblKey = idproduct
(string) Name = product
(string) NamePl = products
(string) NameIA = a
(boolean) NameField = (none)
(string) NameCap = Product
(boolean) HasAuditFields = (none)
(integer) Id = 164
(array) Record:
(NULL) previous_idproduct = (none)
(NULL) next_idproduct = (none)
end.
(boolean) Records = (none)
(array) FormFields:
(string) 0 = idproduct_category
(string) 1 = title
(string) 2 = description
(string) 3 = price
(string) 4 = dimensions
(string) 5 = show_in_rotator
(string) 6 = sold
end.
(boolean) FormFieldPrefix = (none)
end.
(string) do = view
end.