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 1415403139 at 1415403139 ---------------

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.

[Dave]

AdminCP > Maintenance > Repair/Optimize Tables > look for the table, tick repair/optimize and click on continue.

[austinelse]

Dave, thank you for the direction on how to resolve the search bar issue. We have it fixed and working now.

Our activity stream still isn't updating anything new since last Wednesday. The host for our forum is looking into that currently. We tried to repair the activity stream on the forum but were unable to do so. Is there anything else we can look into to fix this issue?

[Zachery]

Does running the search, still produce an SQL error?

[austinelse]

The SQL error is gone now when performing a search.

[HM666]

Just a stab in the dark but have you tried to repair & optimize all the tables through the process that Dave stated above? You might want to try that.

[austinelse]

Yes we have attempted to repair/optimize as suggested above

[HM666]

Ok as an unregistered user I click on the "What's New" link and I see updates from today in the list of updates. So I wonder if its only something that happens when you are logged in. Have you tried logging out and looking at that page to see if you get something different from when you are logged in? When you are logged in you should see threads that you have not read yet. At least I think that is how it works, it may not be though.

[austinelse]

sorry I haven't responded since the 12th. Our forum is back up and running. Thanks for all of the help and suggestions.

[Budget101]

sorry I haven't responded since the 12th. Our forum is back up and running. Thanks for all of the help and suggestions.


I am also running the same version php & experiencing the same issues as well- it just doesn't seem to update past 2 days no matter what I try. How did you get yours fixed?

[Gio~Logist]

Are you running any caching mods on vBulletin or perhaps running a 3rd party caching tool on your server?