Simple Google Analytics - Support

[econcepts]

Hello reference my original post #1600. I am assuming the problem is within my setup on the test system, rather than a code error, due to the overwhelming number of successful users.

But it still seems odd that no one else has had a problem

To try and locate the problem I have updated to the latest version of xampp for win 32 1.7.4

Rewritten the code into a new sql file

Neither have any beneficial effect

I guess the next step is to try and cross reference against other SQL instructions

I have an odd feeling I am going to kick myself when the reason for the error becomes apparent!

Centec2b

There shouldn't be any issues with the original install code (if you are using Simple Google Analytics.)

Copy and paste it into the zen cart Admin (don't use phpMyAdmin and don't 'upload' it in the zen admin ... copy and paste is the way to go.)

If you changed the SQL file, you might have made a mistake in the coding (is an apostrophe missing near this line TYPE=M' ?)

I've never heard of this issue and there are a lot of users.

[econcepts]

i believe i have added everything correct. I receive no errors of any kind and even analytics says its receiving data. In fact, my traffic dropped to 0 so i know its not calculating my traffic. Also, when i view my source code on any page in the site, i cannot see any code relating to google analytics.

i am using the "iC_AcadameV1.2" template along with the latest version of Zen Cart.

i also had to copy the "html_header" into my iC_AcadameV1.2 template folder because it was not there.

Anyone got any ideas?

Send a url to look at. The only way you will not get any traffic recorded is if you either did not install the tracking code on the pages, or if you installed the tracking code but did not use the tracking ID for the account you are looking at.

This install works with any template and all version of zen cart so it should work on yours.

[Centec2b]

There shouldn't be any issues with the original install code (if you are using Simple Google Analytics.)

Copy and paste it into the zen cart Admin (don't use phpMyAdmin and don't 'upload' it in the zen admin ... copy and paste is the way to go.)

If you changed the SQL file, you might have made a mistake in the coding (is an apostrophe missing near this line TYPE=M' ?)

I've never heard of this issue and there are a lot of users.

Good Evening Eric

Thank you for this guidance

I have made progress (some)

It would appear that the folks at MySQL are evolving the language and the term

TYPE

has been replaced by

ENGINE

although from what I understand there should be backwards compatibility

However when I had tried several times copying and pasting into the install SQL patches with a copy of a new SQL file and it still failed, I used phpMyAdmin and I installed the SQL instructions with ENGINE substituting for TYPE and it installed ok

On looking at the database entries I noticed several errors where foreign language punctuation had been used and corrected by hand (eg French ç).

I found references to this MySQL language change at

http://www.zen-cart.com/forum/showpo...65&postcount=5

and

http://dev.mysql.com/doc/refman/5.0/...ge-engine.html

The system now shows up in Admin and the only remaining problem is the same as #1593 ie the main page is blank.

I checked the error log as suggested and it is saying

[07-Sep-2011 00:51:29] PHP Parse error: syntax error, unexpected '{' in xxxxxxxxxxxxxxxx/common/tpl_main_page.php on line 1

I have checked the file but I am blowed if I can see this error. I have uploaded the file and if anyone can put me right on this I would be grateful.

In conclusion thank you Eric and All for the help and assistance - I wouldn't have got this far by myself

[AdamT]

Running ZC v1.3.9h. Does Simple Google Analytics also work with the COWOA mod?

[econcepts]

Running ZC v1.3.9h. Does Simple Google Analytics also work with the COWOA mod?

Yes. Works with all modules on the market, free and paid.

[AdamT]

Yes. Works with all modules on the market, free and paid.

Great, TY. Got this installed :)

So I have an Adwords conversion ID entered in the Admin, and if I force load the checkout success page I can see the script in the html. If I click one of my Adsense banners (which begins the Google tracking cookie), can I then just paste the checkout success URL in the browser and go to that page for Adwords to record a conversion? Or do you actually have to do a full text checkout and pay to do a test?

[econcepts]

Good Evening Eric

Thank you for this guidance

I have made progress (some)

It would appear that the folks at MySQL are evolving the language and the term has been replaced by although from what I understand there should be backwards compatibility

However when I had tried several times copying and pasting into the install SQL patches with a copy of a new SQL file and it still failed, I used phpMyAdmin and I installed the SQL instructions with ENGINE substituting for TYPE and it installed ok

On looking at the database entries I noticed several errors where foreign language punctuation had been used and corrected by hand (eg French ç).

I found references to this MySQL language change at

http://www.zen-cart.com/forum/showpo...65&postcount=5

and

http://dev.mysql.com/doc/refman/5.0/...ge-engine.html

The system now shows up in Admin and the only remaining problem is the same as #1593 ie the main page is blank.

I checked the error log as suggested and it is saying


I have checked the file but I am blowed if I can see this error. I have uploaded the file and if anyone can put me right on this I would be grateful.

In conclusion thank you Eric and All for the help and assistance - I wouldn't have got this far by myself

A blank page typically means there is an error in your PHP somewhere. This is most often do to incorrectly copy and pasting the code required to run the module into the templates on your site. To resolve that issue you need to go back and make sure each and every element is copy and pasted exactly as shown and that you did not copy over any other code on your site (which may cause accidental removal of PHP tags that make other portions of your page run.

Another thing to keep in mind. If you tried to install this via PHPMyAdmin then you need to make sure you manually inserted your database prefix (if using any) to each of the commands. When you sue the built in Zen Cart patch tool it automatically does this for you, but with PHPMYAdmin you need to adjust the code to find your correct table prefix.

The file you uploaded looks ok. Make sure you take a look at the html header file as well and ensure you didn't accidentally remove anything there when copying code in.

What version of MySQL are you using? I'm running this (and tested installs on) many many machines with MySQL 5.+ and it goes without flaw each time (no alterations to SQL code etc..., no running through PHPMyAdmin, etc...)

[AdamT]

How do you track conversions on individual products and their prices?

[Centec2b]

A blank page typically means there is an error in your PHP somewhere

Another thing to keep in mind. If you tried to install this via PHPMyAdmin then you need to make sure you manually inserted your database prefix (if using any) to each of the commands.

What version of MySQL are you using?

The good news is it is working!

The annoying thing is I cannot say why it is now working!!

I have stared at this code till I am blue in the face - I can only think there was some minor error which I corrected unnoticed.

I am using MySQL 5.0.92

As for the information the analytics reveals - hmmm thats another story!

Eric thank you for this help - it is appreciated

Centec2b

[econcepts]

How do you track conversions on individual products and their prices?

So long as you have ecommerce tracking turned on within Google Analytics, my module here automatically records it for you within that same area. If you want to track conversions from PPC then you need to also turn on and add your Adwords conversion tracking ID too.