After upgrading3.2 unable to see the data in ISPconfig.

Discussion in 'Installation/Configuration' started by Srikanth1261, Jun 1, 2021.

  1. Srikanth1261

    Srikanth1261 Member

    Hi,

    After updating to 3.2, I am unable to login to webmail. I am getting error as "Unknown column 'failed_login' in 'field list'". Also I am unable to see any old data in ISPconfig. Please help me.

    Thank you
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    From which version did you update?
    Did you get any errors during the update?
    Is the MySQL root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf correct?
     
  3. Srikanth1261

    Srikanth1261 Member

    From which version did you update?
    Updated from ISPConfig 3.0.X to ISPconfig3.2.
    Did you get any errors during the update?
    No errors
    Is the MySQL root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf correct?
    Yes, correct. Checked twice.
     
  4. Srikanth1261

    Srikanth1261 Member

    Before that I upgraded OS from debian 7 to debian 10. Sites were not working properly, so I have executed the command "php -q update.php" and gave the default values for the questions. After that site are working fine but I have the issues with ISPconfig and webmail.
     
  5. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    ISPConfig has Business support that can fix your issues for a fee. https://www.ispconfig.org/get-support/
    If you plan to fix yourself, start with this:
    https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
    Have you after upgrading to Debian 10 followed the ISPConfig Perfect Server Guide for Debian 10, installing all packages and doing configurations? When that is done, force reconfigure services with
    Code:
    ispconfig_update.sh --force
    How did you do the upgrade from Debian 7 to Debian 10?
     
  6. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    That field is part of the roundcube database, not ISPConfig's, so you need to update your roundcube schema from the older version. A quick search finds https://github.com/roundcube/roundcubemail/blob/master/UPGRADING which indicates roundcube's installer can check and update your schema, so if you installed roundcube from source you shouldn't have much more to do; if you installed from debian package, read their release notes and see if it mentions specifically what to do (I note there is a /usr/share/roundcube/program/include/rcmail_install.php with a function to update the db, so the required pieces may well be present).
     

Share This Page