#utf8mb4_unicode_520_ci

[kumpulanjurnalmakalah-blog]

[solved] #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

When running a WordPress site, you may encounter the error message “Unknown collation: ‘utf8mb4_unicode_520_ci’”. This error occurs when your database is not properly configured to handle the utf8mb4 character set in WordPress. As WordPress started supporting emoji in version 4.2, it started using utf8mb4 character encoding instead of the standard utf8 character encoding. utf8mb4 encoding…

[darkstarnetwork43]

Unknown collation: utf8mb4_0900_ai_ci

Experienced “Unknown collation: utf8mb4_0900_ai_ci” when i was trying to import a database on a new server. Didn’t realize that the dump was created on a server with MySQL8 and i was trying to import it in MariaDB-10.5. FYI – The “ai” in the collation name stands for “accent insensitive” and the “ci” stands for “case insensitive. One of the solutions i stumbled upon, recommended i replace…

[polyphonetic]

For some reference on how I did it!

https://m.mediawiki.org/wiki/Manual:Installing_MediaWiki

The above was the main tutorial I used! The main parts for me was installing XAMPP, using Apache through the XAMPP console, and then separately using MariaDB *instead of* MySQL (which is in the XAMPP console). When creating the database in MariaDB, use the collation "utf8mb4_unicode_520_ci" instead.

https://m.mediawiki.org/wiki/Manual:Installing_MediaWiki_on_XAMPP

https://m.mediawiki.org/wiki/Manual:MariaDB

tutorial for XAMPP setup and ImageMagick [note that this uses XAMPP's MySQL, my process used MariaDB]:

https://youtube.com/watch?v=PoL_XxhsYRo

For APCu (which is related to caching and speeding up browsing), in XAMPP's php.ini file you'll want to make sure to have 'extension=apcu'. The below page was a big help on making sure you're using the right version, especially the top comment. that phpinfo() command part just literally make a text file with it, save as .php file through like notepad or notepad++, put it in your main folder for your wiki, open localhost to it

https://www.php.net/manual/en/book.apcu.php

Essentially when you get to the "installing the wiki" step, I tried to have ImageMagick and APCu ready and set up and showing that they're installed. I also looked into installing diff3 and File, but you do it after installation of your server when the LocalSettings.php has been created. Info is for some reason

https://m.mediawiki.org/wiki/Manual:Installing_MediaWiki_on_Windows_Server_2008_R2#GNU_diff3_Installation_.28Optional.29

This was a two-day project for me so don't fret if it takes a while to figure out. I hope though that this collection of links expedites the "googling around figuring out what the fuck anything is" stage.

There are many cool extensions you can do with MediaWiki and you can create a forum or a blog on it or just use it for whatever! I just think it feels so cool. Look around at other wikis to see how their CSS is done

MediaWiki:Common.css

https://m.mediawiki.org/wiki/Manual:CSS

https://en.touhouwiki.net/wiki/Touhou_Wiki

https://en.touhouwiki.net/wiki/MediaWiki:Common.css

https://wiki.puella-magi.net/Main_Page

https://wiki.puella-magi.net/MediaWiki:Common.css

YIPPEE I figured out how to host a WIKI on my COMPUTER with PHP and SQL!!!! I am gonna put so much world-building lore in this thing once I figure out some CSS

I can't say anything about the project but aaaaah I am. Excited. I have been wiggling this story concept in my head for like 4 years and am ready to spew them onto my computer much like raw unprocessed ore

[codippa]

How to resolve Unknown collation: 'utf8mb4_0900_general_ci' error 1273 in MySQL

How to resolve Unknown collation: ‘utf8mb4_0900_general_ci’ error 1273 in MySQL

Sometimes when importing a database dump from another MySQL server or executing an SQL query that uses a collation, you might encounter Unknown collation errors something like below

ERROR 1273 Unknown collation: ‘utf8mb4_0900_ai_ci’ ERROR 1273 Unknown collation: ‘utf8mb4_unicode_520_ci’ ERROR 1273 Unknown collation: ‘utf8mb4_unicode_ci’

[the_ad id=”656″]

Solution

Quickest solution to resolve…

[williechiu40]

Managing WordPress Custom Tables with an ACF Repeater Field

Whilst working on the deliciousbrains.com site we had the need to store some data about a custom post type. Because of the nature of the data it didn’t make sense to try and shoehorn it into the post meta table as a serialized array. Instead, creating a custom table to store it was the better approach. We want our customers to be able to download the latest version of the plugin at the time their license expired. We use WooCommerce to sell our WordPress plugins, but that only stores the current product version in post meta. To implement this functionality we need to store all of the versions for a plugin with the date they were released, and the zip filename. The custom table structure would look like this: CREATE TABLE `wp_woocommerce_software_product_versions` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `product_id` bigint(20) NOT NULL, `version` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `filename` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `date_released` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY from ManageWP.org https://managewp.org/articles/18153/managing-wordpress-custom-tables-with-an-acf-repeater-field

[raquelredsocial-blog]

(vía utf8mb4_unicode_520_ci MySQL o MaríaDB como solucionar error al importar base de datos)