XF 1.3 An unexpected database error occurred. Please try again later.

omoe

Member
Hi , When people try to register to my forums they get this error , An unexpected database error occurred. Please try again later.

page source
Code:
An unexpected database error occurred. Please try again later.
<!-- Mysqli prepare error: MySQL server has gone away -->
They can still register fine using FaceBook , Google or Twitter though , I have a VPS with 6GP rams and 4 Cores , Currently i have 30,000 members registered since i started the forum 2 weeks ago , Average users online is 200-750 , Other than the registration problem everything is working fine , I tried File Health Check and there was no problem with the files , Any suggestions ?.
 

Andrej

Well-known member
http://xenforo.com/community/threads/troubleshooting-faq-frequent-problems-solutions.62138/
P: I get an error when attempting to load a page and it states "MySQL server has gone away".
S: This is an issue with your server and something your host will be the best to help you solve. If you attempt to reload the page/rerun the task you received the error on, it is a possibility that it will be successful. Here are some related links to this specific error:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
http://xenforo.com/community/threads/unknown-error.56990/#post-607130
 

Tracy Perry

Well-known member
To add to @Andrej's post... are you using any add-ons that filter/monitor new registrations (anti-spam, etc).... and are they the latest versions?
Does this occur if said add-ons are disabled?
 

omoe

Member
To add to @Andrej's post... are you using any add-ons that filter/monitor new registrations (anti-spam, etc).... and are they the latest versions?
Does this occur if said add-ons are disabled?
Disabling the Add-ons fixed the problem thank you very much! , I know this isnt related to the first post but i have a question about the database , My database size is currently 120MB , But its growing really fast , How large is too large for a database ?.
 

Tracy Perry

Well-known member
Disabling the Add-ons fixed the problem thank you very much! , I know this isnt related to the first post but i have a question about the database , My database size is currently 120MB , But its growing really fast , How large is too large for a database ?.
When you run out of storage. :LOL:

The size is not the restraining factor that you will run into... it will be your processing power/memory.

Try to figure out which add-on it was. There may be a bug in the code and I'm sure the add-on author would like to know about the problem.
 
When you run out of storage. :LOL:

The size is not the restraining factor that you will run into... it will be your processing power/memory.

Try to figure out which add-on it was. There may be a bug in the code and I'm sure the add-on author would like to know about the problem.
For me it was Xenporta, help?
 

Brogan

XenForo moderator
Staff member
If you require help with an add-on, you will need to post in the dedicated discussion thread.
 
Top