ISPConfig update bug on code.

Discussion in 'Installation/Configuration' started by Panagiotis Tsiamis, Feb 28, 2022.

  1. Panagiotis Tsiamis

    Panagiotis Tsiamis New Member

    I have this version of ispconfig and tried to update:
    There is a new Version of ISPConfig 3 available!
    This Version: 3.2.2
    New Version : 3.2.7p1

    The update went like this:

    Operating System: Ubuntu 20.04.4 LTS (Focal Fossa)

    This application will update ISPConfig 3 on your server.

    PHP Warning: Undefined array key "do_backup" in /root/ispconfig3_install/install/lib/installer_base.lib.php on line 86
    PHP Warning: Trying to access array offset on value of type null in /root/ispconfig3_install/install/lib/installer_base.lib.php on line 92
    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]:

    Creating backup of "/usr/local/ispconfig" directory...
    Creating backup of "/etc" directory...
    Checking ISPConfig database .. OK
    Starting incremental database update.
    Loading SQL patch file: /root/ispconfig3_install/install/sql/incremental/upd_dev_collection.sql
    PHP Fatal error: Uncaught mysqli_sql_exception: Table 'dbispconfig.dbispconfigsys_session' doesn't exist in /root/ispconfig3_install/install/lib/mysql.lib.php:234
    Stack trace:
    #0 /root/ispconfig3_install/install/lib/mysql.lib.php(234): mysqli_query()
    #1 /root/ispconfig3_install/install/lib/mysql.lib.php(271): db->_query()
    #2 /root/ispconfig3_install/install/lib/update.lib.php(412): db->query()
    #3 /root/ispconfig3_install/install/update.php(322): updateDbAndIni()
    #4 {main}
    thrown in /root/ispconfig3_install/install/lib/mysql.lib.php on line 234

    Seems somewhere in the code the table parameter is messing and a concatenation is happening so it tries to find the table :dbispconfig.dbispconfigsys_session which it doesnt exist,i subspect a double variable of the database is doing this , something like:

    Dont have the time to search the code if someone can dig it please post the update.

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    No issues here with installing or updating ISPConfig 3.2.7p1, have installed and updated many systems since this version was released. So it's something specific to your setup or you did not install the release code but e.g. a git version instead. Please run the command:

    php --version

    on your system and post the results.
    Th0m likes this.
  3. Panagiotis Tsiamis

    Panagiotis Tsiamis New Member

    Version is a bit latest for ubuntu 20.04
    $ php -v
    PHP 8.1.3 (cli) (built: Feb 21 2022 14:48:42) (NTS)
    Copyright (c) The PHP Group
    Zend Engine v4.1.3, Copyright (c) Zend Technologies
    with Zend OPcache v8.1.3, Copyright (c), by Zend Technologies
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    ISPconfig does not support PHP version 8.
    On Ubuntu 20.04 you should change OS default PHP back to what it was, 7.3 I thing is default for Ubuntu 20.04.
  5. till

    till Super Moderator Staff Member ISPConfig Developer

  6. Panagiotis Tsiamis

    Panagiotis Tsiamis New Member

    Thanks a lot guys.

Share This Page