Jump to content

LaCollision

Clients
  • Posts

    1,001
  • Joined

  • Last visited

  • Days Won

    3

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Posts posted by LaCollision

  1. It won't work. You'll still come across the index too long issue as I keep saying...  Well you're not going to be happy until you get a step by step so try this. At your own large risk!

    • Backup your board.
    • Take the board offline
    • Backup your board!!!!
    • Add/Change conf_global.php to include 'sql_utf8mb4' = true
    • In the ACP goto Support -> Something is not working
    • It will spit out hundreds of MySql commands, copy them to a text file (there's no chance of them working from Fix Automatically unless your board is small)
    • Run the commands in phpmyadmin one by one or in small batches. Make a note of the tables that give errors about indexes being too long

    For the tables with index-too-long error:

    • Goto the table / Structure tab.
    • Scroll down and click on "+indexes"
    • Delete all but the primary indexes
    • Rerun the Support tool in the ACP, it should give you the correct command to recreate the index with the correct length

    Hi!

    Thanks for sharing your experience :)

    I might need some further explanation!

    When I add 'sql_utf8mb4' => true in the conf_global.php, and then I go in the ACP > Support > Something is not working, I don't get the MySQL commands.

    Did you change all the fields collations to utf8mb4 before going in the ACP > Support?

    Thanks a lot :)

     

  2. Hi there,

    Whoah, I'm so sorry to say that, but I'm very disappointed with this Mod :(

    My board is pretty large (1.7 million posts) and :

    1. This script runs 50 000 topics at a time !! It's insane. I launched it a long time ago, and it is still running.

    2. What happens for 50000+ topics ? The script should build incremental files, like topics1.xml, topics2.xml, etc.

    3. It should only run for topics that have not been already inserted in the sitemap.

    I'm so sorry, but this script is OK for only very small boards.
    I have to uninstall it. :unsure:

    Anyway, thanks for your work.

  3. A suggestion for the reputation system : we could choose to prevent warned members from giving a reputation (for example, level-2 or level-3 members could not give a reputation).

    This is very important, according to me : warned members are people that don't really respect the rules on the board. So preventing them from giving a rep, is a good way to be sure that the reputation system is used by "good" people.

×
×
  • Create New...