-----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-----
