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

A server error occurred. Please try again later.

Discussion in 'Troubleshooting and Problems' started by Jeffin, Mar 15, 2013.

  1. Jeffin

    Jeffin Well-Known Member

    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
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Check the log for a more detailed error message:

    Admin CP -> Tools -> Server Error Log
     
    Jeffin likes this.
  3. Jeffin

    Jeffin Well-Known Member

    Hi Jake, I can't even login to AdminCP

    ss.jpg

    It says: Security error occurred. Please press back, refresh the page, and try again.
     
  4. MattW

    MattW Well-Known Member

    Are you getting anything in the logs on the server itself?
     
    Jeffin likes this.
  5. Jeffin

    Jeffin Well-Known Member

    A site monitoring service reported downtime about 4 hours ago which it says may be caused by the server. But I have two wordpress blogs hosted in the same server and both are running okay. This is what made me think that its specific to the forum.
     
  6. MattW

    MattW Well-Known Member

    Do you have any logs on the server itself? Is this shared hosting, or your own VPS/Dedicated server?
     
    Jeffin likes this.
  7. Jeffin

    Jeffin Well-Known Member

    Okay, I just got into AdminCP and found so many server log errors:

    Mysqli prepare error: Table './xxxxxx_xf/xf_session' is marked as crashed and should be repaired1 minute ago - library/Zend/Db/Statement/Mysqli.php:77

    What does this mean?
     
  8. MattW

    MattW Well-Known Member

    Basically, there is an issue with the MySQL database. It's telling you that the xf_session table has crashed.

    If you can access the database with phpMyAdmin, you can run a repair on that table.
     
    Renegade, Jeffin and Jake Bunce like this.
  9. Jeffin

    Jeffin Well-Known Member

    Thank you Matt. That seems to be the problem. But I have no experience repairing tables.

    Right now I have logged in phpMyAdmin and brought up the xf_session table from the the correct database. Now it shows in there #145 - Table './jeffinj_xf/xf_session' is marked as crashed and should be repaired

    I can see a few links such as Structure, SQL, Import, Operations. What do I do from here?
     
  10. Jeffin

    Jeffin Well-Known Member

    I own a VPS.
     
  11. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Operations -> Repair Table
     
    Jeffin and MattW like this.
  12. MattW

    MattW Well-Known Member

    If you are happy to give me access, I can take a look for you?
     
    Jeffin likes this.
  13. Jeffin

    Jeffin Well-Known Member

    Sure, I will private message you.
    I don't see the repair table option.
     
  14. MattW

    MattW Well-Known Member

    I've repaired the table, and the site is back online now.
     
  15. Jeffin

    Jeffin Well-Known Member

    Thank you very much MattW and Jake Bunce. You guys are awesome. Love this community. (y):D
     
    wickedstangs, 14DH01 and MattW like this.
  16. Renegade

    Renegade Well-Known Member

    Exact same thing happened to my forum today. Good that this thread was handy. But this makes me think whether this happens often and with multiple instances?
     
  17. Biker

    Biker Well-Known Member

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

    RoldanLT Well-Known Member

    This problem is server issue.
    VPS mis configuration or poor VPS
     
  19. Jeffin

    Jeffin Well-Known Member

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

    MattW Well-Known Member

    If you have access to the server, you could look to see if there is anything in the MySQL error log to see if it reported anything
     
    Jeffin likes this.

Share This Page