Previous Thread
Next Thread
Print Thread
Hop To
#265698 08/29/2023 2:51 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
Hello,

I've run into an interesting issue.

Via the Groups tab, I click on moderators and the forum option. It brings me to the editing permissions page for moderators.

I choose the option Can approve moderated posts. After changing a forum from 0 to 1 I click on update this groups permissions at the bottom of the page.

The issue is that it is not keeping the permission set to 1, When I go back in to double check it is showing 0 still. I've done this several times with no success.

I need some assistance here, because I don't think I'm doing something wrong here and it's not updating the change.

Please advise and thanks in advance.

FREAK #265699 08/29/2023 3:26 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
It appears this whole section is not working. It removed the moderators ability to edit posts on it's own and now I can't get it to change from zero to 1 in this area as well.

FREAK #265700 08/29/2023 3:34 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
I was able to go into specific forums and do it one by one instead of being able to do it in one step.

FREAK #265701 08/29/2023 8:57 PM
Joined: Jun 2006
Posts: 16,275
Likes: 114
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,275
Likes: 114
Using the System Requirements Test what is the value for "max_input_vars"? You can see supplimental information at UBBDev: Issues with PHP max_input_vars Setting

I usually have mine set to a baseline minimum of 5000, the math to figure out a minimum for your environment is in the above article
Quote
There is no "perfect value", and the total is completely relative to your install; the more forums you have the more of a chance you'll have at reaching this limit. To figure out a value for your forums you should take the amount of forums you have (X) and multiply that value by 26 (current fields) and add 4 (additional fields); ex: (X forums * 26 current setting fields)+ 4 additional fields. The result should be the minimum value needed.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #265702 08/29/2023 9:38 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
Thanks for the reply Gizmo. I'm looking at what you posted and it might as well be in another language, because I have no clue. frown

FREAK #265703 08/30/2023 4:28 PM
Joined: Dec 2003
Posts: 6,551
Likes: 76
Joined: Dec 2003
Posts: 6,551
Likes: 76
from his php ini it is set to 1000 with 28 forums


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
FREAK #265704 08/30/2023 5:48 PM
Joined: Jun 2006
Posts: 16,275
Likes: 114
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,275
Likes: 114
That setting is likely at fault here, I would suggest emailing your host to extend this value to 5000


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
FREAK #265705 09/01/2023 3:15 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
Thank You. I'll e-mail them.

A new problem while trying to upload a pdf that is shy of 21MB

Script: /home/freaksfo/public_html/scripts/filemanager.inc.php
Line: 219
SQL Error: Out of range value for column 'FILE_SIZE' at row 1
SQL Error: 1264

Query:
INSERT INTO
ubbt_FILES
(FILE_ADD_TIME, FILE_TYPE, FILE_SIZE, FILE_MD5, USER_ID, FILE_DESCRIPTION, FILE_SHA1)
VALUES
(1693599256, 'pdf', 21391081, '386ec44f7e04ad4abfc6cd2a44d23a96', 2, 'ITPBNCAAF', '')

Any ideas on this one?

FREAK #265706 09/01/2023 3:34 PM
Joined: Jun 2006
Posts: 16,275
Likes: 114
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,275
Likes: 114
Column FILE_SIZE expects an integer from 0 to 999999 values/6 characters long; you're however sending it an int "21391081" which is 8 characters long; your PDF seems to be 21.391081 MB where the db column would expect something under a meg; I think that you could likely just adjust the FILE_SIZE column to read an 8 vs a 6 but it would be an unsupported modification to the database.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
FREAK #265707 09/01/2023 3:50 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
Thanks for that. I'm not sure how the string ends up like that. I merely downloaded the PDF from the source to then upload it in the forum.

The ini was changed from 1K to 5K and memory from 128 to 256 as well.

FREAK #265708 09/01/2023 4:02 PM
Joined: Jun 2006
Posts: 16,275
Likes: 114
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,275
Likes: 114
I think it's just too big for the forum to store its size, you could try to adjust the FILE_SIZE column to read an 8 vs a 6 but it would be an unsupported modification to the database or you could upload it to a section on your webspace and link to the file in your post.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
FREAK #265709 09/01/2023 4:09 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
I tried to upload it in another area of the forum and received the same error.

I'm a bit lost here which isn't unusual for these things, I just don't have enough knowledge or know how to understand.

Maximum size per file is 64 MB so this is about 1/3 of the size.

FREAK #265711 09/07/2023 10:56 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
Here's what I'm finding........... bigger pdf's 10MB or more, won't upload but anything that will.

The forum itself shows Maximum size per file is 64 MB

I've uploaded pdf's forever and never ran into any problems until now. I have two pdf's that come up with the error, one is nearly 11MB, the other is nearly 19MB. All other pdf's that have loaded up with no problem are 8MB and smaller.

There is some commonality now.

Suggestions?

Gizmo #265712 09/07/2023 10:59 PM
Joined: Jun 2006
Posts: 16,275
Likes: 114
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,275
Likes: 114
Originally Posted by Gizmo
I think it's just too big for the forum to store its size, you could try to adjust the FILE_SIZE column to read an 8 vs a 6 but it would be an unsupported modification to the database or you could upload it to a section on your webspace and link to the file in your post.
Again, the database isn't designed to display files that large, you can either upload them to your webspace via FTP and link to it or adjust the int value in your database to be an 8 vs a 6.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
FREAK #265713 09/07/2023 11:02 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
I have confirmed it's the size, I used a PDF compressor and turned the 10MB to 7.6MB and the 18MB to 2MB ( Don't ask how it did that big of a drop without losing quality)

They both loaded up with no issues.

FREAK #265714 09/07/2023 11:06 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
Quote
or adjust the int value in your database to be an 8 vs a 6.

What are the steps to do this and is it recommended? Or should I just compress the ones that issues?

Strange things are happening overall with the forum. For example in my groups area it shows I have 1 user as a guest and upon clicking on the 1, it comes back that no members meet the criteria. I've never had guests that would have posting ability.

I'm really not sure what's going on with these strange things taking place.

FREAK #265715 09/07/2023 11:45 PM
Joined: Jun 2006
Posts: 16,275
Likes: 114
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,275
Likes: 114
It's completely unsupported, but you would be changing the structure of the FILE_SIZE column in the ubbt_FILES table to read as an int(9) vs a mediumint(6) via PHPMyAdmin or whatever tool your webhost has available.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
FREAK #265716 09/07/2023 11:47 PM
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
I'll leave it be, I don't want to blow things up. Any thoughts on the mystery guest?


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
UBB 20 Years button
by Morgan - 02/20/2024 4:21 PM
Attachment/Cloudflar
e issue

by Morgan - 02/15/2024 5:47 AM
Forums down
by Nightcrawler - 02/14/2024 2:31 PM
How is this possible?
by Baldeagle - 02/08/2024 2:49 PM
Error Logs
by Outdoorking - 02/03/2024 9:41 PM
Who's Online Now
1 members (Nightcrawler), 417 guests, and 176 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)