#79 closed defect (bug) (fixed)
MySQL error on topic.php
| Reported by: |
|
Owned by: |
|
|---|---|---|---|
| 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)
Note: See
TracTickets for help on using
tickets.
(In [140]) MySQL error, fixes #79