My forum isn't updating

[austinelse]

My forum, Killbillet.com isn't updating the post count. If you click on the What's new tab you aren't seeing any posts from yesterday only from two days ago. Also if I reply on a post it isn't updating the reply on the thread. I see an error when posting a new post to a thread saying database error.

Anyone have any idea why this is happening all of a sudden?

[Lynne]

Are your Scheduled Tasks running (check that all "Next Time"s are in the future)?

Anything in the error_logs (if you don't know where they are, ask your host)?

Have you tried disabling your plugins?

When did the problem start and did you ask your host if they changed anything on the server at that time?

[austinelse]

I see all of my scheduled tasks are running as they should be. I don't see an error's log in my Statistics and Log section. I don't think the plugins would be causing this.

The error must have happened between yesterday and this morning. I didn't notice it yesterday but it is happening now.

[Lynne]

As I said, if you don't know where your error_logs are, you will need to ask your host. These are not vbulletin error_logs, they are server (apache) error_logs.

And, you didn't say whether you asked your host if they changed anything yesterday on the server. That's important to know.

[austinelse]

That is in process, just waiting to hear back from our host.

Thanks for your help so far.

[Lynne]

It would also be helpful to know what version of vB you are running and what version of PHP and MySQL are on the server.

[austinelse]

We are running version 4.2.1 for VB and PHP is 5.3.29. I'll check on the MySQL.

--------------- Added [DATE]1415403139[/DATE] at [TIME]1415403139[/TIME] ---------------

I haven't heard back from our hosting service yet on the issue but the forum is still showing the same error. Is there anything else I can check to make sure it is working as it should?

[austinelse]

I'm still waiting to hear back from our host for the errors we are seeing. I found out our Search bar is also not working. I see this error when trying to perform a search.

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT searchcore.searchgroupid, searchgroup.dateline
FROM searchcore AS searchcore
JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)
JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid)

WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('ratrod' IN BOOLEAN MODE);

MySQL Error : Table './killbill_forum/searchcore_text' is marked as crashed and should be repaired
Error Number : 145
Request Date : Monday, November 10th 2014 @ 12:15:57 PM
Error Date : Monday, November 10th 2014 @ 12:15:57 PM
Script : http://www.killbillet.com/search.php?do=process
Referrer : http://www.killbillet.com/forum.php
IP Address : 73.53.69.136
Username : Dan the Man
Classname : vB_Database
MySQL Version : 5.5.37-cll

[Zachery]

Repair the searchcore_text table then.

[austinelse]

where would I find searchcore_text table? I have an IT guy that normally takes care of things like this for me as I am not web design smart but I know the forum.