Rails <-> MySQL

Rails
1

Hi there,

I have this table “friendships” and it contains the 2 columns:

  • fsrq_sender_id
  • fsrq_receiver_id

When I tell Rails to create a record, the log file says (correctly, it
seems to me):
INSERT INTO friendships (fsrq_sender_id, fsrq_receiver_id)
VALUES(139, 140)

But when I check the new database record, both of the fields hold the
value ‘127’ (instead of ‘139’ and ‘140’).

How can this be???

Thanks a lot for any help with this strange thing!
Tom

2

But when I check the new database record, both of the fields hold the
value ‘127’ (instead of ‘139’ and ‘140’).

How can this be???

Odds are the fields in that table are using TINYINT which has a maximum
value of 127. What’s the schema for that table?

-philip

3

Thanks, Philip! That was exactly it!

Good to have guys like you…
Tom