Smart search indexer fails with "Unable to set as revision as current revision on post"
By Roel on Tuesday, 11 August 2015
Posted in Technical Issues
Likes 0
Views 1.8K
Votes 0
Hi,

I have version 5.0.19 of easyblog and I want to use smart search.
For that, I installed the smart search plugin and logged into a SSH session.
Then I run the 
php finder_indexer.php
command.

It stops after a first batch with the error: "UNABLE TO SET AS REVISION AS CURRENT REVISION ON POST"

This exact problem was fixed in this thread, but I don't have enough info from that thread to fix my own issue. (http://stackideas.com/forums/cannot-access-blogs-at-all-error-400-unable-to-set-as-revision-as-current-revision-on-post)

The exact output from the SSH client:



Smart Search INDEXER

============================

Starting Indexer

Setting up Smart Search plugins

Setup 1041 items in 0.443 seconds.

 * Processed batch 1 in 12.032 seconds.

Unable to set as revision as current revision on post.


Can you help me?

Thanks,

Roel
Hey Roel,

I am really sorry that delay of this reply,

I've checked in your database, it seems like some of the data from your `xx_easyblog_revisions` table exist `created_by` = 0 , I've already help you removed these record and I help you re-index again, it work fine now .
Arlex Wong
·
Wednesday, 19 August 2015 16:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Roel,

I am sorry for the delay of this reply.

Can you give us your phpMyAdmin access so we can your database directly? It seems like there are revision post that are not associated with any of your current blog post thus causing the issue when smart search are trying to index your blog post.

Please advise.
Ezrul Fazwan
·
Tuesday, 11 August 2015 13:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Ezrul,

Ok. I tried the following statement, but it did not return any anomalities.

SELECT `post_id` 

FROM `xx_easyblog_revisions`  

WHERE NOT EXISTS 

(SELECT `id` FROM `xx_easyblog_post`)


I will send you the phpadmin login.

Thank you,

Roel
Roel
·
Tuesday, 11 August 2015 16:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Ezrul,

Did you have time to have a look at it?

Thanks,

Roel
Roel
·
Friday, 14 August 2015 19:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Fantastic, Thank you!
Roel
·
Thursday, 20 August 2015 23:53
·
0 Likes
·
0 Votes
·
0 Comments
·
You're welcome, glad to heard your issue resolved.
Arlex Wong
·
Friday, 21 August 2015 16:58
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post