A server error occurred. Please try again later.

[Jeffin]

Just a few hours ago, my forum is showing
A server error occurred. Please try again later.

and when I login to the forum, it shows
Security error occurred. Please press back, refresh the page, and try again.

Any idea what it might be? I haven't changed any settings or installed anything and only I have admin access to the forum. Need help please. My site is www.christianforumsite.com

 

[Jake Bunce]

Since converting to XF a year and a half ago, I've never once had to repair my DB.

It's the first time it happened to me. No idea what might have caused it? May be server load or something?

MyISAM tables are more susceptible to superficial corruption during events like server crashes. A repair will usually fix it.

XenForo uses mostly InnoDB tables which don't experience the same kind of superficial corruption as MyISAM. But there are a few tables in XF that use MyISAM such as xf_session which became corrupt for jeffinj. A repair fixed it.

 

[fury]

A circuit breaker tripped which caused several databases and tables to go wonky

Is there a way I can inject a message into the site while the database is being repaired? Right now all it is doing is telling people a server error occurred (and before I turned off debug mode, it was even going as far as to describe them the call stack and specific mysql error). I would like to change that message to say "hey, I'm working on the problem but I don't know when it will finish, lots of databases to go through and repair" but I'm not sure right off the bat where to go do that

 

[Jake Bunce]

Use htaccess to redirect visitors to a temporary page with a message on it:

http://xenforo.com/community/thread...s-away-during-installation.30075/#post-344694

 

[fury]

Use htaccess to redirect visitors to a temporary page with a message on it:

http://xenforo.com/community/thread...s-away-during-installation.30075/#post-344694

Thanks! Dunno why I didn't think of that, I guess the heat of the moment..sigh. stupid circuit breakers

 

[SportainmentMG]

This is now happening to me - my server error states:

ErrorException: Undefined variable: errno - library/Zend/Http/Client/Adapter/Socket.php:236

It is at the moment preventing people from registering. Anyone know a way to fix it? I am on shared hosting.

 

[Paul B]

That indicates a server problem.

Have you tried contacting your host to see if there are any current issues?

 

[sforum]

Just a few hours ago, my forum is showing
A server error occurred. Please try again later.

and when I login to the forum, it shows
Security error occurred. Please press back, refresh the page, and try again.

Any idea what it might be? I haven't changed any settings or installed anything and only I have admin access to the forum. Need help please. My site is www.christianforumsite.com

Exactly the same thing is happening to my site. My host has advised "Likely stems from table corruption. Databases > phpMyAdmin > check & repair the tables", but I have logged into phpMyAdmin and I can't see anything like "Check & repair tables".

Can someone help, please? I'm a complete MySQL noob so don't know what I'm doing, and I don't want to mess up the database.

Thanks.

 

[sforum]

If it's any help, I have just logged-on to phpMyAdmin to see if anything was obviously wrong (even to a bumbling buffoon like me), and noticed the following lines:

xf_session

Browse Structure

Search Insert

Empty Drop in use
xf_session_activity

Browse Structure

Search Insert

Empty Drop

0​

MEMORY utf8_general_ci

0 B​

-​

xf_session_admin Browse Structure Search Insert Empty Drop

1​

MyISAM utf8_general_ci

4.1 KiB​

988 B​

I don't remember seeing anything like that before. Is that right?

I haven't got a clue where to start fixing this.

 

[MattW]

Exactly the same thing is happening to my site. My host has advised "Likely stems from table corruption. Databases > phpMyAdmin > check & repair the tables", but I have logged into phpMyAdmin and I can't see anything like "Check & repair tables".

Can someone help, please? I'm a complete MySQL noob so don't know what I'm doing, and I don't want to mess up the database.

Thanks.

Check the tables that are marked as crashed. Down the bottom, there is a drop down box.

 

[sforum]

Check the tables that are marked as crashed. Down the bottom, there is a drop down box.

View attachment 47379

Thanks for the prompt reply. How do I know which tables are crashed? xf_session is flagged as "in use" - is that what you mean?

 

[MattW]

Thanks for the prompt reply. How do I know which tables are crashed? xf_session is flagged as "in use" - is that what you mean?

Well it depends on what exactly is happening with your site. Do you have a link so we can see what's going on?

 

[sforum]

Well it depends on what exactly is happening with your site. Do you have a link so we can see what's going on?

[edit: URL removed as problem now resolved, thanks to MattW]

Thanks.

 

[MattW]

Yes, I'd suggest trying to run a repair on that table.

If it doesn't work via phpMyAdmin, you might need to get your host to do it via command line:

https://billing.handsonwebhosting.c...-but-table-will-not-repair-in-phpmyadmin.html

 

[MattW]

Looks like you are back online

 

[sforum]

Yes, I'd suggest trying to run a repair on that table.

If it doesn't work via phpMyAdmin, you might need to get your host to do it via command line:

https://billing.handsonwebhosting.c...-but-table-will-not-repair-in-phpmyadmin.html

That seemed to do the trick! Thanks so much.

Is there anything else I should be checking - i.e. anything else that might still be "broken", but I'm perhaps not aware of it because the site seems otherwise fine?

 

[MattW]

Not really, if it's back online, and there are no other tables showing with any messages at the side of them in phpMyAdmin, you should be good to go

 

[lazer]

It's threads like this that anyone umm-ing and ahh-ing about buying xF should be directed to.

This community is solid and support offered and given by members is un-surpassed.

 

[sforum]

It's threads like this that anyone umm-ing and ahh-ing about buying xF should be directed to.

This community is solid and support offered and given by members is un-surpassed.

Definitely. I've had a couple of instances of my site going down and I've felt completely helpless, and each time someone from this community has got me back up and running within minutes.

Thanks very much MattW; I was in a right pickle!

 

[JacquiiDesigns]

Wow. I logged into (or tried to log into rather) my forum a few moments ago, only to see the same error.
I wasn't exactly sure what the error was - but had an idea that there was a corrupt table that needed to be reparied or some such. So I googled and immediately this thread came up in the results.

So thanks to all who've assisted the OP with the fix. It was a great help.

Hope you all had a very happy Thanksgiving.

J.