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

[omoe]

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

page source

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]

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

 

[TPerry]

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]

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 ?.

 

[TPerry]

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.

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.

 

[EliteWhopper]

When you run out of storage.

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?

 

[Paul B]

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

 

[Sakata Gintoki]

I think it might have something to do with your MySQL.

 

[EliteWhopper]

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

I think it might have something to do with your MySQL.

It wasn't, I got it fixed though. Sorry for bugging you guys.