General Error
/index.php?type=vers&pid=15&sort_column=2&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 = 15 AND products.deleted = 0 LIMIT 0,1
[2] => SELECT id_sessions id FROM sessions WHERE last_change < 1713542025
[3] => DELETE FROM sessions WHERE last_change < 1713542025
[4] => UPDATE sessions SET last_change = 1713542925.7094, info = " - SkyOffice 5", admin_info = "", contact_id = 0, name = "", agent = "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)", url = "/index.php?type=vers&pid=15&sort_column=2&sort_order=asc" WHERE id = "3crout45sc2g3v5re7oibs8ov6"
[5] => INSERT INTO sessions SET last_change = 1713542925.7094, info = " - SkyOffice 5", admin_info = "", url = "/index.php?type=vers&pid=15&sort_column=2&sort_order=asc", id = "3crout45sc2g3v5re7oibs8ov6", start_time = 1713542925, contact_id = 0, name = "", agent = "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)", contact_ip = "3.19.31.73"
[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 = 15 AND products.deleted = 0 LIMIT 0,1
[2] => SELECT id_sessions id FROM sessions WHERE last_change < 1713542025
[3] => DELETE FROM sessions WHERE last_change < 1713542025
[4] => UPDATE sessions SET last_change = 1713542925.7094, info = " - SkyOffice 5", admin_info = "", contact_id = 0, name = "", agent = "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)", url = "/index.php?type=vers&pid=15&sort_column=2&sort_order=asc" WHERE id = "3crout45sc2g3v5re7oibs8ov6"
[5] => INSERT INTO sessions SET last_change = 1713542925.7094, info = " - SkyOffice 5", admin_info = "", url = "/index.php?type=vers&pid=15&sort_column=2&sort_order=asc", id = "3crout45sc2g3v5re7oibs8ov6", start_time = 1713542925, contact_id = 0, name = "", agent = "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)", contact_ip = "3.19.31.73"
[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