Avariel Posted May 11, 2015 Posted May 11, 2015 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.
Adlago Posted May 11, 2015 Posted May 11, 2015 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.