mysql

[binarydata]

ok, i got a problem

i got 2 servers, 1 windows, 1 linux
both have an identical table

id smallint(5) NOT NULL AUTO_INCREMENT, primary key (id)

on the linux one i can do
insert into table values ('NULL'); and it will work and add the correct number

but on the windows server, i get an error

[ADDKiD]

What version of Windows? Windows 2003? What error, I bet you its the same one I was getting x.x

[binarydata]

its xp and redhat
both mysql 5.0

[ADDKiD]

I'll talk to my Network Administrator Friend, and see what he says. He's pretty good with MySQL, and MSSQL. What's the exact Error?

[binarydata]

# 1366

[bone-you]

insert into table values ('NULL');

try inserting '' or better yet, not inserting anything at all on it. Just leave that field out on the insert and it should work.

[binarydata]

insert into table values ('NULL');

try inserting '' or better yet, not inserting anything at all on it. Just leave that field out on the insert and it should work.

hmm, ill give that a try tomarrow
but what i wanna know is why it would work on linux but not windows?
(ive tried it 2 different linux machines and both worked fine)

[bone-you]

insert into table values ('NULL');

try inserting '' or better yet, not inserting anything at all on it. Just leave that field out on the insert and it should work.

hmm, ill give that a try tomarrow
but what i wanna know is why it would work on linux but not windows?
(ive tried it 2 different linux machines and both worked fine)

I'm thinking it might be a programming error. The windows vs linux ports of the applications. Not everything is exactly the same. Maybe someone made a messup somewhere? The '' or not specifying it should work. Even on windows.

[binarydata]

hmm, im thinkin there some var on the windows machine i need to change/set?
i doubt its a coding error cause im runnign these queries in mysql

ill find out when i go into work later

[Jensen]

I know this gimme 5 minutes so i find what i did to fix it its something about Strict mode being on the server

[Jensen]

Open my.ini in your mysql root
search for
# Set the SQL mode to strict

on the next line i have
sql-mode=""

i forget what it was durring the install probally one of these
STRICT_TRANS_TABLES
STRICT_ALL_TABLES

hope that helps

[binarydata]

Open my.ini in your mysql root
search for
# Set the SQL mode to strict

on the next line i have
sql-mode=""

i forget what it was durring the install probally one of these
STRICT_TRANS_TABLES
STRICT_ALL_TABLES

hope that helps

ah, that was it
just had to get rid of STRICT_TRANS_TABLES in sql mode

[Jensen]

Yeah I ran into that when upgrading to 5.0.X on my windows servers, glad I could help