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

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

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:
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.webp

When attempting to access the actual search index table in myphpadmin it says that it has crashed
 
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
 
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)
 
Top Bottom