sobrenome

Is it possible to IPS make a script to change that database collation from utf8 to utf8mb4 for those that did not chose this collation on the 3.4 to 4.0 upgrade?

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
 

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

We all need to be looking to the future and possible problems that not converting will eventually cause.
This has nothing to do with IIS, its a new suggested standard for MySQL, and they actually suggest that utf8mb4 is the new standard that everyone should be trying to achieve. IPS has adopted this at it's new standard character set.
It seems to me that it would be in the best interest of IPS to make sure everyone running IPB 4.x is running the same character set. This will eventually come back and byte everyone at some point.

I saw this during my investigation online. I manually preformed the conversion, but got a index length error of some kind. I possibly faild to create the database correctly?

i can tell you, its a lot of work, i better will wait for a converter from invision!

Just changed all mine through phpmyadmin and didn't get any errors. Seems to be ok.

How about pulling all the tables in phpmyadmin, and working from that .sql file?
Create a new databse, and then import the modified .sql back into the new database?

Unfortunately it's not that simple. Some of the indexes are created with a length based on 3 bytes per char in mind. So when you try and change the collation on those tables you get an error about indexes being too large. To fix it you have to completely delete the indexes on that table, recreate them with a length suitable for 4 bytes per char. Then you can change the collation.
I did it on my board by deleting all the indexes and then changing the collation type in conf_global.php. Then when you run the support tool it spits out the commands for recreating the indexes - even with the correct index lengths for utf8mb4. Not for the faint hearted, it took about 5 hours to recreate.
Info about the index issue: https://mathiasbynens.be/notes/mysql-utf8mb4 
 

I don't understand the fuss. if using utf8_unicode_ci, characters using 4 bytes such as emoji will be refused by the database. if that is an issue, simply update the collation? it's not like it's a different character set, utf8mb4 is a superset of utf8 in mysql, you can go from utf8 to utf8mb4 easily, there's just no going back from utf8mb4 to utf8 without losing data once there is 4-byte data in the database.

No. The scenarios are:
MySQL <= 5.1You cannot use UTF8MB4 at all MySQL >= 5.5UTF8. Certain characters (like certain Emoji) won’t be supported and could cause problems in earlier releases. Therefore the most recent version now warns you about this when you try to include such characters. UTF8MB4: You are free to use any characters. 

I agree. We need this modification of the wiki permission system.

Yeah I guess this is kinda needed.

after several months there is still no solution from invision ...

Bump on this permission again. Would really make things a bit easier and safer.

The popup is responsive. If the screen's device < the popup width, the width will be 100%.
I see the popup on your site is reponsive on smartphone.
 

The popup is fantastic on the desktop. But on the iphone 6 and iphone 4 screens it needs some improvement.
I have noticed that the popup horizontal and vertical alignments are based in the middle of the screen on desktop.
But in the phones, it seems that this formula does not work. The small screens don't have enough space for the popup, so the width is squeezed to 100%, but the height is not. The top vertical alignment is still in the middle of the screen. That's not good, because the content is not show, it's out the screen, bellow the view area.
It would be nice if in the small phone screens the popup have the vertical alignment based on the top of the screen, using all the screen view area.
Thanks!

I tested and it works fine. Please give me ACP access so I can take a look.

V1.0.3 has been released
Fix ACP restrictions. If 'Number of page views' = 1 the popup will show only once time.  

Is it possible to setup a popup to show only once for every member? So every member in the selected group(s) just sees it once.

yes, you can create multiple popups, each popups have different permissions.
EG: Popup A for guests, Popup B for members...

I'm working for the new version that can based on x number of page views 

Is this permissions based? For example I can make it pop up for guests every X pageviews to encourage them to register.

That's great news!

We have some cool ideas for the AS that we think should solve most of your concerns, including those mentioned here. On the fly filtering may be one thing. We're not going to do pagination (as in navigate to page 4) as it just doesn't fit technically into the backend of the content discovery module.... but, we are working on navigation and you will be able to click a topic in the stream, hit back and pick up where you left off. I get the sense that's what most want with "pagination" so we'll start there. 
That's not months out by any means and should be relatively soon. Virtually any example given regarding "it doesn't do what VNC did" has been successfully refuted. It is every bit as powerful as VNC and then some - I think there's just general confusion on how to use it to its full potential and we need to make a few improvements to make it more intuitive. 
Thanks for the tangible, bullet list feedback - it's very helpful.