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 <[email protected]> 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: [email protected] > 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----- >
