Why am I getting this message after I post a photo?

mySQL query error: UPDATE ibf_topics SET topic_hasattach=topic_hasattach+1 WHERE tid=90964

SQL error: Out of range value for column 'topic_hasattach' at row 1
SQL error code:
Date: Saturday 11th of February 2012 10:11:12 AM

And it only seems to happen when I post on the sandbox photo thread. Other theads it does not happen.

And it only seems to happen when I post on the sandbox photo thread. Other theads it does not happen.

My guess is that thread has too many posts for a single thread.

That might be a clue. My guess is that thread has too many posts for a single thread.


I'll check on it ...

Sure enough, the field 'topic_hasattach' was defined as a SMALLINT which has a maximum value of 32767.

Apparently, you have attached more than 32767 pictures to that thread!




Anyways, i fixed it ...

We must have found the end of the internet.

Thanks Andy. What is our new limit?

It's now a signed 32-bit integer:
http://en.wikipedia.org/wiki/Integer_%28computer_science%29


Let's see if you can figure out the new limit.

Simple:

From − 2,147,483,648 to 2,147,483,647, from − (231) to 231 − 1

Close enough. Since the questing was about the limit, not the range:

The new limit for maximum number of picture attachments for a whole thread is: 2,147,483,647