Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
in Q2A Core by
edited by

I'm having difficulty accessing my server again. My site Q2A is exhibiting again this error message: 


And my server displays this message:

ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 55057976 bytes) (Show.php:217)


Print of the database:





Q2A version: 1.7
Do you use Simple adverts plugin?
I used this plugin for some time but now uninstalled.
This plugin add thousands of lines qa_options but Scott helped me remove.

1 Answer

+1 vote
selected by
Best answer
What is the Show.php file in your error message? Must be from a plugin/theme. There is possible something in that file that is running an infinite loop, or just trying to load too much data.

Your database looks fine. The only possible issue is the eventlog table. It has a lot of entries so perhaps queries of that table from plugins might be slow, or causing the error. You might want to delete data from that table that's older than a few months.
This message appears only when I try to get into the error log. I can no longer access it.

Messages that are now appearing are:

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[08004] [1040] Too many connections (Abstract.php:144)

ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Too many connections (Error code: 1040) (Abstract.php:69)
The memory of the PHP limit is 256M.
Do you think that increasing this limit can solve?
You shouldn't need to increase the memory limit.

Where is the Zend_Db_Adapter_Exception and PleskDBException coming from? They are not in Q2A.
I use the Plesk control panel.