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

#1
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.
 

Brogan

XenForo moderator
Staff member
#3
This error happened right after the windows update on my VPS
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.
 

Chris D

XenForo developer
Staff member
#4
That particular error may well have logged more information in the XenForo Server Error Log in your Admin CP.
 
#12
Log into phpMyAdmin and either repair or truncate the xf_session table.
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:

Brogan

XenForo moderator
Staff member
#15
Truncate means to empty - so just click on the option to empty the table.

You rebuild the search index in the ACP Tools menu.
 
#16
Truncate means to empty - so just click on the option to empty the table.

You rebuild the search index in the ACP Tools menu.
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
 

Brogan

XenForo moderator
Staff member
#17
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
 
#18
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
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)