mysql - hook` varchar(191) COLLATE utf8mb4_' at line 10

Question

I uploaded my databse file from localhost to my website host server and got this error messageStatic analysis:

2 errors were found during analysis.

Unexpected beginning of statement. (near "action_id" at position 211) Unrecognized statement type. (near "bigint" at position 223) SQL query:

-- -- Database: bitnami_wordpress -- -- -------------------------------------------------------- -- -- Table structure for table wp_actionscheduler_actions -- CREATE TABLE wp_actionscheduler_actions ( action_id bigint(20) UNSIGNED NOT NULL, hook varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, status varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, scheduled_date_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00', scheduled_date_local datetime NOT NULL DEFAULT '0000-00-00 00:00:00', args varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, schedule longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, group_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, attempts int(11) NOT NULL DEFAULT 0, last_attempt_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00', last_attempt_local datetime NOT NULL DEFAULT '0000-00-00 00:00:00', claim_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, extended_args varchar(8000) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'action_id bigint(20) UNSIGNED NOT NULL, hook varchar(191) COLLATE utf8mb4_' at line 10 [ Back ]

any help to resolve this would be appreciated

question from:https://stackoverflow.com/questions/65644063/hook-varchar191-collate-utf8mb4-at-line-10

Answer 1

Waitting for answers