[Forum] Posts not showing on users profiles.

[Greeksgal]

A member has just reported that when they go into their profile and then click on "view all posts from this member" that the posts end in the middle of June and all the recent ones are not there. They're still on the forum, haven't been deleted but do not show up under members profiles.

I've checked and it's the same for everyone, they all end on or around the 14th June.

I've disabled all plugins with "define('DISABLE_HOOKS', true);" in the config and it's still the same.

Any ideas?

[Lynne]

what do you have set for vboptions > message searching options > queue search updates ?

[Greeksgal]

It's set to "Yes".

[Lynne]

If you are queuing the search updates, you need to also make sure you are running the "tsq" scheduled task. Do you have that activated? How often is it set to run?

[Greeksgal]

I don't know what the tsq scheduled task is, it is acp or server side? If I set "queue search updates" to no what will happen?

[Lynne]

Sorry, I think mine is named tsq because I installed a pre-release. If you have a Scheduled Task that runs the filename "./includes/cron/queueprocessor.php", you must set it to YES if you also have vboptions > message searching options > queue search updates set to Yes.

[Greeksgal]

Sorry I took so long in replying, was on holiday. I don't have any sceduled tasks that runs "./includes/cron/queueprocessor.php".

[Lynne]

If you are going to Queue your search updates, and you don't have a scheduled task that does this, then you need to add one:

Title: Search Queue Update
Minute: 0, 10, 20, 30, 40, 50
Active: Yes
Filename: ./includes/cron/queueprocessor.php

Save it.  Run it.  It should now be set to run every 10 minutes on your forum and index all new posts every 10 minutes.

[Greeksgal]

Ok, I did this, I ran it and it said done but all posts under profiles still stop on or around the middle of June.

[Lynne]

Does your database have a table called indexqueue and does it have any rows in it?

Have you ever run maintenance > update counters > rebuild search index?

[Greeksgal]

Not exactly sure what "Rows" are, sorry. I do have a table called indexqueue and it has the following values

records - 65,964
size - 4.7MiB
overhead - 526.9KiB

I have run the rebuild search index, yes. Quite a while back now when I moved over to VB4.

[Lynne]

If you have that many records in that table, then you have not run the cron job I wrote about. When it is done running, you should have 0 records in that table.

Can you post a screen capture of that cron job details?

[Greeksgal]

Sure, find it attached below.

[Greeksgal]

I tried running the job again and got a Database error

Invalid SQL:
SELECT searchcoreid FROM reflexsearchcore WHERE contenttypeid = 7 AND primaryid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number  : 1064
Request Date  : Friday, August 20th 2010 @ 12:38:16 PM
Error Date    : Friday, August 20th 2010 @ 12:38:16 PM
Script        : http://www.*********.com/admincp/cronadmin.php?do=runcron&cronid=38
Referrer      : http://www.*********.com/admincp/cronadmin.php?do=modify
IP Address    : ***********
Username      : ****
Classname     : vB_Database
MySQL Version : 5.0.91-community

[Greeksgal]

Anyone?