UBB.threads PHP Forum Software Community Forums UBB.threads Bug Reports Permissions

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.

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.

I was able to go into specific forums and do it one by one instead of being able to do it in one step.

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

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.

from his php ini it is set to 1000 with 28 forums

That setting is likely at fault here, I would suggest emailing your host to extend this value to 5000

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?

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.

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.

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 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.

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?

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 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.

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.

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'll leave it be, I don't want to blow things up. Any thoughts on the mystery guest?