Max length of default news post?

Konan · **Max length of default news post? -** 02-26-2003, 11:43 PM

For some reason when I try to post news it says it post it but it does not show up so from experimenting i shortened it and it worked but then tried it again by making it longer and it didn't work. If someone knows anything about the max length or if there is a feature you could change to make it so you can post longer news post i would greatly appreicate it. This has never happened before and just started recently happening. I find it very weird.

Thanks,

-Konan

mikem · 02-27-2003, 07:03 AM

I think there is a Maxlength setting somewhere for the News postings. I think it's hardcoded in one of the files..can't remember... :?

mikem <=scratches head

Cyberclark · 02-27-2003, 08:18 AM

The only place I know it to be limited is in the mySQL database itself. I believe the field that holds the post_text is a text field which means it is limited to 65535 characters. Now that would be one hell of a long news post. But even if you enter too much data into a field it should just truncate the data, not die altogether?

Anyways you could dig into the tables and try changing that field to Longtext which is capable of holding 4294967295 characters. Although not sure how this would change the performance of the db as a whole.

For more info see the mySql site

Make sure you have your db backed up before making any changes. Also I am not 100% sure the problem is with the db in this case just talking out loud here

Konan · 02-27-2003, 11:54 AM

I think i just need to backup and reinstall because i have been experienceing many problems lately and it's really starting to get annoying. But I will try the mysql thing first.

thanks for your help

-Konan

Konan · 02-27-2003, 12:00 PM

Another thing is the post aren't even that many characters which is REALLY weird and I think my shit is messed up because i have so many custom changes and what not and if i think i did a fresh reinstall i would be messed up. Hopefully 6.5 will fix this and if it doesn't i will be trying something else besides phpnuke.

-Konan

IACOJ · 02-27-2003, 12:03 PM

You aren't telling it to program the article are you? I noticed on mine that if it is programed, it doesn't show up. I think that is only for backend syndication.

Konan · 02-27-2003, 12:08 PM

no im not.

IACOJ · 02-27-2003, 12:55 PM

I'm wondering if the analyzer script from nukecops might show you what the problem is?

Konan · 02-27-2003, 01:07 PM

where do i get the script?

Konan · 02-27-2003, 01:16 PM

I found the analyzer over at www.nukecops.com and ran it and this is what it gave me and i do not know if this has anything to do with the news problem.

Code:

WARNING! WARNING! WARNING! Vulnerable MySQL Server On Your Server!
MySQL Server Version Reason For Vulnerability 
3.23.54 A vulnerability has been discovered in MySQL that may cause a denial of service. It has been reported that, under certain circumstances, a malicious MySQL client may be able to trigger a condition in which MySQL attempts to free the same memory twice. MySQL Daemon can be crashed unless upgraded. Details can be found by clicking --> here. Until that is resolved, PHP-Nuke should be the least of your worries.

Hopefully someone knows what is wrong and can help me fix it.

-Konan