Jaap Posted October 24, 2022 Share 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? Link to comment Share on other sites More sharing options...
Adriano Faria Posted October 24, 2022 Share Posted October 24, 2022 Post the content of your log. You have a database error. Link to comment Share on other sites More sharing options...
Marc Posted October 24, 2022 Share 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. Link to comment Share on other sites More sharing options...
Jaap Posted October 24, 2022 Author Share 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 Link to comment Share on other sites More sharing options...
Jaap Posted October 24, 2022 Author Share 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. Link to comment Share on other sites More sharing options...
Jim M Posted October 24, 2022 Share Posted October 24, 2022 Looks like a calendar error is being thrown on them. Could you please install the patch in ACP -> Support. Link to comment Share on other sites More sharing options...
Jaap Posted October 25, 2022 Author Share 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 Link to comment Share on other sites More sharing options...
Solution Marc Posted October 25, 2022 Solution Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts