*Help* Delete all posts by user not working

[Praxea]

My forum was hit hard by spam bots a day ago, I attempt to moderate and delete all posts by user but there are so many that I get an error (I'm assuming it's related to the volume).

https://vborg.vbsupport.ru/external/2017/01/10.png

Is there a query I can run to delete posts by user? I can't find anything for VB5 on this :(

Any help would be appreciated.

[noypiscripter]

Check the server for error logs to see the exact error. And if there was a database error, you should have received an email from the email address configured to receive database error emails in the core config file.

[Praxea]

Checked, I'm seeing a lot of "Maximum execution time of 30 seconds exceeded "

[noypiscripter]

Increase the max_execution_time in php.ini on your server. If you don't have access to it, then you should ask your host to change it. If you are on a shared plan, then usually it cannot be changed as it may affect other sites on the same aerver. In that case, you should upgrade to a VPS or dedicated plan.