Simple Google Analytics - Support

econcepts:

A blank page means you have an error in your PHP somewhere. Typically this is caused when trying to insert any of the lines needed to run the module and on in removes or replaces code by accident. The new instructions are very unclear and are being re-written in my next release to go back to the previous way.

For the time being, I would revert your changes to the previous files, then start again following the instructions in the old version (just before the 1.5 upgrade version was uploaded.) You will need to register the pages with the 1.5 admin, but the instructions on what you need to do are more clear with the older install.

Let me know if that helps.

Sorry, a little confused. How can I get the older version, and what version is that one? I ended up getting my site to show up again though but I had to delete all of the files that got uploaded. I made sure that when copied the code into my body that I didn't copy over any existing code. Is that ga.js file supposed to be in my checkout success folder? Why wouldn't it be? I haven't even touched any of those files.

Yes, I saw that (went to your site via the PM you sent me.)

The install should be actually very easy (but with the current instructions is seems to be more difficult.)

I would recommend installing the version 1.2.5 -- no 'b' / 'c' version. (look lower in the downloads area of the zen cart section).

This one is identical to the others but it has easier to understand instructions. The only things you will need to be aware of (if running 1.5) is that you will still need to register the pages in the admin (not included in the instructions for 1.2.5 as that was not available during the initial writing.)

OR, you can use my newest version here (I have yet to upload) which covers it all plus some new items.

There should be nothing in the way of ga.js anywhere in your download. My packages do not contain that at all. The code is automatically generated for you so no worries on that. Just upload a few files (2 or so) add one line of code to the tpl_main_page.php file, and your all set.

It you still have issues or want me to help you with it, just let me know (PM me again.)

Again, very quick install (prior to the 1.5 upgrade version that went into place I was told it was one of the easiest and pain free installs. )

econcepts:

Yes, I saw that (went to your site via the PM you sent me.)

The install should be actually very easy (but with the current instructions is seems to be more difficult.)

I would recommend installing the version 1.2.5 -- no 'b' / 'c' version. (look lower in the downloads area of the zen cart section).

This one is identical to the others but it has easier to understand instructions. The only things you will need to be aware of (if running 1.5) is that you will still need to register the pages in the admin (not included in the instructions for 1.2.5 as that was not available during the initial writing.)

OR, you can use my newest version here (I have yet to upload) which covers it all plus some new items.

There should be nothing in the way of ga.js anywhere in your download. My packages do not contain that at all. The code is automatically generated for you so no worries on that. Just upload a few files (2 or so) add one line of code to the tpl_main_page.php file, and your all set.

It you still have issues or want me to help you with it, just let me know (PM me again.)

Again, very quick install (prior to the 1.5 upgrade version that went into place I was told it was one of the easiest and pain free installs. )Link to new version???

Ok so I went through the older versions install and copied everything over, ran the SQL but I dont see the Analytics option under my config menu in the admin. I saw some earlier posts in this thread about registering it in the admin but when I go to myPHPadmin and run the query I don't get anything back, it says it can't find it something. Is it a problem if I run the SQL install commands more than once? It doesn't seem to be putting that info in..so I'm kind of stuck...

Check my PM to you. The only thing the old version did not have was the instructions to register the page with the Admin (a new feature in 1.5 that was not out when that version was published ... but it still works fine on 1.5 etc...).

So all you have to do now is register the page with the admin and you're all set.

Let me know if that helps.

Still no go, running the query doesn't give me an gID, i don't think it's installed, but I've run the sql installer multiple times. What a pain....Where's a download link to the latest version????

I haven't uploaded the new version to Zen downloads yet. Will be doing that in a few days here. I will post a link to another location it can be donwloaded here once I get that in place (for those who are waiting on it.)

Cool. Would running the sql install file multiple times cause any problems? It seems that running it now isn't 'installing' it for me...I only assume it's not installed since 1)running the latest version doesn't add it to my admin 2) trying to run the query from myphpadmin returns no results....

"#1146 - Table 'thisish2_znc1.configuration' doesn't exist"

Running it multiple times is not going to hurt, but if you have already included your Tracking IDs etc... into the admin, it will remove them and you would need to re-enter those. You may also see (in some cases) if you run it multiple times an error saying 'can't add table xxx' (or something like that) because it already exists. No problem there either. The system is just saying the table already is present (or changes in it.)

If you try to run the query from phpmyadmin (which I don't recommend), just make sure you add any databsae prefix to all sections that are referenced to be added. When using the SQL patch tool in the Zen Cart admin, this is done automatically for you.

If you don't see the contribution configuration section in your admin make sure you try one of the following:

1) Check to see if you are running any "Admin Profiles" type of add-on that might need permissions added for the user who is logged in. If so, add the permissions to view the new contribution configuration section, and you should see it.

2) If you are not running any "Admin Profiles" type of add-on then look at the following:

If you are running the 1.2.5 version (the first 1.2.5 version .. .not subsequent 'b' / 'c' versions) then you still need to do the following for it to show up in your admin (this is included in the versions after my 1.2.5 original one, but it seems as though people are having issues with those newer versions do to the way they were setup and instructions were written. I'll likely be rolling this back in the next version here to make it easier to understand install again (it's actually very straight forward and should only take a maximum of 5 minutes to install and configure.)

The original 1.2.5 version did not include the additional language file for adding the section to you admin. Likewise, it didn't include instructions on how to register the page with the admin either (as neither of those options were available at the time of that release.)

So to get it showing in your admin do the following (again, this is already built into my newest 1.2.6 release set to be added soon.)

