SMF Support > SMF 1.1.x Support

Known issues on SMF 1.1.8 regarding message ids?

(1/9) > >>

ParatumCorMeum:
Sorry to bother you all with a really kind of non-specific question....

On SMF 1.x... are there any known issues that relate to message IDs, etc?

On a board I frequent, running SMF 1.1.8, there is a message about having run out of message ids?

Here's the message posted by the forum administrator:

--- Quote ---The message IDs are about to max out, and for some things they have. To put it simply, each message has an ID #. Let's say the database can only hold messages numbered up to 100,000 Well, the current message is like around 90,000. So, you are going to run out of message ID's eventually... The message IDs are higher than SMF can handle. The database is giving back a number too big for it. So this goes to having to renumber the messages. If I renumber the messages, though, any links to messages will break because they use the message number in the link. You won't lose any, but the links will be broken. Deleting messages doesn't help because the message ID always goes up; it doesn't re-use message IDs. This is kinda dangerous. The best way to do it is to put the forum in maintenance mode, download the database here so I can figure out the code to renumber everything and test it. Then run it on the live database on the server.
--- End quote ---

I installed a copy of 1.1.8 on my own server, as this is a strange issue and thought I might contribute a patch to fix this... but I cannot find anything that suggests a hard limit of any less than nine billion at an SQL level, and two billion from PHP's perspective before it begins treating declared integers as float values per the PHP documentation...

So it looks like the only hard limit is nine billion at a SQL level.... but maybe I'm chewing on shoe leather here, and don't know it yet.


Any ideas, guys?

Jade Elizabeth:
Never heard of that, but is your admin a member of SMFs big boards group? They can help with all sorts of things like that.

How many posts/topics do you guys have?

Arantor:
There is a hard limit of 4.2bn at SQL level (upper bound of an int column being 2^32), 2.1bn message ids at SMF level (since for safety it assumes one bit is signed, giving you 2^31 for message ids)

There is another cap on topics, which is 16m at SQL level, 8m at SMF level (again, it assumes a sign bit)

Are they *really* at message ids extending into the billions? Got a link? (PM me if you'd prefer) There is only one forum I've ever encountered that's SMF based that has ever encountered that problem and that got fixed differently.

Renumbering it is technically a bad idea for a lot of reasons unless you're extremely careful.

Jade Elizabeth:
I think this is your forum?
http://www.fisheaters.com/update.html

It says there's over a million posts :).

ParatumCorMeum:

--- Quote from: Jade Elizabeth on July 29, 2012, 09:29:55 PM ---I think this is your forum?
http://www.fisheaters.com/update.html [nofollow]

--- End quote ---

Yup, that is the forum. 

Navigation

[0] Message Index

[#] Next page