I add 10 records to phpbb_users table in phpbb forum. 11th record store user_id as '2147483647' instead of autoincrementing it to '11'
Now when next record is added to the phpbb_users table, it shows the following error:
1062 - Duplicate entry '2147483647' for key 1
insert into phpbb_users (username, user_regdate, user_email) values ('rg', '1145418044', 'email@example.com')
Can anyone help me? Why user_id field is not autoincrementing?