so I had difficulty going from 6.0 to 6.1. I was informed that there would be an update so waited for that. I tried to go from 6.0 to 6.2 and got the error (see below). so I went back to 6.0 and tried to upgrade to 6.1 - works! then tried going from 6.1 to 6.2 and got the error. So a little stuck. Went through my database on the birthday issues and there doesn't seem a problem. Not sure about the rest. So currently working on 6.1 😃 but need help to get to 6.2 :roll:
Type: E_USER_ERROR (256)
Message: mysqlt error: [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 '-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.' at line 1] in EXECUTE("SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807")
File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php
Line=77
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "mysqlt error: [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 '-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.' at line 1] in EXECUTE(\"SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807\") ", "/home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 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 '-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.' at line 1", "SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807", false, Object (ADODB_mysqlt), "SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807", false, "mysqlt error: [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 '-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.' at line 1] in EXECUTE(\"SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807\") "))
File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [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 '-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.' at line 1] in EXECUTE(\"SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807\") ", 256)
File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php
line 1071
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 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 '-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.' at line 1", "SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807", false, "Object (ADODB_mysqlt)")
File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php
line 1027
function called: _Execute("SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807")
File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/drivers/adodb-mysql.inc.php
line 591
function called: Execute("SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC LIMIT 0,9223372036854775807", Array ())
[PHP core called function]
function called: SelectLimit("SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC", -1, 0, Array ())
File: /home/bdwmcom1/public_html/1extranet/DBase/include/database.php
line 454
function called: call_user_func_array(Array (Object (ADODB_mysqlt), "SelectLimit"), Array ("SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC", -1, 0, Array (#0)))
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1514
function called: SelectLimit("SELECT * FROM contact_data_1 AS r WHERE active=1 AND (false OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL) OR (r.f_birth_date LIKE 1969-12-31 AND r.f_birth_date IS NOT NULL)) ORDER BY f_last_name ASC", -1, 0, Array ())
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 2740
function called: get_records("contact", Array (Array (#3)), Array (), Array (Array (#3)), null)
[PHP core called function]
function called: mini_view(Array (Array (#2), Array (#2), Array (#2)), Array (Array (#3)), Array ("ASC"), "test", null, Array ("3", "Upcoming Birthdays", "a"), Array ("Upcoming Birthdays", true, null, false, "body", Array (#0), Array (#0), Array (#0), "157"))
File: /home/bdwmcom1/public_html/1extranet/DBase/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "mini_view"), Array (Array (#3), Array (#1), Array (#1), "test", null, Array (#3), "Array (\"Upcoming Birthdays\", true, null, false, \"body\", Array (#0), Array (#0), Array (#0), \"157\")"))
File: /home/bdwmcom1/public_html/1extranet/DBase/include/module.php
line 713
function called: get_html_of_module(Object (Utils_RecordBrowser), Array (Array (#3), Array (#1), Array (#1), "test", null, Array (#3), "\"Array (\\"Upcoming Birthdays\\", true, null, false, \\"body\\", Array (#0), Array (#0), Array (#0), \\"157\\")\""), "mini_view")
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Applets/Birthdays/Birthdays_0.php
line 75
function called: display_module("Object (Utils_RecordBrowser)", Array (Array (#3), Array (#1), Array (#1), "test", null, Array (#3), "\"\\"Array (\\\"Upcoming Birthdays\\\", true, null, false, \\\"body\\\", Array (#0), Array (#0), Array (#0), \\\"157\\\")\\"\""), "mini_view")
[PHP core called function]
function called: applet(Array ("3", "Upcoming Birthdays", "a"), "\"\\"\\\"Array (\\\\"Upcoming Birthdays\\\\", true, null, false, \\\\"body\\\\", Array (#0), Array (#0), Array (#0), \\\\"157\\\\")\\\"\\"\"", "157")
File: /home/bdwmcom1/public_html/1extranet/DBase/include/module.php
line 793
function called: call_user_func_array(Array (Object (Applets_Birthdays), "applet"), Array (Array (#3), "\"\\"\\\"\\\\"Array (\\\\\"Upcoming Birthdays\\\\\", true, null, false, \\\\\"body\\\\\", Array (#0), Array (#0), Array (#0), \\\\\"157\\\\\")\\\\"\\\"\\"\"", "157"))
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Base/Dashboard/Dashboard_0.php
line 192
function called: get_html_of_module(Object (Applets_Birthdays), Array (Array (#3), "\"\\"\\\"\\\\"\\\\\"Array (\\\\\\"Upcoming Birthdays\\\\\\", true, null, false, \\\\\\"body\\\\\\", Array (#0), Array (#0), Array (#0), \\\\\\"157\\\\\\")\\\\\"\\\\"\\\"\\"\"", "157"), "applet")
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Base/Dashboard/Dashboard_0.php
line 126
function called: display_dashboard("1")
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Base/Dashboard/Dashboard_0.php
line 29
function called: dashboard()
[PHP core called function]
function called: body()
File: /home/bdwmcom1/public_html/1extranet/DBase/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Dashboard), "body"), Array ())
File: /home/bdwmcom1/public_html/1extranet/DBase/include/module.php
line 713
function called: get_html_of_module(Object (Base_Dashboard), null, "body")
File: /home/bdwmcom1/public_html/1extranet/DBase/include/module.php
line 886
function called: display_module("Object (Base_Dashboard)", null, "body")
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Base/HomePage/HomePage_0.php
line 24
function called: pack_module("Base/Dashboard", null, "body", null)
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Base/HomePage/HomePage_0.php
line 17
function called: show_home_page(Array ("Base/Dashboard"))
[PHP core called function]
function called: body()
File: /home/bdwmcom1/public_html/1extranet/DBase/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_HomePage), "body"), Array ())
File: /home/bdwmcom1/public_html/1extranet/DBase/include/module.php
line 713
function called: get_html_of_module(Object (Base_HomePage), null, null)
File: /home/bdwmcom1/public_html/1extranet/DBase/modules/Base/Box/Box_0.php
line 151
function called: display_module("Object (Base_HomePage)")
File: /home/bdwmcom1/public_html/1extranet/DBase/include/epesi.php
line 241
function called: body()
File: /home/bdwmcom1/public_html/1extranet/DBase/include/epesi.php
line 286
function called: go(Object (Base_Box))
File: /home/bdwmcom1/public_html/1extranet/DBase/include/epesi.php
line 309
function called: process("__action_module__=%2FBase_Box%7C0%2FBase_User_Login%7Clogin&__location=1413809691.9199", false, true)
File: /home/bdwmcom1/public_html/1extranet/DBase/process.php
line 35
function called: process("_qf__libs_qf_1bbae4d400dd068c367ef84d19555f40=&submited=1&username=Alan%20Dempster&password=Al4n!959&submit_button=Login&__action_module__=%2FBase_Box%7C0%2FBase_User_Login%7Clogin", false)
