jucs Posted October 19, 2022 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}
Marc Posted October 19, 2022 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.
jucs Posted October 19, 2022 Author 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
Marc Posted October 19, 2022 Posted October 19, 2022 Your login requires email. We would need email adding rather than display name
jucs Posted October 19, 2022 Author 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.
Marc Posted October 19, 2022 Posted October 19, 2022 I would need an example user who is getting this. On the same device, I am seeing no issues
Richard Arch Posted October 19, 2022 Posted October 19, 2022 Badly generated SQL, the IN statement is missing parameters..
Marc Posted October 19, 2022 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
jucs Posted October 19, 2022 Author 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.
Marc Posted October 19, 2022 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.
jucs Posted October 19, 2022 Author 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
Marc Posted October 20, 2022 Posted October 20, 2022 Please respond to the ticket to let our techs know if you have been asked in the ticket
jucs Posted October 20, 2022 Author 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.
jucs Posted October 20, 2022 Author 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
Marc Posted October 20, 2022 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
Recommended Posts