Unable to re-install/modify plesk in add/remove programs

[sergiorodrigues]

After Upgrading to last version (plesk_8.1.1_build070326.13.exe) and installing recent patchs (plesk_8.1.1_update070409.12.msp and plesk_8.1.1.2_update070517.18.exe), I've noticed that I was unable to control/create/modify... MySQL DB from server/SQL database Menu, and from domains.

The Server/SQL Database error is (as described in plesk):.
"The operation you were performing failed. You can retry the operation with or without changing its parameters. You may also want to report this problem to our support so that we could help you as soon as possible.
Show DetailsShow Details // This is a button
Hide DetailsHide Details // This is a button
Report ErrorReport Error // This is a button
OKOK // This is a button


Additional Information

DB query failed: Unknown column 'db_server_id' in 'field list'
---------------------- Debug Info -------------------------------
0: C:\Programas\SWsoft\Plesk\admin\plib\common_func.php3:211
db_query(string 'select db_server_id, count(id) as `count` from data_bases group by db_server_id')
1: C:\Programas\SWsoft\Plesk\admin\plib\DatabaseServerList.php:59
DatabaseServerList->fetchDatabaseServerList()
2: C:\Programas\SWsoft\Plesk\admin\plib\class.cList.php3:94
cList->fetchList()
3: C:\Programas\SWsoft\Plesk\admin\plib\class.cList.php3:113
cList->init()
4: C:\Programas\SWsoft\Plesk\admin\plib\DatabaseServersForm.php:25
DatabaseServersForm->assign(string '', boolean false)
5: C:\Programas\SWsoft\Plesk\admin\htdocs\server\db_servers.php:128
"
The Domain/Database error is (as described in plesk):"
The operation you were performing failed. You can retry the operation with or without changing its parameters. You may also want to report this problem to our support so that we could help you as soon as possible.

Show DetailsShow Details // This is a button
Hide DetailsHide Details // This is a button
Report ErrorReport Error // This is a button
OKOK // This is a button


Additional Information

DB query failed: Unknown column 'db.db_server_id' in 'field list'
---------------------- Debug Info -------------------------------
0: C:\Programas\SWsoft\Plesk\admin\plib\common_func.php3:211
db_query(string 'SELECT db.id, db.type, db.name, db.db_server_id, rs.app_id FROM data_bases db LEFT JOIN SiteAppResources rs ON ( rs.type="database" AND rs.res_id=db.id ) WHERE db.dom_id=31 AND db.type IN ('mysql','mssql')')
1: C:\Programas\SWsoft\Plesk\admin\plib\class.DataBasesList.php:66
DataBasesList->fetchDataBasesList()
2: C:\Programas\SWsoft\Plesk\admin\plib\class.cList.php3:94
cList->fetchList()
3: C:\Programas\SWsoft\Plesk\admin\plib\class.cList.php3:113
cList->init()
4: C:\Programas\SWsoft\Plesk\admin\htdocs\domains\databases\db.php3:33
"

MySQL isn't Working, I cannot re-install/modify/repair plesk installation throw add/remove programs in control panel, since I have the following error (during the re-instalation process):"
Plesk 8.1 for Microsoft Windows Setup Alert

Checksums of the following files do not match:

c:\....\SWsoft\Install\070326.13\ClientMySQL.msi
c:\....\SWsoft\Install\070326.13\AWStats.msi
c:\....\SWsoft\Install\070326.13\SpamAssassin.msi
c:\....\SWsoft\Install\070326.13\Python.msi
c:\....\SWsoft\Install\070326.13\AdminMySQL.msi

Retry Cancel
"
The same error apears if I download the installation file and start installation from it (doesn't matter if it is the web installer or the network installer.

Don't know what else to do.
meanwhile every service that needs mysql is stoped, like webmail...

Can any one give some clue to repair the re-install/modify process?

Please Help.

Sérgio Rodrigues.

 

[cranuncios]

The same Problem

I have the same problem

 

[zettaweb]

I am having the same problem when I try to change my Plesk Installation.

Luckily I have no problem with Databases or Webmail, but it's a serious problem can't change Plesk components.

 

[zettaweb]

The Plesk support team has fixed this problem.

I sent an email to [email protected] telling what is happening and they resolve the problem on their side.

Now I can add and remove components normally.

 

[DjFarout]

Where do I find the fix for this?? I'm having the same problem! My backups arent able to run because of this!

 

[sergiorodrigues]

Could you please tell us, Zettaweb, how did you solve those problems?

 

[jbolter]

I also have this same problem, can anyone shed some light on the solution? i know my databases are fine because I can access them through the mysql command line interface.
Thanks!

 

[sergius]

Gentlemn,

Could you please contact with SWsoft support?

http://www.swsoft.com/en/support/plesk/form/

 

[DjFarout]

I fixed mine...

during an update, the database changed and it didn't include a few fields. So I had to go create them. And it worked!!

If I remember correctly add these field
Database : PSA
Table : data_bases
add 'db_server_id' as an integer, not null

Heads up.. Once I did this, I ran it.. and got another error.. another field was missing! But I forget exactly which one it was...
It was in the either table databaseservers or db_users

Here are fields I have for both of them
table : db_users
id (int) Auto, notnull
login (char128) notnull
passwd (char(16)) notnull
db_id (int) notnull <<<<<<<----- this could be it!?!

------------------------------
table : databaseservers
id (int) Auto, notnull
host (char63) notnull
port (char63) notnull
type (ENUM('mysql','postgresql','mssql')) notnull, default 'mysql'
admin_login (char(255)) notnull
admin_passwd (char(255)) notnull
last_error (ENUM('no_error','connection_failed','permission_denied','other_error','credentials_not_set')) notnull, default 'no_error'


This fixed my issues! and I was able to do everything like normal!

 

[jbolter]

i added the fields and i am able to now see the databases again, although it says they are not activated for webadmin. any ideas on that? also when running the plesk backup utility i run into another database missing field. what kind of upgrade is this that removes all these fields???

sergius, when trying to contact support i was informed that my license was not bought directly from SWSoft so I would have to contact my hosting company. They are not much help so I'm doing my best with the forums here. I would love to work with support to fix this issue though as the upgrade seems to have affected the database considerably.

Thanks.

 

[DjFarout]

Hey Jbolter,

Login to the plesk admin & goto Server->databases.

it should list your db servers, click on one!

Do you get any errors there? if so post it here or msg me with it.
Also run the online backup.. and post any errors you get here.

 

[sergius]

DjFarout, thank you very much.

 

[DjFarout]

No Problem.

 

[jbolter]

Originally posted by DjFarout
Hey Jbolter,

Login to the plesk admin & goto Server->databases.

it should list your db servers, click on one!

Do you get any errors there? if so post it here or msg me with it.
Also run the online backup.. and post any errors you get here.

Ok, first problem is that it does not list any database servers here. I have MySQL which is working fine when I connect to the command line interface, but nothing shows up in Server->databases.

If i go to a domain and look at the databases they show up.
However, if i click on one I can not do WebAdmin.

I also can no longer add new databases.

Should I add a database server in Server->Databases? How could this have gotten blown away by an upgrade?

Thanks for the help.