Simple Google Analytics - Support

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.

Quote:

---

Originally Posted by 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:

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)
) TYPE=MyISAM;

---

TO:

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;

---

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

http://www.zen-cart.com/showthread.p...NE#post1107759


http://www.zen-cart.com/showthread.p...04#post1092404


http://www.zen-cart.com/showthread.p...NE#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: http://www.zen-cart.com/images/smilies/no.gif

Quote:

---

Originally Posted by 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:

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)
) TYPE=MyISAM;

---

TO:

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;

---

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

---

Hey Everyone-

I've just run through ANOTHER install, and still don't see the Analytics code showing up on any of my pages.

The configuration menu shows up fine in the admin screen. I entered the correct UA code, checked the permissions for my admin profile, enabled e-commerce in my GA account... I'm out of ideas. Anybody know what I could be doing wrong?

I'm running v1.3.9h. I can PM a link to our beta store if needed.
Please help! Thanks!

I'm sorry Econcepts and Everyone (Diva :-P) for yelling. I won't be doing that any more.

@g00glethis1: It really isn't a hard install at all (it should only take about 3 - 4 minutes max and has no overwrites.) There is only one minor change (already referenced) in the original SQL code if you are running PHP 5 or higher. Other than that, it is very straight forward.

Keep in mind that the latest version of code uploaded (along with instructions) are not mine (thanks for pointing that out DivaVocals). They were uploaded by another zen cart user who updated it to work with Zen 1.5 and made some other alterations (not to core code or functionality) to the installation instructions and file set layout. This apparently has made things more difficult to understand for others and will be migrated back to my original layout which didn't cause as many issues with understanding install apparently.

I have a new version just about ready and it will be uploaded very soon.

If you want help from the forums you really should read the rules and ask for help with more etiquette. Yelling is not appropriate, not tolerated, and will get you nowhere.

OK,OK I screwed the instructions up I apologize. Anybody who wants to install this module please install econcepts version Simple Google Analytics - Version: 1.2.5
1.2.5 works on all version of zen cart including (not limited to 1.5.x)