Cannot Login To Plesk After Update, countries.php3 errors

[MarshallT]

I am having a problem with Plesk after applying the update to 8.2.0, originally I got the error others have talked about where it displays that it cannot install the msi file but then, after hitting cancel, installs fine. The only difference is that mine is not fine.

Whenever I go to the Plesk Control Panel area, instead of seeing a login page I see:

Notice: Undefined offset: 1 in C:\Program Files\SWsoft\Plesk\admin\plib\countries.php3 on line 344

repeated around 100 times followed by:

We sorry, we have a temporary problem

Try to reload this page or begin with start page

(you can view this for yourselves at https://208.100.4.143:8443).

I have already tried going to the Plesk 8.2.0 installer and telling it to repair the installation but that did not work as I am still getting this error.

In the event viewer, I am seeing php errors popup with the following text:

The description for Event ID (2000) in Source (php) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: php[3784], PHP Notice: Undefined offset: 1 in C:\Program Files\SWsoft\Plesk\admin\plib\countries.php3 on line 344.

I cannot find any answers on the forums or google to this and am wondering if anyone knows how to solve this problem and get plesk working again.

 

[MarshallT]

Ok it looks like my plesk server database got owned during the upgrade, I switched it from Jet to MySQL and it is kind of working now. I just cant get a default language because it looks like the locales tables got wiped. Does anyone have a sample of what their locales table looks like in their plesk for windows?

 

[MarshallT]

Aha, I originally put it on a MySQL 5 server which it is incompatible with as it uses two different cases for table names throughout the control panel and MySQL 5 is case sensitive to table names.

Switched it to the 4.1.22 running on the same server as it then ran:

INSERT INTO `plesk`.`locales` (`id` ,`active`) VALUES ('en-US', 'true');
update misc set val="en-US" where param="def_locale";

to fix the language issue and it is running fine now.

 

[sergius]

Gentlemen,

Please try tool ftp://pleskwin.download.swsoft.com/Plesk/Autoupdate/Windows/8.2.0/121108/upgrade_locales.exe

 

[emferh]

Hello everyone

For me this tool didnt help. Can you provide some another solution for this problem.

Event Type: Error
Event Source: upgrade_locales.exe
Event Category: None
Event ID: 1
Date: 2.11.2007
Time: 12:13:58
User: N/A
Computer: ***************
Description:
Can't execute DROP TABLE IF EXISTS `ms_jet_counter`: MySql error 1051:Unknown table 'ms_jet_counter'
at (MySQLDatabaseProvider::execute line 318)
at Upgrade locales(wmain line 73)
Execute file name: C:\Documents and Settings\:::::::::\Desktop\upgrade_locales.exe

 

[sergius]

Seems plesk db is inconsistent on your server.
Please contact with SWsoft support.