Sql Error - Incorrect integer value

Question

I'm getting following error when I submit a form:

Can't added a new post. Incorrect integer value: '' for column 'aid' at row 1

Php Code:

$insert = mysql_query("INSERT INTO brt_articles VALUES( '', '$post_title', '$des', 
'$date', '$org_date')");    

    if($insert)
    {
        echo "<font color=green>Successfully added a new article.</font>";
        header("Refresh:3; url=allbrtarticle.php");
    }
    else
    {
        echo "<font color=red>Can't added a new post</font>" . 
              mysql_error();
    }

In my Localhost It's ok. But in server why it's giving me a error message ?

change aid to autoincrement in database table will fix the issue. — Madan Sapkota
– Madan Sapkota, Commented Feb 25, 2013 at 4:31

sectus · Accepted Answer · 2013-02-25 05:06:47Z

2

Probably that DB has differents settings than your local. STRICT_TRANS_TABLES mode might be turned on. Try SELECT @@GLOBAL.sql_mode; and SELECT @@SESSION.sql_mode;.

edited Feb 25, 2013 at 5:06

answered Feb 25, 2013 at 4:48

sectus

15.7k5 gold badges59 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Starx · Accepted Answer · 2013-02-25 04:36:46Z

0

The aid field does not accept '' value as input.

The safest way is to specify column names as you are sending the query.

INSERT INTO brt_articles (title_field, description_field, date_field, org_date, fieldname) VALUES('$post_title', '$des', '$date', '$org_date');

If aid is a primary key, simply omit that field in your query

INSERT INTO brt_articles VALUES('$post_title', '$des', '$date', '$org_date')

answered Feb 25, 2013 at 4:36

Starx

79.3k50 gold badges187 silver badges266 bronze badges

2 Comments

Babu Ahmed Over a year ago

Thanks @Starx Working with your first statement. But I already set aid column to primary key and autoincrement. So why your second statement is not working ?

Babu Ahmed Over a year ago

And I upload it(my code) to another server BUT It's working fine!

Patashu · Accepted Answer · 2013-02-25 04:30:28Z

0

aid is a column that is an integer, and you're trying to insert '' into it. '' is not a number, so the insertion fails.

Perhaps there's a server setting to auto-convert the incorrect type, but you shouldn't rely on it (as you've just found out)

answered Feb 25, 2013 at 4:30

Patashu

21.8k4 gold badges49 silver badges53 bronze badges

Comments

BizApps · Accepted Answer · 2013-02-25 04:32:53Z

0

This causes the error aid(INT) - which is included on you table columns(first column).

If its auto increment remove the ''.

$insert = mysql_query("INSERT INTO brt_articles VALUES('$post_title', '$des', 
'$date', '$org_date')");

Regards

answered Feb 25, 2013 at 4:32

BizApps

6,1409 gold badges42 silver badges65 bronze badges

2 Comments

Babu Ahmed Over a year ago

It's a autoincrement field.

BizApps Over a year ago

you should not be adding a value if its auto increment field.

Dipesh Parmar · Accepted Answer · 2013-02-25 04:35:02Z

0

try

"INSERT INTO brt_articles VALUES('".$post_title."', '".$des."', '".$date."', '".$org_date."')"

Remove first '' it's not needed as MySQL automatically add it if its primary key and auto_increment.

answered Feb 25, 2013 at 4:35

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

Comments

mson · Accepted Answer · 2013-02-25 04:42:33Z

0

your local db has the value of that column set to auto increment or has a default value.

on the server db, the table definition is not the same.

review and compare the table definitions and then make them consistent.

answered Feb 25, 2013 at 4:42

mson

7,8426 gold badges43 silver badges70 bronze badges

2 Comments

Madan Sapkota Over a year ago

if he uploaded the local database tables to server, then your statement is not true.

mson Over a year ago

thanks - now i see the nonexistent text where he says he uploaded the local database tables to the server

Collectives™ on Stack Overflow

Sql Error - Incorrect integer value

6 Answers 6

Comments

2 Comments

Comments

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

Comments

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related