1 (edited by Frank H 2005-01-09 17:13)

Topic: Small bug in users table

When poking around to plan the attachment mod I stumbled upon a small bug (and probably not even noticable for anyone atm wink).

In the users table, the group_id column is an int(10), but it's missing the UNSIGNED attribute.  But someone has first to create a shitload of groups before it's even possible to be affected, so I doubt it's something needing quick patching wink

Re: Small bug in users table

you can still create 2 billion groups can't you?

3

Re: Small bug in users table

Connorhd wrote:

you can still create 2 billion groups can't you?

why would you want to creat 2 billon groups?

Re: Small bug in users table

Nice smile I'll fix it.

I'm sorry, but if you have more than 2147483648 user groups, you're screwed for now smile

Edit: Just so you know, I'll fix it in the install script, but I won't update it for already installed 1.2 forums.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: Small bug in users table

Connorhd wrote:

you can still create 2 billion groups can't you?

yep smile

but I was more thinking on the 'consistency', two cells to hold the same value not having the same type/attributes ... I said it was a small bug wink

Re: Small bug in users table

i managed to make 873,992 groups before mysql broke sad