Taxonomy feed : Error in db_range_query arguments order

Yoran - December 6, 2007 - 08:23
Project:Drupal
Version:5.4
Component:taxonomy.module
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed
Description

Little mistake in last drupal version (5.4) , in taxonomy.module, line 1271 :

$result = db_query_range($sql, 0, variable_get('feed_default_items', 10),$args);

should be
$result = db_query_range($sql, $args, 0, variable_get('feed_default_items', 10));

#1

hannesk - December 6, 2007 - 10:11

Thank You Very Much For This Solution!

I was struggling with this problem for hours now and this saved my day :)

Thank You

Best Regards

Hannes

#2

Gábor Hojtsy - December 6, 2007 - 10:23
Version:5.4» 5.x-dev
Status:active» reviewed & tested by the community

Committed this fix to Drupal 6. Will alert Niel Drumm, the Drupal 5 maintainer. Seems like we did not test this use case well, and introduced a bug here. Attached patch is RTBC for Drupal 5.

AttachmentSize
db_query_range.patch 752 bytes

#3

killes@www.drop.org - December 6, 2007 - 10:40

4.7 is patched

#4

drumm - December 6, 2007 - 18:17
Status:reviewed & tested by the community» fixed

Committed to 5.x.

#5

lutegrass - December 7, 2007 - 03:08

Ok, can somebody give the line that needs to be changed for 4.7.8? Just want to fix the broken line. Thanks.

#6

jason342 - December 7, 2007 - 05:56

So the only difference between 5.4 and 5.5 is that one line of code, and nothing else?

#7

Heine - December 7, 2007 - 06:21

If you do not update, but just copy the two files, update status will no longer work for your site.

The change:

-      $result = db_query_range($sql, 0, variable_get('feed_default_items', 10), $args);
+      $result = db_query_range($sql, $args, 0, variable_get('feed_default_items', 10));

Please do not further divert this issue.

#8

mercmobily - December 14, 2007 - 04:52

Hi,

Quick question. I don't have time to upgrade right now.
What do you mean by:

"If you do not update, but just copy the two files, update status will no longer work for your site."

What update status?

Merc.

#9

Gábor Hojtsy - December 14, 2007 - 10:49

Update status is a contribtued module which helps you getting informed about available updates for your site.

#10

karthik_admin - December 21, 2007 - 11:18

How to run the patch?

#11

mercmobily - December 21, 2007 - 14:08

Hi,

I am a Drupal developer, and yet I don't know the basics. Shame on me.

Thanks for the hint,

Merc.

#12

smikey - December 27, 2007 - 23:20
Version:5.x-dev» 5.5
Status:fixed» active

Any chance of a hotfix for 5.5? Not great running patches as I'm not a dev. Thanks

#13

Heine - December 27, 2007 - 23:22
Status:active» fixed

5.5 doesn't have this bug. A patch for 5.4 is on #2.

#14

Heine - December 27, 2007 - 23:22
Version:5.5» 5.4

Restoring the version.

#15

smikey - December 27, 2007 - 23:34

Thanks, Heine. I checked the module out, and 5.5 seems to be using the updated code. Anyone know why my Taxonomy module no longer shows up in my module list? Everything seemed to be working until I updated to version 5.5..

#16

smikey - December 27, 2007 - 23:42

To answer my own question, the module is no longer in my Drupal db. What caused this, I have no idea. Thanks for your assistance on this.. :)

#17

ron_mahon - January 3, 2008 - 20:03
Title:Taxonomy feed : Error in db_range_query arguments order» Taxonomy module & CCK
Version:5.4» 5.5

I am having trouble with the taxonomy and CCK lookup field.

These all worked before the 5.4 and then 5.5 update.
The filter selects the proper vocabulary but returns a empty data set.
It i select just a tax term it works fine except all the other vocabulary's are present also.

I installed it with version
"$Id: taxonomy.module,v 1.330.2.14 2007/12/06 18:16:38 drumm Exp $" and it works fine.

"$Id: taxonomy.module,v 1.330.2.11 2007/09/12 07:49:36 drumm Exp $" version is the one with the strange behavior.

I look for the section referenced above, it's not on line 1271

Hope you can help
Many thanks
Ron

#18

Anonymous - January 17, 2008 - 20:11
Status:fixed» closed

Automatically closed -- issue fixed for two weeks with no activity.

#19

RobRoy - August 18, 2008 - 21:56
Title:Taxonomy module & CCK» Taxonomy feed : Error in db_range_query arguments order
Version:5.5» 5.4

Restoring correct title and version.

 
 

Drupal is a registered trademark of Dries Buytaert.