Simple Google Analytics - Support

[Limitless]

Hello

I am running zen cart v1.3.9h and Mysql 5.5

I installed all the files and edited the tpl_main_page file

i then tried to install the SQL commands in Admin but got an error

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 'TYPE=MyISAM' at line 1
in:
[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;]
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.

Any help please

thanks

Change TYPE=ISAM to ENGINE=ISAM

[notageek]

In response to several postings of this nature:
[QUOTE]
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 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE [?QUOTE]
In trying to research the 1064 error where the MySQL tables have not accepted the sql patch, I ran across an answer in this thread.

http://www.zen-cart.com/forum/showthread.php?p=689865

This question seems to pop up in a great many threads where people are installing modules. It probably should have a thread of its own.

Notageek

[hfxracing]

what is language_key? where to find it? Good question as I don't know either.

Step by Step the Admin
How & what do you put in each section?

Mine never appeared on config after installing this mod

so if all new plugin's require this I would like to know the
meaning of each section in the Admin.

Page Key (e.g. myModPageName)
Page Name (e.g. BOX_MY_MOD_PAGE_NAME)
Page Filename (e.g. FILENAME_PAGE_NAME)
Page Parameters (e.g. option=1 or, more usually, leave blank)
Menu
Display on Menu?
Sort Order



Page Key= The Name of the New Setting?
Page Name? for the title pages or is it the same as above?
Page Filename? is this like a .EXE or .PHP the executes the setting? where are they usually held? admin/includes/functions?
Page Parameters ? No Idea
sort order ? I didn't know the rest of the zen cart settings were sorted so I would need to know the order of whats there now so I don't understand this setting at all.
HELP! lol

[hfxracing]

Still no luck I read all 172 posts to no avail & re downloaded the mod. I am not recieving errors anywhere! google looks to be finding the code & the sql patch went in I even checked my PHPadmin. It's all there except for tables for config settings looks like Language & groups went it. The config setting are still not showing in my admin panel do I have to name my folder back to ADMIN before I run patch? I have it renamed to something differnt for security. Frustration is setting in. One more shot at this if anyone have another suggestion to try. if not this mod is coming out & I will put the basic code back in my INDEX.PHP file.

[hfxracing]

Ok now I am seeing all the tables in MYPHPadmin but still not in admin panel

[joepixel]

I managed to get Simple Google Analytics Version: 1.2.5 to work for me on Zen version 1.5 and added to the admin menu. I thought I'd share.

The new GA version does not seem to have a language file to define one of the settings for the admin menu to appear. I created this file: admin/includes/languages/english/extra_definitions/googleanalytics.php and placed the following code in this file:

<?php
define('UN_BOX_GOOGLE_ANALYTICS', 'Simple Google Analytics');

Here are the settings I used in the admin registration page.

Page Key: Simple Google Analytics
Page Name: UN_BOX_GOOGLE_ANALYTICS
Page Filename: FILENAME_CONFIGURATION
Page Parameters: gID=36 (make sure you look up this in your database because the number will be different. see below on how to do this.)
Menu: configuration
Display on Menu? Y
Sort Order: whatever you want

To find the gID number run this select statement in phpMyAdmin:

SELECT * FROM `configuration` WHERE configuration_key like '%google%'

Then look for the configuration_group_id. This is the number to use after gID=

I hope this helps someone!

[pinkchalkstudio]

I've been using Simple Google Analytics successfully for over a year. Tracking visitors and conversions.

I recently installed some 3rd party tracking code using the instructions in this ZenCart Tutorial: https://www.zen-cart.com/tutorials/i...hp?article=399

The tutorial directs you to create a checkout_success directory under includes/templates/XXXXX/ and place a tpl_footer.php file there. That all worked just fine until I realized that this solution caused my Analytics conversion tracking to stop.

It appears to have disabled the execution of the Simple Google Analytics code on the checkout success page. After investigating and running some tests, just the existence of a tpl_footer.php file under checkout_success causes the conversion tracking to stop (ie same file no 3rd party mods in it).

I found some references to this incompatibility in this thread and took the advice to move my tracking code to includes/templates/XXXXX/common/tpl_main_page.php and deleted the checkout_success override directory and tpl_footer.php in it.

This solved the problem, conversion tracking is working again and my 3rd party tracking code is executing.

I just wanted to share this experience. I don't understand why the incompatibility occurred but I'm very glad to have it all working again!

[armyabn1]

I managed to get Simple Google Analytics Version: 1.2.5 to work for me on Zen version 1.5 and added to the admin menu. I thought I'd share.

The new GA version does not seem to have a language file to define one of the settings for the admin menu to appear. I created this file: admin/includes/languages/english/extra_definitions/googleanalytics.php and placed the following code in this file:

<?php
define('UN_BOX_GOOGLE_ANALYTICS', 'Simple Google Analytics');

Here are the settings I used in the admin registration page.

Page Key: Simple Google Analytics
Page Name: UN_BOX_GOOGLE_ANALYTICS
Page Filename: FILENAME_CONFIGURATION
Page Parameters: gID=36 (make sure you look up this in your database because the number will be different. see below on how to do this.)
Menu: configuration
Display on Menu? Y
Sort Order: whatever you want

To find the gID number run this select statement in phpMyAdmin:

SELECT * FROM `configuration` WHERE configuration_key like '%google%'

Then look for the configuration_group_id. This is the number to use after gID=

I hope this helps someone!

Thank you for this!!! I don't know how many hours you saved me of trying to look into this further.....but it is a lot! Worked perfectly.

[merrydown]

Thank you JOE PIXEL.

Beats me why this solution is still not part of the read me... Thanks again!!!

Jim

I managed to get Simple Google Analytics Version: 1.2.5 to work for me on Zen version 1.5 and added to the admin menu. I thought I'd share.

The new GA version does not seem to have a language file to define one of the settings for the admin menu to appear. I created this file: admin/includes/languages/english/extra_definitions/googleanalytics.php and placed the following code in this file:

<?php
define('UN_BOX_GOOGLE_ANALYTICS', 'Simple Google Analytics');

Here are the settings I used in the admin registration page.

Page Key: Simple Google Analytics
Page Name: UN_BOX_GOOGLE_ANALYTICS
Page Filename: FILENAME_CONFIGURATION
Page Parameters: gID=36 (make sure you look up this in your database because the number will be different. see below on how to do this.)
Menu: configuration
Display on Menu? Y
Sort Order: whatever you want

To find the gID number run this select statement in phpMyAdmin:

SELECT * FROM `configuration` WHERE configuration_key like '%google%'

Then look for the configuration_group_id. This is the number to use after gID=

I hope this helps someone!