getFollowingandOthers query problem - fix

[fisnik]

I loaded this project based on your recomendations on twitter and got it to work half way. There is a problem with your Cypher Query data retrieval for the following part.

Currently it is - var follows = results[i][count(rel)]; It should be - var follows = results[i][COUNT(rel)];

as it is returning none of the followers to the caller function.

After these changes all worked as expected.

[aseemk]

Hmm, did you see the comment below that line?

var follows = results[i]['count(rel)'];
    // XXX neo4j bug: returned names are always lowercase!
    // TODO FIXME when updating to the next version of neo4j.

The lowercase was a workaround for the bug which was present in Neo4j 1.6. Are you on a more recent version? If so, which one?

I ask because Neo4j 1.7 had introduced a different bug (a regression) which prevented the followers from getting returned:

https://groups.google.com/forum/#!topic/neo4j/rfYgK68oGSI

I got this reply:

hey aseem,

sorry for the upgade. i downgraded this database to1.6.2, but as we will go live the only available version will be 1.8.

can you duplicate your heroku app and try to use the latest snapshot? (heroku addons:add neo4j --neo4j-version 1.8.M04)

thanks a lot for finding the bug,

cheers, thomas

So hopefully both these bugs are indeed fixed!

[fisnik]

Using a local version -1.8. where the UpperCase worked. When i tried to push that on Heroku however, the non-followers are not returned (so back to square 0).

do you know how do i get the followers cypher to work on heroku neo4j?

[aseemk]

Which version of Neo4j is running on Heroku? You can tell by going to the webadmin.

If it's not the same version as your local one, you could try removing and re-adding the add-on with the --neo4j-version flag as the email above shows.

Great to hear both bugs are fixed in 1.8.

[fisnik]

webadmin is constantly down on my heroku - no way of telling for now! will update you on it once they bring it up again.

[fisnik]

1.8.M06 installed on heroku all seems to be working nominally -- the cypher is returning the results in the right variable. The previous version on heroku was 1.7 and none of the cyphers related to relationships were returning anything.

Thanks for pointing out and providing the heroku addon script. Right now heroku is at 1.8.M06.

[aseemk]

Great to hear. As soon as 1.8 GA is out, I'll update the deployment and this code. Thanks again!

[aseemk]

Applied this fix to the code (thanks @fisnik), but the Heroku addon is failing to deploy Neo4j 1.8. Have an email out to the Neo4j team to check. Will close this as soon as this is live.

[fisnik]

did you try "heroku addons:add neo4j --neo4j-version 1.8.M0[x]" --- also Heroku finally fixed the neo4j web console (first time i saw it working was last night) while the addon was always working for me

[aseemk]

I had and it was failing. But it started working again a while back and the live version is working. Thanks for the reminder -- this is fixed!