query failed: Out of range value

[clankill3r]

I get a "query failed: Out of range value" error,

this is the value: 15660018291

 

what i only don't get is that tweet_id has a int type of 30 (as in int(30)).

The id to add is only 11 long..

 

$twitter_id fleuragemapvv 
$tweet_id 15660018291
$tweet Reactie op Klink in opinieartikel in Volkskrant morgen
$reply_to_id 
$date 2010-06-08 00:22:21

query failed: Out of range value for column 'tweet_id' at row 1 INSERT INTO tweets VALUES (NULL, 'fleuragemapvv ', '15660018291', 'Reactie op Klink in opinieartikel in Volkskrant morgen', '', '2010-06-08 00:22:21')

[Maq]

Please refer to the manual - http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

INT signed - 2147483647

  unsigned - 4294967295

[clankill3r]

thanks that worked

 

one more thing,

 

often the $reply_to_id is not set,

however that seems to give problems when i want to insert it in the database

 

now i tried this:

 

if($reply_to_id == ""){

$reply_to_id = NULL;

}

 

but that don't work either.

 

I also tried it with setting the default value for $reply_to_id in the database to NULL.

So how can this be fixed?

 

[Maq]

To check if a variable isset use isset.  You are checking if the variable is empty, which is not the same.

 

Can you post the table structure?

[clankill3r]

[Maq]

Set the column DEFAULT to NULL if that's what you want when $reply_to_id is not set.