> > No, the last inserted id is just 1051 or something like that.
> > Must be something else.
> > Dunno where '2147483647' comes from.
> >
> > Is there a way to reset the auto_increment value or something?
> >
> First, check out with myisamchk if the table isn't crashed.
> Then you can use SET INSERT_ID=value (or similar, I don't
> remember exactly)
I've used CHECK TABLE, REPAIR TABLE and no errors were reported.
I've used:
mysql> SET INSERT_ID=1034;
Query OK, 0 rows affected (0.00 sec)
mysql> alter table user_info change column userid userid int not null
auto_increment;
Query OK, 1026 rows affected (0.02 sec)
Records: 1026 Duplicates: 0 Warnings: 0
And then inserting:
mysql> insert into user_info (nickname) values('test');
Query OK, 1 row affected (0.00 sec)
mysql> insert into user_info (nickname) values('test');
ERROR 1062: Duplicate entry '2147483647' for key 1
And it get's fuckedup again. Why do the counter freakout??
How do I rebuild the indexfile?
I do not have access to the files, only to the consoleutilities (using
shell acount to my isp).
query = nospam
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
