sql-mode="NO_ENGINE_SUBSTITUTION"

Discussion in 'Installation/Configuration' started by carpman, Oct 22, 2016.

  1. carpman

    carpman Member

    Hi, have done a install and setup using following guide:
    https://www.howtoforge.com/perfect-server-debian-wheezy-apache2-bind-dovecot-ispconfig-3-p5

    though changed mysql for mariadb, now when i try and do an install for ISPconfig i get error:

    MySQL database to create [dbispconfig]:
    MySQL charset [utf8]:
    PHP Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50550 Library:100118 in /home/admin/tmp/ispconfig3_install/install/install.php on line 235
    PHP Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50550 Library:100118 in /home/admin/tmp/ispconfig3_install/install/lib/mysql.lib.php on line 79
    Wrong SQL-mode. You should use NO_ENGINE_SUBSTITUTION. Add
    sql-mode="NO_ENGINE_SUBSTITUTION"
    to the mysqld-section in your mysql-config and restart mysqld afterwards


    any ideas?

    thanks
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    "You should use NO_ENGINE_SUBSTITUTION. Add sql-mode="NO_ENGINE_SUBSTITUTION" to the mysqld-section in your mysql-config and restart mysqld afterwards"

    apt-get install php5-mysqlnd
     

Share This Page