Jump to content

Featured Replies

Posted

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}

Could contain: Text, File, Mobile Phone, Electronics, Phone, Cell Phone

  • 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. 

 

  • 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 by jucs

  • Community Expert

Your login requires email. We would need email adding rather than display name

  • Author
16 minutes ago, Marc Stridgen said:

Your login requires email. We would need email adding rather than display name

Whoops. Sorry. updated.

  • Community Expert

I would need an example user who is getting this. On the same device, I am seeing no issues

Badly generated SQL, the IN statement is missing parameters..

Could contain: Text, Word

  • Community Expert
42 minutes ago, Richard Arch said:

Badly generated SQL, the IN statement is missing parameters..

Could contain: Text, Word

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 

  • 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.

  • 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. 

  • 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.

  • Community Expert

Please respond to the ticket to let our techs know if you have been asked in the ticket

  • 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. 

  • 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.

  • 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

Recently Browsing 0

  • No registered users viewing this page.