jensroyakkers
23/05/16, 16:31
Wanneer ik de tabellen uit een database exporteer en deze in een andere wil importeren via phpmyadmin krijg ik de volgende melding:
Statische analyse:
1 fouten werden gevonden tijdens de analyse.
4 waarden werden verwacht, maar 47 gevonden. (near "(" at position 3199)
SQL-query:
INSERT INTO `wp_cb_email_template_admin` (`email_id`, `email_to`, `email_from`, `body_content`, `subject`, `send_to`, `form_id`, `from_name`, `reply_to`, `cc`, `bcc`, `name`) VALUES (4, '[control_7]', 'maxime@thefrontrowblog.com', '<p>Hi,</p><p>Thank you for filling out the contact form. I\\\'ll get back to you as soon as possible.</p><p>Xoxo,</p><p><strong>Maxime</strong></p>', 'Thanks for filling out the contact form', 1, 1, 'The Front Row', '', '', '', 'Thank you'), (3, 'maxime@domein.com', 'auto@domein.com', '<p>Hey Maxime,</p><p>Someone filled out the contact form on domein.</p><p>Here are the details :</p><p>Thanks,</p><p><em>The Front Row</em></p><p><strong>Name</strong> : [control_5]</p><p><strong>Email</strong> : [control_7]</p><p><strong>Message</strong> : [control_8]</p>', 'New Contact recieved from Website', 0, 1, 'Site Administration', '[control_7]', '', '', 'Admin Notification'); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `wp_cb_form_settings_table` -- CREATE TABLE `wp_cb_form_settings_table` ( `id` int(10) UNSIGNED NOT NULL, `form_id` int(10) NOT NULL, `form_message_key` varchar(200) NOT NULL, `form_message_value` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden geëxporteerd voor tabel `wp_cb_form_settings_table` -- INSERT INTO `wp_cb_form_settings_table` (`id`, `form_id`, `form_message_key`, `form_message_value`) VALUES (12, 1, 'form_description', ''), (11, 1, 'incorrect_email_message', 'Please enter a valid e-mail address'), (10, 1, 'blank_field_message', 'Required field must not be blank'), (8, 1, 'redirect_url', ''), (9, 1, 'success_message', ''), (7, 1, 'redirect', '0'); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `wp_cb_frontend_data_table` -- CREATE TABLE `wp_cb_frontend_data_table` ( `id` int(10) UNSIGNED NOT NULL, `form_id` int(10) NOT NULL, `field_Id` int(10) NOT NULL, `dynamic_control_id` int(10) NOT NULL, `dynamic_frontend_value` text NOT NULL, `form_submit_id` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `wp_cb_frontend_forms_table` -- CREATE TABLE `wp_cb_frontend_forms_table` ( `id` int(10) UNSIGNED NOT NULL, `form_id` int(10) NOT NULL, `submit_id` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `wp_cb_layout_settings_table` -- CREATE TABLE `wp_cb_layout_settings_table` ( `id` int(10) UNSIGNED NOT NULL, `form_id` int(10) NOT NULL, `form_settings_key` varchar(200) NOT NULL, `form_settings_value` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden geëxporteerd voor tabel `wp_cb_layout_settings_table` -- INSERT INTO `wp_cb_layout_settings_table` (`id`, `form_id`, `form_settings_key`, `form_settings_value`) VALUES (86, 1, 'submit_button_text_direction', 'inherit'), (85, 1, 'submit_button_rdl_text_align', '0'), (84, 1, 'submit_button_border_radius', '2'), (83, 1, 'submit_button_border_size', '1'), (82, 1, 'submit_button_border_color', '(81, 1, 'submit_button_text_color', '#000000'), (80, 1, 'submit_button_hover_bg_color', '#e5e5e5'), (79, 1, 'submit_button_bg_color', '#B8B8B8'), (78, 1, 'submit_button_button_width', '110'), (77, 1, 'submit_button_font_size', '12'), (76, 1, 'submit_button_font_style', 'normal'), (75, 1, 'submit_button_text', 'Submit '), (74, 1, 'submit_button_font_family', 'inherit'), (73, 1, 'input_field_input_size', 'layout-span10'), (72, 1, 'input_field_text_direction', 'inherit'), (71, 1, 'input_field_rdl_text_align', '0'), (70, 1, 'input_field_rdl_multiple_row', '1'), (69, 1, 'input_field_clr_bg_color', '********'), (68, 1, 'input_field_border_style', 'solid'), (67, 1, 'input_field_border_size', '1'), (66, 1, 'input_field_border_color', '#e5e5e5'), (65, 1, 'input_field_border_radius', '0'), (64, 1, 'input_field_font_size', '14'), (63, 1, 'input_field_font_style', 'normal'), (62, 1, 'input_field_font_color', '#000000'), (61, 1, 'input_field_font_family', 'inherit'), (60, 1, 'label_setting_text_direction', 'inherit'), (59, 1, 'label_setting_hide_label', '0'), (58, 1, 'label_setting_field_align', 'left'), (57, 1, 'label_setting_field_size', '11'), (56, 1, 'label_setting_label_position', 'top'), (55, 1, 'label_setting_font_align_left', '0'), (54, 1, 'label_setting_font_size', '16'), (53, 1, 'label_setting_font_style', 'normal'), (52, 1, 'label_setting_font_color', '#000000'), (51, 1, 'label_setting_font_family', 'inherit'), (87, 1, 'success_msg_font_family', 'inherit'), (88, 1, 'success_msg_font_size', '12'), (89, 1, 'success_msg_bg_color', '#e5ffd5'), (90, 1, 'success_msg_border_color', '#e5ffd5'), (91, 1, 'success_msg_text_color', '#6aa500'), (92, 1, 'success_msg_rdl_text_align', '0'), (93, 1, 'success_msg_text_direction', 'inherit'), (94, 1, 'error_msg_font_family', 'inherit'), (95, 1, 'error_msg_font_size', '12'), (96, 1, 'error_msg_bg_color', '#ffcaca'), (97, 1, 'error_msg_border_color', '#ffcaca'), (98, 1, 'error_msg_text_color', '#ff2c38'), (99, 1, 'error_msg_rdl_text_align', '0'), (100, 1, 'error_msg_text_direction', 'inherit')
MySQL meldt: Documentatie
#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 'CREATE TABLE `wp_cb_form_settings_table` (
`id` int(10) UNSIGNED NOT NULL,
`' at line 11
Weet iemand hoe ik dit kan verhelpen en wat her probleem juist is?
Statische analyse:
1 fouten werden gevonden tijdens de analyse.
4 waarden werden verwacht, maar 47 gevonden. (near "(" at position 3199)
SQL-query:
INSERT INTO `wp_cb_email_template_admin` (`email_id`, `email_to`, `email_from`, `body_content`, `subject`, `send_to`, `form_id`, `from_name`, `reply_to`, `cc`, `bcc`, `name`) VALUES (4, '[control_7]', 'maxime@thefrontrowblog.com', '<p>Hi,</p><p>Thank you for filling out the contact form. I\\\'ll get back to you as soon as possible.</p><p>Xoxo,</p><p><strong>Maxime</strong></p>', 'Thanks for filling out the contact form', 1, 1, 'The Front Row', '', '', '', 'Thank you'), (3, 'maxime@domein.com', 'auto@domein.com', '<p>Hey Maxime,</p><p>Someone filled out the contact form on domein.</p><p>Here are the details :</p><p>Thanks,</p><p><em>The Front Row</em></p><p><strong>Name</strong> : [control_5]</p><p><strong>Email</strong> : [control_7]</p><p><strong>Message</strong> : [control_8]</p>', 'New Contact recieved from Website', 0, 1, 'Site Administration', '[control_7]', '', '', 'Admin Notification'); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `wp_cb_form_settings_table` -- CREATE TABLE `wp_cb_form_settings_table` ( `id` int(10) UNSIGNED NOT NULL, `form_id` int(10) NOT NULL, `form_message_key` varchar(200) NOT NULL, `form_message_value` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden geëxporteerd voor tabel `wp_cb_form_settings_table` -- INSERT INTO `wp_cb_form_settings_table` (`id`, `form_id`, `form_message_key`, `form_message_value`) VALUES (12, 1, 'form_description', ''), (11, 1, 'incorrect_email_message', 'Please enter a valid e-mail address'), (10, 1, 'blank_field_message', 'Required field must not be blank'), (8, 1, 'redirect_url', ''), (9, 1, 'success_message', ''), (7, 1, 'redirect', '0'); -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `wp_cb_frontend_data_table` -- CREATE TABLE `wp_cb_frontend_data_table` ( `id` int(10) UNSIGNED NOT NULL, `form_id` int(10) NOT NULL, `field_Id` int(10) NOT NULL, `dynamic_control_id` int(10) NOT NULL, `dynamic_frontend_value` text NOT NULL, `form_submit_id` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `wp_cb_frontend_forms_table` -- CREATE TABLE `wp_cb_frontend_forms_table` ( `id` int(10) UNSIGNED NOT NULL, `form_id` int(10) NOT NULL, `submit_id` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `wp_cb_layout_settings_table` -- CREATE TABLE `wp_cb_layout_settings_table` ( `id` int(10) UNSIGNED NOT NULL, `form_id` int(10) NOT NULL, `form_settings_key` varchar(200) NOT NULL, `form_settings_value` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden geëxporteerd voor tabel `wp_cb_layout_settings_table` -- INSERT INTO `wp_cb_layout_settings_table` (`id`, `form_id`, `form_settings_key`, `form_settings_value`) VALUES (86, 1, 'submit_button_text_direction', 'inherit'), (85, 1, 'submit_button_rdl_text_align', '0'), (84, 1, 'submit_button_border_radius', '2'), (83, 1, 'submit_button_border_size', '1'), (82, 1, 'submit_button_border_color', '(81, 1, 'submit_button_text_color', '#000000'), (80, 1, 'submit_button_hover_bg_color', '#e5e5e5'), (79, 1, 'submit_button_bg_color', '#B8B8B8'), (78, 1, 'submit_button_button_width', '110'), (77, 1, 'submit_button_font_size', '12'), (76, 1, 'submit_button_font_style', 'normal'), (75, 1, 'submit_button_text', 'Submit '), (74, 1, 'submit_button_font_family', 'inherit'), (73, 1, 'input_field_input_size', 'layout-span10'), (72, 1, 'input_field_text_direction', 'inherit'), (71, 1, 'input_field_rdl_text_align', '0'), (70, 1, 'input_field_rdl_multiple_row', '1'), (69, 1, 'input_field_clr_bg_color', '********'), (68, 1, 'input_field_border_style', 'solid'), (67, 1, 'input_field_border_size', '1'), (66, 1, 'input_field_border_color', '#e5e5e5'), (65, 1, 'input_field_border_radius', '0'), (64, 1, 'input_field_font_size', '14'), (63, 1, 'input_field_font_style', 'normal'), (62, 1, 'input_field_font_color', '#000000'), (61, 1, 'input_field_font_family', 'inherit'), (60, 1, 'label_setting_text_direction', 'inherit'), (59, 1, 'label_setting_hide_label', '0'), (58, 1, 'label_setting_field_align', 'left'), (57, 1, 'label_setting_field_size', '11'), (56, 1, 'label_setting_label_position', 'top'), (55, 1, 'label_setting_font_align_left', '0'), (54, 1, 'label_setting_font_size', '16'), (53, 1, 'label_setting_font_style', 'normal'), (52, 1, 'label_setting_font_color', '#000000'), (51, 1, 'label_setting_font_family', 'inherit'), (87, 1, 'success_msg_font_family', 'inherit'), (88, 1, 'success_msg_font_size', '12'), (89, 1, 'success_msg_bg_color', '#e5ffd5'), (90, 1, 'success_msg_border_color', '#e5ffd5'), (91, 1, 'success_msg_text_color', '#6aa500'), (92, 1, 'success_msg_rdl_text_align', '0'), (93, 1, 'success_msg_text_direction', 'inherit'), (94, 1, 'error_msg_font_family', 'inherit'), (95, 1, 'error_msg_font_size', '12'), (96, 1, 'error_msg_bg_color', '#ffcaca'), (97, 1, 'error_msg_border_color', '#ffcaca'), (98, 1, 'error_msg_text_color', '#ff2c38'), (99, 1, 'error_msg_rdl_text_align', '0'), (100, 1, 'error_msg_text_direction', 'inherit')
MySQL meldt: Documentatie
#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 'CREATE TABLE `wp_cb_form_settings_table` (
`id` int(10) UNSIGNED NOT NULL,
`' at line 11
Weet iemand hoe ik dit kan verhelpen en wat her probleem juist is?