Skip to:
Content

bbPress.org

Opened 21 years ago

Closed 21 years ago

Last modified 20 years ago

#79 closed defect (bug) (fixed)

MySQL error on topic.php

Reported by: skeltoac's profile Skeltoac Owned by: matt's profile Matt
Milestone: Priority: normal
Severity: normal Version: 0.1
Component: Back-end Keywords: query
Cc:

Description

Topic.php gives a MySQL error on the following query:

SELECT * FROM tagged JOIN tags ON (tags.tag_id = tagged.tag_id) WHERE topic_id = '1'

If I run the same query from the shell, I get the same error. Adding the keyword "RIGHT" before "JOIN" resolved it. The function is get_topic_tags() in functions.php, very near the end of the file. I applied the fix to my bbPress and the tags are now listed and the error is gone.

I am running MySQL 3.23.58.

Thanks,
Andy Skelton

Change History (2)

#1 @matt
21 years ago

  • Resolution set to fixed
  • Status changed from new to closed

(In [140]) MySQL error, fixes #79

#2 @(none)
20 years ago

  • Milestone Version 0.1 deleted

Milestone Version 0.1 deleted

Note: See TracTickets for help on using tickets.