Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Xpresskonami on September 16, 2021, 03:54:52 AM

Title: New Post Reduction On SMF
Post by: Xpresskonami on September 16, 2021, 03:54:52 AM
Hello, i am having issue with my website content.... Whenever i try to publish new topic or member wants to comments , my content automatically reduce, EXAMPLE: I want to publish a topic of 5000 words, when i post the topic it will shorten the topic to 200 or 300 words. I check admin page under my Maximum allowed post size its 0. Please how can i fix this.
Title: Re: New Post Reduction On SMF
Post by: Illori on September 16, 2021, 05:07:54 AM
try changing from 0 to a higher value like 10000 and see if that helps any. also are the posts written in an editor like word then copied to the forum? if so then you need to convert to utf-8.
Title: Re: New Post Reduction On SMF
Post by: live627 on September 16, 2021, 10:37:33 PM
hitting the 65535 char limit probably; need to convert to mediumtext
Title: Re: New Post Reduction On SMF
Post by: Arantor on September 17, 2021, 04:00:46 AM
300 words is probably in the under 10k category though...

Easy way to tell: put the limit in as 60000 and see if SMF complains it's too long (since having 0 just means it doesn't bother checking). If the post is longer than 60000, change the limit to 70000 and try again.

Setting it over 65535 will try to make it bigger automagically but should check that's the problem before doing it.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on September 24, 2021, 10:43:01 PM
I tried do follow this comment one after the other I input the limit to 60000, still not working. Still gotten short of post, it is when I modify and repost it will show full post
Title: Re: New Post Reduction On SMF
Post by: Arantor on September 25, 2021, 05:27:16 AM
When you say "still not working", what *exactly* happens? Explaining the detail is important if you want this fixed.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on September 26, 2021, 07:37:37 AM
Quote from: Arantor on September 25, 2021, 05:27:16 AMWhen you say "still not working", what *exactly* happens? Explaining the detail is important if you want this fixed.

Whenever I want to publish a new post. It always reduce all the content and topic. This error start this month. I don't have any issues with it before.

I can't publish a 1000 content it will always reduce it to 50 or 60. It did the same error in the Subject box as well.
Title: Re: New Post Reduction On SMF
Post by: Arantor on September 26, 2021, 08:14:27 AM
OK so I left some other questions on your other topic that would be useful to debug this.
Title: Re: New Post Reduction On SMF
Post by: mickjav on September 27, 2021, 06:49:37 AM
I have a lot of very large posts i had to update the field I think in forum management/database

https://www.databasedreams.co.uk/charts/weekly-charts-analysis/uk-singlesalbums-charts-24-sep-2021-to-30-sep-2021-analysis/msg6688/#msg6688
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on September 27, 2021, 10:49:14 AM
Quote from: Arantor on September 26, 2021, 08:14:27 AMOK so I left some other questions on your other topic that would be useful to debug this.

The topic has been split. I can't find out the split topic , but the main issues to this was the symbols " and ' include in the content.
Title: Re: New Post Reduction On SMF
Post by: Arantor on September 27, 2021, 11:06:53 AM
You did find it, you even posted in it. It's very confusing. Maybe we should ask thr mods to close both and start a new one summarising where everything is at especially since I'm no longer sure if you just want the problem fixed or if you want to upgrade.

Especially considering you haven't, as far as I know, actually tested the content here on this site meaning that depending on the problem, upgrading might not fix it either! There was a reason I asked you to test it and it wasn't because I was being a bit random.
Title: Re: New Post Reduction On SMF
Post by: Steve on September 28, 2021, 08:28:50 AM
Quote from: Xpresskonami on September 27, 2021, 10:49:14 AMThe topic has been split. I can't find out the split topic
YOUR topic was not split. A post unrelated to your topic was split out to be it's own topic.

Please do as Arantor asked. Otherwise, he can't help you if you won't follow his advice.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on September 30, 2021, 11:45:42 PM
Quote from: Arantor on September 27, 2021, 11:06:53 AMYou did find it, you even posted in it. It's very confusing. Maybe we should ask thr mods to close both and start a new one summarising where everything is at especially since I'm no longer sure if you just want the problem fixed or if you want to upgrade.

Especially considering you haven't, as far as I know, actually tested the content here on this site meaning that depending on the problem, upgrading might not fix it either! There was a reason I asked you to test it and it wasn't because I was being a bit random.

Ok, thanks. i come up with the main causes of the short content. my content do no allow me to write the symbols £ ' " and €. Whenevr any of this is include in the content, it cut the content from it.
Title: Re: New Post Reduction On SMF
Post by: Kindred on October 01, 2021, 07:02:26 AM
 I repeat again..  your issue is almost definitely related to a failureto convert to utf8
