Seite 1 von 3 123 LetzteLetzte
Ergebnis 1 bis 10 von 23

Thema: Simple Google Analytics 1.2.3 - Fehler beim SQL patch

  1. #1
    Padawan Anwärter Avatar von domifix
    Registriert seit
    27.07.2009
    Beiträge
    17
    Themen
    10
    DANKE
    2
    Erhaltene Danke: 0

    Standard 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
    Geändert von webchills (10.11.2010 um 09:37 Uhr)

  2. #2
    Jedi-Ritter Avatar von webchills
    Registriert seit
    30.10.2004
    Ort
    Österreich
    Beiträge
    6.092
    Themen
    85
    DANKE
    3
    Erhaltene Danke: 961

    Standard

    Bitte einfach die extra für die deutsche Version angepasste Version dieses Moduls verwenden:
    Google Analytics 1.3
    !!! kostenloser Support ausschließlich im Forum - Nicht per Email, nicht per Telefon und nicht per PM !!!

  3. #3
    Padawan Anwärter Avatar von domifix
    Registriert seit
    27.07.2009
    Beiträge
    17
    Themen
    10
    DANKE
    2
    Erhaltene Danke: 0
    Erstellt von

    Standard

    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

  4. #4
    Jedi-Ritter Avatar von webchills
    Registriert seit
    30.10.2004
    Ort
    Österreich
    Beiträge
    6.092
    Themen
    85
    DANKE
    3
    Erhaltene Danke: 961

    Standard

    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.
    !!! kostenloser Support ausschließlich im Forum - Nicht per Email, nicht per Telefon und nicht per PM !!!

  5. #5
    Padawan Anwärter Avatar von domifix
    Registriert seit
    27.07.2009
    Beiträge
    17
    Themen
    10
    DANKE
    2
    Erhaltene Danke: 0
    Erstellt von

    Standard

    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                       Stellen Sie sicher, dass Sie VOR DEM AUSFÜHREN DIESES SCRIPTS eine VOLLSTÄNDIGE SICHERUNG IHRER DATENBANK erstellt haben!                   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!                                           Abfrageergebnisse:                          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:
    
    Note:
    It is NOT recommended to use the old tracking code!
    
    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.
    
    Important Note: 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 has been confirmed 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 ZenCartOptimization.com
    
    Do you want to use the older "urchin.js" tracking code?
    ', @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 ZenCartOptimization.com
    
    Enter your Google Analytics account number (starting with the "UA-") in the space provided below.
    ', @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 ZenCartOptimization.com
    
    Which address type do you want to use for recording transaction information?
    ', @gid, 3, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''customers'', ''delivery'', ''billing''),'), (NULL, 'GA - Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Google Analytics:
    
    This optional 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 ZenCartOptimization.com
    
    If you have one, enter your optional partner or store affiliation in the space provided below.
    ', @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 ZenCartOptimization.com
    
    Indicate which identifier you want to use to track product performance by selecting one of the options below.', @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.
    
    Please Note: Conversion tracking is used to track the effectiveness of Google AdWords paid search campaigns. If you are not 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 requires you 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 ZenCartOptimization.com
    
    Do you want to turn on Google AdWords Conversion Tracking?
    ', @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 must 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 ZenCartOptimization.com
    
    Enter your AdWords Conversion Tracking ID Number below.', @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 ZenCartOptimization.com
    
    Select your language below
    ', @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:
    
    Nicht empfohlen!
    Voreingestellt ist die neue Variante des Google Analytics Codes (ga.js). Wenn möglich unbedingt diese neuere Variante verwenden.
    
    Soll der alte Code verwendet werden?:', 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
    
    Tragen Sie hier Ihre Analytics Account Nummer ein:', 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.
    
    Welchen Adresstyp wollen Sie für die Aufzeichnung der Transaktionen verwenden?', 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.
    
    Tragen Sie hier den Affiliate ein:', 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.
    
    Wählen Sie hier aus, was angezeigt werden soll: product_id = interne Zen-Cart Artikel ID
    products_model = eingegebene Artikelnummer', 43), ('GA - Conversion Tracking aktivieren?', 'GOOGLE_ANALYTICS_CONVERSION_ACTIVE', 'Google Analytics:
    
    WICHTIG:
    Diese Einstellung nur aktivieren, wenn auch das kostenpflichtige Google Adwords genutzt wird!
    
    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.
    
    Wollen Sie Google AdWords Conversion Tracking aktivieren?', 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.
    
    Geben Sie hier Ihre AdWords Conversion Tracking ID ein:', 43), ('GA - Google Adwords Sprache', 'GOOGLE_ANALYTICS_CONVERSION_LANG', 'Google Analytics:
    
    Spracheinstellung für Google Adwords. Voreingestellt ist: Deutsch
    
    Wählen Sie die gewünschte Sprache aus:', 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);
    Geändert von webchills (10.11.2010 um 09:37 Uhr)

  6. #6
    Jedi-Ritter Avatar von webchills
    Registriert seit
    30.10.2004
    Ort
    Österreich
    Beiträge
    6.092
    Themen
    85
    DANKE
    3
    Erhaltene Danke: 961

    Standard

    Hast Du Zugriff auf phpMyAdmin?
    Verwendest Du ein Präfix bei den Zen-Cart Datenbanktabellen?
    !!! kostenloser Support ausschließlich im Forum - Nicht per Email, nicht per Telefon und nicht per PM !!!

  7. #7
    Padawan Anwärter Avatar von domifix
    Registriert seit
    27.07.2009
    Beiträge
    17
    Themen
    10
    DANKE
    2
    Erhaltene Danke: 0
    Erstellt von

    Standard

    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)

  8. #8
    Jedi-Ritter Avatar von webchills
    Registriert seit
    30.10.2004
    Ort
    Österreich
    Beiträge
    6.092
    Themen
    85
    DANKE
    3
    Erhaltene Danke: 961

    Standard

    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.
    !!! kostenloser Support ausschließlich im Forum - Nicht per Email, nicht per Telefon und nicht per PM !!!

  9. Folgende 2 User sagen Danke zu webchills für den nützlichen Beitrag:

    domifix (10.11.2010),Runik (19.07.2011)

  10. #9
    Padawan Anwärter Avatar von domifix
    Registriert seit
    27.07.2009
    Beiträge
    17
    Themen
    10
    DANKE
    2
    Erhaltene Danke: 0
    Erstellt von

    Standard

    Hat funktioniert ))))

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

    Geniess den Capuccino

  11. #10
    Jedi-Ritter Avatar von webchills
    Registriert seit
    30.10.2004
    Ort
    Österreich
    Beiträge
    6.092
    Themen
    85
    DANKE
    3
    Erhaltene Danke: 961

    Standard

    Danke für den Capuccino
    !!! kostenloser Support ausschließlich im Forum - Nicht per Email, nicht per Telefon und nicht per PM !!!

