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 -

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to