Why in the hell is this happening?
Posted
by user202411
on Stack Overflow
See other posts from Stack Overflow
or by user202411
Published on 2010-04-17T05:06:39Z
Indexed on
2010/04/17
5:13 UTC
Read the original article
Hit count: 184
I just can't understand why is my database (mysql) behaving like this! My console shows that the record is created properly (please, notice the "remote_id" value):
Tweet Create (0.3ms)
INSERT INTO `tweets` (`remote_id`, `text`, `user_id`, `twitter_account_id`)
VALUES (12325438258, 'jamaica', 1, 1)
But when I check the record, it shows that the remote_id is 2147483647 intead of the provided value (12325438258 in the example above)...
This table has many entries, but this field is always written with 2147483647... It was supposed to fill this space with an unique id (which I guarantee you is being generated properly).
© Stack Overflow or respective owner