• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Plesk 8.11 upgrade to 8.2 problem

N

nunor

Guest
After upgrading from plesk 8.11 to version 8.2 I can't access the main domains & clients in the plesk admin web interface.

I still keep receive this error:

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`=1')
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(string '1')
4: /usr/local/psa/admin/plib/common_func.php3:2867
objectMaker(string 'Client', string '1')
5: /usr/local/psa/admin/plib/class.DomainControlForm.php:268
DomainControlForm->assign(object of type BsDomain)
6: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:152
Click to expand...

Has anyone an idea? I can't edit neither create new domains & clients.
Subdomains is working.

Mysql itself is working fine. OS is FC2

Many thanks

Nuno
 
Same Problem here, and all my Domains are down... Holy Moly... I am on Suse 10.1
 
Same problem here -running on FC2.
This doesn't look good - my clients are all down!

PHP: 
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`=5')
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 '5')
4: /usr/local/psa/admin/plib/common_func.php3:2867
    objectMaker(string 'Client', integer '5')
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 false, 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
 
Just called swsoft - and because I didn't pay for the super premium support - they won't help me at all!

Now, I maintain an active SUS agreement which entitles me to upgrades, but apparently when an upgrade doesn't work, tough luck!

All I know is that all of my clients are down and sw-soft pretty much told me to screw off. When I said they would lose a customer, they were "Ok, fine... whatever"

Am I the only one who sees the conflict here? By releasing fault software they can FORCE anyone to buy their premium support package? Isn't this extortion?
 
I'm in the same boat.

My upgrade was errornous, but not so much as to take down websites.

The only thing down is our email, but Plesk has screwed up big style.

See http://forum.swsoft.com/showthread.php?s=&threadid=45608

Luckly we got our server through a reseller who has this support package and they are escalating it for us.

See what happens tomorrow. If I can find out any info for people, I will.
 
Same issue here.
Man this is so annoying!

Any updates or success resolving this guys?
 
Since someone had to do it...

I chucked out the $75 for a support incident, and let them fix it.

The following lines were found in root's .bash_history:

Code: 
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
cd /root/psa/PSA_8.2.0/dist-rpm-FedoraCore-2-i386/base/
rpm -Uvh --force *
mysql -uadmin -p`cat /etc/psa/.psa.shadow`

And these couple lines were in ~/.mysql_history:

Code: 
ALTER TABLE psa.subdomains ADD INDEX dom_id_2 (`dom_id`);
UPDATE mysql.user SET user='ROOT' WHERE user='root';
UPDATE mysql.user SET user='root' WHERE user='ROOT';

I'm assuming SWSoft logged in, issued the first two database commands, reinstalled all the Plesk RPMs, then issued the last database command.

(Fun trivia, apparently /etc/psa/.psa_shadow is the control panel admin password, in cleartext. Never noticed that one before.)

Play with it, see if some combination of the above commands gets you going.
 
so is it safe to assume that we are all having these problems on FC2?
 
Terrible, my whole server was down for 3h or so. Had emergency service of my hosting company fix it at 100 Euro charge.

Dont they test their Updates at SWSoft????
 
I tried that SQL on my server but that field already exists.

Also - I suspect it's not all they did as it does not handle the missing uid field.

Any more clues?
 
I have an almost exact match server that the 8.2.0 update did work on, so I duplicated the structure of the psa database from that to the one that is not working, removed watchdog (which complained because my installation of MySQL doesn't support the 'status' verb), and then ran up2date -u. All of my packages updated. Then I ran:
Code: 
service psa stopall
service psa start
At this point they all appear to have worked, but there were two errors in the midst of it, as so:

Code: 
# service psa start
Starting xinetd service...                                           done
Starting named service...                                            done
Starting mysqld service...                                           done
Starting qmail service...                                            done
Starting courier-imap service...                                     done
Starting postgresql service...                                       done
Starting psa-spamassassin service...                                 done
websrvmng: Service /etc/init.d/httpd failed to stop
websrvmng: Service /etc/init.d/httpd failed to stop
Starting Plesk...                                                    done


Then I hit port 8443, and nothing came up. So I checked,
Code: 
# service psa status
psa dead but subsys locked


After Googling and searching the forums, the best I can come up with is this:

Code: 
# service psa stopall
# rm -f /var/lock/subsys/psa
# service psa start

Same two errors in the 'start', and after a 'status', I still get the subsys error:

Code: 
# service psa status
psa dead but subsys locked


I'm REALLY hoping someone has a solution to this. I've escalated it to my provider, but they tend to be slow to actually fix anything.
 
Originally posted by shall
I've escalated it to my provider, but they tend to be slow to actually fix anything.
Click to expand...

On the plus side, the tech I talked to said that he saw the same thing yesterday and someone from his team was able to resolve it.
 
Please post back if you solved this - my Suse 10.1 Plesk is messed up with that error after trying to upgrade :confused:
 
Man - you rock!
I did that and needed to add a --force to the RPM command to re-install some of the stuff.

All worked and I now got a WORKING Plesk 8.2 - thanks for sharing this!
 
This took care of the problem for me:

1) remove 'caching-nameserver' package if it is installed:
# rpm -e caching-nameserver
2) alter the database of Plesk adding the field if it is missing:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> ALTER TABLE psa.subdomains ADD INDEX dom_id_2 (`dom_id`);
3) rename 'root' MySQL user if it exists to other name before upgrade
and rename it back to 'root' after:
mysql> UPDATE mysql.user SET user='ROOT' WHERE user='root';

then perform the following command (please correct the path if needed)
cd /root/psa/PSA_8.2.0/dist-rpm-FedoraCore-2-i386/base/
rpm -Uvh --force *

and then rename ROOT back to root:
mysql> UPDATE mysql.user SET user='root' WHERE user='ROOT';
Click to expand...
 
yeah, thats what I had posted in other thread about this - I just posted a link to that thread a couple posts up becuase its better to have one thread on the subject then three so I was trying to send people to that thread to find the answer and share.

oh well.
 
You must log in or register to reply here.

Similar threads

jola
Issue Plesk webserver inaccessible
2
Replies
20
Views
5K
jola
jola
J
Issue Logs Browser Plesk error
Replies
7
Views
1K
JuanCar
J
V
Resolved Error using git pull with an additional user
Replies
2
Views
956
vruiz
V
F
Resolved issue on plesk mail migrator
2
Replies
23
Views
3K
Sebahat.hadzhi
Sebahat.hadzhi
M
Issue File dump-header not found on first position in archive.
Replies
0
Views
1K
massin
M
Back
Top