Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 24Feb 24 I getting the following errors:This, below, is when I click on the Admin Panel > Members section.OutOfRangeException: (0)#0 /var/www/applications/core/modules/admin/members/members.php(369): IPS\Patterns\_ActiveRecord::load()#1 /var/www/system/Helpers/Table/Db.php(454): IPS\core\modules\admin\members\_members->IPS\core\modules\admin\members\{closure}()#2 /var/www/system/Helpers/Table/Table.php(504): IPS\Helpers\Table\_Db->getRows()#3 /var/www/applications/core/modules/admin/members/members.php(629): IPS\Helpers\Table\_Table->__toString()#4 /var/www/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\members\_members->manage()#5 /var/www/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()#6 /var/www/admin/index.php(13): IPS\_Dispatcher->run()#7 {main}This, below, is when I click on the Admin Panel > Group section.OutOfRangeException: (0)#0 /var/www/applications/core/modules/admin/members/groups.php(152): IPS\Patterns\_ActiveRecord::load()#1 /var/www/system/Helpers/Table/Db.php(476): IPS\core\modules\admin\members\_groups->IPS\core\modules\admin\members\{closure}()#2 /var/www/system/Helpers/Table/Table.php(504): IPS\Helpers\Table\_Db->getRows()#3 /var/www/applications/core/modules/admin/members/groups.php(169): IPS\Helpers\Table\_Table->__toString()#4 /var/www/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\members\_groups->manage()#5 /var/www/applications/core/modules/admin/members/groups.php(39): IPS\Dispatcher\_Controller->execute()#6 /var/www/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\members\_groups->execute()#7 /var/www/admin/index.php(13): IPS\_Dispatcher->run()#8 {main} Edited February 24Feb 24 by NAWAC
February 24Feb 24 Was your previous database completely deleted? Typically, this is that the system could not find the requested record in the database: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.
February 24Feb 24 Author 10 minutes ago, Jim M said:Was your previous database completely deleted? Typically, this is that the system could not find the requested record in the database:No, I followed the directions for moving to another server.Maybe there was an error in importing the database using phpMyAdmin. It had to upload several iterations due to the number of records in my database so it wouldn't timeout (standard phpMyAdmin procedure). Maybe I'll try re-importing everything into MySQL again, this time using the command prompt, that seems to always work without any hiccups. I'll do that first, then if I'm still getting the error, I'll update my access information in my Client Area.
February 24Feb 24 Just now, NAWAC said:No, I followed the directions for moving to another server.Maybe there was an error in importing the database using phpMyAdmin. It had to upload several iterations due to the number of records in my database so it wouldn't timeout (standard phpMyAdmin procedure). Maybe I'll try re-importing everything into MySQL again, this time using the command prompt, that seems to always work without any hiccups. I'll do that first, then if I'm still getting the error, I'll update my access information in my Client Area.Most likely there is an error with your migration to the new server then. SSH should be used for database restores for anything over a few MBs as web browsers are not reliable and may cause errors.
February 24Feb 24 Author Solution Importing to MySQL from the command prompt seem to have fixed the problem. Sorry to bother everyone. I should have known better. Thanks.