Hi, I've only started to investigate your module and was testing the features for my use case.

And oops i've broken it already! I was only trying out CCK and Taxonomy features and now I get this error:

# user warning: 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 query: INSERT INTO associated_nodes_cache (aid, nid, associated_nid, score) VALUES in /var/www/explorer/sites/all/modules/associated_nodes/associated_nodes.module on line 403.
# user warning: 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 query: INSERT INTO associated_nodes_cache (aid, nid, associated_nid, score) VALUES in /var/www/explorer/sites/all/modules/associated_nodes/associated_nodes.module on line 403...............................

What should I do?

Comments

jfberroyer’s picture

jfberroyer commented

Hello,

Can you give me the complete SQL queries that fail ?
I know there is a bug with some insert query of Associated Nodes when using PostgreSQL, but I don't think it is the problem here.
Don't hesitate to tell me if you have more informations about this bug. Thanks.

ludo1960’s picture

ludo1960 commented

Hi,

Thanks for getting back to me, seems I had broken links (from tests) in a view that I had created. Problem gone!

I was just playing about with a test site trying to work out how your module works, I found your module after getting the Content Taxonomy module and i'm trying see if it all fits my use case. A couple of questions if I may:

1 Any advantage of using Taxonomy over CCK for Node association or vice versa?
2 Does your module ignore any references created by Node reference?

My use case:

I need 3 CCK content types, 1 would be Car faults, 2 would be Things to check, 3 would be Solutions, So the user would input my car has fault x,y and z from Vocab 1, and Associated nodes would find from Things to check nodes that are tagged x,y,z and x,y,w in a block as would Content type Solutions. Am I correct in assuming these things?

Thanks...