[SOLVED] ERROR deleting messages.

For general questions, rule questions, trade advice, FAQ's, and other assistance-related matters. This forum is for Bartertown related questions/help ONLY.

Moderator: Moderators

Post Reply
User avatar
smilbuta ( 148 )
Resident Trader
Posts: 305
Joined: Sat Oct 25, 2003 3:19 am
Location: Winter Springs, Fla (orlando area)

[SOLVED] ERROR deleting messages.

Post by smilbuta »

I am attempting to clear old sent messages.
I get the following error.

Code: Select all

SQL ERROR [ mysqli ]
BIGINT UNSIGNED value is out of range in '(`barterto_main`.`bt_privmsgs_folder`.`pm_count` - 11)' [1690]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Steps to replicate:
1. go to Private Messages
2. go to Saved Messages
3. Select 'mark all'
4. Chose "Delete Marked"
5. Press 'GO'
6. Confirm 'yes'
7...Error message at this part.
----------------------------------------------
My Trading Rules:
NOTICE: NO INTERNATIONAL TRADES OR SALES PERIOD.
1) I expect Bartertown courtesy during trades, Low Rating Ships First.
2) I never send PayPal as GIFT and you should not either.
3) Any Bad Refs on your REP in the last year, then you ship first.(Negotiable based on over all REP).
4) If your buying, you pay first.
5) If you have '0' Refs we cannot do business.

READ--->PLEASE DO NOT POST REPLY'S IN MY THREADS, PM ME.
User avatar
3eland ( 76 )
Token Canadian
Posts: 4061
Joined: Tue Aug 09, 2011 5:12 pm
Location: Ontario, Canada

Re: ERROR deleting messages.

Post by 3eland »

Thanks for the post, I'll make sure the Mechanic is directed to this post!

Ryan
~Ryan~
I'm like superman, but without the super.

The rules for Bartertown can be found here: viewtopic.php?f=44&t=45470
Helpful guide for sending packages to Canada: viewtopic.php?f=1&t=123125
User avatar
Plarz ( 362 )
The Technomage
Posts: 823
Joined: Tue Sep 25, 2007 3:05 am
Location: Washington DC, USA
Contact:

Re: ERROR deleting messages.

Post by Plarz »

smilbuta wrote:
Mon Oct 05, 2020 2:49 pm
I am attempting to clear old sent messages.
I get the following error.

Code: Select all

SQL ERROR [ mysqli ]
BIGINT UNSIGNED value is out of range in '(`barterto_main`.`bt_privmsgs_folder`.`pm_count` - 11)' [1690]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Steps to replicate:
1. go to Private Messages
2. go to Saved Messages
3. Select 'mark all'
4. Chose "Delete Marked"
5. Press 'GO'
6. Confirm 'yes'
7...Error message at this part.
Thanks for the detailed error report! Super helpful. Also, I'm sorry you're running into an issue. That sucks.

I'm going to run a repair on the database and we'll see if that fixes whatever's going on. If it doesn't, then we'll have to see what issue phpBB ran itself into, and what we can do to help you out.

Are you trying to delete old stuff because it's old, or are you out of PM space?

Tech mutterings: Oh, the joys of using MySQL in production...
MagickalMemories wrote:Please, nobody take this the wrong way when I say... Plarz, I love you.
No, no, guard, turn, parry, dodge, spin and - then - thrust!
Plarzoid.com: A Miniatures Blog
Currently trading with: - | Owed Refs from: - | Owe refs to: -
If I owe you a ref, PM me!
User avatar
Plarz ( 362 )
The Technomage
Posts: 823
Joined: Tue Sep 25, 2007 3:05 am
Location: Washington DC, USA
Contact:

Re: ERROR deleting messages.

Post by Plarz »

Go ahead and retry at your convenience. I think I resolved the issue and you should be able to delete the messages now.
MagickalMemories wrote:Please, nobody take this the wrong way when I say... Plarz, I love you.
No, no, guard, turn, parry, dodge, spin and - then - thrust!
Plarzoid.com: A Miniatures Blog
Currently trading with: - | Owed Refs from: - | Owe refs to: -
If I owe you a ref, PM me!
User avatar
smilbuta ( 148 )
Resident Trader
Posts: 305
Joined: Sat Oct 25, 2003 3:19 am
Location: Winter Springs, Fla (orlando area)

Re: ERROR deleting messages.

Post by smilbuta »

Hello,
Yep it worked, Thanks!

I was simply doing house cleaning on old messages. Had plenty of space. All other folders allowed for bulk deletion except that one.
----------------------------------------------
My Trading Rules:
NOTICE: NO INTERNATIONAL TRADES OR SALES PERIOD.
1) I expect Bartertown courtesy during trades, Low Rating Ships First.
2) I never send PayPal as GIFT and you should not either.
3) Any Bad Refs on your REP in the last year, then you ship first.(Negotiable based on over all REP).
4) If your buying, you pay first.
5) If you have '0' Refs we cannot do business.

READ--->PLEASE DO NOT POST REPLY'S IN MY THREADS, PM ME.
User avatar
Plarz ( 362 )
The Technomage
Posts: 823
Joined: Tue Sep 25, 2007 3:05 am
Location: Washington DC, USA
Contact:

Re: ERROR deleting messages.

Post by Plarz »

smilbuta wrote:
Tue Oct 06, 2020 2:11 pm
Hello,
Yep it worked, Thanks!

I was simply doing house cleaning on old messages. Had plenty of space. All other folders allowed for bulk deletion except that one.
Cool, glad you're good to go. Thanks for the quick follow-up!

For those interested in the technical bits of what happened:
phpBB (for some reason) stored the number of messages in a folder in a table, rather than calculating it every time. Likely for speed, which makes sense. It somehow got out of sync, and the stored size was less than the number of messages that were actually in the folder. When it tried to zero out that stored size value, the calculation ended up as a negative number, which won't fit inside a column that's an unsigned integer (positive numbers only). So, the database errored out, phpBB panicked and we got the error message reported.

I solved it by manually setting that stored count of messages to the real number of messages in the folder. I used this solution for two reasons:
  1. If the operation failed again in normal use (when I asked smibuta to try again) then I'd know the issue was repeatable, and I could take it to phpBB as a bug. I would then have worked with smibuta to handle the issue in a more manual method (likely manually deleting things from the database), or left it until phpBB could help, if it's non-urgent.
  2. I don't know what extra steps phpBB takes under the hood when things get deleted, nor did I want to try and take the time to find out. For all I know, just deleting the messages manually could have weird consequences for the users who sent/received those messages. Safer to not mess with things unless I absolutely have to. That said, I did manually update the table in this case. However, it's one simple value, and easy to revert.
At this point, I'm considering this as a one-off fluke unless it happens again.
MagickalMemories wrote:Please, nobody take this the wrong way when I say... Plarz, I love you.
No, no, guard, turn, parry, dodge, spin and - then - thrust!
Plarzoid.com: A Miniatures Blog
Currently trading with: - | Owed Refs from: - | Owe refs to: -
If I owe you a ref, PM me!
User avatar
tordeck ( 248 )
Expert Trader
Posts: 575
Joined: Wed Jan 19, 2011 4:57 pm
Location: Houston, TX

Re: [SOLVED] ERROR deleting messages.

Post by tordeck »

I just gotta comend Plarz on that AAR. Not many admins would bother to explain all that.
Buying or Trading, Lower Rating Ships First.
I Trade within the United States only.
I only use and accept Cash App or USPS Money Orders for payments.

The Dark City
Post Reply

Return to “Have Questions? Need Help?”