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

XF 1.5 Error A server error occurred. Please try again later.

Discussion in 'Troubleshooting and Problems' started by Appledevdude, Nov 22, 2015.

  1. Appledevdude

    Appledevdude Member

    This error happened right after the windows update on my VPS, i run windows 2012, if anyone has any ideas on how to fix this.

    Code:
    Beryllium Servers - Error
    A server error occurred. Please try again later.
     
  2. Appledevdude

    Appledevdude Member

    I already contacted the VPS host (NFO), they said they cant do anything about it.
     
  3. Brogan

    Brogan XenForo Moderator Staff Member

    That sounds like a possible candidate then.

    Ask your host to check the server error log and investigate as necessary.

    If they are unwilling or unable to assist then you may want to consider a different host.
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    That particular error may well have logged more information in the XenForo Server Error Log in your Admin CP.
     
  5. Appledevdude

    Appledevdude Member

  6. Brogan

    Brogan XenForo Moderator Staff Member

  7. Appledevdude

    Appledevdude Member

  8. Brogan

    Brogan XenForo Moderator Staff Member

    Log into phpMyAdmin and either repair or truncate the xf_session table.
     
  9. Appledevdude

    Appledevdude Member

    :p
    I have no idea how, i never mess with phpmyadmin
     
  10. Brogan

    Brogan XenForo Moderator Staff Member

    Your host may be able to help if you explain to them what needs to be done.
     
  11. Appledevdude

    Appledevdude Member

    never mind, i found it, the forum is fixed
     
  12. Webby

    Webby Member

    I was getting A server error occurred. Please try again later. when trying to post. To resolve the issue I clicked repair in phpmyadmin and but now I am getting this error when attempting to post:

    help.png

    Apparently the repair failed, does the guy here know what he is talking about with running the repair manually?
    https://stackoverflow.com/questions/2296444/how-to-repair-a-mysql-table-without-using-phpmyadmin

    I ran

    repair table xf_session

    Still same problem. :(
     
    Last edited: Dec 24, 2015
  13. Brogan

    Brogan XenForo Moderator Staff Member

    Truncate it and rebuild the search index.
     
    Webby likes this.
  14. Webby

    Webby Member

    I read about truncate but doesn't that mean to essentially delete it? Should I back it up?

    Also for search index you are talking about xf_search_index right?
     
  15. Brogan

    Brogan XenForo Moderator Staff Member

    Truncate means to empty - so just click on the option to empty the table.

    You rebuild the search index in the ACP Tools menu.
     
    Webby likes this.
  16. Webby

    Webby Member

    Mysql says that it returned an empty result set, I also got this after rebuilding the searches

    help22.png

    When attempting to access the actual search index table in myphpadmin it says that it has crashed
     
  17. Brogan

    Brogan XenForo Moderator Staff Member

    You may need to contact your host if the table is crashing continuously.

    A repair or truncate and rebuild is typically all that is required to resolve it.

    Otherwise you can try dropping and recreating it:
    Code:
    CREATE TABLE `xf_search_index` (
     `content_type` varchar(25) NOT NULL,
     `content_id` int(10) unsigned NOT NULL,
     `title` varchar(250) NOT NULL DEFAULT '',
     `message` mediumtext NOT NULL,
     `metadata` mediumtext NOT NULL,
     `user_id` int(10) unsigned NOT NULL DEFAULT '0',
     `item_date` int(10) unsigned NOT NULL,
     `discussion_id` int(10) unsigned NOT NULL DEFAULT '0',
     PRIMARY KEY (`content_type`,`content_id`),
     KEY `user_id_item_date` (`user_id`,`item_date`),
     FULLTEXT KEY `title_message_metadata` (`title`,`message`,`metadata`),
     FULLTEXT KEY `title_metadata` (`title`,`metadata`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8
     
    Webby likes this.
  18. Webby

    Webby Member

    Yeah I was having other problems(Error 500,mysqli statement execute error:diskfull) earlier today and I contacted my host. They said that they are updating their server. I am using arvixe. Hopefully they will be able to help, in the meantime I can sit in the corner and cry. :cry:

    Thanks for the help buddy. Great service as always.(y)
     

Share This Page