Title: Re: New Post Reduction On SMF
Post by: Steve on October 01, 2021, 08:15:03 AM
As this isn't a bug but more of a support issue, moving to Support board.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 01, 2021, 10:02:29 PM
Quote from: Steve on October 01, 2021, 08:15:03 AMAs this isn't a bug but more of a support issue, moving to Support board.

Ok thank you
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 01, 2021, 10:03:42 PM
Quote from: Xpresskonami on September 30, 2021, 11:45:42 PM
Quote from: Arantor on September 27, 2021, 11:06:53 AMYou did find it, you even posted in it. It's very confusing. Maybe we should ask thr mods to close both and start a new one summarising where everything is at especially since I'm no longer sure if you just want the problem fixed or if you want to upgrade.

Especially considering you haven't, as far as I know, actually tested the content here on this site meaning that depending on the problem, upgrading might not fix it either! There was a reason I asked you to test it and it wasn't because I was being a bit random.

Ok, thanks. i come up with the main causes of the short content. my content do no allow me to write the symbols £ ' " and €. Whenevr any of this is include in the content, it cut the content from it.

This is the causes of my forum issues
Title: Re: New Post Reduction On SMF
Post by: Illori on October 02, 2021, 05:22:26 AM
Quote from: Kindred on October 01, 2021, 07:02:26 AMI repeat again..  your issue is almost definitely related to a failure to convert to utf8

have you tried to convert to UTF-8? that is the fix to your issue.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 02, 2021, 01:11:53 PM
Quote from: Illori on October 02, 2021, 05:22:26 AM
Quote from: Kindred on October 01, 2021, 07:02:26 AMI repeat again..  your issue is almost definitely related to a failure to convert to utf8

have you tried to convert to UTF-8? that is the fix to your issue.

Yes it ask me to upgrade my database and I don't know I can upgrade my database. How can I upgrade my database to convert to UTF????
Title: Re: New Post Reduction On SMF
Post by: Illori on October 02, 2021, 01:21:30 PM
what is the exact error message you are getting? we need that to assist you further.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 02, 2021, 10:45:54 PM
Quote from: Illori on October 02, 2021, 01:21:30 PMwhat is the exact error message you are getting? we need that to assist you further.

Column 'subject' cannot be part of FULLTEXT index
File: /home1/username/public_html/Sources/ManageMaintenance.php
Line: 666

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.18, while your database is at version 2.0.13. The above error might possibly go away if you execute the latest version of upgrade.php.
Title: Re: New Post Reduction On SMF
Post by: Illori on October 03, 2021, 05:07:21 AM
if you have a fulltext index for searching setup, you need to delete the index and convert then create it again.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 03, 2021, 03:42:34 PM
Quote from: Illori on October 03, 2021, 05:07:21 AMif you have a fulltext index for searching setup, you need to delete the index and convert then create it again.

How will I do that please
Title: Re: New Post Reduction On SMF
Post by: Illori on October 03, 2021, 03:53:13 PM
check the search method page in admin.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 04, 2021, 05:54:22 AM
I check under the search mode, this is what I found. It select on the No index

You cannot see attachments on this board.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 04, 2021, 09:39:51 PM
Quote from: Xpresskonami on October 04, 2021, 05:54:22 AMI check under the search mode, this is what I found. It select on the No index

You cannot see attachments on this board.

What should I do next??
Title: Re: New Post Reduction On SMF
Post by: GL700Wing on October 05, 2021, 12:05:30 AM
Quote from: Xpresskonami on October 04, 2021, 09:39:51 PMWhat should I do next??
Quote from: Illori on October 03, 2021, 05:07:21 AMif you have a fulltext index for searching setup, you need to delete the index and convert then create it again.
What Illori said ...
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 05, 2021, 03:51:13 AM
Quote from: GL700Wing on October 05, 2021, 12:05:30 AM
Quote from: Xpresskonami on October 04, 2021, 09:39:51 PMWhat should I do next??
Quote from: Illori on October 03, 2021, 05:07:21 AMif you have a fulltext index for searching setup, you need to delete the index and convert then create it again.
What Illori said ...


How am I going to delete the index, that's what I'm concern about?
Title: Re: New Post Reduction On SMF
Post by: Illori on October 05, 2021, 04:42:04 AM
it looks like you dont have a full text search index. so one or more of your mods has added one. you would need to check with them and post in there support topic for further steps.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 05, 2021, 02:03:18 PM
Quote from: Illori on October 05, 2021, 04:42:04 AMit looks like you dont have a full text search index. so one or more of your mods has added one. you would need to check with them and post in there support topic for further steps.

