-
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
-
-
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
-
Thank you very much stoo2000 for your answer ; I'll be watching this topic very closely.
Good luck for the next version ! -
^ I actually have 1.1 million posts on my board and it's been running just fine.
Only your first 50 000 topics must have been "sitemapped" ? -
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. -
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. -
Hi there,
My IPB forum runs like a charm with 1.5 million posts :
http://www.clubpoker.net/forum-poker
This is the 2.3.6 forum but I'm about to upgrade to 3.x.
I had some issues with the conversion from phpBB2, but since then, I'm a happy customer.- TCattitude and troskal
- 2
AutoIt Anti-Spam
in Marketplace
Posted
Hi,
Can't download version 1.0.3… when I try the change log version with 1.0.3, this is the 1.0.4 I get.
Could it be an IPS bug?
Thanks