SQL ERROR: Unknown system variable 'GTID_PURGED' | Unknown collation: ‘utf8mb4_unicode_520_ci’

 Need remove all lines with GTID_PURGED

sed -i '/@@GLOBAL.GTID_PURGED=/d' your_file.sql

The final file will load without problems




Open the sql file in your text editor;

1. Search: utf8mb4_unicode_ci Replace: utf8_general_ci (Replace All)

2. Search: utf8mb4_unicode_520_ci Replace: utf8_general_ci (Replace All)

3. Search: utf8mb4 Replace: utf8 (Replace All)

Save and upload!

留言

發佈留言

此網誌的熱門文章

Install Drupal 10 with composer in XAMPP htdocs OR PHP Command

create a dummy drupal project in XAMPP for setup MySQL   composer create - project - n drupal / recommended - project : ^ 10 my_site_name browser browse .../ my_site_name/web ==================================== Create a real project:   composer create - project - n drupal / recommended - project : ^ 10 my_site_name cd my_site_name php web / core / scripts / drupal install edit settings.php of the real one remove all sqlite settings & replace with: $databases [ 'default' ][ 'default' ] = array ( 'database' => ' my_site_name ' , 'username' => 'root' , 'password' => '' , 'prefix' => '' , 'host' => '127.0.0.1' , 'port' => '3306' , 'isolation_level' => 'READ COMMITTED' , 'driver' => 'mysql' , 'namespace' => 'Drupal \\ mysql \\ Driver \\ Database \\ mysql' , 'autoload...
閱讀更多

fix drupal 11 install error

  您好， 我發現了一個能夠在本機系統上安裝 Drupal 的調整： 在您網站的根資料夾中，有一個 .htaccess 文件，在編輯器中開啟它，然後將第 30 行周圍的行更改為 < IfModule mod_php.c > php_value assert . active 0 </ IfModule > 到 < IfModule mod_php.c > # php_value assert.active 0 </ IfModule > 在我的 XAMPP 本機系統上它可以工作。您可以再次安裝 Drupal。我用D10.3.10測試過。 安裝後，您可以再次編輯文件至舊版本。 C:\wamp64\www\my_site_name\web\core\assets\scaffold\files\htaccess
閱讀更多

[custom block module]Correcting Heredoc Syntax and Attaching JS

To create a custom block module in Drupal that includes both HTML and JavaScript, you'll need to follow several steps. This guide assumes you're using Drupal 8 or Drupal 9, given their similarity in handling custom modules and blocks. Step 1: Create the Module Folder and Files Module Folder : Navigate to /modules/custom in your Drupal installation (create the custom directory if it doesn't exist). Create a new folder named html_js_custom_block . .info.yml File : Inside html_js_custom_block , create a file named html_js_custom_block.info.yml . This file defines the basic metadata about your module. Populate it with the following content: yaml Copy name: 'HTML and JS Custom Block' type: module description: 'A custom block that includes HTML and JavaScript.' package: Custom core_version_requirement: ^8 || ^9 dependencies: - drupal:block .module File : This file isn't strictly necessary for this simple example, but it's standa...
閱讀更多