JaxOFW Posted September 8, 2020 Share Posted September 8, 2020 After moving my files to a new server and installing all the dependencies I got this error. 2020_09_08_serverlist_requery.php - Tue, 08 Sep 2020 13:37:12 +0000 IPS\Db\Exception::2006 MySQL server has gone away #0 /var/www/system/Db/Select.php(373): IPS\_Db->preparedQuery('/*IPS\\serverlis...', Array, true) #1 /var/www/system/Db/Select.php(436): IPS\Db\_Select->runQuery() #2 /var/www/applications/serverlist/sources/Library/Library.php(75): IPS\Db\_Select->rewind() #3 /var/www/applications/serverlist/tasks/serverlist.php(48): IPS\serverlist\_Library->requeryAll() #4 /var/www/system/Task/Task.php(261): IPS\serverlist\tasks\_serverlist->execute() #5 /var/www/system/Task/Task.php(224): IPS\_Task->run() #6 /var/www/applications/core/interface/task/task.php(56): IPS\_Task->runAndLog() #7 {main} 2020_09_08_uncaught_exception.php - Tue, 08 Sep 2020 13:37:12 +0000 IPS\Db\Exception::2006 MySQL server has gone away #0 /var/www/system/Db/Db.php(1150): IPS\_Db->preparedQuery('/*IPS\\_Task::ru...', Array) #1 /var/www/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`core_tasks` co...', '`running`=?,`ne...', 'WHERE id=?') #2 /var/www/system/Task/Task.php(267): IPS\Patterns\_ActiveRecord->save() #3 /var/www/system/Task/Task.php(224): IPS\_Task->run() #4 /var/www/applications/core/interface/task/task.php(56): IPS\_Task->runAndLog() #5 {main} Link to comment Share on other sites More sharing options...
0 Oni Posted September 9, 2020 Share Posted September 9, 2020 Check that there is a PRIMARY KEY set on your table (core_acp_notifications), and that the PRIMARY KEY is set to AUTO-INCREMENT. Please no more private messages, mentions or anything like that. I don't offer any support at the moment. Link to comment Share on other sites More sharing options...
0 JaxOFW Posted September 8, 2020 Author Share Posted September 8, 2020 getting this error now, I followed these guides. https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mariadb-php-lamp-stack-debian9 https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-debian-9 Link to comment Share on other sites More sharing options...
0 Oni Posted September 8, 2020 Share Posted September 8, 2020 Install MySQL 5.6.2 or above as recommended or use another version of MariaDB, it seems like IPS doesn't support your version of MariaDB. Please no more private messages, mentions or anything like that. I don't offer any support at the moment. Link to comment Share on other sites More sharing options...
0 JaxOFW Posted September 8, 2020 Author Share Posted September 8, 2020 (edited) 30 minutes ago, Oni said: Install MySQL 5.6.2 or above as recommended or use another version of MariaDB, it seems like IPS doesn't support your version of MariaDB. I've done so multiple times. Also, I have multiple ip addresses attached to the server and I think that is causing the issue. Edited September 8, 2020 by JaxOFW Link to comment Share on other sites More sharing options...
0 JaxOFW Posted September 9, 2020 Author Share Posted September 9, 2020 (edited) Getting This Now Edited September 9, 2020 by JaxOFW Link to comment Share on other sites More sharing options...
0 JaxOFW Posted September 9, 2020 Author Share Posted September 9, 2020 (edited) 2 hours ago, Oni said: Check that there is a PRIMARY KEY set on your table (core_acp_notifications), and that the PRIMARY KEY is set to AUTO-INCREMENT. thanks Edited September 9, 2020 by JaxOFW Link to comment Share on other sites More sharing options...
0 Administrator Tony Posted December 1, 2020 Administrator Share Posted December 1, 2020 The question(s) in this support topic have been answered and the topic author has resolved their issue. This topic is now closed. If you have other questions, please open a new topic. Link to comment Share on other sites More sharing options...
Question
JaxOFW
After moving my files to a new server and installing all the dependencies I got this error.
2020_09_08_serverlist_requery.php
-
Tue, 08 Sep 2020 13:37:12 +0000
IPS\Db\Exception::2006
MySQL server has gone away
#0 /var/www/system/Db/Select.php(373): IPS\_Db->preparedQuery('/*IPS\\serverlis...', Array, true)
#1 /var/www/system/Db/Select.php(436): IPS\Db\_Select->runQuery()
#2 /var/www/applications/serverlist/sources/Library/Library.php(75): IPS\Db\_Select->rewind()
#3 /var/www/applications/serverlist/tasks/serverlist.php(48): IPS\serverlist\_Library->requeryAll()
#4 /var/www/system/Task/Task.php(261): IPS\serverlist\tasks\_serverlist->execute()
#5 /var/www/system/Task/Task.php(224): IPS\_Task->run()
#6 /var/www/applications/core/interface/task/task.php(56): IPS\_Task->runAndLog()
#7 {main}
2020_09_08_uncaught_exception.php
-
Tue, 08 Sep 2020 13:37:12 +0000
IPS\Db\Exception::2006
MySQL server has gone away
#0 /var/www/system/Db/Db.php(1150): IPS\_Db->preparedQuery('/*IPS\\_Task::ru...', Array)
#1 /var/www/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`core_tasks` co...', '`running`=?,`ne...', 'WHERE id=?')
#2 /var/www/system/Task/Task.php(267): IPS\Patterns\_ActiveRecord->save()
#3 /var/www/system/Task/Task.php(224): IPS\_Task->run()
#4 /var/www/applications/core/interface/task/task.php(56): IPS\_Task->runAndLog()
#5 {main}
Link to comment
Share on other sites
7 answers to this question
Recommended Posts