1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Problems while upgrading

Discussion in 'Plesk for Linux - 8.x and Older' started by Filipok, Mar 29, 2006.

  1. Filipok

    Filipok Guest

    0
     
    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. <2919.1143683450@localhost.localdomain>
    user info@fandex.net
    +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?
     
  2. Mentat

    Mentat Guest

    0
     
    I have same problem on FC2 :(
     
  3. Filipok

    Filipok Guest

    0
     
  4. Mentat

    Mentat Guest

    0
     
    I have uninstalled psa-spamassasin, after that Plesk 8.0 installed without errors ansd email works as well.
     
  5. Filipok

    Filipok Guest

    0
     
    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!
     
  6. ChipMonk

    ChipMonk Guest

    0
     
    where you put this value?

    I think everyone who has FC2 is facing this problem.
     
  7. otsego

    otsego Guest

    0
     
    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
     
  8. ChipMonk

    ChipMonk Guest

    0
     
    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 :(
     
  9. otsego

    otsego Guest

    0
     
    As a temporary resort, I deleted the bf1942 module. apt-get remove psa-bf1942.
     
  10. ChipMonk

    ChipMonk Guest

    0
     
    thanx brother.


    let me hug you and kiss on your forehead :cool:
     
  11. Filipok

    Filipok Guest

    0
     
    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
     
  12. ChipMonk

    ChipMonk Guest

    0
     
    well, instead i uninstalled the module, as its not needed actually.
     
  13. otsego

    otsego Guest

    0
     
    If you uninstall it, and then install it again it'll work perfectly and will be reconfigured anyway.
     
  14. windtalker

    windtalker Guest

    0
     
    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.
     
  15. chopperpl

    chopperpl Guest

    0
     
    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...
     
  16. mac0310

    mac0310 Guest

    0
     
    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;
     
  17. chopperpl

    chopperpl Guest

    0
     
    thx mac0310, but this change doesn't work for me. I confirmed this change, but still no luck:(
     
  18. mac0310

    mac0310 Guest

    0
     
    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'
     
  19. MachTzu

    MachTzu Guest

    0
     
    I am also having the same problems after upgrading to 4.x MySQL, that query you provided did not fix the issue.
     
  20. MachTzu

    MachTzu Guest

    0
     
    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.
     
Loading...