Create 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=[enter your number here] (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=

Upload that file to the directory on your server (listed in the path above) and try to access it from the admin again.

econcepts:

If you try to run the query from phpmyadmin (which I don't recommend), just make sure you add any databsae prefix to all sections that are referenced to be added. When using the SQL patch tool in the Zen Cart admin, this is done automatically for you.

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

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

How exactly should I run it from admin panel, what do I type and where will i get the gID? I tried copying and pasting the query into the sql patch tool but didn't get an ID.

I have a feeling the sql installer isn't installing what needs to be installed. I've run the query from myphpadmin and I keep getting errors...so frusterating how I can't get this to work.

In the instructions it says:

Make sure your body tag in /includes/templates/[your_template]/common/tpl_main_page.php
includes this code

But the template I'm using doesn't have that file. All I've got in that directory is:
html_header.php,
tpl_box_default_left.php,
tpl_box_default_right.php,
tpl_columnar_display.php,
tpl_drop_menu.php,
tpl_header.php,
tpl_footer.php.

Which should I add the code to?

If your template does not have it, you need to copy that from the template_default directory into your custom template directory. Once you have it in that location, add the code referenced on the install.

Let me know if that helps.

The SQL query you referenced in this post should be run from a tool like phpmyadmin (all others in the install package should be run by copy and pasting them into the SQL Patch tool within your Zen Cart admin (under "Tools" menu.). All the query you listed is used for is to get your "id" that needs to be plugged into the proper location in the file referenced in my original post.

This query does not do anything in the way of installing the mod. You already ran that one earlier (you said) and that should be complete.

Let me know if that helps.

econcepts:

This query does not do anything in the way of installing the mod. You already ran that one earlier (you said) and that should be complete.
That's the thing. I've run the sql install multiple times, old and new. I don't see the Google Analytics menu option in my config, so I try to run the query in myPHPadmin and I get the error I posted above. It seems to be looking for something that's not there, so it makes me think that the sql install hasn't done anything? So I try to manually get the gID to register it in the admin, but I can't get it since the query turns up no information, so where do I go from here?

I finally got it installed and in my config menu. Running the php query wasn't working so I manually went into my database and found the ID by looking through the list and registered it in the admin. Now I'm just waiting for it to receive the data.

I'm not sure if this might have caused an issue but I was having some other problems with some things not working quite right. I found out that when I installed zen cart via BlueHost's cPanel they added two slashes in my configure.php files (two files, one in the admin folder) so it was showing '//' for the DIR_WS_CATALOG' and DIR_WS_HTTPS_CATALOG entries..I deleted the extra slash in both files, changed permissions, saved and now things are working so much better.

Glad you got it working. That may or may not have been the problem, but one thing I do know is that often times, those 'automated install' scripts hosts have don't always work the way they should. That is one reason I prefer to manually install each time.

Let me know if you need anything else.

econcepts:

The SQL query you referenced in this post should be run from a tool like phpmyadmin (all others in the install package should be run by copy and pasting them into the SQL Patch tool within your Zen Cart admin (under "Tools" menu.). All the query you listed is used for is to get your "id" that needs to be plugged into the proper location in the file referenced in my original post.

This query does not do anything in the way of installing the mod. You already ran that one earlier (you said) and that should be complete.

Let me know if that helps.

SO MANY PEOPLE ARE HAVING PROBLEMS WITH YOUR SQL CODE BECAUSE YOU NEED TO CORRECT YOU BASIC CODING!!!!!!!!

THANKS FOR THE FRUSTRATION & WASTING HOURS OF MY LIFE I WILL NOT GET BACK ECONCEPTS!!!!!!!!

For SQL File (googleanalytics-INSTALL.sql) the following need to be corrected:

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)
) [B]TYPE[/B]=MyISAM;

TO:

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)
) [B]ENGINE[/B]=MyISAM;

IM SO MAD AT YOU RIGHT ABOUT NOW!!!!!

http://www.zen-cart.com/showthread.php?53701-Simple-Google-Analytics-Support&p=1107759&highlight=ENGINE#post1107759

http://www.zen-cart.com/showthread.php?53701-Simple-Google-Analytics-Support&p=1092404#post1092404

http://www.zen-cart.com/showthread.php?53701-Simple-Google-Analytics-Support&p=1091141&highlight=ENGINE#post1091141

I'm still learning code, now I know what to look for.

And let's start with the fact that yelling at people (beside being in poor form) is generally NOT the way to get help around here..

Second, Eric (Econcepts) is NOT the author of the CURRENT version of this add-on.. :no:

that said yelling at the current author isn't helpful either.. It's a simple mistake that was made without malice.. ALL add-ons here are contributed for free by volunteers who do it in the spirit of sharing with the community..

If you are going to yell at everyone for making a simple mistake, well that's just not cool.. IMHO :shocking:

g00glethis1:

SO MANY PEOPLE ARE HAVING PROBLEMS WITH YOUR SQL CODE BECAUSE YOU NEED TO CORRECT YOU BASIC CODING!!!!!!!!

THANKS FOR THE FRUSTRATION & WASTING HOURS OF MY LIFE I WILL NOT GET BACK ECONCEPTS!!!!!!!!

For SQL File (googleanalytics-INSTALL.sql) the following need to be corrected:

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)
) [B]TYPE[/B]=MyISAM;

> 
> TO:
> 
> ```
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)
) [B]ENGINE[/B]=MyISAM;

IM SO MAD AT YOU RIGHT ABOUT NOW!!!!!