Freedom4um

Status: Not Logged In; Sign In

4play
See other 4play Articles

Title: 4um: One fix made to article posting to address missing articles completed.
Source: [None]
URL Source: [None]
Published: Jun 28, 2021
Author: Pinguinite
Post Date: 2021-06-28 23:20:05 by Pinguinite
Keywords: None
Views: 213
Comments: 6

I finally got off my duff to fix the occasional problem of articles not posting properly, where the show up missing. I was aware of the youtube of the Russian guitarist who goes by the name "ДиДюЛя" that would not post. I determined that failure to be due to his name being too long for the DB. While it's only 6 Russian letters, converting that name to the HTML equivalent, which browsers do, results in a name is well over 40 characters, which is the max limit in the database. That causes the DB to reject the insert operation, and that results in the article being missing but otherwise appearing as a comment.

I am certain that in the past, the DB software accepted such overly long fields and truncated them, which was fine, but that some upgrade was instituted along the way which changed that behavior to a rejection of the entire data insert operation.

So I've put in a check for the author to see if it's bigger than 40 characters, and if so, it trims it down to 40 and then passes it to the DB. So the cause of that problem is fixed.

However, this particular issue could easily exist with other data fields besides the Author field. In fact it would have to, but given it's such a rare problem I'd rather identify which fields have been a practical issue and address them as it may not be a de facto practical problem with any field. And for all I know it may be a different issue with some articles aside from field lengths.

If you encounter this issue in the future, please notify me with relevant info, namely the URL source of what you're posting along with any aggravating put downs and vulgar insults you'd like to dole out at me for this being so long in the fixing, and I'll take a look. Right now I'm more available to address this than I have been in past months, and I have a small digital workbench set up that will let me analyze and determine the problem in rather short order.

Thanks for your lack of patience.

Post Comment   Private Reply   Ignore Thread  


TopPage UpFull ThreadPage DownBottom/Latest

Begin Trace Mode for Comment # 6.

#3. To: Pinguinite (#0)

While you're under the hood, please do away with the Categories, since the Auto Categorize function doesn't work. Thanks for keeping 4um up and running.

Lod  posted on  2021-06-29   7:23:57 ET  Reply   Untrace   Trace   Private Reply  


#4. To: Lod (#3)

If by "doesn't work" you mean it can't autocategorize, that's admin controlled. All I need to do is add more key words to the DB for categories and the software does a better job, usually.

It does require articles to actually contain a reasonable amount of text. Posting videos alone won't register any recommendation. I don't yet have the ability to write code to watch vids and have any clue of the topic.

Pinguinite  posted on  2021-06-29   17:33:50 ET  Reply   Untrace   Trace   Private Reply  


#6. To: Pinguinite (#4)

I don't yet have the ability to write code to watch vids and have any clue of the topic.

Can you create a category called "FUBAR", er, "Video"? That is, if you can recognize a video-only post.

You should start selling ads and get rich.

Anthem  posted on  2021-07-24   14:41:26 ET  Reply   Untrace   Trace   Private Reply  


Replies to Comment # 6.

        There are no replies to Comment # 6.


End Trace Mode for Comment # 6.

TopPage UpFull ThreadPage DownBottom/Latest