Please find the attached screenshot.
updated by @sbhadauria: 08/28/18 07:02:53AM
JAMROOM
MySQL error after updating Jamroom
My website stopped working after jamroom update from 6.1.5 to 6.1.7
Please find the attached screenshot.
updated by @sbhadauria: 08/28/18 07:02:53AM
Please find the attached screenshot.
updated by @sbhadauria: 08/28/18 07:02:53AM
Have you tried clearing the caches and running the INTEGRITY CHECK tool?
https://www.jamroom.net/the-jamroom-network/documentation/troubleshooting/114/somethings-wrong-what-do-i-do
https://www.jamroom.net/the-jamroom-network/documentation/troubleshooting/114/somethings-wrong-what-do-i-do
Thanks for reply @michale but I already did
_jrCore_db_search_items function in datastore.php is creating errors. when I have replaced this function to old jamroom release (6.1.5) then MySql errors fixed.
Maybe try rebuilding the search index
ACP -> MODULES -> LISTING -> SEARCH -> TOOLS -> REBUILD INDEXES
ACP -> MODULES -> LISTING -> SEARCH -> TOOLS -> REBUILD INDEXES
not working still getting errors
I cannot replicate this issue on this end - the DS is passing all unit tests as well. This is coming from your dashboard - have you created any custom dashboard panels? Do you know what panels are active? (look in the database jr_jrcore_settings table for the "dashboard_config" entry for the jrCore module).
--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Not coming only from dashboard. Below mentioned type of searching giving errors.
$_cnt = array(
'search' => array(
"notification_user_id = {$_user['_user_id']}",
"notification_status = unread"
),
'return_keys' => array('_item_id','notification_type','notification_title','notification_url','notification_status'),
'limit' => 1000000,
'skip_triggers' => true,
'pending_check' => false,
'privacy_check' => false,
'no_cache' => true
);
$items = jrCore_db_search_items('xtCustomMod', $_cnt);
make sure that _user_id is being set, seems like it might not be there.
still not working, I can not update production
sbhadauria:
still not working, I can not update production
still not working, I can not update production
Disable your custom modules and see if it works. No other site has reported this issue, and unit tests are passing 100% for the datastore. I can see your query is missing info, so check your {jrCore_list} calls and calls to jrCore_db_search_items().
--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Looking at this some more, my suspicion is that you have a {jrCore_list} call either in your header.tpl or footer.tpl that is relying on a variable being set in the template (or passed in via $_post) that is NOT being set. Since the error in your first screenshot came in on the activity log, that makes me think it's probably in your header/footer.
--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Hi @brian sorry for late response was busy in another task.
why I am not getting any error in 6.1.5 version?
why I am not getting any error in 6.1.5 version?
sbhadauria:
Hi @brian sorry for late response was busy in another task.
why I am not getting any error in 6.1.5 version?
Hi @brian sorry for late response was busy in another task.
why I am not getting any error in 6.1.5 version?
I have no idea without spending time debugging it on your system. There is no other report from any site of this happening, so unfortunately I cannot tell you what it is.
--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
