Drupal 10 Error After Migration From Hosting to Localhost

At first I didn't know what really happened, but when I access my drupal site, my webiste error like bellow

The web  like can’t execute php script, just showing php script with black screeen on google chrome. So I try to compare my site .htaccess with default htaccess and I found different,  ijust remove line from my htaccess like this :

# START MultiPHP Version

<FilesMatch "\.(php4|php5|php3|php2|php|phtml)$">

    SetHandler application/x-httpd-alt-php82___lsphp
</FilesMatch>

# END MultiPHP Version

But now the site have different problem, showing message “The website encountered an unexpected error. Try again later”

After that I remember when I am import database, I have error like this when create table

-- --------------------------------------------------------
--
-- Table structure for table help_search_items
--
CREATE TABLE help_search_items (
  sid int UNSIGNED NOT NULL COMMENT 'Numeric index of this item in the search index',
  section_plugin_id varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The help section the item comes from',
  permission varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The permission needed to view this item',
  topic_id varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The topic ID of the item'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores information about indexed help search items';

#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'

I try to remove database and reimport database, but before I change collation FROM  utf8mb4_0900_ai_ci TO   utf8mb4_general_ci

sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_general_ci/g' nama_file.sql

Finally mydrupal site return to normal

PLEASE SHARE

Share it Share it Tweet Share it Pin it

Ahmad Zaelani

Seorang laki - laki biasa yang senang duduk sendirian di pinggir pantai, pengagum embun pagi dan lembayung senja, suka blogging, coding dan jogging. Moto hidupnya adalah hidup santai dan simple