Errors after 8.1.1 -> 8.2

[NETSource]

Control panel header still says 8.1.1 when logging in.

Receive the following from the "dashboard":

ERROR: PleskMainDBException
MySQL query failed: Unknown column 'uid' in 'field list'

0: /usr/local/psa/admin/plib/common_func.php3:216
db_query(string 'select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`uid`,`ownership` from clients where `id`=2')
1: /usr/local/psa/admin/plib/class.Table.php:180
Table->select()
2: /usr/local/psa/admin/plib/class.cObject.php:443
cObject->fetchAttrsFromTable_()
3: /usr/local/psa/admin/plib/class.Client.php3:74
Client->Client(integer '2')
4: /usr/local/psa/admin/plib/common_func.php3:2867
objectMaker(string 'Client', integer '2')
5: /usr/local/psa/admin/plib/ui/client.php:69
plesk__client->getDisplayName()
6: /usr/local/psa/admin/plib/UIPointer.php:846
UIPointer->getCaption(string 'description', NULL null, NULL null, object of type UserAdmin, NULL null, string '')
7: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:515
DashboardElement->getDefaultCaption(string 'description', object of type UserAdmin, NULL null)
8: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:508
DashboardElement->getCaption(string 'description', object of type UserAdmin, NULL null)
9: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1456
DashboardElement_shortcut->renderHtml(object of type UserAdmin, NULL null)
10: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:584
DashboardElement->renderHtml_shortcuts(array, object of type UserAdmin, NULL null)
11: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:554
DashboardElement->renderHtml_common(array, object of type UserAdmin, NULL null)
12: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1097
DashboardElement_tab->renderHtml_content(boolean true, object of type UserAdmin, NULL null)
13: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1047
DashboardElement_tabs->renderHtml(object of type UserAdmin, NULL null)
14: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:557
DashboardElement->renderHtml_common(array, object of type UserAdmin, NULL null)
15: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:944
DashboardElement_section->renderHtml(object of type UserAdmin, NULL null)
16: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:557
DashboardElement->renderHtml_common(array, object of type UserAdmin, NULL null)
17: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:564
DashboardElement->renderHtml(object of type UserAdmin, NULL null)
18: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:898
DashboardElement_column->renderHtml(object of type UserAdmin, NULL null)
19: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:571
DashboardElement::renderHtml_columns(array, object of type UserAdmin, NULL null)
20: /usr/local/psa/admin/plib/dashboard/Dashboard.php:197
Dashboard::renderHtml(array, object of type UserAdmin)
21: /usr/local/psa/admin/plib/dashboard/DashboardForm.php:95
DashboardForm->assign(array, object of type UserAdmin)
22: /usr/local/psa/admin/plib/dashboard/DashboardLocation.php:55
DashboardLocation->accessItem(string 'GET', NULL null)
23: /usr/local/psa/admin/plib/UIPointer.php:520
UIPointer->access(string 'GET')
24: /usr/local/psa/admin/htdocs/plesk.php:19



On the auto-update page, still show 8.1.1 and 8.2 updates being available. Only package not updated is 8.2. Autoinstaller log shows the following:

The following packages you requested are already updated:
psa
The packages were installed successfully.
Filefetcher: get file PSA_8.2.0/plesk-8.2.0-rhel3-i386.inf3

No errors/unresolved dependencies reported by autoinstaller. Have run multiple times, no sucesss.

Any help would be appreciated! It appears the control panel is usable except for the dashboard, but I'm seriously afraid that the integrity of the database is in jeopardy.

 

[lvalics]

Seems DB structure was not updated correctly. Need to do a manual update on that.

 

[NETSource]

And that would be done how?

 

[lvalics]

/usr/local/psa/etc/db here are the update files.

 

[NETSource]

I have psa_db_dasyboard_presets.sql which has todays date, but no psa_db_upgrade_820.sql (like the others). Should I?

 

[lvalics]

