My server has been getting multiple SQL attacks, and now I can't even log in! Anyone experience this before? I need help repairing this!?
An exception occurred while executing 'SELECT DISTINCT e.* FROM elgg_entities e JOIN elgg_users_entity type_table ON e.guid = type_table.guid WHERE ((type_table.username = 'M1K3')) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((e.access_id IN (2,-5))) ORDER BY e.time_created desc LIMIT 0, 1':
SQLSTATE[HY000]: General error: 145 Table '.\DBNAME\elgg_users_entity' is marked as crashed and should be repaired
QUERY: SELECT DISTINCT e.* FROM elgg_entities e JOIN elgg_users_entity type_table ON e.guid = type_table.guid WHERE ((type_table.username = 'M1K3')) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((e.access_id IN (2,-5))) ORDER BY e.time_created desc LIMIT 0, 1
PARAMS: Array
(
)
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by Raül Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Nikolai Shcherbin@rivervanrain

Nikolai Shcherbin - 0 likes
- Using PHP My Admin check on elgg_users_entity table and run 'Repair'
- Using terminal connect to your mysql DB and run command:
- M1K3@M1K3

M1K3 - 0 likes
You must log in to post replies.In first, backup your DB.
Now choose of method:
Learn docs also
got it using this, thanks
mysqlcheck -uroot -p --repair --all-databases