• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

ERROR: PleskMainDBException

M

musictus

Basic Pleskian
After upgrading, when I login I have the following error:


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`=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
....

and the release is still 8.1

Running the updater again does not solve the problem.

Indeas?
 
Try this. It worked for me on the same problem (Fedora Core 2)

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...
 
Thank You, this fixed my issue. I upgraded to 8.2 but it kept being reported as 8.1 and started getting the mysql errors. Took your advace and it worked perfectly
 
Hello,

I had the same problem when i updated plesk 8.1.0 to 8.2.0. Then I restore an old 8.1.0 version. I rename the root-user in mysql before i update. Then I update to version 8.1.1 and then to version 8.2.0 and no errors appear. All is working. I rename root back, So the result for me that there is a problem with the root-user in mysql. All problems were with the tables-updates of mysql.

But if you don't know it before you update, so you have problems.
 
mine's still not working: it's reporting the following when trying the command "rpm -Uvh --force *":

error: Failed dependencies:
psa-security = 8.1 is needed by (installed) psa-firewall-1.0.1-fc2.build81070322.17
psa-security = 8.1 is needed by (installed) cs-gs-2.0.0-fc2.build81070322.17
psa-security = 8.1 is needed by (installed) psa-vpn-2.0.1-fc2.build81070322.17
psa-security = 8.1 is needed by (installed) psa-bf1942-1.0.0-fc2.build81070322.17
psa-security = 8.1 is needed by (installed) psa-bf2-1.0.0-fc2.build81070322.17
psa-security = 8.1 is needed by (installed) psa-fileserver-1.0.0-fc2.build81070322.17
psa-security = 8.1 is needed by (installed) psa-watchdog-2.0.2-fc2.build81070322.17
psa = 8.1.1 is needed by (installed) psa-migration-manager-8.1.1-fc2.build81070404.14
psa = 8.1.1 is needed by (installed) psa-api-rpc-8.1.1-fc2.build81070404.14
psa = 8.1.1 is needed by (installed) psa-backup-manager-8.1.1-fc2.build81070404.14
psa-api = 8.1.1-fc2.build81070404.14 is needed by (installed) psa-migration-manager-8.1.1-fc2.build81070404.14
psa-api = 8.1.1-fc2.build81070404.14 is needed by (installed) psa-api-rpc-8.1.1-fc2.build81070404.14
 
you should use the upgrade utility. Those errors don't really belong to this post. its a different issue. login to your plesk and upgrade through interface. you can also use the command line to run the updates.
 
the utility bombs too. I get an email with the subject "Plesk autoupdate failure report." And the end of the email says "error: Failed dependencies:
psa-api-rpc = 8.1.1-fc2.build81070404.14 is needed by (installed) psa-backup-manager-8.1.1-fc2.build81070404.14
ERROR: Unable to install the requested packages because of package dependency problems."
 
Originally posted by nunor
Try this. It worked for me on the same problem (Fedora Core 2)
Click to expand...

I have the same error on my CentOs4 server. Let us know which sql database file changed psa or mysql. can any one give me full details Please, like step to step.

Thanks
Kanagaraj
 
This is the error that I get when I try to look at a domain in the Plesk Control Panel.
Was Plesk 8.1.1 (on a GoDaddy VDS) Fedora Core 2. Upgraded to 8.2 as prompted on the desktop. Still reports as 8.1.1. Rebooting did not fix it. Will the above work for me?

Cheers,

M

---------------------
Domains >
ERROR: PleskMainDBException
Add To FavoritesAdd To Favorites
Up LevelUp Level
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`=9')
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 '9')
4: /usr/local/psa/admin/plib/common_func.php3:2867
objectMaker(string 'Client', string '9')
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
 
Originally posted by nunor
Try this. It worked for me on the same problem (Fedora Core 2)
Click to expand...

Hi, I tried this cause getting same errors when trying to view domains or clients on my server with Plesk 8.2 update.
I removed 'caching-nameserver' package
When I tried # mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> ALTER TABLE psa.subdomains ADD INDEX dom_id_2 (`dom_id`);

I get

ERROR 1064: You have an error in your SQL syntax near 'mysql> ALTER TABLE psa.subdomains ADD INDEX dom_id_2 (`dom_id`)' at line 1

Any way to trouble shoot and fix this error. I don't know alot about ssh so I will need step by step help if I can get it thenks....
 
Originally posted by phoenixisp
Try this:

mysql> ALTER TABLE clients ADD uid VARCHAR(36);

Worked for me -
Click to expand...

Ok I tried it and now I get error 1046 : NO database selected.
What is the database plesk uses in mysql?

Thanks for your help on this.

I think I guessed it, psa, used the command again and it said database changed. I will now login to plesk and check to see if the error is gone. Will post the results when I get them.

Thank you very much phoenixisp!

Ok now I get an error in plesk
"MySQL query failed: Unknown column 'ownership' in 'field list'"

Can I use the same command but change to
mysql> ALTER TABLE clients ADD ownership VARCHAR(36);

Went ahead and did that and Horray! it works now!
thanks again for your excellent help on my issue phoenix!
 
Originally posted by originalmguy
This is the error that I get when I try to look at a domain in the Plesk Control Panel.
Was Plesk 8.1.1 (on a GoDaddy VDS) Fedora Core 2. Upgraded to 8.2 as prompted on the desktop. Still reports as 8.1.1. Rebooting did not fix it. Will the above work for me?

Cheers,

M

---------------------
Domains >
ERROR: PleskMainDBException
Add To FavoritesAdd To Favorites
Up LevelUp Level
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`=9')
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 '9')
4: /usr/local/psa/admin/plib/common_func.php3:2867
objectMaker(string 'Client', string '9')
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...

Our fix will not work for you but I did see another post some where on this forum. Try searching for "Unknown column 'uid' in 'field list'"
 
below is the error i am getting. i have tried the fix on the first page but when i get to the part where i am pointing to the update i am not sure what to change the path to. i do know that there is no 8.2 directory. any help is greatly appreciated


-patrick



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`,`pa
rams_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
 
Originally posted by vesterman
Ok I tried it and now I get error 1046 : NO database selected.
What is the database plesk uses in mysql?

Thanks for your help on this.

I think I guessed it, psa, used the command again and it said database changed. I will now login to plesk and check to see if the error is gone. Will post the results when I get them.

Thank you very much phoenixisp!

Ok now I get an error in plesk
"MySQL query failed: Unknown column 'ownership' in 'field list'"

Can I use the same command but change to
mysql> ALTER TABLE clients ADD ownership VARCHAR(36);

Went ahead and did that and Horray! it works now!
thanks again for your excellent help on my issue phoenix!
Click to expand...

Nice, worked for me too, but one question: which type should "uid" and "ownership" fields be?

When I add a client to plesk now, it writes "true" to ownership, and leaves uid null.

Upd: It still says, that plesk 8.0.1 is installed, but the real version is 8.2.0 alredy. Anyone know, how to fix this?
Any help really appreciated.
 
You must log in or register to reply here.

Similar threads

J
Issue mail import fails
Replies
1
Views
271
Peter Debik
P
HoracioS
Resolved Mail import - Error
Replies
2
Views
1K
HoracioS
HoracioS
P
  • Locked
Internal error: Package with UID '' not found.
Replies
2
Views
2K
Preocupao
P
D
Websites and Domain tab doesn't load
Replies
1
Views
1K
InderS
I
V
Error while creating Full Backup
Replies
10
Views
3K
IgorG
IgorG
Back
Top