1.6.3 - > 1.7.0 upgrade through cpanel, fatal error

[sverdlov]

I extracted the zip file from sourceforge to a new folder on my server, then moved all the extracted files overwriting ALL files in the original 1.6.3 install....

At first, it was giving me 500 error - changed ALL folders and files to 755, then...

Whatever the cause, I can't go to public/upgrade, can't do anything -

Error
We are sorry, but a fatal error prevented Feng Office from executing your request. An Error Report has been sent to the administrator.

[cabeza]

Is debug=true? Anything in your log?

[sverdlov]

Error (DBQueryError)
Query failed with message 'Unknown column 'type' in 'field list''
Error params:
File:    /home/nopasara/public_html/wo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line:    386
Sql:    SELECT `id`, `company_id`, `username`, `email`, `type`, `token`, `salt`, `twister`, `display_name`, `title`, `avatar_file`, `timezone`, `created_on`, `created_by_id`, `updated_on`, `updated_by_id`, `last_login`, `last_visit`, `last_activity`, `can_edit_company_data`, `can_manage_workspaces`, `can_manage_security`, `can_manage_configuration`, `auto_assign`, `personal_project_id`, `can_manage_contacts`, `can_manage_templates`, `can_manage_reports`, `can_manage_time`, `can_add_mail_accounts`, `default_billing_id` FROM `wo_users` WHERE `id` = '1'
Error number:    1054
Error message:    Unknown column 'type' in 'field list'
Backtrace:
#0 /home/nopasara/public_html/wo/environment/library/database/adapters/AbstractDBAdapter.class.php(285): AbstractDBAdapter->prepareAndExecute('SELECT `id`, `c...', NULL)
#1 /home/nopasara/public_html/wo/environment/library/database/DB.class.php(179): AbstractDBAdapter->executeOne('SELECT `id`, `c...', NULL)
#2 /home/nopasara/public_html/wo/environment/classes/dataaccess/DataManager.class.php(456): DB::executeOne('SELECT `id`, `c...')
#3 /home/nopasara/public_html/wo/environment/classes/dataaccess/DataManager.class.php(426): DataManager->loadRow(1)
#4 /home/nopasara/public_html/wo/environment/classes/dataaccess/DataManager.class.php(330): DataManager->load(1, false)
#5 /home/nopasara/public_html/wo/application/models/users/base/BaseUsers.class.php(233): DataManager->findById(1, false)
#6 /home/nopasara/public_html/wo/application/models/users/base/BaseUsers.class.php(235): BaseUsers->findById(1, false)
#7 /home/nopasara/public_html/wo/application/models/ApplicationDataObject.class.php(357): BaseUsers->findById(1)
#8 /home/nopasara/public_html/wo/application/models/CompanyWebsite.class.php(67): ApplicationDataObject->getCreatedBy()
#9 /home/nopasara/public_html/wo/application/models/CompanyWebsite.class.php(45): CompanyWebsite->initCompany()
#10 /home/nopasara/public_html/wo/application/models/CompanyWebsite.class.php(49): CompanyWebsite->init()
#11 /home/nopasara/public_html/wo/application/application.php(19): CompanyWebsite::init()
#12 /home/nopasara/public_html/wo/init.php(139): require_once('/home/nopasara/...')
#13 /home/nopasara/public_html/wo/index.php(9): require('/home/nopasara/...')
#14 {main}
Autoglobal varibles:
$_GET:    
$_POST:    
$_COOKIE:    Array (
  ['PHPSESSID'] => (string) '07047cf16f07eec430fddf5529728028'
  ['id'] => (string) '1'
  ['token'] => (string) '4f35c02f53a3d4d12926355842a3066e3e64cd15'
)
$_SESSION:    
Execution time:
Total execution time: 0.209510 seconds

Forgot to mention, that beforehand I tried autoupgrading couple of times, every time it just displayed me an empty page - go back, old version of feng...

[cabeza]

Did you try 777?
Just in case ...

[sverdlov]

777 of what?

main folder - 500
All files - 500
All folders - 500

 that this would cause error 500 in all cases

[cabeza]

http://forums.fengoffice.com/index.php?topic=4378

[sverdlov]

that forum thread gives no info - the dude there just rolled back to 1.6.2....

I can restore from backup too - but how do I upgrade to 1.7.0?

Is there a way to do a clean install and import all databases/files on it?

[cabeza]

that forum thread gives no info - the dude there just rolled back to 1.6.2....

It's not what I understood, but I may me wrong ...

Is there a way to do a clean install and import all databases/files on it?

Not that I know. But the script shouldn't be hard to build.

[sverdlov]

You have a bug in the permissions of the files in your archive. To be exact: whenever I download your .zip file and work with it on cPanel, the upgrades fail (that was happening since your betas, so... prettty consistent I would say).

IF however, the archive is extracted to a folder on a Windows system and then working to upload/replace files, all works like a charm.

Take a note on that.

[cabeza]

Please report bugs in our bug tracker.
Thanks!