Which specific mod will I post in, for the support topic that I know. This is the mod I have been using since version smf 2.0.16 without the error. It suddenly comes up last month after all this while I have been using the forum script
Title: Re: New Post Reduction On SMF
Post by: shadav on October 05, 2021, 02:11:21 PM
some things from your other thread to help move things along for those trying to help and if you could answer them
Quote from: shadav on September 24, 2021, 11:44:13 PMmore than likely your current issues are due to mods you've installed
Quote from: Arantor on September 27, 2021, 11:04:11 AMSo what mods did you install? I want to guess you installed some kind of related topics mod at some point? Are you still going to try to install it after the upgrade?
Quote from: Xpresskonami on September 27, 2021, 10:27:27 PMSimilar topic mod.
Quote from: Arantor on September 28, 2021, 05:45:07 AMAnd did you change the size of the subject field at some point?

How about you also answer my other questions? I asked them because they're relevant.
without knowing what mods you use, how would we know where to point you to the proper mod support thread
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 07, 2021, 06:47:59 AM
Quote from: shadav on October 05, 2021, 02:11:21 PMsome things from your other thread to help move things along for those trying to help and if you could answer them
Quote from: shadav on September 24, 2021, 11:44:13 PMmore than likely your current issues are due to mods you've installed
Quote from: Arantor on September 27, 2021, 11:04:11 AMSo what mods did you install? I want to guess you installed some kind of related topics mod at some point? Are you still going to try to install it after the upgrade?
Quote from: Xpresskonami on September 27, 2021, 10:27:27 PMSimilar topic mod.
Quote from: Arantor on September 28, 2021, 05:45:07 AMAnd did you change the size of the subject field at some point?

How about you also answer my other questions? I asked them because they're relevant.
without knowing what mods you use, how would we know where to point you to the proper mod support thread

I answered those questions. I didn't install any recent mod! But make use of similar topic mod, I change the topic maximum settings to 60,000 and later back to 0 when it's not fixing my error.

I announced that the may issues to this error is the symbols in my content which are ' " and £. I was told to convert my text to utf but the database says I use old version of the smf that I needs to upgrade. I reply to everyone questions when you check.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 07, 2021, 12:55:39 PM
No way to solve my problem??
Title: Re: New Post Reduction On SMF
Post by: shawnb61 on October 07, 2021, 01:35:05 PM
The Similar Topics mod has definitely added an index to the subject column in the messages table.  (If you read up on Similar Topics, that's what it says it's gonna do.)

That index is preventing the utf8 conversion.

You may want to check in the Similar Topics support thread how best to remove the index (https://www.simplemachines.org/community/index.php?topic=489947.0).

Once the index is removed, re-attempt the utf8 conversion.

If the mod does not provide a remove/re-add index function, you may need to remove the FULLTEXT index on the subject column on the messages table manually.  Best to check with that support thread, though.
Title: Re: New Post Reduction On SMF
Post by: shawnb61 on October 07, 2021, 02:41:20 PM
And some questions, just to be clear:
 - What version of SMF are you running?
 - What version of php are you running?
 - What version of MySQL are you running?
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 07, 2021, 08:41:08 PM
Quote from: shawnb61 on October 07, 2021, 02:41:20 PMAnd some questions, just to be clear:
 - What version of SMF are you running?
 - What version of php are you running?
 - What version of MySQL are you running?

What version of SMF are you running? = SMF 2.0.18
What version of php are you running? = PHP version: 5.6.30
What version of MySQL are you running? = Server version: 5.6.32-78.1

When i try to convert to utf, i got this
Column 'subject' cannot be part of FULLTEXT index
File: /home1/user/public_html/Sources/ManageMaintenance.php
Line: 666

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.18, while your database is at version 2.0.13. The above error might possibly go away if you execute the latest version of upgrade.php.
Title: Re: New Post Reduction On SMF
Post by: Xpresskonami on October 07, 2021, 09:05:29 PM
Quote from: shawnb61 on October 07, 2021, 01:35:05 PMThe Similar Topics mod has definitely added an index to the subject column in the messages table.  (If you read up on Similar Topics, that's what it says it's gonna do.)

That index is preventing the utf8 conversion.

You may want to check in the Similar Topics support thread how best to remove the index (https://www.simplemachines.org/community/index.php?topic=489947.0).

Once the index is removed, re-attempt the utf8 conversion.

If the mod does not provide a remove/re-add index function, you may need to remove the FULLTEXT index on the subject column on the messages table manually.  Best to check with that support thread, though.

You cannot see attachments on this board.

Yes i found the FULLTEXT In smf_related_subject
Title: Re: New Post Reduction On SMF
Post by: Kindred on October 08, 2021, 09:57:44 AM
Quote from: shawnb61 on October 07, 2021, 01:35:05 PMThat index is preventing the utf8 conversion.

You may want to check in the Similar Topics support thread how best to remove the index (https://www.simplemachines.org/community/index.php?topic=489947.0).

Once the index is removed, re-attempt the utf8 conversion.