Batnik Posted April 12, 2016 Share Posted April 12, 2016 I have made a small script that creates some "sql queries" to convert your database from utf8 to utf8mb4. THIS IS A TEST-SCRIPT <USE ONLY ON A TEST-BOARD> USE AT YOUR OWN RISK!!! 1. Download this script. 2. Upload it to the root directory of your test-forum 3. Run it in your browser by entering <yourforumurl>/dbc.php 4. Copy all of the commands and run all of them on your database 5. Change your /conf_global.php 'sql_utf8mb4' => true, i have not tested this yet at all, it took me 1 hour to create that script, so run only on test forums, it might be that it has to be optimized. dbc.php if would be nice if someone can download and test it on a test forum to see if it works becose i do not have a test forum installed Link to comment Share on other sites More sharing options...
Batnik Posted April 12, 2016 Author Share Posted April 12, 2016 running this script will not harm anything, it only generates sql-queries that you have to execute on your database. warning: it will create sql-queries to covert to utf8mb4 for ALL TABLES AND COLUMNS that are included in your DATABASE. Link to comment Share on other sites More sharing options...
MADMAN32395 Posted April 12, 2016 Share Posted April 12, 2016 1 hour ago, Batnik said: becose i do not have a test forum installed would recommend doing that that is if you're going to be developing and publishing. Link to comment Share on other sites More sharing options...
Batnik Posted April 12, 2016 Author Share Posted April 12, 2016 37 minutes ago, MADMAN32395 said: would recommend doing that that is if you're going to be developing and publishing. im not going to develop, i created a fix for my forums and want to share with others Link to comment Share on other sites More sharing options...
Batnik Posted April 12, 2016 Author Share Posted April 12, 2016 running this right now on my live-forums, i tell you when im done :) Link to comment Share on other sites More sharing options...
PANL Posted April 12, 2016 Share Posted April 12, 2016 So what are the benefits of using utf8mb4 instate of using UTF8? Link to comment Share on other sites More sharing options...
Batnik Posted April 12, 2016 Author Share Posted April 12, 2016 use of emojis (only) ... Link to comment Share on other sites More sharing options...
Batnik Posted April 12, 2016 Author Share Posted April 12, 2016 to many problems ... Link to comment Share on other sites More sharing options...
Batnik Posted April 12, 2016 Author Share Posted April 12, 2016 i give up for now, there is just toooooooo much more work to do ... no time to fix invision problems Link to comment Share on other sites More sharing options...
MADMAN32395 Posted April 13, 2016 Share Posted April 13, 2016 54 minutes ago, Batnik said: no time to fix invision problems im still confused on how this is an invision problem when it's related to a serverside database issue? Link to comment Share on other sites More sharing options...
Batnik Posted April 13, 2016 Author Share Posted April 13, 2016 its related to bad and not very userfriendly installation where some choices can not be undone. and this is invision problem. Link to comment Share on other sites More sharing options...
MADMAN32395 Posted April 13, 2016 Share Posted April 13, 2016 24 minutes ago, Batnik said: its related to bad and not very userfriendly installation where some choices can not be undone. and this is invision problem. installation asks if you want utf8 or utf8mb4 iirc; and you could just change the database and tables to utf8mb4 later via the database directly or phpmyadmin. no? They don't control your server software. not like they are modifying or installing php for you? Link to comment Share on other sites More sharing options...
sobrenome Posted April 13, 2016 Share Posted April 13, 2016 2 hours ago, MADMAN32395 said: installation asks if you want utf8 or utf8mb4 iirc; and you could just change the database and tables to utf8mb4 later via the database directly or phpmyadmin. no? They don't control your server software. not like they are modifying or installing php for you? I missed this conversion opportunity because I did not know that emojis need UTF8mb4. It was not explained on the 3.4 to 4.0 upgrade. I think that IPS should adapt the conversion script for those that missed the conversion back there (from 3.4 to 4.0) to allow the conversion on 4.1 series. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.