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 'AND n.status = 1 AND n.promote=0 ) ORDER BY skc.karma DESC LIMIT 5' at line 1 query: SELECT * FROM node n LEFT JOIN simple_karma_cache skc ON skc.otype='n' AND skc.oid=n.nid LEFT JOIN term_node t ON n.nid = t.nid WHERE ( 1=1 ) AND ( n.type='drigg' AND n.created > UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - 60*60*48 AND t.tid= AND n.status = 1 AND n.promote=0 ) ORDER BY skc.karma DESC LIMIT 5 in /home/estringc/public_html/webvideobubble.com/includes/database.mysql.inc on line 172.

Comments

mercmobily’s picture

mercmobily commented

Hi,

On which page do you get the error?

Have you configured the module? (that is, have you hit "submit" in the module configuration?)

Have you set up categories for Drigg?

Merc.

Anonymous’s picture

Anonymous (not verified) commented

On some nodes. Just figured out it is from changing a categories label.

$tid=drigg_is_section_valid( $category );

returns false if the category has been changed and the query proceeds as normal but fails.

J

mercmobily’s picture

mercmobily commented
Assigned: Unassigned » mercmobily

Hi,

Thank you for your great bug report. You really nailed it.

I really, really need to write a function that recalculates the drigg_node's category name (it's stored there for optimisation purposes, to speed up queries), or problems like this will arise forever.

I will get this done in the next release, in a week or so.

Bye,

Merc.

mercmobily’s picture

mercmobily commented
Status: Active » Fixed

Hi,

OK, this is fixed in the upcoming developer's snapshot of Drigg. Now there is a function that will recalculate the safe_section for every single drigg node, so that if you change the name of a section all you have to do is recalculate the cache and you're sorted.

Thanks for the report,

Merc.

mercmobily’s picture

mercmobily commented
Version: » 5.x-1.x-dev
Status: Fixed » Closed (fixed)