You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@vcl.apache.org by "Waldron, Michael H" <mw...@email.unc.edu> on 2015/09/17 17:25:44 UTC
Apache Error with VCL pages (205)
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] => valencia@unc.edu<ma...@unc.edu>
[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
Re: Apache Error with VCL pages (205)
Posted by Andy Kurth <an...@ncsu.edu>.
Hi Mike,
I'm pretty sure the error is due to the ownerid being undefined. There
should be an integer in between the commas: ...Limit', , 1, 36,...
This line doesn't look correct:
[owner] => valencia@unc.edu<ma...@unc.edu>
I don't think this should contain the email address section. I would take
a look at the corresponding entry in the user table, particularly the
user.unityid value. Is it formatted correctly and the same as other users
which aren't experiencing problems?
If it is indeed different, you'll need to figure out how/why it got that
way. Assuming you're using LDAP, there could be a problem with the source
LDAP data or with the $authMechs section in your conf.php file.
Regards,
Andy
On Thu, Sep 17, 2015 at 11:25 AM, Waldron, Michael H <mwaldron@email.unc.edu
> wrote:
> 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] => valencia@unc.edu<ma...@unc.edu>
>
> [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
>
>