Out of range Value fo column 'topic_views'

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
djsupport
Registered User
Posts: 30
Joined: Tue Jul 25, 2006 7:56 pm

Out of range Value fo column 'topic_views'

Post by djsupport »

Hopefully this can be fixed it was reported by a user:

Support Request Template
What version of phpBB are you using? phpBB 3.3.14
What is your board's URL? https://www.freestylersupport.com/fsforum/
Who do you host your board with? IONOS
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.3.13
What extensions do you have installed? Board Announcments
Share On
Multilinks
Obscure Contact Us
Google Search
What styles do you currently have installed? Pro Silver Speciel Editiom
What language(s) is your board currently using? British English
Which database type/version are you using? MariaDB
What is your level of experience? Comfortable with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? None, reported by a user it could have been like it for some time
Please describe your problem. In the 'FreeStyler - 3rd Party Addon's and utilities' section Click on the 'GO Monkey - Theater / Band Cue Stack' and then the topic announcment 'GO Monkey - Theater / Band Cue Stack'

it comes up with SQL error :

SQL ERROR [ mysqli ]

Out of range value for column 'topic_views' at row 1 [1264]

SQL

UPDATE fsforum_topics SET topic_views = topic_views + 1, topic_last_view_time = 1738189714 WHERE topic_id = 2787

BACKTRACE
Generated by SRT Generator
rxu
Extensions Development Team
Posts: 4018
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation

Re: Out of range Value fo column 'topic_views'

Post by rxu »

That is by design.
The topic_views field is mediumint(8) UNSIGNED for MySQL which means the maximum value of 16777215 is allowed. If a topic views count goes beyond this value, the MySQL error occurs.
There're 2 ways to workaround that: one is to manually change the column type to allow higher values (f.e. int(10)) and another is to manually drop the value of topic_views column for the topic down to f.e. 0.
djsupport
Registered User
Posts: 30
Joined: Tue Jul 25, 2006 7:56 pm

Re: Out of range Value fo column 'topic_views'

Post by djsupport »

So basically, because the forum is 17 years old and I can't find another person saying this, basically the topic has become sooo popular it broke itself 🤣
djsupport
Registered User
Posts: 30
Joined: Tue Jul 25, 2006 7:56 pm

Re: Out of range Value fo column 'topic_views'

Post by djsupport »

Thank you for your help I changed to INT 10 and it worked

Return to “[3.3.x] Support Forum”