Seite 1 von 3 123 LetzteLetzte

Ähnliche Themen

  1. Datenbank optimieren (Admin) -> SQL Fehler
    Von Ignatius im Forum Archivierte Beiträge Zen-Cart Support
    Antworten: 3
    Letzter Beitrag: 30.06.2011, 10:17
  2. sql Fehler 1064 ~ coupons
    Von Windgefluester im Forum Archivierte Beiträge Zen-Cart Support
    Antworten: 0
    Letzter Beitrag: 16.11.2009, 11:08
  3. Ultimate SEO URLs v2.103 Fehlerbehebung bei SQL Fehler
    Von Onkel_Hotte im Forum Archivierte Beiträge Zen-Cart Support
    Antworten: 40
    Letzter Beitrag: 10.07.2008, 14:25
  4. Hosteurope und Google Analytics
    Von kermie im Forum Archivierte Beiträge Zen-Cart Support
    Antworten: 3
    Letzter Beitrag: 28.02.2008, 12:22
  5. SQL Patch Befehl
    Von elpego im Forum Archivierte Beiträge Zen-Cart Support
    Antworten: 1
    Letzter Beitrag: 19.01.2008, 14:09

Lesezeichen

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •  
zen-cart-pro.at
Zen Cart ist eine kostenlose unter der GPL-Lizenz veröffentlichte Open-Source Shopsoftware. Das System wird in den USA entwickelt, die amerikanische Website dazu ist www.zen-cart.com

Die deutsche Zen-Cart Version, um die es hier auf zen-cart-pro.at geht, ist eine Anpassung der amerikanischen Version an die Bedürfnisse von Onlineshopbetreibern im deutschsprachigen Raum.

Die deutsche Zen Cart Version wird von einem Team von Entwicklern in Österreich und Deutschland betreut, weiterentwickelt und supportet und steht kostenlos in unserem Downloadbereich zur Verfügung.

[mehr]
Follow Us
  • zen-cart-pro-at auf Twitter
  • zen-cart-pro-at auf Github
  • zen-cart-pro-at auf SourceForge
Aktuelle Version
Zen Cart 1.5.5 deutsch
Revision 1188 vom 02.12.2016
[Download]