I am getting the following error email from VCL when I user tries to save a new
image and need help interpreting what the problem is. This is on VCL 2.4.2 by
the way. From the user end, after clicking the installer agreement pop-up, he
gets the message "Error encountered: Please try again later".
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 ' 1, 36, 3072, 1, 1000,
10, NULL, 10, 1, 1, 'x86', 'ADMS Airport 3.4 w/ no Source' at line 1
INSERT INTO image (prettyname, ownerid, platformid, OSid, minram,
minprocnumber, minprocspeed, minnetwork, maxconcurrent, reloadtime, deleted,
forcheckout, architecture, description, `usage`, basedoffrevisionid) VALUES
('ADMS Airport 3.4 w/ no Source Limit', , 1, 36, 3072, 1, 1000, 10, NULL, 10,
1, 1, 'x86', 'ADMS Airport 3.4 w/ no Source Limit', '', 2036)
ERROR(205): Failed to execute query 1 in Image::addResource
Logged in user was valenal
Mode was AJsaveResource
Backtrace:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:Image.AJsaveResource() (line#:102)
Call#:2 => image.php:Image.createImage() (line#:702)
Call#:3 => image.php:Image.addResource() (line#:869)
Call#:4 => image.php:doQuery() (line#:1153)
Backtrace with Arguments:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:Image.AJsaveResource() (line#:102)
Arguments(none):
-----------------------
Call#:2 => image.php:Image.createImage() (line#:702)
Arguments(none):
-----------------------
Call#:3 => image.php:Image.addResource() (line#:869)
Arguments(1)
Argument#: 1 => Array
(
[error] => 0
[name] => ADMS Airport 3.4 w/ no Source Limit
[owner] => [email protected]<mailto:[email protected]>
[ram] => 3072
[cores] => 1
[cpuspeed] => 1000
[networkspeed] => 10
[concurrent] => 0
[reload] => 10
[checkout] => 1
[checkuser] => 1
[rootaccess] => 1
[sethostname] => 0
[sysprep] => 1
[connectmethodids] => 2
[requestid] => 255127
[imageid] => 1165
[baserevisionid] => 2036
[desc] => ADMS Airport 3.4 w/ no Source Limit
[usage] =>
[comments] =>
[mode] => add
[platformid] => 1
[osid] => 36
[ostype] => windows
[basedoffrevisionid] => 2036
[autocaptured] => 0
)
-----------------------
Call#:4 => image.php:doQuery() (line#:1153)
Arguments(2)
Argument#: 1 => INSERT INTO image (prettyname, ownerid, platformid, OSid,
minram, minprocnumber, minprocspeed, minnetwork, maxconcurrent, reloadtime,
deleted, forcheckout, architecture, description, `usage`, basedoffrevisionid)
VALUES ('ADMS Airport 3.4 w/ no Source Limit', , 1, 36, 3072, 1, 1000, 10,
NULL, 10, 1, 1, 'x86', 'ADMS Airport 3.4 w/ no Source Limit', '', 2036)
Argument#: 2 => 205
-----------------------
Mike Waldron
Systems Specialist
ITS - Research Computing Center
University of North Carolina at Chapel Hill
