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.
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.
hitting the 65535 char limit probably; need to convert to mediumtext
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.
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
When you say "still not working", what *exactly* happens? Explaining the detail is important if you want this fixed.
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.
OK so I left some other questions on your other topic that would be useful to debug this.
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
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.
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.
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.
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.
I repeat again.. your issue is almost definitely related to a failureto convert to utf8
As this isn't a bug but more of a support issue, moving to Support board.
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
Quote from: Xpresskonami on September 30, 2021, 11:45:42 PMQuote 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
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.
Quote from: Illori on October 02, 2021, 05:22:26 AMQuote 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????
what is the exact error message you are getting? we need that to assist you further.
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.
if you have a fulltext index for searching setup, you need to delete the index and convert then create it again.
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
check the search method page in admin.
I check under the search mode, this is what I found. It select on the No index
83FD8A0F-5111-4550-B08A-323D90495FE5.jpeg
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
83FD8A0F-5111-4550-B08A-323D90495FE5.jpeg
What should I do next??
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 ...
Quote from: GL700Wing on October 05, 2021, 12:05:30 AMQuote 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?
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.
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
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
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.
No way to solve my problem??
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.
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?
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.
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.
11.jpg
Yes i found the FULLTEXT In smf_related_subject
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.