• 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

Problems while upgrading

F

Filipok

Guest
Tried to update plesk on FC2 machine. Nothing happened, plesk is not updated, but now my mail does not work.

Tried to connect through telnet, and this is what i get:

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Hello there. <[email protected]>
user [email protected]
+OK Password required.
pass sdfsd
Error: HTTPD_INCLUDE_D not defined

System error 11: Resource temporarily unavailable
Connection closed by foreign host.


Any idea what could be wrong?
 
I have uninstalled psa-spamassasin, after that Plesk 8.0 installed without errors ansd email works as well.
 
Well it was an easy fix for me, I had to set a default value for field
psa.module_bf1942_servers.srv_bandwidth to 0

Plesk 8 now works!
 
Originally posted by Filipok
Well it was an easy fix for me, I had to set a default value for field
psa.module_bf1942_servers.srv_bandwidth to 0

Plesk 8 now works!

where you put this value?

I think everyone who has FC2 is facing this problem.
 
Debian 3.1
Code:
ERROR: PleskMainDBException
MySQL query failed: Invalid default value for 'srv_bandwidth'

0: /opt/psa/admin/plib/common_func.php3:230
	db_query(string 'ALTER TABLE `module_bf1942_servers` MODIFY `rcon_username` varchar(32) CHARACTER SET binary  NOT NULL default ''')
1: /opt/psa/admin/plib/mysql41/mysql41.php:39
	mysql41_adopt_column(string 'module_bf1942_servers', string 'rcon_username', string 'varchar(32)', string ' NOT NULL default ''', array)
2: /opt/psa/admin/plib/mysql41/mysql41.php:112
	MySQL41TableUpgrader->_handleColumn(array)
3: /opt/psa/admin/plib/SQLParser.php:99
	SQLParser->_parseLineInTable(string '  `rcon_username` varchar(32) NOT NULL default '',')
4: /opt/psa/admin/plib/SQLParser.php:45
	SQLParser::parseLine(string '  `rcon_username` varchar(32) NOT NULL default '',', integer '4')
5: :
	array_walk(array, array)
6: /opt/psa/admin/plib/SQLParser.php:25
	SQLParser->getArray(array)
7: /opt/psa/admin/plib/mysql41/mysql41.php:67
	mysql41_adopt_table(string 'module_bf1942_servers', array, string 'utf8', string 'utf8_general_ci')
8: /opt/psa/admin/plib/mysql41/mysql41.php:29
	mysql41_adopt_database(array, string 'utf8', string 'utf8_general_ci')
9: /opt/psa/admin/plib/mysql41/MySQL41PSADBUpgrader.php:41
	MySQL41PSADBUpgrader->run()
10: /opt/psa/admin/plib/mysql41/mysql41_psa.php:28
	mysql41_adopt_psa_database(string 'php://stderr', boolean  false)
11: /opt/psa/admin/auto_prepend/auth.php3:88
 
very strange that so far there is no fix for this trouble? and ALMOST every one is facing this problem.

Sites are working, but plesk is down :(
 
As a temporary resort, I deleted the bf1942 module. apt-get remove psa-bf1942.
 
All you need to do is set 0 as default value for the field srv_bandwidth in the module_bf1942_servers table in the psa database
 
well, instead i uninstalled the module, as its not needed actually.
 
If you uninstall it, and then install it again it'll work perfectly and will be reconfigured anyway.
 
Same kind of problem after upgrade to 8.0.0

Hi there,

I'm having lot of trouble since I upgraded to Plesk 8. When clicking on the desktop link, I get this :

ERROR: PleskMainDBException


MySQL query failed: Table 'psa.Modules' doesn't exist

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/plib/common_func.php3:230
db_query(string 'select id from Modules where name = 'watchdog' and release >= 20000')
1: /usr/local/psa/admin/plib/news/WhatsNew800.php:88
FeatureWatchdog2->getAvailability(object of type UserAdmin)
2: /usr/local/psa/admin/plib/news/WhatsNewArticle.php:71
WhatsNewArticle->getAvailability(object of type UserAdmin)
3: /usr/local/psa/admin/plib/news/NewsManager.php:70
NewsManager->getArticles(integer '0')
4: /usr/local/psa/admin/plib/news/NewsManager.php:35
NewsManager->getNewArticles()
5: /usr/local/psa/admin/plib/class.Form.php:330
Form->assign()
6: /usr/local/psa/admin/plib/dashboard/DashboardForm.php:100
DashboardForm->assign(array, object of type UserAdmin)
7: /usr/local/psa/admin/plib/dashboard/DashboardLocation.php:56
DashboardLocation->access(string 'GET')
8: /usr/local/psa/admin/plib/UIPointer.php:423
UIPointer->access(string 'GET')
9: /usr/local/psa/admin/htdocs/plesk.php:14

And impossible to delete any client/domain ! I get this error :

ERROR: PleskFatalException


Unable to remove clients: Incapable de supprimer le client: filemng failed: rm: cannot remove `/var/lib/psa/dumps/10': Permission denied filemng: Error occured during /bin/rm command.

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/htdocs/clients/clients.php3:68

Anyone could help ? I'm really lost and not well versed into this.
 
Originally posted by Filipok
Well it was an easy fix for me, I had to set a default value for field
psa.module_bf1942_servers.srv_bandwidth to 0

Plesk 8 now works!

How did you do it? I can't bring up phpMyAdmin anymore, and I'm not good with MySQL commands to make that change. Could you please post exact commands? Thanks for Your help...
 
How to set a default value for field
psa.module_bf1942_servers.srv_bandwidth to 0.

[root@??? /] # mysql -u admin -p
Enter password: ???
mysql> USE psa;
mysql> ALTER TABLE module_bf1942_servers ALTER srv_bandwidth SET DEFAULT 0;
 
thx mac0310, but this change doesn't work for me. I confirmed this change, but still no luck:(
 
The above post is intended only to answer the question of how to set the default value to zero in the PSA MySQL database table psa.module_bf1942_servers.srv_bandwidth.

To the best of my knowledge this will only fix the Plesk Control Panel not working error.
ERROR: PleskMainDBException
MySQL query failed: Invalid default value for 'srv_bandwidth'
 
I am also having the same problems after upgrading to 4.x MySQL, that query you provided did not fix the issue.
 
Fixed it!

Follow as above but change the ALTER to:

ALTER TABLE module_bf2_servers ALTER srv_bandwidth SET DEFAULT 0;

That should do it.
 
Back
Top