Query Error

Tearow

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

georg

i get the same Error with

Apache 2.2
PHP 5.38
MysQL 5.5.8

with an Windows 7 OS

creiss

Hi,

did you have tried an update to 0.9.9-6?

Regards
Christian

georg

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.

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

georg

Sorry,
bad english

disable in my.ini the line

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER_NO_ENGINE_SUBSTITUTION"

and it works

Tearow

@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