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

[Appledevdude]

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.

Beryllium Servers - Error
A server error occurred. Please try again later.

 

[Appledevdude]

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

 

[Paul B]

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]

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

 

[Appledevdude]

I tried to access the admin panel, to follow these instructions, but i cant.

https://xenforo.com/community/threads/a-server-error-occurred-please-try-again-later.46190/

 

[Paul B]

You can access it directly here: http://berylliumservers.com/forums/admin.php

 

[Appledevdude]

alright, i got into the admin panel, and it shows the same errror as https://xenforo.com/community/threads/a-server-error-occurred-please-try-again-later.46190/, how do i repair the table?

 

[Paul B]

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

 

[Appledevdude]

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

how do i repair the table?

I have no idea how, i never mess with phpmyadmin

 

[Paul B]

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

 

[Appledevdude]

never mind, i found it, the forum is fixed

 

[Webby]

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:



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.

 

[Paul B]

Truncate it and rebuild the search index.

 

[Webby]

Truncate it and rebuild the search index.

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?

 

[Paul B]

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]

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



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

 

[Paul B]

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:

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]

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:

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.

Thanks for the help buddy. Great service as always.