-----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,
> 
> 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 "
>  >              .       "rq.start < \"$end\" "
> 
> Wow, great support!
> 
>   - Doug -
> 
> On 5/19/2011 1:20 PM, Josh Thompson wrote:
> > -----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 sql statement from the mysql command line.  In case
> > you're also new to mysql, here are the steps to test it:
> > 
> > Run 'mysql' to start the command line interface.
> > Then, at the prompt, enter 'use vcl'.
> > Next, type
> > 
> > SELECT DISTINCT COUNT(rs.managementnodeid) AS count, rs.managementnodeid
> > AS mnid FROM reservation rs, request rq WHERE rs.managementnodeid IN (1)
> > AND rq.start>  "2011-05-19 09:45:00" AND rq.start<
> > "2011-05-19 10:45:00" GROUP BY rs.managementnodeid ORDER BY count;
> > 
> > If it gives you the same error, try it again, but replace the double
> > quotes (") with single quotes (').
> > 
> > As a side note, there is a bug in that SQL statement because there is no
> > conditional to join the two tables together.  However, it won't cause any
> > undesired results if you only have one management node.
> > 
> > Josh
> > 
> > On Thursday May 19, 2011, Douglas Dodson wrote:
> >> Hello,
> >> 
> >> I'm a new VCL user/admin and am also a php rookie.  Any help is
> >> appreciated.
> >> 
> >> I have deployed VCL on a single server as part of a proof of concept
> >> evaluation.  I'm making steady progress, but have hit a wall with this
> >> error.  I have VMware Server 2.0.2 deployed under CentOS 5.6 and VCL
> >> 2.2.1 with required components up and running.  I have created an image
> >> named "VMwareCentOS56" and I believe that I have entered it and
> >> associated computers into the VCL database correctly.
> >> 
> >> However, when I attempt to navigate to the "New Reservation" option of
> >> the VCL web interface either as a normal user or and admin, I get the
> >> following dump Emailed to me and I get an AJAX error in my browser.
> >> This occurs immediately when I see the "New Reservation" page - I don't
> >> 
> >> even have a chance to make any selections or changes:
> >>> Unknown column '2011-05-19 09:45:00' in 'where clause'
> >>> 
> >>> SELECT DISTINCT COUNT(rs.managementnodeid) AS count,
> >>> rs.managementnodeid AS mnid FROM reservation rs, request rq WHERE
> >>> rs.managementnodeid IN (1) AND rq.start>   "2011-05-19 09:45:00" AND
> >>> rq.start<   "2011-05-19 10:45:00" GROUP BY rs.managementnodeid ORDER
> >>> BY count ERROR(101): General MySQL error
> >>> Logged in user was testxyz
> >>> Mode was AJupdateWaitTime
> >>> 
> >>> 
> >>> Backtrace:
> >>> =-=-=-=-=-=-=-=-=-=-=-=
> >>> Call#:1 =>   index.php:AJupdateWaitTime() (line#:86)
> >>> Call#:2 =>   requests.php:isAvailable() (line#:255)
> >>> Call#:3 =>   utils.php:allocComputer() (line#:3738)
> >>> Call#:4 =>   utils.php:findManagementNode() (line#:3828)
> >>> Call#:5 =>   utils.php:doQuery() (line#:4313)
> >>> 
> >>> Backtrace with Arguments:
> >>> =-=-=-=-=-=-=-=-=-=-=-=
> >>> Call#:1 =>   index.php:AJupdateWaitTime() (line#:86)
> >>> Arguments(none):
> >>> -----------------------
> >>> Call#:2 =>   requests.php:isAvailable() (line#:255)
> >>> Arguments(5)
> >>> 
> >>> Argument#: 1 =>   Array
> >>> (
> >>> 
> >>>       [4] =>   Array
> >>>       
> >>>           (
> >>>           
> >>>               [id] =>   4
> >>>               [name] =>   noimage
> >>>               [prettyname] =>   No Image
> >>>               [ownerid] =>   1
> >>>               [owner] =>   admin@Local
> >>>               [platformid] =>   1
> >>>               [platform] =>   i386
> >>>               [osid] =>   2
> >>>               [os] =>   sun4x_58
> >>>               [minram] =>   0
> >>>               [minprocnumber] =>   1
> >>>               [minprocspeed] =>   0
> >>>               [minnetwork] =>   10
> >>>               [maxconcurrent] =>
> >>>               [reloadtime] =>   0
> >>>               [deleted] =>   0
> >>>               [test] =>   0
> >>>               [resourceid] =>   4
> >>>               [lastupdate] =>
> >>>               [forcheckout] =>   0
> >>>               [maxinitialtime] =>   0
> >>>               [imagemetaid] =>
> >>>               [imagerevision] =>   Array
> >>>               
> >>>                   (
> >>>                   
> >>>                       [4] =>   Array
> >>>                       
> >>>                           (
> >>>                           
> >>>                               [id] =>   4
> >>>                               [revision] =>   0
> >>>                               [userid] =>   1
> >>>                               [user] =>   admin@Local
> >>>                               [datecreated] =>   1980-01-01 00:00:00
> >>>                               [prettydate] =>   1/01/80 12:00 AM
> >>>                               [production] =>   1
> >>>                               [imagename] =>   noimage
> >>>                           
> >>>                           )
> >>>                   
> >>>                   )
> >>>           
> >>>           )
> >>>       
> >>>       [19] =>   Array
> >>>       
> >>>           (
> >>>           
> >>>               [id] =>   19
> >>>               [name] =>   vmwarelinux-VMwareCentOS5619-v0
> >>>               [prettyname] =>   VMwareCentOS56
> >>>               [ownerid] =>   1
> >>>               [owner] =>   admin@Local
> >>>               [platformid] =>   1
> >>>               [platform] =>   i386
> >>>               [osid] =>   36
> >>>               [os] =>   vmwarelinux
> >>>               [minram] =>   1024
> >>>               [minprocnumber] =>   1
> >>>               [minprocspeed] =>   1000
> >>>               [minnetwork] =>   100
> >>>               [maxconcurrent] =>
> >>>               [reloadtime] =>   10
> >>>               [deleted] =>   0
> >>>               [test] =>   0
> >>>               [resourceid] =>   32
> >>>               [lastupdate] =>   2011-05-16 14:55:13
> >>>               [forcheckout] =>   1
> >>>               [maxinitialtime] =>   0
> >>>               [imagemetaid] =>
> >>>               [imagerevision] =>   Array
> >>>               
> >>>                   (
> >>>                   
> >>>                       [17] =>   Array
> >>>                       
> >>>                           (
> >>>                           
> >>>                               [id] =>   17
> >>>                               [revision] =>   0
> >>>                               [userid] =>   1
> >>>                               [user] =>   admin@Local
> >>>                               [datecreated] =>   2011-05-16 14:55:13
> >>>                               [prettydate] =>   5/16/11 2:55 PM
> >>>                               [production] =>   1
> >>>                               [imagename] =>
> >>>                               vmwarelinux-VMwareCentOS5619-v0
> >>>                           
> >>>                           )
> >>>                   
> >>>                   )
> >>>           
> >>>           )
> >>> 
> >>> )
> >>> 
> >>> Argument#: 2 =>   19
> >>> Argument#: 3 =>   17
> >>> Argument#: 4 =>   1305814500
> >>> Argument#: 5 =>   1305819000
> >>> -----------------------
> >>> Call#:3 =>   utils.php:allocComputer() (line#:3738)
> >>> Arguments(5)
> >>> 
> >>> Argument#: 1 =>    (empty array)
> >>> Argument#: 2 =>    (empty array)
> >>> Argument#: 3 =>   Array
> >>> (
> >>> 
> >>>       [0] =>   2
> >>>       [1] =>   3
> >>>       [2] =>   4
> >>>       [3] =>   5
> >>>       [4] =>   6
> >>>       [5] =>   7
> >>>       [6] =>   8
> >>>       [7] =>   9
> >>> 
> >>> )
> >>> 
> >>> Argument#: 4 =>   2011-05-19 10:15:00
> >>> Argument#: 5 =>   now
> >>> -----------------------
> >>> Call#:4 =>   utils.php:findManagementNode() (line#:3828)
> >>> Arguments(3)
> >>> 
> >>> Argument#: 1 =>   2
> >>> Argument#: 2 =>   2011-05-19 10:15:00
> >>> Argument#: 3 =>   now
> >>> -----------------------
> >>> Call#:5 =>   utils.php:doQuery() (line#:4313)
> >>> Arguments(2)
> >>> 
> >>> Argument#: 1 =>   SELECT DISTINCT COUNT(rs.managementnodeid) AS count,
> >>> rs.managementnodeid AS mnid FROM reservation rs, request rq WHERE
> >>> rs.managementnodeid IN (1) AND rq.start>   "2011-05-19 09:45:00" AND
> >>> rq.start<   "2011-05-19 10:45:00" GROUP BY rs.managementnodeid ORDER BY
> >>> count Argument#: 2 =>   101
> >>> -----------------------
> >> 
> >> I am guessing that I have something mis-configured, but it is not
> >> obvious to me what it might be.  Please let me know what other
> >> information might be needed to help get this sorted out.
> >> 
> >> Thanks.
> >> 
> >>    - Doug -
> > 
> > - --
> > - -------------------------------
> > Josh Thompson
> > VCL Developer
> > North Carolina State University
> > 
> > my GPG/PGP key can be found at pgp.mit.edu
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v2.0.17 (GNU/Linux)
> > 
> > iEYEARECAAYFAk3VUXMACgkQV/LQcNdtPQNbCwCfSD4hcJlKfwEJYhFx3mFw5Twb
> > ImMAn0M2bsRB0E9AAs4Gfi3GXpuPHzQ7
> > =5/DP
> > -----END PGP SIGNATURE-----
- -- 
- -------------------------------
Josh Thompson
VCL Developer
North Carolina State University

my GPG/PGP key can be found at pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)

iEYEARECAAYFAk3VdVEACgkQV/LQcNdtPQPviQCfXpjIkPFWTQGd7lOqQWnFouZR
Ms4An3OB3ddj2MeG9ZTfNg0z13FRHiKy
=afUp
-----END PGP SIGNATURE-----

Reply via email to