General Error
/index.php?type=prod&sort_column=1&sort_order=ascError on Query
Debug:
#1 trigger_error ([0] => Error on Query, [1] => 256) called at [/data/http/history/inc/database.php:108]
#2 Data_Base->Query ([0] => SELECT * FROM contact_settings WHERE contact_id = AND `option` = "products" LIMIT 0,1) called at [/data/http/history/inc/database.php:166]
#3 Data_Base->Execute ([0] => SELECT * FROM contact_settings WHERE contact_id = AND `option` = "products" LIMIT 0,1) called at [/data/http/history/inc/database.php:208]
#4 Data_Base->Read_Record ([0] => contact_settings, [1] => contact_id = AND `option` = "products", [2] =>) called at [/data/http/history/inc/database.php:172]
#5 Data_Base->Read_Field ([0] => id_contact_settings, [1] => contact_settings, [2] => contact_id = AND `option` = "products") called at [/data/http/history/inc/data_browser.php:504]
#6 Data_Browser->Write_Settings () called at [/data/http/history/inc/data_browser.php:1386]
#7 Data_Browser->Render () called at [/data/http/history/index.php:76]
SQL Queries:
Array
(
[0] => SELECT * FROM config WHERE id_config = 'core' LIMIT 0,1
[1] => SELECT id_sessions id FROM sessions WHERE last_change < 1695922754
[2] => DELETE FROM sessions WHERE last_change < 1695922754
[3] => UPDATE sessions SET last_change = 1695923654.7125, info = "Browsing Product Definitions", admin_info = "", contact_id = 0, name = "", agent = "CCBot/2.0 (https://commoncrawl.org/faq/)", url = "/index.php?type=prod&sort_column=1&sort_order=asc" WHERE id = "g8evqkj53ggeso045t4abglhk2"
[4] => INSERT INTO sessions SET last_change = 1695923654.7125, info = "Browsing Product Definitions", admin_info = "", url = "/index.php?type=prod&sort_column=1&sort_order=asc", id = "g8evqkj53ggeso045t4abglhk2", start_time = 1695923654, contact_id = 0, name = "", agent = "CCBot/2.0 (https://commoncrawl.org/faq/)", contact_ip = "44.197.111.121"
[5] => SELECT COUNT(*) res FROM sessions WHERE contact_id = 0
[6] => SELECT COUNT(*) res FROM sessions
[7] => SELECT * FROM contact_settings WHERE contact_id = AND `option` = "products" LIMIT 0,1
)
SQL Error:
Array
(
[message] => 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 `option` = "products" LIMIT 0,1' at line 1
[code] => 1064
)
Debug:
#1 trigger_error ([0] => Error on Query, [1] => 256) called at [/data/http/history/inc/database.php:108]
#2 Data_Base->Query ([0] => SELECT * FROM contact_settings WHERE contact_id = AND `option` = "products" LIMIT 0,1) called at [/data/http/history/inc/database.php:166]
#3 Data_Base->Execute ([0] => SELECT * FROM contact_settings WHERE contact_id = AND `option` = "products" LIMIT 0,1) called at [/data/http/history/inc/database.php:208]
#4 Data_Base->Read_Record ([0] => contact_settings, [1] => contact_id = AND `option` = "products", [2] =>) called at [/data/http/history/inc/database.php:172]
#5 Data_Base->Read_Field ([0] => id_contact_settings, [1] => contact_settings, [2] => contact_id = AND `option` = "products") called at [/data/http/history/inc/data_browser.php:504]
#6 Data_Browser->Write_Settings () called at [/data/http/history/inc/data_browser.php:1386]
#7 Data_Browser->Render () called at [/data/http/history/index.php:76]
SQL Queries:
Array
(
[0] => SELECT * FROM config WHERE id_config = 'core' LIMIT 0,1
[1] => SELECT id_sessions id FROM sessions WHERE last_change < 1695922754
[2] => DELETE FROM sessions WHERE last_change < 1695922754
[3] => UPDATE sessions SET last_change = 1695923654.7125, info = "Browsing Product Definitions", admin_info = "", contact_id = 0, name = "", agent = "CCBot/2.0 (https://commoncrawl.org/faq/)", url = "/index.php?type=prod&sort_column=1&sort_order=asc" WHERE id = "g8evqkj53ggeso045t4abglhk2"
[4] => INSERT INTO sessions SET last_change = 1695923654.7125, info = "Browsing Product Definitions", admin_info = "", url = "/index.php?type=prod&sort_column=1&sort_order=asc", id = "g8evqkj53ggeso045t4abglhk2", start_time = 1695923654, contact_id = 0, name = "", agent = "CCBot/2.0 (https://commoncrawl.org/faq/)", contact_ip = "44.197.111.121"
[5] => SELECT COUNT(*) res FROM sessions WHERE contact_id = 0
[6] => SELECT COUNT(*) res FROM sessions
[7] => SELECT * FROM contact_settings WHERE contact_id = AND `option` = "products" LIMIT 0,1
)
SQL Error:
Array
(
[message] => 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 `option` = "products" LIMIT 0,1' at line 1
[code] => 1064
)
Please notify the administrator or webmaster: sand@skycode.com