Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted May 11, 201510 yr One of my users spammed my forum creating about 500 topics in few seconds, now i can't log in into ACP: An error occured with the SQL server: mySQL query error: SELECT * FROM ipbadmin_login_logs WHERE admin_success = 0 AND admin_time > 0 ORDER BY admin_time DESC LIMIT 0,4 This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Mon, 11 May 2015 18:46:26 +0000 Error: 2006 - MySQL server has gone away IP Address: 46.151.136.60 - /admin/index.php?adsess=20089776754c07f1b276f5313f2cf311 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT * FROM ipbadmin_login_logs WHERE admin_success = 0 AND admin_time > 0 ORDER BY admin_time DESC LIMIT 0,4 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/base/ipsController.php | [admin_core_mycp_dashboard].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Before someone will say 'mysql server problem' ect. More complicated queries works fie (example inner join queries). This is a only mysql problem i've got, like somehow forum cached this error. How to fix it? or how to disable this specific query.
May 11, 201510 yr Register a new user.Open in phpMyAdmin table "ipbmembers"Open for editing your new user. In cell member_group_id change value =4.Sign in with your new profile in the forum and try to log into the admin panel.
Archived
This topic is now archived and is closed to further replies.