Bizarre counter problem..numbers get ridiculously huge!

[John E. Lester]

Hi,

I just set up a site at http://www.braintalk.org (we migrated from an old UBB system we had been using for 4 years). Didn't import anything, just a fresh start. Mac OS X Panther with the current updates, and the built-in MySQL and pHp. Purchased vBulletin and installed the 3.0.0 Release Candidate 4.

Everything seems fine....except for some bizarre counter things. I don't see any errors in my MySQL database, so I have no idea what's causing this.

The error pops up in several places where counters are working. The calculations get screwed up and balloon to numbers like 34453453322 and such. So far I've seen them affect the counter for the number of incoming private messages and the counter when you hover on an icon for a thread so that it says something like "you have 2343242423242 posts in this thread."

I had to turn off private messaging, since the page would just time out when people would try open their private message Inbox....I guess from trying to "calculate" something like 34508325029345 messages... :P

You can see all the details of my server at:


http://brain.hastypastry.net/forums/...?=7&do=phpinfo

Any ideas?

[John E. Lester]

Aha! I noticed it is also messing with the "primary users" in the usergroup page. It's even doing huge NEGATIVE numbers! Bizarre...


---
(COPPA) Users Awaiting Moderation 144,115,188,075,855,870 - Edit Usergroup (id: 4)Edit PromotionsShow All Primary UsersShow All Additional UsersView Reputation Administrators 72,057,594,037,927,940 - Edit Usergroup (id: 6)Edit PromotionsShow All Primary UsersShow All Additional UsersView Reputation Moderators - 2 Edit Usergroup (id: 7)Edit PromotionsShow All Primary UsersShow All Additional UsersView Reputation Registered Users -8,356,992,058,539,376,000 - Edit Usergroup (id: 2)Edit PromotionsShow All Primary UsersShow All Additional UsersView Reputation Super Moderators - - Edit Usergroup (id: 5)Edit PromotionsShow All Primary UsersShow All Additional UsersView Reputation Unregistered / Not Logged In - - Edit Usergroup (id: 1)Edit PromotionsShow All Primary UsersShow All Additional UsersView Reputation Users Awaiting Email Confirmation -3,386,706,919,782,613,000 -

[Zachery]

This is a weird one.... never seen somthing like this,

You might want to try updating your counters...

It seems like your running MySQL 3.x try upgrading to 4.0.16 or newer

Otherwise i have no idea what to tell you :/ sorry.

[Jake Bunce]

The last I heard, MySQL 4 is not required to run vB3 but it is highly recommended.

[John E. Lester]

Thank you for the quick reply.

I ran every single option in the "Update Counters" admin page. Nothing has changed.

Do you have *any* idea what is causing this? Is it a bug in the pHp code? Or something wrong with the database (and if so, what table?). I've seen you write here how you will log on to other people's sites and manually check things out...will you do that with my site?

I haven't upgraded to MySQL 4 yet. If it's not necessary to run vB3, I'd rather try all my options before resorting to that.

[Zachery]

As Jake said MySQL 4 would be a good improvement in general. As i said ive never seen this problem before. and i honestly cant think of anything that would cause it.

[John E. Lester]

Since this is a completely new bug and you've no idea what's causing it, do you want me to give you access to my site so you can check things out manually?

[Zachery]

No, not me personally, I will see if there is someone who might know better like a dev.

[John E. Lester]

One more thing...I've noticed a pattern.

For every number that should be just 1, it instead uses the number:

72,057,594,037,927,940

This is consistent....so if I have a usergroup with just one user (like admins...just me), or if I create a new usergroup and then just add one person to it as a primary group, it ALWAYS uses that number.

And if I put 2 people....well, then it's 2 x 72,057,594,037,927,940


144,115,188,075,855,880


So bizarre..

Well...other than this disabling my usage of private messages, the board seems to run fine. I love all the features, and my users are having a great time. Thanks for all your work.

[Floris]

I advice you to try and reproduce this by making a new database aside from the current one and upload the files in ascii and the images in binairy and the .xml files in ascii again and then do a fresh installation and see if that instance also has this weird event going on for it.

[Scott MacVicar]

Caused by autoincrement going a bit bizare I saw this when i used a signed datatype and specified a -1 value it caused the key to start at Max Value -1.

Can you provide me with phpMyAdmin and i'll attemp to repair as much as possible.

[John E. Lester]

I'm running what came installed with Mac OS X Panther... Apache/1.3.29


Forgot to mention. I'm running the Server version of Panther. So that's Mac OS X Server Panther. Not sure if that would make a difference.

[Zachery]

Im looking at your site, and on the frontside it doesnt seem to display anything with such large numbers

[John E. Lester]

Caused by autoincrement going a bit bizare I saw this when i used a signed datatype and specified a -1 value it caused the key to start at Max Value -1.

Can you provide me with phpMyAdmin and i'll attemp to repair as much as possible.

Ahhh....what's phpMyAdmin? Do I need to install it?

Sorry...I'm no MySQL expert.

[John E. Lester]

Ahh....looks like I'm already running MySQL 4....

This is a capture from my terminal session on the server:

mysql> status
--------------
mysql Ver 12.22 Distrib 4.0.16, for apple-darwin7.0 (powerpc)

Connection id: 478338
Current database:
Current user: [email protected]
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.16
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 3 days 7 hours 34 min 5 sec

Threads: 1 Questions: 6020345 Slow queries: 0 Opens: 85 Flush tables: 1984 Open tables: 64 Queries per second avg: 21.017
--------------

Hmmm...an *average* of 21 queries per second since I booted up the board 3 days ago. Smokin'!