jucs Posted October 19, 2022 Share Posted October 19, 2022 Just did the latest monthly update. I have a user with a Samsung Galaxy s21 showing template errors and I went to the logs and saw system logs racking up with this. Screenshot from his phone is attached too. I assume some bug was introduced in the lastest monthly since no prior errors until now? I have never made any modifications to any of the forum templates from the default btw. Please advise. Thanks. The URL of page the error occurred on was https://www.gripboard.com/index.php?/forum/15-grip-contests/ IPS\Db\Exception::1064 SELECT COUNT(*) FROM `ibf_core_rc_index` AS `core_rc_index` WHERE (( ( class='IPS\\core\\Messenger\\Conversation' AND ( perm_id IN(2,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,585,593,594,595,597,598,599,600,601,602,603,604,605,608,609,610,611,614,615,616) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Messenger\\Message' AND ( perm_id IN(2,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,585,593,594,595,597,598,599,600,601,602,603,604,605,608,609,610,611,614,615,616) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Statuses\\Status' AND ( perm_id IN(2,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,585,593,594,595,597,598,599,600,601,602,603,604,605,608,609,610,611,614,615,616) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Statuses\\Reply' AND ( perm_id IN(2,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,585,593,594,595,597,598,599,600,601,602,603,604,605,608,609,610,611,614,615,616) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic' AND ( perm_id IN(465,466,467,468,472,478,479,480,481,482,483,484,485,488,489,490,491,492,494,496,498,499,500,501,502,503,507,508,509,510,511,512,513,514,515,516,518,519,520,523,524,525,526,586,587,589,591,607,612) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic\\Post' AND ( perm_id IN(465,466,467,468,472,478,479,480,481,482,483,484,485,488,489,490,491,492,494,496,498,499,500,501,502,503,507,508,509,510,511,512,513,514,515,516,518,519,520,523,524,525,526,586,587,589,591,607,612) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic\\ArchivedPost' AND ( perm_id IN(465,466,467,468,472,478,479,480,481,482,483,484,485,488,489,490,491,492,494,496,498,499,500,501,502,503,507,508,509,510,511,512,513,514,515,516,518,519,520,523,524,525,526,586,587,589,591,607,612) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Image' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Image\\Comment' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Image\\Review' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Album\\Item' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Album\\Comment' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Album\\Review' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event' AND ( perm_id IN() ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event\\Comment' AND ( perm_id IN() ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event\\Review' AND ( perm_id IN() ) OR perm_id IS NULL )) OR ( class='IPS\\nexus\\Package\\Item' ) OR ( class='IPS\\nexus\\Package\\Review' )) AND status IN( 1,2 ) 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 ') ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event\\Comment' AND ( per' at line 1 #0 /home/gripboar/public_html/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*gripboar_grip...', Array, true) #1 /home/gripboar/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 /home/gripboar/public_html/system/Db/Select.php(370): IPS\Db\_Select->rewind() #3 /home/gripboar/public_html/system/Member/Member.php(3174): IPS\Db\_Select->first() #4 /home/gripboar/public_html/system/Theme/Theme.php(885) : eval()'d code(8886): IPS\_Member->reportCount() #5 /home/gripboar/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->mobileNavigation() #6 /home/gripboar/public_html/system/Theme/Theme.php(885) : eval()'d code(6787): IPS\Theme\_SandboxedTemplate->__call('mobileNavigatio...', Array) #7 /home/gripboar/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->globalTemplate('a9a956a28572a22...', '\n\n\n\n\n\t\n\t<div cl...', Array) #8 /home/gripboar/public_html/system/Dispatcher/Dispatcher.php(173): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #9 /home/gripboar/public_html/system/Dispatcher/Standard.php(113): IPS\_Dispatcher->finish() #10 /home/gripboar/public_html/system/Dispatcher/Front.php(630): IPS\Dispatcher\_Standard->finish() #11 /home/gripboar/public_html/system/Dispatcher/Dispatcher.php(155): IPS\Dispatcher\_Front->finish() #12 /home/gripboar/public_html/index.php(13): IPS\_Dispatcher->run() #13 {main} Link to comment Share on other sites More sharing options...
Marc Posted October 19, 2022 Share Posted October 19, 2022 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Link to comment Share on other sites More sharing options...
jucs Posted October 19, 2022 Author Share Posted October 19, 2022 (edited) 9 minutes ago, Marc Stridgen said: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Done. Updated Admin CP login. Edited October 19, 2022 by jucs Link to comment Share on other sites More sharing options...
Marc Posted October 19, 2022 Share Posted October 19, 2022 Your login requires email. We would need email adding rather than display name Link to comment Share on other sites More sharing options...
jucs Posted October 19, 2022 Author Share Posted October 19, 2022 16 minutes ago, Marc Stridgen said: Your login requires email. We would need email adding rather than display name Whoops. Sorry. updated. Link to comment Share on other sites More sharing options...
Marc Posted October 19, 2022 Share Posted October 19, 2022 I would need an example user who is getting this. On the same device, I am seeing no issues Link to comment Share on other sites More sharing options...
Richard Arch Posted October 19, 2022 Share Posted October 19, 2022 Badly generated SQL, the IN statement is missing parameters.. Link to comment Share on other sites More sharing options...
Marc Posted October 19, 2022 Share Posted October 19, 2022 42 minutes ago, Richard Arch said: Badly generated SQL, the IN statement is missing parameters.. While I can see the error in the mysql statement, I would still need to know a user who has reported this so I can see why its happening Link to comment Share on other sites More sharing options...
jucs Posted October 19, 2022 Author Share Posted October 19, 2022 As in the system logs, Jedd Johnson You can see the errors in the Admin CP jacking up and when clicking on the details it's this user. Thanks. Link to comment Share on other sites More sharing options...
Marc Posted October 19, 2022 Share Posted October 19, 2022 I have created a ticket for you, and someone will be in contact as soon as possible. This is happening regardless of device and is related to that moderator. Link to comment Share on other sites More sharing options...
jucs Posted October 19, 2022 Author Share Posted October 19, 2022 I have re-updated AdminCP access as it seems to be getting overwritten on the pop up as I just made sure again it is correct. Marc 1 Link to comment Share on other sites More sharing options...
Marc Posted October 20, 2022 Share Posted October 20, 2022 Please respond to the ticket to let our techs know if you have been asked in the ticket Link to comment Share on other sites More sharing options...
jucs Posted October 20, 2022 Author Share Posted October 20, 2022 16 minutes ago, Marc Stridgen said: Please respond to the ticket to let our techs know if you have been asked in the ticket No clue where this is now. Link to comment Share on other sites More sharing options...
Marc Posted October 20, 2022 Share Posted October 20, 2022 This is in your email Link to comment Share on other sites More sharing options...
jucs Posted October 20, 2022 Author Share Posted October 20, 2022 21 minutes ago, Marc Stridgen said: This is in your email Ok, well I just did a reply back. I mean one was asking for the info I already supplied which was updating my AdminCp login. Marc 1 Link to comment Share on other sites More sharing options...
Marc Posted October 20, 2022 Share Posted October 20, 2022 10 minutes ago, jucs said: Ok, well I just did a reply back. I mean one was asking for the info I already supplied which was updating my AdminCp login. No problem. This will be looked into for you further on the ticket Link to comment Share on other sites More sharing options...
Recommended Posts