Re: Unknown column error entering "New Reservation" page

2011-05-19 Thread Douglas Dodson
Josh, The server version is: 5.1.52-log. Thanks again. - Doug - On 5/19/2011 3:53 PM, Josh Thompson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Doug, Thanks for the report back. I created a bug report (VCL-474) for it so that it will be fixed in the next release. Do you know wh

Re: Unknown column error entering "New Reservation" page

2011-05-19 Thread Josh Thompson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Doug, Thanks for the report back. I created a bug report (VCL-474) for it so that it will be fixed in the next release. Do you know what version of mysql you have installed? Josh On Thursday May 19, 2011, Douglas Dodson wrote: > Josh, > > Thank

Re: Unknown column error entering "New Reservation" page

2011-05-19 Thread Douglas Dodson
Josh, Thanks for the quick response. Single quotes did it. I made the following change to utils.php: 4309,4310c4309,4310 < . "rq.start > '$start' AND " < . "rq.start < '$end' " --- > . "rq.start > \"$start\" AND " > .

Re: Unknown column error entering "New Reservation" page

2011-05-19 Thread Josh Thompson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Doug, That's a strange one. I don't see anything wrong with the SQL statement it gives. The only thing I can think of is that you have a more recent version of mysql than I've ever used, and it doesn't like the double quotes ("). Try running the