Posted October 19, 20222 yr 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}
October 19, 20222 yr Community Expert 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.
October 19, 20222 yr Author 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, 20222 yr by jucs
October 19, 20222 yr Community Expert Your login requires email. We would need email adding rather than display name
October 19, 20222 yr Author 16 minutes ago, Marc Stridgen said: Your login requires email. We would need email adding rather than display name Whoops. Sorry. updated.
October 19, 20222 yr Community Expert I would need an example user who is getting this. On the same device, I am seeing no issues
October 19, 20222 yr Community Expert 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
October 19, 20222 yr Author 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.
October 19, 20222 yr Community Expert 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.
October 19, 20222 yr Author 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.
October 20, 20222 yr Community Expert Please respond to the ticket to let our techs know if you have been asked in the ticket
October 20, 20222 yr Author 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.
October 20, 20222 yr Author 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.
October 20, 20222 yr Community Expert 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