Re: Apache Error with VCL pages (205)

[Josh Thompson <jo...@ncsu.edu>]

Mike,

I'm working on the JIRA issue (VCL-908) that Andy created for this problem.  
However, I cannot reproduce it.  Can you reproduce it?  Do you know  
specifically what he was entering in to the Owner field?  I've tried 
everything I can think of, and it always restricts submitting it because the 
Owner field is invalid.

Josh

On Thu September 24 2015 3:31:14 PM Waldron, Michael H wrote:
> Andy,
> 
> Thanks for that information, it helped me pinpoint the problem. The unityid
> field in the user table was correct, and what you said about the email
> information not belonging there made me ask the user what was being
> displayed in the Owner field on the Add Image page. It turns out he was
> replacing the correct user@affiliation information with his email address.
> It works fine after telling him not to change that field.
> 
> Thanks,
> Mike
> 
> ------------------------------------------------------------------------
> 
> 
> 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] =>
> vale...@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 <mwal...@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] => vale...@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
> 
> 
> Mike Waldron
> Systems Specialist
> ITS - Research Computing Center
> University of North Carolina at Chapel Hill
-- 
-------------------------------
Josh Thompson
Systems Programmer
Virtual Computing Lab (VCL)
North Carolina State University

Josh_Thompson@ncsu.edu
919-515-5323

my GPG/PGP key can be found at www.keyserver.net

All electronic mail messages in connection with State business which
are sent to or received by this account are subject to the NC Public
Records Law and may be disclosed to third parties.