General Error
/index.php?type=vers&pid=12&sort_column=7&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` = "versions" 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` = "versions" 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` = "versions", [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` = "versions") 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:105]
SQL Queries:
Array
(
[0] => SELECT * FROM config WHERE id_config = 'core' LIMIT 0,1
[1] => SELECT * FROM products WHERE products.id_products = 12 AND products.deleted = 0 LIMIT 0,1
[2] => SELECT id_sessions id FROM sessions WHERE last_change < 1686034134
[3] => DELETE FROM sessions WHERE last_change < 1686034134
[4] => UPDATE sessions SET last_change = 1686035034.8858, info = " - SkyCore 6", admin_info = "", contact_id = 0, name = "", agent = "CCBot/2.0 (https://commoncrawl.org/faq/)", url = "/index.php?type=vers&pid=12&sort_column=7&sort_order=asc" WHERE id = "4ne9l9cokp9vdt37r66hiiduc5"
[5] => INSERT INTO sessions SET last_change = 1686035034.8858, info = " - SkyCore 6", admin_info = "", url = "/index.php?type=vers&pid=12&sort_column=7&sort_order=asc", id = "4ne9l9cokp9vdt37r66hiiduc5", start_time = 1686035034, contact_id = 0, name = "", agent = "CCBot/2.0 (https://commoncrawl.org/faq/)", contact_ip = "44.200.112.172"
[6] => SELECT COUNT(*) res FROM sessions WHERE contact_id = 0
[7] => SELECT COUNT(*) res FROM sessions
[8] => SELECT * FROM contact_settings WHERE contact_id = AND `option` = "versions" 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` = "versions" 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` = "versions" 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` = "versions" 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` = "versions", [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` = "versions") 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:105]
SQL Queries:
Array
(
[0] => SELECT * FROM config WHERE id_config = 'core' LIMIT 0,1
[1] => SELECT * FROM products WHERE products.id_products = 12 AND products.deleted = 0 LIMIT 0,1
[2] => SELECT id_sessions id FROM sessions WHERE last_change < 1686034134
[3] => DELETE FROM sessions WHERE last_change < 1686034134
[4] => UPDATE sessions SET last_change = 1686035034.8858, info = " - SkyCore 6", admin_info = "", contact_id = 0, name = "", agent = "CCBot/2.0 (https://commoncrawl.org/faq/)", url = "/index.php?type=vers&pid=12&sort_column=7&sort_order=asc" WHERE id = "4ne9l9cokp9vdt37r66hiiduc5"
[5] => INSERT INTO sessions SET last_change = 1686035034.8858, info = " - SkyCore 6", admin_info = "", url = "/index.php?type=vers&pid=12&sort_column=7&sort_order=asc", id = "4ne9l9cokp9vdt37r66hiiduc5", start_time = 1686035034, contact_id = 0, name = "", agent = "CCBot/2.0 (https://commoncrawl.org/faq/)", contact_ip = "44.200.112.172"
[6] => SELECT COUNT(*) res FROM sessions WHERE contact_id = 0
[7] => SELECT COUNT(*) res FROM sessions
[8] => SELECT * FROM contact_settings WHERE contact_id = AND `option` = "versions" 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` = "versions" LIMIT 0,1' at line 1
[code] => 1064
)
Please notify the administrator or webmaster: sand@skycode.com