Error 001: _mlw_quizzes doesn’t exist

Hello,
i found more information about this error. I get the following error when i activate (install) the plugin and this error causes the error i reported at first.

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 'system INT NOT NULL,\n  \t\t\trandomness_order INT NOT NULL,\n  \t\t\tloggedin_user_cont' at line 19 f\xc3\xbcr Abfrage CREATE TABLE gowp_mlw_quizzes (\n  \t\t\tquiz_id mediumint(9) NOT NULL AUTO_INCREMENT,\n  \t\t\tquiz_name TEXT NOT NULL,\n  \t\t\tmessage_before TEXT NOT NULL,\n  \t\t\tmessage_after TEXT NOT NULL,\n  \t\t\tmessage_comment TEXT NOT NULL,\n  \t\t\tmessage_end_template TEXT NOT NULL,\n  \t\t\tuser_email_template TEXT NOT NULL,\n  \t\t\tadmin_email_template TEXT NOT NULL,\n  \t\t\tsubmit_button_text TEXT NOT NULL,\n  \t\t\tname_field_text TEXT NOT NULL,\n  \t\t\tbusiness_field_text TEXT NOT NULL,\n  \t\t\temail_field_text TEXT NOT NULL,\n  \t\t\tphone_field_text TEXT NOT NULL,\n  \t\t\tcomment_field_text TEXT NOT NULL,\n  \t\t\temail_from_text TEXT NOT NULL,\n  \t\t\tquestion_answer_template TEXT NOT NULL,\n  \t\t\tleaderboard_template TEXT NOT NULL,\n  \t\t\tsystem INT NOT NULL,\n  \t\t\trandomness_order INT NOT NULL,\n  \t\t\tloggedin_user_contact INT NOT NULL,\n  \t\t\tshow_score INT NOT NULL,\n  \t\t\tsend_user_email INT NOT NULL,\n  \t\t\tsend_admin_email INT NOT NULL,\n  \t\t\tcontact_info_location INT NOT NULL,\n  \t\t\tuser_name INT NOT NULL,\n  \t\t\tuser_comp INT NOT NULL,\n  \t\t\tuser_email INT NOT NULL,\n  \t\t\tuser_phone INT NOT NULL,\n  \t\t\tadmin_email TEXT NOT NULL,\n  \t\t\tcomment_section INT NOT NULL,\n  \t\t\tquestion_from_total INT NOT NULL,\n  \t\t\ttotal_user_tries INT NOT NULL,\n  \t\t\ttotal_user_tries_text TEXT NOT NULL,\n  \t\t\tcertificate_template TEXT NOT NULL,\n  \t\t\tsocial_media INT NOT NULL,\n  \t\t\tsocial_media_text TEXT NOT NULL,\n  \t\t\tpagination INT NOT NULL,\n  \t\t\tpagination_text TEXT NOT NULL,\n  \t\t\ttimer_limit INT NOT NULL,\n  \t\t\tquiz_stye TEXT NOT NULL,\n  \t\t\tquestion_numbering INT NOT NULL,\n  \t\t\tquiz_settings TEXT NOT NULL,\n  \t\t\ttheme_selected TEXT NOT NULL,\n  \t\t\tlast_activity DATETIME NOT NULL,\n  \t\t\trequire_log_in INT NOT NULL,\n  \t\t\trequire_log_in_text TEXT NOT NULL,\n  \t\t\tlimit_total_entries INT NOT NULL,\n  \t\t\tlimit_total_entries_text TEXT NOT NULL,\n  \t\t\tscheduled_timeframe TEXT NOT NULL,\n  \t\t\tscheduled_timeframe_text TEXT NOT NULL,\n  \t\t\tdisable_answer_onselect INT NOT NULL,\n  \t\t\tajax_show_correct INT NOT NULL,\n  \t\t\tquiz_views INT NOT NULL,\n  \t\t\tquiz_taken INT NOT NULL,\n  \t\t\tdeleted INT NOT NULL,\n                        quiz_author_id INT NOT NULL,\n  \t\t\tPRIMARY KEY  (quiz_id)\n  \t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci von activate_plugin, do_action('activate_quiz-master-next/mlw_quizmaster2.php'), WP_Hook->do_action, WP_Hook->apply_filters, QSM_Install::install, dbDelta

My mySQL version is in my message before. Can i make any mySQL settings to solve the problem? Have i false charater sets in mysql or something? Or could there be a name length restriction or anything else? Or perhaps because the website is in german?

Thank you and best regards

• This reply was modified 6 years ago by Yui. Reason: please use CODE button for proper formatting