That didn't seem to have made a difference. Where would the logging messages appear?
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... On Thu, Mar 26, 2015 at 12:58 PM, Ryan J Ollos <rjol...@apache.org> wrote: > On Thu, Mar 26, 2015 at 9:56 AM, Tim Tisdall <tisd...@gmail.com> wrote: >> >> After upgrading from 0.7 to 0.8 my /products page says: >> >> ProgrammingError: (1064, "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='icon'' at line 3") >> >> After many many many tries on the demo site I managed to get that page >> to load with no issue, so I suspect there's something not right with >> just my environment. >> >> Unfortunately I'm not sure how to get the whole SQL query but it >> starts with "\n SELECT product, value FROM >> bloodhound_productconfig\n". > > > Setting [trac] debug_sql = true might provide more info. > > http://trac.edgewall.org/wiki/TracIni#trac-section