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] => [email protected]<mailto:[email protected]> 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 <[email protected] 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] => [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 Mike Waldron Systems Specialist ITS - Research Computing Center University of North Carolina at Chapel Hill
