bloodhound-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ryan Ollos <ryan.j.ol...@gmail.com>
Subject Re: /products page error
Date Thu, 26 Mar 2015 17:44:14 GMT
On Thu, Mar 26, 2015 at 10:10 AM, Tim Tisdall <tisdall@gmail.com> wrote:

> That didn't seem to have made a difference.  Where would the logging
> messages appear?
>

The messages would appear in trac.log, provided you've set the [logging]
log_level = DEBUG. Sorry about omitting that detail earlier.


> I think I figured it out, though...
>
> mysql> select * from bloodhound_productconfig where option='whut';
> ERROR 1064 (42000): 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 'option='whut'' at line 1
> mysql> select * from bloodhound_productconfig where `option`='whut';
> Empty set (0.00 sec)
>
> mysql> select * from bloodhound_productconfig where
> bloodhound_productconfig.option='whut';
> Empty set (0.00 sec)
>
>
> It seems the "option" part is a keyword or something in mysql and
> needs to be properly escaped or qualified.  Seems like an easy
> patch...


Looks like you are correct. Good find. I'll try to push a fix this evening.

https://dev.mysql.com/doc/refman/5.6/en/reserved-words.html

Mime
View raw message