Ankündigung

Einklappen
Keine Ankündigung bisher.

Simple Google Analytics 1.2.3 - Fehler beim SQL patch

Einklappen
X
 
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

    Simple Google Analytics 1.2.3 - Fehler beim SQL patch

    Hallo zusammen

    Ich wollte bei meiner ZC 1.3.8a installation das "Simple Google Analytics 1.2.3" Modul installieren. Ich habe das ganze als Neuinstallation durchgeführt in im nachhinein bemerkt, dass ich die version 1.2.2 bereits am laufen hatte.

    Anyway,habe alles wie beschrieben gemacht und wollte das SQL Patch laufen lassen jedoch kam folgender Fehler:
    Code:
    1136 Column count doesn't match value count at row 1
    in:
    [INSERT INTO configuration_group VALUES ('', 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
    
    
    Das SQL Patch hatte folgenden Inhalt:
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4 
    FROM configuration_group
    WHERE configuration_group_title= 'Google Analytics Configuration';
    DELETE FROM configuration WHERE configuration_group_id = @t4 AND configuration_group_id != 0;
    DELETE FROM configuration_group WHERE configuration_group_id = @t4 AND configuration_group_id != 0;
    
    INSERT INTO configuration_group VALUES ('', 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');
    UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
    
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4 
    FROM configuration_group
    WHERE configuration_group_title= 'Google Analytics Configuration';
    
    #INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Use Older "urchin.js" Tracking Code', 'GOOGLE_URCHINTRACKING_ACTIVE', 'No', 'This enables you to select which type of tracking code to use (either the older "urchin.js" version or the newer "ga.js" version. By default the system now uses the newer "ga.js" code.<br><br><span style="color:#ff0000;font-weight:bold;">Important Note:</span> There are hundreds of reports across the Internet of ecommerce tracking not being exactly correct when using the new "ga.js" tracking code Google released.<br><br>It <strong>has been confirmed</strong> by Google that the problem is on their end. They are working on the issue and a fix is supposed to be out for the new "ga.js" code near the first week in April 2008.<br><br>Until then, if you want to get more accurate ecommerce tracking results, use the older "urchin.js" tracking code. To revert back tothe older urchin.js code, set this opotion to "Yes" temporarily (meaning you will actually be using the older "urchin.js" tracking code). When Google issues the fix you can then easily switch back to the new "ga.js" tracking code by setting this option to "No".<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>Do you want to use the older "urchin.js" tracking code?</b><br>', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), ');
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'This number is the unique id you were given by Google when you registered for your Google Analytics account.<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>Enter your Google Analytics account number (starting with the "UA-") in the space provided below.</b><br>', @t4, 1, NOW(), NOW(), NULL, NULL);
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'This element is used in conjunction with Google E-Commerce Tracking. It indicates how you want your "transactions" to be identified in your Analytics reports.<br><br>Addresses consist of City,State, and Country.<br><br>This information can help you determine locality of orders placed, shipped to, or billed to.<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>Which address type do you want to use for recording transaction information?</b><br>', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''customers'', ''delivery'', ''billing''),');
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'This <b>optional</b> tracking element is used in conjunction with Google E-Commerce Tracking.<br><br>The Affiliation tag describes the affiliating store or processing site.<br><br>It can be used if you have multiple stores (or web sites) in various locations and is used to track from which location a particular sale originated.<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>If you have one, enter your optional partner or store affiliation in the space provided below.</b><br>', @t4, 3, NOW(), NOW(), NULL, NULL);
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'This tracking element is used in conjunction with Google Analytics E-Commerce tracking.<br><br>It enables you to track which products perform better than others using either the Product ID, or the Product Model Number as a unique identifier.<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>Indicate which identifier you want to use to track product performance by selecting one of the options below.</b>', @t4, 4, now(), now(), NULL, 'zen_cfg_select_option(array(''products_id'', ''products_model''),');
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate Adwords Conversion Tracking', 'GOOGLE_CONVERSION_ACTIVE', 'No', 'This element enables you turn on or off Google Conversion Tracking.<br><br><span style="color:#ff0000;font-weight:bold;">Please Note:</span> Conversion tracking is used to track the effectiveness of Google AdWords paid search campaigns. If you are <b>not</b> running any paid search campaigns, then you should leave this set to "No".<br><br>If you are running Google AdWords (paid search) campaigns, then turning this on will place the proper conversion tracking code on your checkout success page and enable you to start tracking conversions.<br><br>Turning this on <b>requires you</b> to enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" number shown in the next section.<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>Do you want to turn on Google AdWords Conversion Tracking?</b><br>', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), ');
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Google AdWords Conversion Tracking Number', 'GOOGLE_CONVERSION_IDNUM', 'XXXXXXXXXX', 'If you activated Conversion Tracking in the previous section, then you <b>must</b> enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" shown in the space provided below.<br><br>If you have activated Conversion Tracking, and do not enter your number below, tracking will not work.<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>Enter your AdWords Conversion Tracking ID Number below.</b>', @t4, 6, NOW(), NOW(), NULL, NULL);
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Google AdWords Language', 'GOOGLE_CONVERSION_LANG', 'en_US', 'Select the language to be used. The default is "English US".<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>Select your language below</b><br>', @t4, 7, NOW(), NOW(), NULL, 'zen_cfg_pull_down_google_languages(');
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Google Tracking Code Type To Use', 'GOOGLE_ANALYTICS_TRACKING_TYPE', 'ga.js', 'Select the type of tracking you wish to use. The default is the "ga.js" style. You have the ability to change this to either the older Urchin code or the newest Asycronous tracking code. Visit the <a href="http://code.google.com/apis/analytics/docs/tracking/home.html" target="_blank">Google Analytics Website</a> for more information on each.<br><br>For more hints and tips on how to use Google Analytics to increase sales from your store, visit <b><a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a></b><br><br><b>Select your tracking preference below</b><br>', @t4, 8, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''ga.js'', ''Urchin'', ''Asynchronous''), ');
    # INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Add Custom Tracking Before Main Analytics Code?', 'GOOGLE_ANALYTICS_CUSTOM_BEFORE', 'Disable', 'Do you want to include any custom tracking before the main tracking segment?', @t4, 9, now(), now(), NULL, 'zen_cfg_select_option(array(''Enable'', ''Disable''),'), (NULL, 'Google Custom Code - Before', 'GOOGLE_ANALYTICS_BEFORE_CODE', 'Please copy and paste or add your custom tracking here.', 'Insert custom tracking code', @t4, 10, now(), now(), NULL, 'zen_cfg_textarea(');
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Add Custom Tracking After Main Analytics Code?', 'GOOGLE_ANALYTICS_CUSTOM_AFTER', 'Disable', 'Do you want to include any custom tracking after the main tracking segment? This can be used to customize the tracking code to your individual needs. Adding tracking objects according to the details on the <a href="http://code.google.com/apis/analytics/docs/tracking/gaTrackingCustomVariables.html" target="_blank">Google Analytics site<a/>. ', @t4, 11, now(), now(), NULL, 'zen_cfg_select_option(array(''Enable'', ''Disable''),'), (NULL, 'Google Custom Code - After', 'GOOGLE_ANALYTICS_AFTER_CODE', 'Please copy and paste or add your custom tracking here.', 'Insert custom tracking code', @t4, 12, now(), now(), NULL, 'zen_cfg_textarea(');
    
    
    #################################################################
    # Add Table for Language support with Google Conversion Tracking.
    #################################################################
    #
    # Table structure for table 'google_analytics_languages'
    #
    
    DROP TABLE IF EXISTS google_analytics_languages;
    CREATE TABLE google_analytics_languages (
      languages_id int(11) NOT NULL auto_increment,
      name varchar(50) NOT NULL default '',
      code char(10) NOT NULL default '',
      sort_order int(3) default NULL,
      PRIMARY KEY  (languages_id),
      KEY idx_languages_name_zen (name)
    ) TYPE=MyISAM;
    
    # --------------------------------------------------------
    
    #
    # Add data to new google language table 
    #
    
    INSERT INTO google_analytics_languages VALUES ('','Chinese (simplified) - ???','zh_CN',1);
    INSERT INTO google_analytics_languages VALUES ('','Chinese (traditional) - ???','zh_TW',2);
    INSERT INTO google_analytics_languages VALUES ('','Danish - Dansk','da',3);
    INSERT INTO google_analytics_languages VALUES ('','Dutch - Nederlands','nl',4);
    INSERT INTO google_analytics_languages VALUES ('','English (Australia)','en_AU',5);
    INSERT INTO google_analytics_languages VALUES ('','English (UK))','en_GB',6);
    INSERT INTO google_analytics_languages VALUES ('','English (US)','en_US',7);
    INSERT INTO google_analytics_languages VALUES ('','Finnish - suomi','fi',8);
    INSERT INTO google_analytics_languages VALUES ('','French - Français','fr',9);
    INSERT INTO google_analytics_languages VALUES ('','German - Deutsch','de',10);
    INSERT INTO google_analytics_languages VALUES ('','Hebrew - ???','iw',11);
    INSERT INTO google_analytics_languages VALUES ('','Italian - Italiano','it',12);
    INSERT INTO google_analytics_languages VALUES ('','Japanese - ???','ja',13);
    INSERT INTO google_analytics_languages VALUES ('','Korean - ???','ko',14);
    INSERT INTO google_analytics_languages VALUES ('','Norwegian - Norsk','no',15);
    INSERT INTO google_analytics_languages VALUES ('','Polish - polski','pl',16);
    INSERT INTO google_analytics_languages VALUES ('','Portuguese (Brazil) - Português (Brasil)','pt_BR',17);
    INSERT INTO google_analytics_languages VALUES ('','Portuguese (Portugal) - Português (Portugal)','pt_PT',18);
    INSERT INTO google_analytics_languages VALUES ('','Russian - ???????','ru',19);
    INSERT INTO google_analytics_languages VALUES ('','Spanish - Español','es',20);
    INSERT INTO google_analytics_languages VALUES ('','Swedish - Svenska','sv',21);
    INSERT INTO google_analytics_languages VALUES ('','Turkish - Türkçe','tr',22);
    
    
    # --------------------------------------------------------
    Weiss jemand wo der Fehler ist?

    Danke und Gruss
    Zuletzt geändert von webchills; 10.11.2010, 09:37.

    #2
    Bitte einfach die extra für die deutsche Version angepasste Version dieses Moduls verwenden:
    Google Analytics 1.3

    Kommentar


      #3
      Hi

      Habe alles wie beschrieben gemacht jedoch gab es (wohl weil bereits eine ältere version installiert war) folgende statements gegeben:

      42 statements processed. ERROR: Kann configuration_key "" nicht einfügen, da er bereits vorhanden ist. ERROR: Kann configuration_key "" nicht einfügen, da er bereits vorhanden ist. ERROR: Kann configuration_key "" nicht einfügen, da er bereits vorhanden ist. ERROR: Kann configuration_key "" nicht einfügen, da er bereits vorhanden ist. Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

      Zudem können unter Konfiguration > Google Analytics Einstellungen keine Einstellungen gemacht werden, Seite ist leer.

      Gruss
      Dominic

      Kommentar


        #4
        Im Ordner SQL des Downloads befindet sich eine uninstall.sql
        Mit einem Texteditor öffnen, Inhalt ins Eingabefeld unter Admin > Tools > SQL Patches installieren einfügen und absenden.
        Danach erneut den Inhalt der install.sql einspielen.

        Kommentar


          #5
          Uninstall hat funktioniert:

          6 statements processed.

          Beim Installieren das selbe Problem:
          42 statements processed. ERROR: Kann configuration_key "" nicht einfügen, da er bereits vorhanden ist. ERROR: Kann configuration_key "" nicht einfügen, da er bereits vorhanden ist. ERROR: Kann configuration_key "" nicht einfügen, da er bereits vorhanden ist. ERROR: Kann configuration_key "" nicht einfügen, da er bereits vorhanden ist. Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

          Folgende Meldungen erscheinen:
          Code:
          SQL Query Executor         [IMG]http://www.fettsack.ch/admin/images/pixel_trans.gif[/IMG]              Stellen Sie sicher, dass Sie VOR DEM AUSFÜHREN DIESES SCRIPTS eine VOLLSTÄNDIGE SICHERUNG IHRER DATENBANK erstellt haben!                   [B]Wenn Sie 3rd-Party Kontributionen installieren, bedenken Sie bitte, dass Sie dies auf eigenen Gefahr machen.
          Zen Cart™ gibt keine Garantie für die Sicherheit oder Funktion von 3rd-Party Kontributionen. Testen Sie die Kontributionen, bevor Sie diese auf eimen Live-System einsetzen![/B]                                           [B]Abfrageergebnisse:[/B]                          SET @gid=0;
          SELECT @gid:=configuration_group_id FROM configuration_group WHERE configuration_group_title LIKE '%Google Analytics Configuration%' LIMIT 1;
          DELETE FROM configuration WHERE configuration_group_id = @gid;
          DELETE FROM configuration_group WHERE configuration_group_id = @gid;
          SET @gid=0;
          SELECT @gid:=configuration_group_id FROM configuration_group WHERE configuration_group_title LIKE '%Google Analytics Einstellungen%' LIMIT 1;
          DELETE FROM configuration WHERE configuration_group_id = @gid;
          DELETE FROM configuration_group WHERE configuration_group_id = @gid;
          DELETE FROM configuration_group WHERE configuration_group_title LIKE '%Google Analytics Configuration%';
          DELETE FROM configuration_group WHERE configuration_group_title LIKE '%Google Analytics Einstellungen%';
          DELETE FROM configuration WHERE configuration_description LIKE 'Google Analytics%' LIMIT 12;
          DELETE FROM configuration WHERE configuration_title LIKE 'GA - %' LIMIT 12;
          INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Analytics Configuration', 'Google Analytics Configuration Settings', '1', '1');
          SET @gid=last_insert_id();
          UPDATE configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
          INSERT INTO configuration VALUES (NULL, 'GA - Use Older "urchin.js" Tracking Code', 'GOOGLE_ANALYTICS_URCHINTRACKING_ACTIVE', 'No', 'Google Analytics:
          
          [B]Note:
          It is NOT recommended to use the old tracking code![/B]
          
          This enables you to select which type of tracking code to use (either the older "urchin.js" version or the newer "ga.js" version. By default the system now uses the newer "ga.js" code.
          
          [COLOR=#ff0000][B]Important Note:[/B][/COLOR] There were hundreds of reports across the Internet of ecommerce tracking not being exactly correct when using the new "ga.js" tracking code Google released.
          
          It [B]has been confirmed[/B] by Google that the problem is on their end. They were working on the issue and a fix has been out for the new "ga.js" code near the first week in April 2008.
          
          So there is no need to use the older "urchin.js" tracking code anymore. Anyway: To revert back to the older urchin.js code, set this opotion to "Yes" temporarily (meaning you will actually be using the older "urchin.js" tracking code).
          
          For more hints and tips on how to use Google Analytics to increase sales from your store, visit [B][URL="http://www.zencartoptimization.com/"]ZenCartOptimization.com[/URL][/B]
          
          [B]Do you want to use the older "urchin.js" tracking code?[/B]
          ', @gid, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), '), (NULL, 'GA - Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'Google Analytics:
          
          This number is the unique id you were given by Google when you registered for your Google Analytics account.
          
          For more hints and tips on how to use Google Analytics to increase sales from your store, visit [B][URL="http://www.zencartoptimization.com/"]ZenCartOptimization.com[/URL][/B]
          
          [B]Enter your Google Analytics account number (starting with the "UA-") in the space provided below.[/B]
          ', @gid, 2, NOW(), NOW(), NULL, NULL), (NULL, 'GA - Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'Google Analytics:
          
          This element is used in conjunction with Google E-Commerce Tracking. It indicates how you want your "transactions" to be identified in your Analytics reports.
          
          Addresses consist of City,State, and Country.
          
          This information can help you determine locality of orders placed, shipped to, or billed to.
          
          For more hints and tips on how to use Google Analytics to increase sales from your store, visit [B][URL="http://www.zencartoptimization.com/"]ZenCartOptimization.com[/URL][/B]
          
          [B]Which address type do you want to use for recording transaction information?[/B]
          ', @gid, 3, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''customers'', ''delivery'', ''billing''),'), (NULL, 'GA - Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Google Analytics:
          
          This [B]optional[/B] tracking element is used in conjunction with Google E-Commerce Tracking.
          
          The Affiliation tag describes the affiliating store or processing site.
          
          It can be used if you have multiple stores (or web sites) in various locations and is used to track from which location a particular sale originated.
          
          For more hints and tips on how to use Google Analytics to increase sales from your store, visit [B][URL="http://www.zencartoptimization.com/"]ZenCartOptimization.com[/URL][/B]
          
          [B]If you have one, enter your optional partner or store affiliation in the space provided below.[/B]
          ', @gid, 4, NOW(), NOW(), NULL, NULL), (NULL, 'GA - Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'Google Analytics:
          
          This tracking element is used in conjunction with Google Analytics E-Commerce tracking.
          
          It enables you to track which products perform better than others using either the Product ID, or the Product Model Number as a unique identifier.
          
          For more hints and tips on how to use Google Analytics to increase sales from your store, visit [B][URL="http://www.zencartoptimization.com/"]ZenCartOptimization.com[/URL][/B]
          
          [B]Indicate which identifier you want to use to track product performance by selecting one of the options below.[/B]', @gid, 5, now(), now(), NULL, 'zen_cfg_select_option(array(''products_id'', ''products_model''),'), (NULL, 'GA - Activate Conversion Tracking', 'GOOGLE_ANALYTICS_CONVERSION_ACTIVE', 'No', 'Google Analytics:
          
          This element enables you turn on or off Google Conversion Tracking.
          
          [COLOR=#ff0000][B]Please Note:[/B][/COLOR] Conversion tracking is used to track the effectiveness of Google AdWords paid search campaigns. If you are [B]not[/B] running any paid search campaigns, then you should leave this set to "No".
          
          If you are running Google AdWords (paid search) campaigns, then turning this on will place the proper conversion tracking code on your checkout success page and enable you to start tracking conversions.
          
          Turning this on [B]requires you[/B] to enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" number shown in the next section.
          
          For more hints and tips on how to use Google Analytics to increase sales from your store, visit [B][URL="http://www.zencartoptimization.com/"]ZenCartOptimization.com[/URL][/B]
          
          [B]Do you want to turn on Google AdWords Conversion Tracking?[/B]
          ', @gid, 6, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), '), (NULL, 'GA - Google AdWords Conversion Tracking Number', 'GOOGLE_ANALYTICS_CONVERSION_IDNUM', 'XXXXXXXXXX', 'Google Analytics:
          
          If you activated Conversion Tracking in the previous section, then you [B]must[/B] enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" shown in the space provided below.
          
          If you have activated Conversion Tracking, and do not enter your number below, tracking will not work.
          
          For more hints and tips on how to use Google Analytics to increase sales from your store, visit [B][URL="http://www.zencartoptimization.com/"]ZenCartOptimization.com[/URL][/B]
          
          [B]Enter your AdWords Conversion Tracking ID Number below.[/B]', @gid, 7, NOW(), NOW(), NULL, NULL), (NULL, 'GA - Google AdWords Language', 'GOOGLE_ANALYTICS_CONVERSION_LANG', 'de', 'Google Analytics:
          
          Select the language to be used. The default is "German".
          
          For more hints and tips on how to use Google Analytics to increase sales from your store, visit [B][URL="http://www.zencartoptimization.com/"]ZenCartOptimization.com[/URL][/B]
          
          [B]Select your language below[/B]
          ', @gid, 8, NOW(), NOW(), NULL, 'zen_cfg_pull_down_google_analytics_languages(');
          INSERT INTO configuration_group (configuration_group_id, language_id, configuration_group_title, configuration_group_description, sort_order, visible ) VALUES (@gid, 43, 'Google Analytics Einstellungen', 'Konfiguration von Google Analytics', '1', '1');
          REPLACE INTO configuration_language (configuration_title, configuration_key, configuration_description, configuration_language_id) VALUES ('GA - Alten urchin.js Tracking Code verwenden?', 'GOOGLE_ANALYTICS_URCHINTRACKING_ACTIVE', 'Google Analytics:
          
          [B]Nicht empfohlen![/B]
          Voreingestellt ist die neue Variante des Google Analytics Codes (ga.js). Wenn möglich unbedingt diese neuere Variante verwenden.
          
          [B]Soll der alte Code verwendet werden?:[/B]', 43), ('GA - Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'Google Analytics:
          
          Die ID, die Sie von Google bei der Anmeldung zu Google Analytics bekommen haben.
          Format:
          UA-XXXXXX-X
          
          [B]Tragen Sie hier Ihre Analytics Account Nummer ein:[/B]', 43), ('GA - E-Commerce Tracking Zieladresse', 'GOOGLE_ANALYTICS_TARGET','Google Analytics:
          
          Diese Einstellung bezieht sich auf das Google E-Commerce Tracking und legt fest, ob sie die Auswertung auf Basis von Kundenadresse (customers), Rechnungsadresse (billing) oder Lieferadresse (delivery) haben wollen.
          
          [B]Welchen Adresstyp wollen Sie für die Aufzeichnung der Transaktionen verwenden?[/B]', 43), ('GA - Affiliate', 'GOOGLE_ANALYTICS_AFFILIATION', 'Google Analytics:
          
          Falls ein Affiliate vorhanden ist (z.B. ein zweiter Shop) hier eintragen. Bei dieser Einstellung geht es darum auszuwerten, von welchem Partnershop/Partnerseite der Kunde ursprünglich kam.
          
          [B]Tragen Sie hier den Affiliate ein:[/B]', 43), ('GA - SKU Code', 'GOOGLE_ANALYTICS_SKUCODE', 'Google Analytics:
          
          Diese Einstellung bezieht sich auf das Google E-Commerce Tracking und legt fest, ob die Artikel ID oder die Artikelnummer in den Statistiken angezeigt werden soll.
          
          [B]Wählen Sie hier aus, was angezeigt werden soll: product_id = interne Zen-Cart Artikel ID
          products_model = eingegebene Artikelnummer[/B]', 43), ('GA - Conversion Tracking aktivieren?', 'GOOGLE_ANALYTICS_CONVERSION_ACTIVE', 'Google Analytics:
          
          [B]WICHTIG:
          Diese Einstellung nur aktivieren, wenn auch das kostenpflichtige Google Adwords genutzt wird![/B]
          
          Durch Aktivieren wird der Google Conversion Tracking Code in die Checkout Success Seite eingefügt. Dadurch kann die Effektivität der Adwords Kampagne ausgewertet werden. Wenn Sie hier das Conversion Tracking aktivieren, müssen Sie in der nächsten Option Ihre Conversion Tracking Nummer einstellen.
          
          [B]Wollen Sie Google AdWords Conversion Tracking aktivieren?[/B]', 43), ('GA - Adwords Conversion Tracking Nummer', 'GOOGLE_ANALYTICS_CONVERSION_IDNUM', 'Google Analytics:
          
          Wenn Sie oben Conversion Tracking aktiviert haben, geben Sie hier Ihre Conversion Tracking ID anstelle der XXXXXXXXXXX ein. Sollten Sie hier keine Nummer eingeben, wird das Conversion Tracking nicht funktionieren.
          
          [B]Geben Sie hier Ihre AdWords Conversion Tracking ID ein:[/B]', 43), ('GA - Google Adwords Sprache', 'GOOGLE_ANALYTICS_CONVERSION_LANG', 'Google Analytics:
          
          Spracheinstellung für Google Adwords. Voreingestellt ist: Deutsch
          
          [B]Wählen Sie die gewünschte Sprache aus:[/B]', 43);
          DROP TABLE IF EXISTS google_analytics_languages;
          CREATE TABLE google_analytics_languages ( languages_id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL default '', code char(10) NOT NULL default '', sort_order int(3) default NULL, PRIMARY KEY (languages_id), KEY idx_languages_name_zen (name) ) TYPE=MyISAM;
          INSERT INTO google_analytics_languages VALUES ('','Chinese (simplified) - Chinesisch (einfach)','zh_CN',1);
          INSERT INTO google_analytics_languages VALUES ('','Chinese (traditional) - Chinesisch (traditionell)','zh_TW',2);
          INSERT INTO google_analytics_languages VALUES ('','Danish - Dänisch','da',3);
          INSERT INTO google_analytics_languages VALUES ('','Dutch - Holländisch','nl',4);
          INSERT INTO google_analytics_languages VALUES ('','English (Australia)','en_AU',5);
          INSERT INTO google_analytics_languages VALUES ('','English (UK))','en_GB',6);
          INSERT INTO google_analytics_languages VALUES ('','English (US)','en_US',7);
          INSERT INTO google_analytics_languages VALUES ('','Finnish - Finnisch','fi',8);
          INSERT INTO google_analytics_languages VALUES ('','French - Französisch','fr',9);
          INSERT INTO google_analytics_languages VALUES ('','German - Deutsch','de',10);
          INSERT INTO google_analytics_languages VALUES ('','Hebrew - Hebräisch','iw',11);
          INSERT INTO google_analytics_languages VALUES ('','Italian - Italienisch','it',12);
          INSERT INTO google_analytics_languages VALUES ('','Japanese - Japanisch','ja',13);
          INSERT INTO google_analytics_languages VALUES ('','Korean - Koreanisch','ko',14);
          INSERT INTO google_analytics_languages VALUES ('','Norwegian - Norwegisch','no',15);
          INSERT INTO google_analytics_languages VALUES ('','Polish - Polnisch','pl',16);
          INSERT INTO google_analytics_languages VALUES ('','Portuguese (Brazil) - Portugiesisch (Brasilien)','pt_BR',17);
          INSERT INTO google_analytics_languages VALUES ('','Portuguese (Portugal) - Portugiesisch (Portugal)','pt_PT',18);
          INSERT INTO google_analytics_languages VALUES ('','Russian - Russisch','ru',19);
          INSERT INTO google_analytics_languages VALUES ('','Spanish - Spanisch','es',20);
          INSERT INTO google_analytics_languages VALUES ('','Swedish - Schwedisch','sv',21);
          INSERT INTO google_analytics_languages VALUES ('','Turkish - Türkisch','tr',22);
          Zuletzt geändert von webchills; 10.11.2010, 09:37.

          Kommentar


            #6
            Hast Du Zugriff auf phpMyAdmin?
            Verwendest Du ein Präfix bei den Zen-Cart Datenbanktabellen?

            Kommentar


              #7
              Zugriff auf PHP myadmin ist vorhanden.

              Ein präfix habe ich, soweit ich weiss nicht.

              Folgender Eintrag ist neu in meiner Datenbank:
              google_analytics_languages mit 22 Einträgen (Sprachen)


              Meine Konfigurationsseite --> Google Analytics sieht momentan so aus (siehe anhang)

              Kommentar


                #8
                Spiele die sql via phpMyAdmin ein, nicht über die Zen-Cart Administation.
                Auf die Datenbank wechseln und dann auf SQL:

                Zuerst den Inhalt der uninstall.sql ins Eingabefeld kopieren und Absenden.
                Danach den Inhalt der install.sql ins Eingabefeld kopieren und Absenden.

                Kommentar


                  #9
                  Hat funktioniert ))))

                  Super, ein riesen fettes Dankeschön an dich!!

                  Geniess den Capuccino

                  Kommentar


                    #10
                    Danke für den Capuccino

                    Kommentar


                      #11
                      Danke! Das Problem hatten anscheinend schon einige.

                      Kommentar


                        #12
                        Fatal error:

                        Danke webchills für diesen Weg via phpMyAdmin, der auch bei bis auf einen Punkt funktioniert hat:

                        Unter Admin -> Konfiguration -> Google Analytics Einstellungen
                        kann ich alle Einstellungen vornehmen.

                        Bei "GA - Google AdWords Language" ist der Wert "de" nicht modifizierbar und es erscheint folgende Fehlermeldung:

                        Fatal error
                        : Call to undefined function zen_cfg_pull_down_google_analytics_languages() in .../shop/meinadmin/configuration.php(21 : eval()'d code on line 1

                        Hast Du einen Tip, wie man das beheben könnte?

                        Kommentar


                          #13
                          Du verwendest die aktuelle Version 1.3.3 dieses Moduls aus dem Downloadbereich?

                          Überprüfe, ob folgende Datei am Server vorhanden ist:
                          DEINADMIN/includes/functions/extra_functions/google_analytics_functions.php

                          Kommentar


                            #14
                            Danke für Deine Antwort!

                            Ja, ich verwende: "Google Analytics 1.3.3 fuer Zen-Cart 1.3.9 und 1.3.8 deutsch" und die "google_analytics_functions.php" liegt ebenfalls in dem von Dir genannten Verzeichnis...

                            Kommentar


                              #15
                              Du verwendest anscheinend ein Präfix für die Zen-Cart Datenbanktabellen, hast aber die Tabelle google_analytics_languages ohne Präfix angelegt.
                              Wenn Du die Tabelle google_analytics_languages mit phpMyAdmin umbenennst und mit demselben Präfix ausstattest wie die übrigen Zen-Cart Tabellen, sollte die Welt wieder in Ordnung sein.

                              Alternativ legst Du die Tabelle einfach über die Zen-Cart Administration automatisch mit dem richtigen Präfix an mit folgendem Befehl unter Tools > SQL-Patches installieren:
                              Code:
                              DROP TABLE IF EXISTS google_analytics_languages;
                              CREATE TABLE google_analytics_languages (
                                languages_id int(11) NOT NULL auto_increment,
                                name varchar(50) NOT NULL default '',
                                code char(10) NOT NULL default '',
                                sort_order int(3) default NULL,
                                PRIMARY KEY  (languages_id),
                                KEY idx_languages_name_zen (name)
                              ) ENGINE=MyISAM;
                              
                              
                              INSERT INTO google_analytics_languages VALUES ('','Chinese (simplified) - Chinesisch (einfach)','zh_CN',1);
                              INSERT INTO google_analytics_languages VALUES ('','Chinese (traditional) - Chinesisch (traditionell)','zh_TW',2);
                              INSERT INTO google_analytics_languages VALUES ('','Danish - Dänisch','da',3);
                              INSERT INTO google_analytics_languages VALUES ('','Dutch - Holländisch','nl',4);
                              INSERT INTO google_analytics_languages VALUES ('','English (Australia)','en_AU',5);
                              INSERT INTO google_analytics_languages VALUES ('','English (UK))','en_GB',6);
                              INSERT INTO google_analytics_languages VALUES ('','English (US)','en_US',7);
                              INSERT INTO google_analytics_languages VALUES ('','Finnish - Finnisch','fi',8);
                              INSERT INTO google_analytics_languages VALUES ('','French - Französisch','fr',9);
                              INSERT INTO google_analytics_languages VALUES ('','German - Deutsch','de',10);
                              INSERT INTO google_analytics_languages VALUES ('','Hebrew - Hebräisch','iw',11);
                              INSERT INTO google_analytics_languages VALUES ('','Italian - Italienisch','it',12);
                              INSERT INTO google_analytics_languages VALUES ('','Japanese - Japanisch','ja',13);
                              INSERT INTO google_analytics_languages VALUES ('','Korean - Koreanisch','ko',14);
                              INSERT INTO google_analytics_languages VALUES ('','Norwegian - Norwegisch','no',15);
                              INSERT INTO google_analytics_languages VALUES ('','Polish - Polnisch','pl',16);
                              INSERT INTO google_analytics_languages VALUES ('','Portuguese (Brazil) - Portugiesisch (Brasilien)','pt_BR',17);
                              INSERT INTO google_analytics_languages VALUES ('','Portuguese (Portugal) - Portugiesisch (Portugal)','pt_PT',18);
                              INSERT INTO google_analytics_languages VALUES ('','Russian - Russisch','ru',19);
                              INSERT INTO google_analytics_languages VALUES ('','Spanish - Spanisch','es',20);
                              INSERT INTO google_analytics_languages VALUES ('','Swedish - Schwedisch','sv',21);
                              INSERT INTO google_analytics_languages VALUES ('','Turkish - Türkisch','tr',22);

                              Kommentar

                              Info zu diesem Forenarchiv:
                              Mit Release von 1.5.7 wurde die deutsche Zen Cart Version auf eine reine DIY-Lösung umgestellt.
                              Für einen Support via Forum stehen keine personellen und zeitlichen Ressourcen mehr zur Verfügung.
                              Dieses Supportforum bleibt im Nur-Lesen-Modus als Wissensarchiv noch online verfügbar.
                              PM Funktionalität, Registrierung und Posten neuer Beiträge sind deaktiviert.
                              Zugriff auf Anhänge in den Postings ist auch ohne Registrierung/Einloggen möglich.
                              FAQ und Downloadbereich des Forums wurden in die neue umfangreiche Knowledgebase auf der zen-cart-pro.at Website übernommen.

                              Das Development der deutschen Zen Cart Version geht wie bisher auf Github weiter.
                              Wir werden auch weiterhin neue Versionen bereitstellen und die Onlinedokumentation/Knowledgebase aktualisieren.
                              Fehler in der Software können auf Github als Issues gemeldet werden.
                              Follow us
                              aktuelle version
                              Zen Cart 1.5.7g deutsch
                              vom 12.12.2023
                              [Download]
                              Lädt...
                              X