Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted October 24, 20222 yr 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?
October 24, 20222 yr 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 24, 20222 yr Author On 10/24/2022 at 10:59 AM, 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
October 24, 20222 yr Author On 10/24/2022 at 10:59 AM, 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.
October 24, 20222 yr Looks like a calendar error is being thrown on them. Could you please install the patch in ACP -> Support.
October 25, 20222 yr Author 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, 20222 yr by Jaap
October 25, 20222 yr Solution 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