Error (DBQueryError) after upgrade 1.0 RC3 -> 1.3.1 -- HELP!

[editfish]

Existing install and dB backed up, overwrote appropriate files to update via FTP, ran public/install, no hitches, no errors.  Click 'back to opengoo' and returns following error:

  Error (DBQueryError)
Query failed with message 'Unknown column 'trashed_by_id' in 'where clause''
Error params:
File:    /home/tinwdub4/public_html/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line:    386
Sql:    SELECT * FROM `og_companies` WHERE `trashed_by_id` = 0 AND (`client_of_id` = '0')
Error number:    1054
Error message:    Unknown column 'trashed_by_id' in 'where clause'
Backtrace:
#0 /home/tinwdub4/public_html/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /home/tinwdub4/public_html/opengoo/environment/library/database/DB.class.php(199): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /home/tinwdub4/public_html/opengoo/environment/classes/dataaccess/DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 /home/tinwdub4/public_html/opengoo/application/models/ProjectDataObjects.class.php(31): DataManager->find(Array)
#4 /home/tinwdub4/public_html/opengoo/application/models/companies/base/BaseCompanies.class.php(125): ProjectDataObjects->find(Array)
#5 /home/tinwdub4/public_html/opengoo/environment/classes/dataaccess/DataManager.class.php(228): BaseCompanies->find(Array)
#6 /home/tinwdub4/public_html/opengoo/application/models/companies/base/BaseCompanies.class.php(159): DataManager->findOne(Array)
#7 /home/tinwdub4/public_html/opengoo/application/models/companies/base/BaseCompanies.class.php(161): BaseCompanies->findOne(Array)
#8 /home/tinwdub4/public_html/opengoo/application/models/companies/Companies.class.php(48): BaseCompanies::findOne(Array)
#9 /home/tinwdub4/public_html/opengoo/application/models/CompanyWebsite.class.php(62): Companies::getOwnerCompany()
#10 /home/tinwdub4/public_html/opengoo/application/models/CompanyWebsite.class.php(45): CompanyWebsite->initCompany()
#11 /home/tinwdub4/public_html/opengoo/application/models/CompanyWebsite.class.php(49): CompanyWebsite->init()
#12 /home/tinwdub4/public_html/opengoo/application/application.php(20): CompanyWebsite::init()
#13 /home/tinwdub4/public_html/opengoo/init.php(135): require_once('/home/tinwdub4/...')
#14 /home/tinwdub4/public_html/opengoo/index.php(9): require('/home/tinwdub4/...')
#15 {main}
Autoglobal varibles:
$_GET:    
$_POST:    
$_COOKIE:    Array (
  ['logintheme'] => (string) 'cpanel'
  ['cprelogin'] => (string) 'no'
  ['cpsession'] => (string) 'closed'
  ['rp_user'] => (string) 'bG9naW5faXA9NjkuMTQ4LjI1MC4xNjkmdXNlcl9pZD0xJnVzZXJfbmFtZT1hZG1pbiZkaWdlc3Q9
NnBIdnFtcitrT0plZVBXMWFxKzRqQ1daTkJv
'
  ['PHPSESSID'] => (string) 'cc858cc35dcae355396886fd6751f9e1'
)
$_SESSION:    Array (
  ['cal_version'] => true
  ['month'] => (string) '3'
  ['year'] => (string) '2009'
  ['day'] => (string) '30'
)
Execution time:
Total execution time: 0.028480 seconds


===paste text from log.php===

Session "default" started at 2009-03-30T00:51:56+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 8.2967040538788 seconds
-------------------------------------------------------------------------------

Session "default" started at 2009-03-30T00:53:25+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.21280097961426 seconds
-------------------------------------------------------------------------------
===end paste===

HELP!

[whirls]

I'm getting the same error :-(

Any ideas?

whirls

[whirls]

Ok, I fixed that particular problem - my error. I had selected upgrading from 1.01 to 1.3.1, where I should have upgraded from 1.0.

However now the page loads and immediately disappears with a popup telling me : TypeError: doc.body is null

 

Sarah

[ignacio]

Were you able to fix this problem?

[editfish]

My original problem stemmed from accidently upgrading from 1.1 to 1.3.1.  I restored my original database and site, and reinstalled, choosing 1.0 to 1.3.1 (no option for 1.0 RC 3).  Similar database issue, but different 'column'.

Still errored out and would not load.  I had to re-restore my original 1.1 RC3 install. 

The error as recorded in the log is:

"Session "default" started at 2009-04-02T04:03:00+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.24878692626953 seconds
-------------------------------------------------------------------------------

Session "default" started at 2009-04-02T04:04:16+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.21113705635071 seconds
-------------------------------------------------------------------------------

Session "default" started at 2009-04-02T04:04:51+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.10020089149475 seconds
-------------------------------------------------------------------------------
"

[ignacio]

Hi, I tried upgrading from a fresh install of 1.0 RC3 to 1.3.1 and it worked fine from me. Just unzipped 1.3.1 to the 1.0 RC3 installation, went to public/upgrade, chose to install from 1.0 to 1.3.1 and that was it.

[editfish]

I tried two different ways: first, unzipping the files locally, removing the recommended subdirectories/files the ftp'ing them to my site.  This resulted in the error above.

After restoring the previous install, I uploaded the entire file to a tmp directory, unzipped it, then copied the files over the existing install.  Same results.

I attempted the upgrade four separate times, all with similar results.  I guess I'll wait for the next release and then try again.