flashpoint Posted October 18, 2021 Posted October 18, 2021 Hi there, I recently changed servers for my forum and I've been having a lot of issues afterwards. I made sure to use the exact same software builds and versions as the 1st server to exactly avoid this. I've ran and everything is checked (green) Few of the errors: located on the support utility logs: Array ( [error] => invalid_grant [error_description] => Missing code verifier. ) OutOfRangeException: (0) #0 /var/www/vhosts/myforum.com/httpdocs/system/Theme/Theme.php(396): IPS\Patterns\_ActiveRecord::load() #1 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Standard.php(54): IPS\_Theme::i() #2 /var/www/vhosts/myforum.com/httpdocs/init.php(902) : eval()'d code(40): IPS\Dispatcher\_Standard::baseCss() #3 /var/www/vhosts/myforum.com/httpdocs/init.php(902) : eval()'d code(15): IPS\Dispatcher\videobox_hook_includeJSandCSS::baseCss() #4 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Front.php(751): IPS\Dispatcher\axenserverlist_hook_loadJSandCSS::baseCss() #5 /var/www/vhosts/myforum.com/httpdocs/init.php(902) : eval()'d code(39): IPS\Dispatcher\_Front::baseCss() #6 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Front.php(79): IPS\Dispatcher\bimchatbox_hook_includeJSandCSS::baseCss() #7 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init() #8 /var/www/vhosts/myforum.com/httpdocs/index.php(13): IPS\_Dispatcher::i() #9 {main} Lock wait timeout exceeded; try restarting transaction : I've increased my innodb_lock_wait_timeout to 300 so I think this issue has been fixed. UPDATE `core_widgets` core_widgets SET `caches`='{"widget_Wysiwyg_0aefufigi_0cabed4a03098fde5800197c948baf52":1633015011,"widget_Wysiwyg_9frecvisj_98140581c39cea83ce989445fbbc0481":1633015137}' WHERE `key`='Wysiwyg' AND app='cms' IPS\Db\Exception: Lock wait timeout exceeded; try restarting transaction (1205) #0 /var/www/vhosts/myforum.com/httpdocs/system/Db/Db.php(1154): IPS\_Db->preparedQuery() #1 /var/www/vhosts/myforum.com/httpdocs/system/Widget/Widget.php(914): IPS\_Db->update() #2 /var/www/vhosts/myforum.com/httpdocs/system/Theme/Theme.php(860) : eval()'d code(17997): IPS\_Widget->__toString() #3 /var/www/vhosts/myforum.com/httpdocs/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->widgetContainer() #4 /var/www/vhosts/myforum.com/httpdocs/system/Theme/Theme.php(860) : eval()'d code(15322): IPS\Theme\_SandboxedTemplate->__call() #5 /var/www/vhosts/myforum.com/httpdocs/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->sidebar() #6 /var/www/vhosts/myforum.com/httpdocs/system/Theme/Theme.php(860) : eval()'d code(6628): IPS\Theme\_SandboxedTemplate->__call() #7 /var/www/vhosts/myforum.com/httpdocs/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->globalTemplate() #8 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(173): IPS\Theme\_SandboxedTemplate->__call() #9 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Standard.php(113): IPS\_Dispatcher->finish() #10 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Front.php(674): IPS\Dispatcher\_Standard->finish() #11 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(155): IPS\Dispatcher\_Front->finish() #12 /var/www/vhosts/myforum.com/httpdocs/index.php(13): IPS\_Dispatcher->run() #13 {main} None of the WYSIWYG Editor blocks are showing up on the "public" side but I can edit them as normal with 0 issues. These are located in uploads/logs Mon, 18 Oct 2021 18:58:06 +0000 IPS\Db\Exception::1053 Server shutdown in progress #0 /var/www/vhosts/myforum.com/httpdocs/system/Db/Db.php(1156): IPS\_Db->preparedQuery() #1 /var/www/vhosts/myforum.com/httpdocs/system/Task/Task.php(257): IPS\_Db->update() #2 /var/www/vhosts/myforum.com/httpdocs/system/Task/Task.php(229): IPS\_Task->run() #3 /var/www/vhosts/myforum.com/httpdocs/applications/core/interface/task/task.php(58): IPS\_Task->runAndLog() #4 {main} ------------- Mon, 18 Oct 2021 18:58:13 +0000 Error: Call to undefined method stdClass::language() (0) #0 /var/www/vhosts/myforum.com/httpdocs/init.php(902) : eval()'d code(15): IPS\Dispatcher\_Standard::baseJs() #1 /var/www/vhosts/myforum.com/httpdocs/init.php(902) : eval()'d code(43): IPS\Dispatcher\videobox_hook_includeJSandCSS::baseJs() #2 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Front.php(713): IPS\Dispatcher\axenserverlist_hook_loadJSandCSS::baseJs() #3 /var/www/vhosts/myforum.com/httpdocs/init.php(902) : eval()'d code(16): IPS\Dispatcher\_Front::baseJs() #4 /var/www/vhosts/myforum.com/httpdocs/init.php(902) : eval()'d code(18): IPS\Dispatcher\bimchatbox_hook_includeJSandCSS::baseJs() #5 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Front.php(82): IPS\Dispatcher\nexus_hook_frontDispatcher::baseJs() #6 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init() #7 /var/www/vhosts/myforum.com/httpdocs/index.php(13): IPS\_Dispatcher::i() #8 {main} #0 /var/www/vhosts/myforum.com/httpdocs/init.php(1004): IPS\_Log::log() #1 [internal function]: IPS\IPS::exceptionHandler() #2 {main} When I try to access the bulk mail feature, everything works as normal TILL I get to the email preview section then I get these errors: OutOfRangeException: (0) #0 /var/www/vhosts/myforum.com/httpdocs/applications/core/sources/Promote/Promote.php(239): IPS\Patterns\_ActiveRecord::load() #1 /var/www/vhosts/myforum.com/httpdocs/system/Email/Email.php(922) : eval()'d code(530): IPS\core\_Promote->object() #2 /var/www/vhosts/myforum.com/httpdocs/system/Email/Email.php(925): IPS\Theme\email_html_core_emailWrapper() #3 /var/www/vhosts/myforum.com/httpdocs/system/Email/Email.php(371): IPS\_Email::template() #4 /var/www/vhosts/myforum.com/httpdocs/applications/core/modules/admin/bulkmail/bulkmail.php(308): IPS\_Email->compileContent() #5 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Controller.php(90): IPS\core\modules\admin\bulkmail\_bulkmail->iframePreview() #6 /var/www/vhosts/myforum.com/httpdocs/applications/core/modules/admin/bulkmail/bulkmail.php(45): IPS\Dispatcher\_Controller->execute() #7 /var/www/vhosts/myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\bulkmail\_bulkmail->execute() #8 /var/www/vhosts/myforum.com/httpdocs/admin/index.php(13): IPS\_Dispatcher->run() #9 {main} anddd there is LOTS of errors in the system logs section. I've double checked and made sure that all the files have been restored, double checked and made sure that the database has been properly restored. I've upgraded my IPS, restored old files, no luck, I am out of ideas and hopefully someone else will be able to come up with something. Thanks for your time and help! 🙂
Solution Jim M Posted October 18, 2021 Solution Posted October 18, 2021 The lock timeout, and server shutdown in progress are related to your server itself so asking for assistance from your new hosting provider would be advised. Call to undefined method stdClass::language() is typically a connection error in the database so checking the connection in conf_global.php (or the above with your provider). The first "OutOfRangeException" has some third party add-ons in the stack trace there so I would recommend disabling these and testing again. The final "OutOfRangeException" is referencing loading or an orphaned a failed promotion item from the database. Do you have the previous installation up and running to test? If you're not receiving the same error, I would suggest exporting and importing the database again as it seems something has gone awry with that process. flashpoint 1
flashpoint Posted October 18, 2021 Author Posted October 18, 2021 (edited) 32 minutes ago, Jim M said: The lock timeout, and server shutdown in progress are related to your server itself so asking for assistance from your new hosting provider would be advised. Call to undefined method stdClass::language() is typically a connection error in the database so checking the connection in conf_global.php (or the above with your provider). The first "OutOfRangeException" has some third party add-ons in the stack trace there so I would recommend disabling these and testing again. The final "OutOfRangeException" is referencing loading or an orphaned a failed promotion item from the database. Do you have the previous installation up and running to test? If you're not receiving the same error, I would suggest exporting and importing the database again as it seems something has gone awry with that process. I think resorting the database worked (wonder why it didn't do anything the first 2 times) just tried to do it again on a separate subdomain (dev) and it seemed to fix the issues. I'll try again on the live forum and let you know if it worked. Thanks! 🙂 Edit: Looks like that fixed it. Thank you so much! 🙂 Edited October 18, 2021 by flashpoint Jim M 1
Jim M Posted October 18, 2021 Posted October 18, 2021 Glad to hear you were able to resolve the issue! flashpoint 1
Recommended Posts