Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Suspected Bugs and Errors - 8
  5. View Thread Count Maxing Out at 65535

View Thread Count Maxing Out at 65535

Asked Modified Viewed 3,582 times
Back to Forum Index Previous Topic Next Topic
Print
Y
younis
Y
younis 10
Steve Younis
Superman Homepage - http://www.SupermanHomepage.com
Christopher Reeve Homepage - http://www.ChrisReeveHomepage.com/
Steve's Stuff - http://www.younis.com.au/
  • Member, joined since
  • Contributed 86 posts on the community forums.
  • Started 28 threads in the forums
  • Started this discussions
asked
Member

Hi,

A thread on my Forums is sitting at a maximum of 65535 and won't increase.

I understand that this is a MySQL issue, and that I need to change a Field Type from smallint(5) to mediumint(8)...

But which one?

Any help would be great appreciated.

Steve
0 replies

5 posts

P
PolarFox
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
answered
Veteran Member

idk what are you talking about.

There is a lot of tables and ID's.

Do you have over 65k threads, is this correct? (also at least 65k posts?)
0 replies
T
Tyler
T
Tyler 10
Helping, would be pointing you in the right direction, not doing it all for you.
  • Member, joined since
  • Contributed 198 posts on the community forums.
  • Started 3 threads in the forums
answered
Member

younis - You are correct it is a mysql issue. a smallint has a range of 0 to 65535.

You can set it to just int and that will solve your issue or you can use mediumint - either will fix your issue. int may be more than needed but will assure you won't have any issues....
0 replies
Y
younis
Y
younis 10
Steve Younis
Superman Homepage - http://www.SupermanHomepage.com
Christopher Reeve Homepage - http://www.ChrisReeveHomepage.com/
Steve's Stuff - http://www.younis.com.au/
  • Member, joined since
  • Contributed 86 posts on the community forums.
  • Started 28 threads in the forums
  • Started this discussions
answered
Member

Thanks Tyler. Which one do I change though?

Sorry, to be more precise, it's the Tread Views of one of my Forum's threads that has reached the 65535 limit. Which MySQL database file/entry do I change to mediumint?
0 replies
T
Tyler
T
Tyler 10
Helping, would be pointing you in the right direction, not doing it all for you.
  • Member, joined since
  • Contributed 198 posts on the community forums.
  • Started 3 threads in the forums
answered
Member

You need to go to the threads table and change thread_views column.... It can be accessed via phpmyadmin
0 replies
Y
younis
Y
younis 10
Steve Younis
Superman Homepage - http://www.SupermanHomepage.com
Christopher Reeve Homepage - http://www.ChrisReeveHomepage.com/
Steve's Stuff - http://www.younis.com.au/
  • Member, joined since
  • Contributed 86 posts on the community forums.
  • Started 28 threads in the forums
  • Started this discussions
answered
Member

Thanks! Found it. Updated it successfully.
0 replies

Category Forum

Suspected Bugs and Errors - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 5 posts
  • Votes 0 votes
  • Topic users 3 members

3 participants

Y
Y
younis 10
Steve Younis
Superman Homepage - http://www.SupermanHomepage.com
Christopher Reeve Homepage - http://www.ChrisReeveHomepage.com/
Steve's Stuff - http://www.younis.com.au/
  • Member, joined since
  • Contributed 86 posts on the community forums.
  • Started 28 threads in the forums
  • Started this discussions
P
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
T
T
Tyler 10
Helping, would be pointing you in the right direction, not doing it all for you.
  • Member, joined since
  • Contributed 198 posts on the community forums.
  • Started 3 threads in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet