Error importing SQL wordpress database

Asked

Viewed 30 times

-4

When trying to import database the following error occurs:

Erro
Comando SQL:


CREATE TABLE `wpzm_actionscheduler_actions` (
  `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hook` varchar(191) COLLATE=utf8_general_ci;
Mensagens do MySQL : Documentação

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '=utf8_general_ci' at line 3

How can I solve?

CREATE TABLE wpzm_affiliate_wp_visits ( visit_id bigint(20) NOT NULL AUTO_INCREMENT, affiliate_id bigint(20) NOT NULL, referral_id bigint(20) NOT NULL, rest_id mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, url mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, referrer mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, campaign varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, context varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, ip tinytext COLLATE utf8mb4_unicode_ci NOT NULL, date datetime NOT NULL, PRIMARY KEY (visit_id), KEY affiliate_id (affiliate_id) ) ENGINE=Myisam DEFAULT CHARSET=utf8 COLLATE=utf8mb4_unicode_ci;

mysql sql wordpress mariadb

  • This looks like a syntax error, tries to take out the character ` and run again.

  • Mysql Messages error : Documentation #1064 - You have an error in your SQL syntax; check the manual that Corresponds to your Mariadb server version for the right syntax to use near '`; /*! 40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET c' at line 5

  • The contents of the file are not complete in the question, create the database manually, and then run in parts (ignore the top lines starting with @@) Basically accurate of the tables, imports from the first CREATE TABLE

1 answer

-2

There’s an error in your syntax, try running this:

CREATE TABLE wpzm_actionscheduler_actions ( action_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, hook VARCHAR(250))

Browser other questions tagged mysql sql wordpress mariadb

You are not signed in. Login or sign up in order to post.