What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Suggestion Implemented error after manualy change chat model.php

Ž

ŽivaAkcija

Member
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM xf_siropu_chat_messages LEFT JOIN xf_user ON user_id = message_user_id ' at line 22 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: AlejaSerija, Pre 1 minuta

Stack Trace
#0 /home/alejaserija/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT\n\t\t\t\t...')
#1 /home/alejaserija/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tSELECT\n\t\t\t\t...')
#2 /home/alejaserija/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT\n\t\t\t\t...')
#3 /home/alejaserija/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT\n\t\t\t\t...', Array, 2)
#4 /home/alejaserija/public_html/library/Siropu/Chat/Model.php(138): XenForo_Model->fetchAllKeyed('\n\t\t\tSELECT\n\t\t\t\t...', 'message_id')
#5 /home/alejaserija/public_html/library/SolidMean/Siropu/Chat/Model.php(31): Siropu_Chat_Model->getMessages(Array, Array, false)
#6 /home/alejaserija/public_html/library/Siropu/Chat/ControllerPublic/Chat.php(2486): SolidMean_Siropu_Chat_Model->getMessages(Array)
#7 /home/alejaserija/public_html/library/Siropu/Chat/ControllerPublic/Chat.php(1711): Siropu_Chat_ControllerPublic_Chat->_getChat(Array)
#8 /home/alejaserija/public_html/library/XenForo/FrontController.php(351): Siropu_Chat_ControllerPublic_Chat->actionSubmit()
#9 /home/alejaserija/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/alejaserija/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(45) "http://alejaserija.club/index.php?chat/submit"
["_GET"] => array(1) {
["chat/submit"] => string(0) ""
}
["_POST"] => array(17) {
["message"] => string(2) ":D"
["room_id"] => string(1) "0"
["user_rooms"] => array(1) {
[0] => string(1) "0"
}
["last_id"] => string(1) "0"
["activity_last_id"] => string(1) "0"
["activity_last_update"] => string(1) "0"
["users_last_update"] => string(1) "0"
["session_last_update"] => string(1) "0"
["inverse"] => string(1) "0"
["hide_bot"] => string(1) "0"
["no_users"] => string(1) "0"
["show_ignored"] => string(1) "0"
["all_pages"] => string(1) "0"
["_xfRequestUri"] => string(10) "/index.php"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}
 
Ž

ŽivaAkcija

Member
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM xf_siropu_chat_messages LEFT JOIN xf_user ON user_id = message_user_id ' at line 22 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: AlejaSerija, Pre 4 minuta

Stack Trace
#0 /home/alejaserija/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT\n\t\t\t\t...')
#1 /home/alejaserija/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tSELECT\n\t\t\t\t...')
#2 /home/alejaserija/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT\n\t\t\t\t...')
#3 /home/alejaserija/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT\n\t\t\t\t...', Array, 2)
#4 /home/alejaserija/public_html/library/Siropu/Chat/Model.php(138): XenForo_Model->fetchAllKeyed('\n\t\t\tSELECT\n\t\t\t\t...', 'message_id')
#5 /home/alejaserija/public_html/library/SolidMean/Siropu/Chat/Model.php(31): Siropu_Chat_Model->getMessages(Array, Array, false)
#6 /home/alejaserija/public_html/library/Siropu/Chat/ControllerPublic/Chat.php(2481): SolidMean_Siropu_Chat_Model->getMessages(Array)
#7 /home/alejaserija/public_html/library/Siropu/Chat/ControllerPublic/Chat.php(1796): Siropu_Chat_ControllerPublic_Chat->_getChat(Array)
#8 /home/alejaserija/public_html/library/XenForo/FrontController.php(351): Siropu_Chat_ControllerPublic_Chat->actionRefresh()
#9 /home/alejaserija/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/alejaserija/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(46) "http://alejaserija.club/index.php?chat/refresh"
["_GET"] => array(1) {
["chat/refresh"] => string(0) ""
}
["_POST"] => array(16) {
["room_id"] => string(1) "0"
["user_rooms"] => array(1) {
[0] => string(1) "0"
}
["last_id"] => string(1) "0"
["activity_last_id"] => string(1) "0"
["activity_last_update"] => string(1) "0"
["users_last_update"] => string(1) "0"
["inverse"] => string(1) "0"
["hide_bot"] => string(1) "0"
["no_users"] => string(1) "0"
["show_ignored"] => string(1) "0"
["all_pages"] => string(1) "0"
["loading"] => string(1) "1"
["_xfRequestUri"] => string(10) "/index.php"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}

Izbrisati... Zatvoriti
 
You must log in or register to reply here.
Top