Likes Likes:  0
Resultaten 1 tot 2 van de 2
  1. #1
    Foutmelding bij het importeren van tabellen in phpmyadmin
    geregistreerd gebruiker
    5 Berichten
    Ingeschreven
    23/05/16

    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    0 Berichten zijn liked


    Naam: Jens

    Question Foutmelding bij het importeren van tabellen in phpmyadmin

    Wanneer ik de tabellen uit een database exporteer en deze in een andere wil importeren via phpmyadmin krijg ik de volgende melding:
    Code:
    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?

  2. #2
    Foutmelding bij het importeren van tabellen in phpmyadmin
    Hostingaddict
    210 Berichten
    Ingeschreven
    25/01/11

    Locatie
    Haarlem

    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)
    0 Berichten zijn liked


    Naam: Stefan Triep
    Bedrijf: Hostingindustries
    Functie: Eigenaar
    URL: www.hostingindustries.nl
    Registrar SIDN: JA
    ISPConnect: Lid
    KvK nummer: 34351782
    View stefantriep's profile on LinkedIn

    Waarschijnlijk zit je op PhpMyAdmin versie 3.5, daar zit die bug in en die is verholpen in 3.6 even updaten dus!
    Hostingindustries - http://www.hostingindustries.nl



Labels voor dit Bericht

Webhostingtalk.nl

Contact

  • Rokin 113-115
  • 1012 KP, Amsterdam
  • Nederland
  • Contact
© Copyright 2001-2017 Webhostingtalk.nl.
Web Statistics