Jaap Posted October 24, 2022 Posted October 24, 2022 One of my moderators doesn't have access anymore to the Moderator Control Panel. He get's an error EX1064. See screenshot. I tried to recreate the problem by assigning a fake moderator status to my test-account, but to no avail. Can you please help me out?
Adriano Faria Posted October 24, 2022 Posted October 24, 2022 Post the content of your log. You have a database error.
Marc Posted October 24, 2022 Posted October 24, 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.
Jaap Posted October 24, 2022 Author Posted October 24, 2022 2 hours 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. Will do. TIA
Jaap Posted October 24, 2022 Author Posted October 24, 2022 2 hours 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, should work now. But you could get a certificate error from my server.
Jim M Posted October 24, 2022 Posted October 24, 2022 Looks like a calendar error is being thrown on them. Could you please install the patch in ACP -> Support.
Jaap Posted October 25, 2022 Author Posted October 25, 2022 (edited) Thanks for the suggestion, but there is no patch available? When I look in the log file, this error repeats. I marked the ModCP stuff red. SELECT COUNT(*) as cnt FROM `ibcore_rc_index` AS `core_rc_index` WHERE (( ( class='IPS\\core\\Messenger\\Conversation' AND ( perm_id IN(2,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,192,196,197,198,199,200,203,204,205,206,207,208) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Messenger\\Message' AND ( perm_id IN(2,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,192,196,197,198,199,200,203,204,205,206,207,208) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Statuses\\Status' AND ( perm_id IN(2,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,192,196,197,198,199,200,203,204,205,206,207,208) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Statuses\\Reply' AND ( perm_id IN(2,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,192,196,197,198,199,200,203,204,205,206,207,208) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic' AND ( perm_id IN(4,5,6,7,8,11,26,29,52,65,71,72,73,74,77,86,129,132,133,134,135) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic\\Post' AND ( perm_id IN(4,5,6,7,8,11,26,29,52,65,71,72,73,74,77,86,129,132,133,134,135) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic\\ArchivedPost' AND ( perm_id IN(4,5,6,7,8,11,26,29,52,65,71,72,73,74,77,86,129,132,133,134,135) ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event' AND ( perm_id IN() ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\calendar\\Event\\Comment' AND ( perm_id IN() ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\calendar\\Event\\Review' AND ( perm_id IN() ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Image' AND ( perm_id IN(99,100,101,102,103,104,131) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Image\\Comment' AND ( perm_id IN(99,100,101,102,103,104,131) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Image\\Review' AND ( perm_id IN(99,100,101,102,103,104,131) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Album\\Item' AND ( perm_id IN(99,100,101,102,103,104,131) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Album\\Comment' AND ( perm_id IN(99,100,101,102,103,104,131) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Album\\Review' AND ( perm_id IN(99,100,101,102,103,104,131) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\communitymap\\Markers' AND ( perm_id IN(210) ) OR perm_id IS NULL )) OR ( ( class='IPS\\communitymap\\Markers\\Comment' AND ( perm_id IN(210) ) OR perm_id IS NULL )) OR ( ( class='IPS\\communitymap\\Markers\\Review' AND ( perm_id IN(210) ) OR perm_id IS NULL ))) IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\calendar\\Event\\Comment' A' at line 1 (1064) #0 /var/www/vhosts/v11lemans.com/httpdocs/forums/system/Db/Select.php(388): IPS\_Db->preparedQuery() #1 /var/www/vhosts/v11lemans.com/httpdocs/forums/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 /var/www/vhosts/v11lemans.com/httpdocs/forums/system/Db/Select.php(370): IPS\Db\_Select->rewind() #3 /var/www/vhosts/v11lemans.com/httpdocs/forums/system/Content/Item.php(3211): IPS\Db\_Select->first() #4 /var/www/vhosts/v11lemans.com/httpdocs/forums/system/Helpers/Table/Content.php(352): IPS\Content\_Item::getItemsWithPermission() #5 /var/www/vhosts/v11lemans.com/httpdocs/forums/system/Helpers/Table/Table.php(494): IPS\Helpers\Table\_Content->getRows() #6 /var/www/vhosts/v11lemans.com/httpdocs/forums/applications/core/extensions/core/ModCp/Reports.php(136): IPS\Helpers\Table\_Table->__toString() #7 /var/www/vhosts/v11lemans.com/httpdocs/forums/applications/core/modules/front/modcp/modcp.php(114): IPS\core\extensions\core\ModCp\_Reports->manage() #8 /var/www/vhosts/v11lemans.com/httpdocs/forums/system/Dispatcher/Controller.php(118): IPS\core\modules\front\modcp\_modcp->manage() #9 /var/www/vhosts/v11lemans.com/httpdocs/forums/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #10 /var/www/vhosts/v11lemans.com/httpdocs/forums/index.php(13): IPS\_Dispatcher->run() #11 {main} Edited October 25, 2022 by Jaap
Solution Marc Posted October 25, 2022 Solution Posted October 25, 2022 I have created a ticket for you on this, so we can take a look for you Edit: On speaking to my colleague, this has been fixed in the next upcoming release of the platform
Recommended Posts