Re: database error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yup, worked like a champ, Thx! On 11/23/2010 2:54 PM, David Hutchins wrote: > Looks like the code is getting its value from vmhost.computerid so > smallint(5) should work. > > On Tue, Nov 23, 2010 at 5:43 PM, James O'Dell wrote: > > Hi, > > I just updated my vclweb code via svn. Now I'm getting a database error > Unknown column 'hostcomputerid' in 'field list' INSERT INTO sublog (logid, imageid, imagerevisionid, computerid, > managementnodeid, predictivemoduleid, hostcomputerid) VALUES (238, 16, 29, > 14, 1, 9, 13) ERROR(101): General MySQL error Logged in user was 899500961 Mode was submitRequest Backtrace: =-=-=-=-=-=-=-=-=-=-=-= Call#:1 => index.php:submitRequest() (line#:85) Call#:2 => requests.php:addRequest() (line#:533) Call#:3 => utils.php:addSublogEntry() (line#:4018) Call#:4 => utils.php:doQuery() (line#:7287) Backtrace with Arguments: =-=-=-=-=-=-=-=-=-=-=-= Call#:1 => index.php:submitRequest() (line#:85) Arguments(none): --- Call#:2 => requests.php:addRequest() (line#:533) Arguments(2) Argument#: 1 => (empty string) Argument#: 2 => (empty array) --- Call#:3 => utils.php:addSublogEntry() (line#:4018) Arguments(5) Argument#: 1 => 238 Argument#: 2 => 16 Argument#: 3 => 29 Argument#: 4 => 14 Argument#: 5 => 1 --- Call#:4 => utils.php:doQuery() (line#:7287) Arguments(2) Argument#: 1 => INSERT INTO sublog (logid, imageid, imagerevisionid, > computerid, managementnodeid, predictivemoduleid, hostcomputerid) VALUES > (238, 16, 29, 14, 1, 9, 13) Argument#: 2 => 101 --- > > Can anyone tell my where I can find what type of value 'hostcomputerid' > should be (So, I can update my database scheme)? > > __Jim > > >> - -- Jim O'Dell Network Analyst California State University Fullerton Email: jod...@fullerton.edu Phone: (657) 278-2256 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkzsU3AACgkQREVHAOnXPYREgwCfahA4FBQjdhGwZRvAwUcqIxuF gTgAniw1FajzqPzdcnikLFTEazHtSNUR =WhQV -END PGP SIGNATURE-
Re: database error
Looks like the code is getting its value from vmhost.computerid so smallint(5) should work. On Tue, Nov 23, 2010 at 5:43 PM, James O'Dell wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > I just updated my vclweb code via svn. Now I'm getting a database error > > > Unknown column 'hostcomputerid' in 'field list' > > > > INSERT INTO sublog (logid, imageid, imagerevisionid, computerid, > managementnodeid, predictivemoduleid, hostcomputerid) VALUES (238, 16, 29, > 14, 1, 9, 13) > > ERROR(101): General MySQL error > > Logged in user was 899500961 > > Mode was submitRequest > > > > > > Backtrace: > > =-=-=-=-=-=-=-=-=-=-=-= > > Call#:1 => index.php:submitRequest() (line#:85) > > Call#:2 => requests.php:addRequest() (line#:533) > > Call#:3 => utils.php:addSublogEntry() (line#:4018) > > Call#:4 => utils.php:doQuery() (line#:7287) > > > > Backtrace with Arguments: > > =-=-=-=-=-=-=-=-=-=-=-= > > Call#:1 => index.php:submitRequest() (line#:85) > > Arguments(none): > > --- > > Call#:2 => requests.php:addRequest() (line#:533) > > Arguments(2) > > > > Argument#: 1 => (empty string) > > Argument#: 2 => (empty array) > > --- > > Call#:3 => utils.php:addSublogEntry() (line#:4018) > > Arguments(5) > > > > Argument#: 1 => 238 > > Argument#: 2 => 16 > > Argument#: 3 => 29 > > Argument#: 4 => 14 > > Argument#: 5 => 1 > > --- > > Call#:4 => utils.php:doQuery() (line#:7287) > > Arguments(2) > > > > Argument#: 1 => INSERT INTO sublog (logid, imageid, imagerevisionid, > computerid, managementnodeid, predictivemoduleid, hostcomputerid) VALUES > (238, 16, 29, 14, 1, 9, 13) > > Argument#: 2 => 101 > > --- > > > > Can anyone tell my where I can find what type of value 'hostcomputerid' > should be (So, I can update my database scheme)? > > __Jim > > > - -- > Jim O'Dell > Network Analyst > California State University Fullerton > Email: jod...@fullerton.edu > Phone: (657) 278-2256 > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.9 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAkzsQ4MACgkQREVHAOnXPYQVfwCgmQlNtlLU4F5GcaUvgP56hUS+ > lHwAoMJUjRJPP/Rbva+oygDWDVCEhNU7 > =1/Nn > -END PGP SIGNATURE- >