MySQL Fehler

    Hallo, habe folgendes Problem:

    Ich habe 2.1.1.3 neu installiert, dann meine alte Datenbank wieder eingespielt, dann versuche ich per PHPMyAdmin

    FP1_sql einzuspielen bekomme aber dabei folgende Fehlermeldung:


    SQL-Befehl:

    ##############################################################################
    Final Beta2##############################################################################
    INSERT INTO configuration
    VALUES (
    NULL , 'PRODUCT_IMAGE_MINI_WIDTH', '75', 4, 9, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_HEIGHT', '75', 4, 10, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_BEVEL', '', 4, 21, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_GREYSCALE', '', 4, 22, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_ELLIPSE', '', 4, 23, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_ROUND_EDGES', '', 4, 24, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_MERGE', '', 4, 25, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_FRAME', '', 4, 26, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_DROP_SHADDOW', '', 4, 27, NULL , NOW( ) , NULL , NULL
    ), (
    NULL , 'PRODUCT_IMAGE_MINI_MOTION_BLUR', '', 4, 28, NULL , NOW( ) , NULL , NULL
    );

    MySQL meldet: Dokumentation
    #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 'Final Beta 2
    ##################################################################' at line 2
    [ Zu

    Kann mir jemand einen Tip geben was ich falsch mache.

    Im voraus danke!

    Juergen

    HAllo Juergen,

    Hatte ich auch habe dan die Zeile / Stucken einzel genommen , dan war die fehler nicht da also wahrscheinlich ist einer Kommentaar nicht 100% in den sql sauber, den Reine SQL scheint zu gehen weis nur noch nicht 100% ob wirklich alles drin ist, wegen Sprachen fehlt bei mir in Testshop noch einges, muss ich manuel extra machen.

    hoi,

    entferne bitte mal die kommentare aus dem script (alles mit #), dann sollte es klappen.


    greetz, me

    Hallo Nico, hallo jotest,

    habe zuerst mal nur ### gelöscht, leider ohne Erfolg, dann noch Final, 2 und Final 3 und es klappt.

    Danke für die Hilfe.

    Juergen

    Hier die geänderte FP1_sql:

    INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
    VALUES('', 'PRODUCT_INFO_GALLERY', 'dark_rounded', 1002, 25, NULL, '2011-03-24 18:23:17', NULL, NULL);
    INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
    VALUES('', 'PRODUCT_INFO_GALLERY_SLIDE', 'false', 1002, 26, NULL, '2011-03-24 18:23:17', NULL, 'xtc_cfg_select_option(array(''true'', ''false''), ');

    ALTER TABLE categories_description ADD categories_description_footer TEXT NOT NULL AFTER categories_description;

    INSERT INTO emails (id, email_name, languages_id, email_address, email_address_name, email_replay_address, email_replay_address_name, email_subject, email_forward, email_content_html, email_content_text, email_backup_html, email_backup_text, email_timestamp)
    VALUES
    (NULL, 'askaquestion', 1, 'mail@ihr-shop.de', 'commerce:SEO', '', '', 'Frage zum Produkt', '', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de" lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />\r\n<title>Kontoeröffnung</title>\r\n{literal}\r\n<style type="text/css">\r\nbody, table {font-size:11.5px; font-family:Helvetica, sans-serif;color:#444}\r\ntable.outerTable {border: 1px solid #ccc}\r\ntd.TopRightDesc {letter-spacing: 1px; font-weight: 600}\r\n.lightBackground td {color:#6d88b1;background: #f1f1f1}\r\n.bt {border-top:1px solid #ccc}\r\n.bb {border-bottom:1px solid #ccc}\r\n.bl {border-left:1px solid #ccc}\r\n.br {border-right:1px solid #ccc}\r\n.fs85 {font-size:85%}\r\n</style>\r\n{/literal}\r\n</head>\r\n<body>\r\n<table width="90%" border="0" cellpadding="10" cellspacing="0" align="center" class="outerTable">\r\n <tr>\r\n <td>\r\n <table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n <tr>\r\n <td width="50%">\r\n <img src="{$logo_path}logo.gif" alt="" />\r\n </td>\r\n <td width="50%" class="TopRightDesc" align="right">\r\n Frage zum Produkt\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td><br />\r\n <table width="100%" border="0" cellpadding="10" cellspacing="5" align="center" class="outerTable ">\r\n <tr class="lightBackground">\r\n <td width="1"><nobr>Produktname:</nobr></td>\r\n <td> {$PRODUCT_NAME}</td>\r\n </tr>\r\n <tr class="lightBackground">\r\n <td width="1"><nobr> von:</nobr></td>\r\n <td> {$FROM_EMAIL_ADDRESS}</td>\r\n </tr>\r\n <tr class="lightBackground">\r\n <td> Name:</td>\r\n <td> {$TEXT_NAME}</td>\r\n </tr>\r\n <tr class="lightBackground">\r\n <td>Produkt:</td>\r\n <td><a href="{$PRODUCT_LINK}">{$PRODUCT_LINK}</a></td>\r\n </tr>\r\n <tr class="lightBackground">\r\n <td> Nachricht:</td>\r\n <td> {$MESSAGE}</td>\r\n </tr>\r\n </table>\r\n <br /><br />\r\n </td>\r\n </tr>\r\n</table>', 'Frage zu Artikel:\r\n\r\n{$PRODUCT_NAME}\r\n\r\nvon: {$FROM_EMAIL_ADDRESS}\r\nName: {$TEXT_NAME}\r\nProdukt: {$PRODUCT_LINK}\r\n\r\nNachricht:\r\n{$MESSAGE}\r\n', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de" lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />\r\n<title>Kontoeröffnung</title>\r\n{literal}\r\n<style type="text/css">\r\nbody, table {font-size:11.5px; font-family:Helvetica, sans-serif;color:#444}\r\ntable.outerTable {border: 1px solid #ccc}\r\ntd.TopRightDesc {letter-spacing: 1px; font-weight: 600}\r\n.lightBackground td {color:#6d88b1;background: #f1f1f1}\r\n.bt {border-top:1px solid #ccc}\r\n.bb {border-bottom:1px solid #ccc}\r\n.bl {border-left:1px solid #ccc}\r\n.br {border-right:1px solid #ccc}\r\n.fs85 {font-size:85%}\r\n</style>\r\n{/literal}\r\n</head>\r\n<body>\r\n<table width="90%" border="0" cellpadding="10" cellspacing="0" align="center" class="outerTable">\r\n <tr>\r\n <td>\r\n <table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n <tr>\r\n <td width="50%">\r\n <img src="{$logo_path}logo.gif" alt="" />\r\n </td>\r\n <td width="50%" class="TopRightDesc" align="right">\r\n Frage zum Produkt\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td><br />\r\n <table width="100%" border="0" cellpadding="10" cellspacing="5" align="center" class="outerTable ">\r\n <tr class="lightBackground">\r\n <td width="1"><nobr>Produktname:</nobr></td>\r\n <td> {$PRODUCT_NAME}</td>\r\n </tr>\r\n <tr class="lightBackground">\r\n <td width="1"><nobr> von:</nobr></td>\r\n <td> {$FROM_EMAIL_ADDRESS}</td>\r\n </tr>\r\n <tr class="lightBackground">\r\n <td> Name:</td>\r\n <td> {$TEXT_NAME}</td>\r\n </tr>\r\n <tr class="lightBackground">\r\n <td>Produkt:</td>\r\n <td><a href="{$PRODUCT_LINK}">{$PRODUCT_LINK}</a></td>\r\n </tr>\r\n <tr class="lightBackground">\r\n <td> Nachricht:</td>\r\n <td> {$MESSAGE}</td>\r\n </tr>\r\n </table>\r\n <br /><br />\r\n </td>\r\n </tr>\r\n</table>', 'Frage zu Artikel:\r\n\r\n{$PRODUCT_NAME}\r\n\r\nvon: {$FROM_EMAIL_ADDRESS}\r\nName: {$TEXT_NAME}\r\nProdukt: {$PRODUCT_LINK}\r\n\r\nNachricht:\r\n{$MESSAGE}\r\n', 12345612);

    ALTER TABLE products_description ADD products_google_taxonomie TEXT NULL , ADD products_taxonomie TEXT NULL;

    INSERT INTO configuration VALUES
    (NULL, 'PRODUCT_IMAGE_MINI_WIDTH', '75', 4, 9, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_HEIGHT', '75', 4, 10, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_BEVEL', '', 4, 21, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_GREYSCALE', '', 4, 22, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_ELLIPSE', '', 4, 23, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_ROUND_EDGES', '', 4, 24, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_MERGE', '', 4, 25, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_FRAME', '', 4, 26, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_DROP_SHADDOW', '', 4, 27, NULL, NOW(), NULL, NULL),
    (NULL, 'PRODUCT_IMAGE_MINI_MOTION_BLUR', '', 4, 28, NULL, NOW(), NULL, NULL);

    INSERT INTO configuration VALUES (NULL, 'PRODUCT_GOOGLE_STANDARD_TAXONOMIE', '', 1002, 27, NULL, NOW(), NULL, NULL);

    INSERT INTO configuration VALUES (NULL, 'PRODUCT_DETAILS_TAB_MANUFACTURERS', 'false', 1002, 22, NULL, NOW(), NULL, "xtc_cfg_select_option(array('true', 'false'), ");

    hey @ll,

    das die texte in den kommentaren (also die kommentare selbst...) mit entfernt werden sollten, dachte ich ist klar. aber ich habe mich wohl etwas unglücklich ausgedrückt->sorry.

    das problem mit den kommentaren ist eigentlich nur das (web)tool welches zum einspielen genutzt wird. denn zb. mysqldumper oder phpmyadmin, nutzen unterschiedliche kommentarzeichen, sodass es hier zu fehlern beim einspielen kommen kann...leider.
    für alle die es wissen möchten, das std-mysql kommentarzeichen ist die raute: #

    greetz, me


    ps: thema gelöst?