Query Error



  • When i log in and go to a object in infrastructure and i push new i get this error:

    isys_exception_database : Query error: 'INSERT INTO isys_catg_global_list (isys_catg_global_list__id, isys_catg_global_list__isys_catg_global_category__id, isys_catg_global_list__isys_purpose__id, isys_catg_global_list__isys_obj__id, isys_catg_global_list__hostname, isys_catg_global_list__description, isys_catg_global_list__scantime, isys_catg_global_list__imported, isys_catg_global_list__status) VALUES (DEFAULT, '1', NULL, '18', '', '','',null,'1')': Field 'isys_catg_global_list__order_no' doesn't have a default value.

    Webserver: Apache2.2
    PHP version: 5.3.5
    MySQL version: MySQL Server 5.1
    I-doit tried: 0.9.9-4 & 0.9.9-5



  • i get the same Error with

    Apache 2.2
    PHP 5.38
    MysQL 5.5.8

    with an Windows 7 OS


  • i-doit Kenner

    Hi,

    did you have tried an update to 0.9.9-6?

    Regards
    Christian



  • Hi,

    I have the 0.9.9.6 installed.

    I think I have found a Reason, why.

    when I remarke in the my.ini the Line

    sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER_NO_ENGINE_SUBSTITUTION"

    then I have no Problem, and the progrmm works very well.



  • What did you mean with "remarke"? I have the same problem on my system. I found in my my.ini the line. But what should I do?

    edit: disable Strict Mode in MySQL-Settings solve the problem. I disable it with the MySQL Instance Configuration Wizard. Now it works 🙂



  • Sorry,
    bad english

    disable in my.ini the line

    sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER_NO_ENGINE_SUBSTITUTION"

    and it works



  • @schwielownet:

    What did you mean with "remarke"? I have the same problem on my system. I found in my my.ini the line. But what should I do?

    edit: disable Strict Mode in MySQL-Settings solve the problem. I disable it with the MySQL Instance Configuration Wizard. Now it works 🙂

    Yup disabled strict mode in mysql-settings and works thx


 


Datenschutz / Privacy Policy