Apache Friends Support Forum

Hello,

At the moment i have got 99 records in my table. When i try to insert one more record, the phpmyadmin client freezes, the record is not being inserted, and also no errorcode is given. If i delete my 99th record, and then try to insert a record, then there is no problem. Obviously there is a maximum limit, but i dont know how to set this limit higher.

I have 1 primary key field/column in the table with auto_increment and datatype=int(50).And there are also 13 more columns in the table, all with datatype varchar(200). What could be the reason for this problem?

int(50) is nonsense.
Max value for unsigned Int is 4294967295 (10 Digits)
signed int can have a size of 11 (-2147483648)

But the number in the Brackets just define how many digits will be shown, not how many will be saved.

I know, that has nothing to do with your problem, but it's good to know