[bbDev] release date?

[Rob Santoro]

yes Luc - that is the same error that I am getting as well.
how do you check the version of mysql ?

thanks!


On Sun, 6 Mar 2005 12:24:40 +0100, Luc Saint-Elie <luc at saint-elie.com> wrote:
> At 3:02 -0800 6/03/05, Matthew Mullenweg wrote:
> >Luc Saint-Elie wrote:
> >>>The nightly works fine for me - except the
> >>>search function returns two SQL errors.
> >>
> >I haven't been able to recreate this. Maybe it has to do with an old
> >version of MySQL?
> 
> My phpmyadmin reports :
> 
> MySQL 3.23.58-log running on xxx as xxxx
> 
> error is (for example I searched with "fichiers" as keyword) :
> 
> WordPress database error: [You have an error in your SQL syntax near
> 'ON topic_last_post_id = post_id WHERE LOWER(topic_title) LIKE
> ('%fichiers%') AND' at line 1]
> SELECT * FROM bb_topics JOIN bb_posts ON topic_last_post_id = post_id
> WHERE LOWER(topic_title) LIKE ('%fichiers%') AND topic_status = 0
> ORDER BY post_time DESC LIMIT 5
> 
> WordPress database error: [You have an error in your SQL syntax near
> 'ON topic_last_post_id = post_id WHERE LOWER(post_text) LIKE
> ('%fichiers%') AND p' at line 1]
> SELECT * FROM bb_posts JOIN bb_topics ON topic_last_post_id = post_id
> WHERE LOWER(post_text) LIKE ('%fichiers%') AND post_status = 0 ORDER
> BY post_time DESC LIMIT 5
> 
> 
> Luc
> _______________________________________________
> bbDev mailing list
> bbDev at lists.bbpress.org
> http://lists.bbpress.org/mailman/listinfo/bbdev
>