• Welcome to Simple Machines Community Forum. Please login or sign up.
November 30, 2021, 08:13:47 PM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


New Post Reduction On SMF

Started by Xpresskonami, September 16, 2021, 03:54:52 AM

Previous topic - Next topic

Xpresskonami

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.

Illori

if you have a fulltext index for searching setup, you need to delete the index and convert then create it again.

Xpresskonami

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

Illori

check the search method page in admin.

Xpresskonami

I check under the search mode, this is what I found. It select on the No index

You cannot see attachments on this board.

Xpresskonami

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

GL700Wing

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 ...
Life doesn't have to be perfect to be wonderful ...

Xpresskonami

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?

Illori

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.

Xpresskonami

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

shadav

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

Xpresskonami

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.

Xpresskonami


shawnb61

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.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

shawnb61

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?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Xpresskonami

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.

Xpresskonami

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

Kindred

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.

 
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: