• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

#1
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
#2
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
#3
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?
 
#4
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
#5
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.
 
#6
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
#7
If you require help with an add-on, you will need to post in the dedicated discussion thread.