Posted May 6May 6 Hi Just upgraded to Invision 4 on a second forum and there are two key issues1) I'm getting logged out of the ACP frequently and the error message is about IP address changing. However I use a VPN so the IP address stays constant until I update proxies. No issues on the other forum.2) After the upgrade, I can't post. I get the following configuration error: INSERT INTO forums_topics ( start_date, last_post, starter_id, starter_name, last_real_post, last_poster_id, last_poster_name, forum_id, approved, state, views, pinned, featured, is_future_entry, posts, topic_queuedposts, topic_hiddenposts, publish_date, title, title_seo, poll_state ) VALUES ( 1746538698, 1746538698, 2, 'Kiwi', 1746538698, 2, 'Kiwi', 12, 1, 'open', 0, 0, 0, 0, 0, 0, 0, 1746538698, 'Sorry...server issues.', 'sorryserver-issues', NULL )IPS\Db\Exception: PROCEDURE guitardatab.CheckSub does not exist (1305)#0 /home/nginx/domains/guitarchat.co.uk/public/system/Db/Db.php(941): IPS\_Db->preparedQuery()#1 /home/nginx/domains/guitarchat.co.uk/public/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert()#2 /home/nginx/domains/guitarchat.co.uk/public/applications/forums/sources/Topic/Topic.php(1617): IPS\Patterns\_ActiveRecord->save()#3 /home/nginx/domains/guitarchat.co.uk/public/system/Content/Item.php(587): IPS\forums\_Topic->save()#4 /home/nginx/domains/guitarchat.co.uk/public/applications/forums/sources/Topic/Topic.php(581): IPS\Content\_Item->processForm()#5 [internal function]: IPS\forums\_Topic->processForm()#6 /home/nginx/domains/guitarchat.co.uk/public/init.php(947) : eval()'d code(108): call_user_func_array()#7 /home/nginx/domains/guitarchat.co.uk/public/system/Content/Item.php(423): IPS\forums\marketplace_hook_Market->processForm()#8 /home/nginx/domains/guitarchat.co.uk/public/system/Content/Item.php(153): IPS\Content\_Item::createFromForm()#9 /home/nginx/domains/guitarchat.co.uk/public/applications/forums/modules/front/forums/forums.php(645): IPS\Content\_Item::create()#10 /home/nginx/domains/guitarchat.co.uk/public/system/Dispatcher/Controller.php(107): IPS\forums\modules\front\forums\_forums->add()#11 /home/nginx/domains/guitarchat.co.uk/public/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()#12 /home/nginx/domains/guitarchat.co.uk/public/index.php(13): IPS\_Dispatcher->run()#13 {main}Are both of the above issues due to invisions CSRF token being out of date? If not, what might the cause be and would it be possible to have someone from Invision reinstall the update?
May 6May 6 Community Expert 5 minutes ago, Chatgroup said:IPS\Db\Exception: PROCEDURE guitardatab.CheckSub does not exist (1305)Sounds like you have a third party application/plugin trying to access a stored procedure which does not exist.6 minutes ago, Chatgroup said:I'm getting logged out of the ACP frequently and the error message is about IP address changing. However I use a VPN so the IP address stays constant until I update proxies. No issues on the other forum.If you're using CloudFlare or another proxy, you'll need to enable ACP -> System -> Advanced Configuration -> Trust IP addresses provided by proxies.
May 6May 6 Author 12 minutes ago, Jim M said:Sounds like you have a third party application/plugin trying to access a stored procedure which does not exist.I wonder what might that be...? There's only one plug in installed for bumping topics and it was purchased off here. Edited May 6May 6 by Chatgroup
May 6May 6 Community Expert 2 minutes ago, Chatgroup said:I wonder what might that be...? There's only one plug in installed for bumping topics and it was purchased off here.Please note that our Marketplace was only third party items so they are outside our scope of support. You'd need to contact the author for any assistance.
May 6May 6 Community Expert 27 minutes ago, Chatgroup said:1) I'm getting logged out of the ACP frequently and the error message is about IP address changing. However I use a VPN so the IP address stays constant until I update proxies. No issues on the other forum.Usually this type of issue happens when the ip address changes. Have a look at the following guide and try the recommended suggestions given there. Hopefully it will help.
May 7May 7 Author Usually this type of issue happens when the ip address changes. Have a look at the following guide and try the recommended suggestions given there. Hopefully it will help.IP issue was solved with a simple setting change in the ACP to trust IP proxies from Cloudflare. The other issue being unable to post was due to a database issue - somehow code from the other website made it into this website. Also deleted so now problem solved. Thanks everyone for your contributions. Edited May 7May 7 by Chatgroup
May 7May 7 Community Expert Glad to hear that you managed to get the issue resolved, and thank you for letting us know what the issue was.