Is hard to say like this :-(
If you upgraded to 8.2 then should be there.

 

[NETSource]

Actually found a post on this - however one of the fixes was to go into /root/psa/PSA_8.2.0/dist-rpm-RedHat-el3-i386 folder and rpm -Uva * ... there are no rpm files there at all. Just build-8.2.0-rhel3-i386.hdr.gz and opt/ which has the autoupdater (which is installed).

 

[lvalics]

it is hard to say like this, only doing the job you can achieve the goal

 

[NETSource]

Solution was ugly - apparently for some reason the rpm refused to uninstall the older version (8.1.1). Results of rpm -q psa showed both version 8.2 and 8.1.1 installed. I removed 8.1.1 and the dependant file (skin changer I believe). Everything still showed as 8.1.1 in the control panel, however now it had removed 8.1.1 from the update page and showed my 8.2 as a complete install. I still had the errors from the database, and the login/title bar still said 8.1.1.

I manually downloaded the PSA installation files, went to the dist/base folder and rpm -Uvh --force * . All packages reinstalled sucessfully, and everything was back to normal.

 

[ziggie216]

I swear every time I run an update, something breaks. Are these updates ever tested before release?

# rpm -q psa
psa-8.1.0-fc1.build81061129.23
psa-8.2.0-fc1.build82070706.15

so do I run
rpm -e psa-8.1.0-fc1.build81061129.23
cd /root/psa/PSA_8.2.0/dist-rpm-FedoraCore-1-i386/base
rpm rpm -Uvh --force *

 

[NETSource]

Yes, I did exactly that, except there's one file I had that was dependant on 8.1.1 (skin chooser I believe) that I had to remove also. It IS actually running the 8.2 (well, was for me) but the database never got updated so it wasn't reporting the right version. So removing 8.1 didn't hurt anything on my end - however you might have issues that I didn't. Love how it works!

I had to download the installation files manually as well. It seems like the updater removes them when it thinks it completed.

 

[ziggie216]

got that message too

# rpm -e psa-8.1.0-fc1.build81061129.23
error: Failed dependencies:
psa = 8.1.0 is needed by (installed) psa-manual-custom-skin-guide-8.1.0-fc1.build81061129.23
psa = 8.1.0 is needed by (installed) psa-hotfix3-8.1.0-fc1.build81061212.22
psa = 8.1.0 is needed by (installed) psa-hotfix4-8.1.0-fc1.build81061226.14
psa = 8.1.0 is needed by (installed) psa-hotfix5-8.1.0-fc1.build81070201.15
psa = 8.1.0 is needed by (installed) psa-hotfix6-8.1.0-fc1.build81070224.19

 

[ziggie216]

plesk control pannel still shows 8.1.0 on IE...

I did get some error during the rpm

ERROR while trying to upgrade SQL database from 810
Check the error reason(see log file: /tmp/psa_8.2.0_fc1.build82070706.15_upgrade.070912.12.52.log), fix and try again

Aborting...

error: %post(psa-8.2.0-fc1.build82070706.15) scriptlet failed, exit status 1
  11:psa-libpam-plesk       ########################################### [ 65%]
 Trying to install PAM module... done
  12:psa-awstats-configurato########################################### [ 71%]
  13:psa-horde              ########################################### [ 76%]
 Trying to establish test connection... connected
done
  14:psa-hotfix3            ########################################### [ 82%]
 Trying to replace files and set up right permissions... cp: missing destination file
Try `cp --help' for more information.
done
 Trying to establish test connection... connected
done
Stopping httpd: [FAILED]
Starting httpd: [  OK  ]
  15:psa-api                ########################################### [ 88%]
  16:psa-imp                ########################################### [ 94%]
 Trying to establish test connection... connected
done
  17:psa-updates            ########################################### [100%]

any idea how I can redownload the install files other than to use update or ask my provider?
this is what I have so far

]# ls
courier-imap-3.0.8-fc1.build82070706.15.i586.rpm                psa-horde-3.1.4-fc1.build82070706.15.noarch.rpm              psa-proftpd-1.3.0-fc1.build82070706.15.i586.rpm
libidn-0.4.2-fc1.build82070706.15.i586.rpm                      psa-hotfix3-8.2.0-fc1.build82070807.17.i586.rpm              psa-proftpd-xinetd-1.3.0-fc1.build82070706.15.i586.rpm
psa-8.2.0-fc1.build82070706.15.i586.rpm                         psa-imp-4.1.4-fc1.build82070706.15.noarch.rpm                psa-pylibplesk-8.2.0-fc1.build82070706.15.i586.rpm
psa-api-8.2.0-fc1.build82070706.15.noarch.rpm                   psa-libpam-plesk-8.2.0-fc1.build82070706.15.i586.rpm         psa-qmail-1.03-fc1.build82070807.17.i586.rpm
psa-awstats-configurator-1.0.0-fc1.build82070706.15.noarch.rpm  psa-locale-base-en-US-8.2.0-fc1.build82070807.17.noarch.rpm  psa-updates-8.2.0-fc1.build82070807.17.noarch.rpm
psa-courier-imap-add-8.2.0-fc1.build82070706.15.i586.rpm        psa-logrotate-3.7-fc1.build82070706.15.i586.rpm

 

[NETSource]

https://register.swsoft.com/login.php?redirect_page=products/

You can create an account and download the complete installation tar there.

Also - what is the error that's given in the update log?

 

[ziggie216]

in the psa_8.2.0_fc1.build82070706.15_upgrade.070912.12.52.log, the last few lines was
ERROR while trying to upgrade SQL database from 810

Aborting...

but I think that was from the autoupdate

I did run some mysql commands stated in some other post about change uid and owner so that fix one problem. Only other thing is that control pannel is still labeled 8.1. Is it only the labeling that is wrong? Everything else seems to be working at this moment

 

[numard]

Hi there,
the problem is with the 810 SQL upgrade script as pointed out elsewhere.

The script drops indeces/columns and adds new ones. When it fails the first time (I'm unsure why), the changes are not rolled back( WHY OH WHY can't they use transactions?! ).

anyway, the 2nd-nth time u run the script, it will probably fail earlier than the first time - because now the sql script attempts to drop an object that was already dropped before, and bails out with an error.

to solve it, i used a small bit of SQL to revert the actions of the 810 upgrade script. run this BEFORE re-running the rpm -Uvh --force plesk-8.2 ... rpm

alter table subdomains add index `dom_id_2` ( `dom_id`);
alter table subdomains drop index `dom_id_displayName`;

alter table mail_resp add index `mn_id` (`mn_id`);
alter table mail_resp drop index `mn_id_resp_name`;

ALTER TABLE `DatabaseServers` add INDEX `host` (`host`);
ALTER TABLE `DatabaseServers` drop INDEX `host_port` ;


alter table spamfilter_preferences add index `spamfilter_id` (`spamfilter_id`);

ALTER TABLE SiteAppPackages drop COLUMN `package_type` ;
ALTER TABLE SiteAppPackages drop COLUMN `params_id` ;
ALTER TABLE SiteAppPackages drop KEY `params_id` ;

ALTER TABLE SiteAppResources drop COLUMN `res_param_1`;

ALTER TABLE DatabaseServers drop COLUMN `server_version` ;

delete from actions where name="siteapp_upgrade";

ALTER TABLE clients drop COLUMN uid ;
ALTER TABLE clients drop COLUMN ownership ;

ALTER TABLE dom_level_usrs drop COLUMN uid ;
ALTER TABLE dom_level_usrs drop COLUMN ownership ;

delete from NewsArticles where class = 'WhatsNew8_2';

BTW, the upgrade will take a long time because of the execution of quotacheck. You can kill the quotacheck process (from another term) with minimal side effects.