Bizarre counter problem..numbers get ridiculously huge!

[Scott MacVicar]

Its a PHP Script for managing mysql.

http://www.phpmyadmin.net

Download unzip and edit config.inc.php to match your mysql username and password.

[John E. Lester]

Wooo! I got phpadmin installed and running!

I'll Private Message you the URL....

THANK YOU SO MUCH!

[Scott MacVicar]

The database appears to be fine and it wasn't what i initially thought. This could be indicating a problem with sprintf, there isn't actually those large numbers of rows just the actual number getting transformed.

I wont be able to get access to my iBook till tomorrow so I'll give it a try and see if its a PHP problem or a Mac OS problem.

[John E. Lester]

The database appears to be fine and it wasn't what i initially thought. This could be indicating a problem with sprintf, there isn't actually those large numbers of rows just the actual number getting transformed.

I wont be able to get access to my iBook till tomorrow so I'll give it a try and see if its a PHP problem or a Mac OS problem.

Thanks so much, Scott. I'm happy it's not a corrupted database. Thanks for working with me on this bug.

[John E. Lester]

The database appears to be fine and it wasn't what i initially thought. This could be indicating a problem with sprintf, there isn't actually those large numbers of rows just the actual number getting transformed.

I wont be able to get access to my iBook till tomorrow so I'll give it a try and see if its a PHP problem or a Mac OS problem.

I found this via Google...is this the bug?

http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/92973

I have no idea what they're talking about on that post...just a shot in the dark.

[John E. Lester]

Any news on this bug?

My users would really like to be able to use private messages on my system.

And when my 2,500 registered users really want something, I hear about it. Constantly.

[John E. Lester]

Joy! An update to Mac OS X Server just came out today (10.3.3). I installed it, and now the counter problem has mysteriously disappeared.

Something in the update fixed things. Maybe because MySQL was updated to 4.0.18 ??

Anyway, I'm one happy camper.

[luroca]

I am having the same problem, suddenly auto_increment goes mad and userid, postid and so became huge and board crash: invalid user, invalid forum, invalid link and so
I have repair manually the erroneus entries in the database but is very annoying and I don´t know what is wrong
The problem has been with RC4, 3.0.0 and 3.01 in two different boards in the same server:

Dual xeon 2,4 with 2048 MB ram
Redhat Enterprise 3.0 - Taroon
Apache 2.0.46
Mysql 4.0.18
PHP 4.3.6

Is there any solution for this problem?
Regards