Simple Google Analytics - Support

[Centec2b]

Hello - has anyone had experience of this issue when doing a clean install

I am installing onto my test system prior to installing on the live version and I keep getting a sql syntax error when trying to install the SQL file

#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 '

PRIMARY KEY (languages_id),

KEY idx_languages_name_zen ('name')

) TYPE=M' at line 5

I have looked at the MySQL reference but have to confess I got somewhat lost

I am using Zen Cart 1.3.9h
Database Patch Level 1.3.9h
PHP 5.3.5
Mysql 5.5.8

I have searched the thread and the forum and am perplexed that there doesnt seem to be others who have experienced the problem

Any help gratefully received

Thank you

Centec2b

[raider1016]

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?

[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]

Hello - has anyone had experience of this issue when doing a clean install

I am installing onto my test system prior to installing on the live version and I keep getting a sql syntax error when trying to install the SQL file

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

[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.

[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...)