Simple Google Analytics - Support

[rgshearer]

I'm having the same problem mentioned earlier when I try to apply the SQL Patch. I get the dreaded 1064 error:

Do you want to turn on Google AdWords Conversion Tracking?
', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('Yes', 'No'), ');
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 'Yes', 'No'), ')' at line 1
in:

I'm using the "future_zen" template and I've tried installing the google_analytics subdir under both the future_zen directory and the template_default directory.

No joy. Analytics is at least partially installed, as it is an option under configuration and google confirms that its working. This LOOKS like its a syntax error in the sql patch... not a problem with a file location...

HELP!

-Rob Shearer

[rgshearer]

Oddly enough, when I opened up the .sql file in notepad and copied and pasted the text into the "query to be executed" box, it ran fine... and installed all the new stuff.

Weird.

uploading the file from my local hard drive failed with the 1064 msg. Copying the SAME text from the .sql file into the box ran without error.

[scratching head...]

Whatever, now its working.

- rob shearer

[crabdance]

Oddly enough, when I opened up the .sql file in notepad and copied and pasted the text into the "query to be executed" box, it ran fine... and installed all the new stuff.

Weird.

uploading the file from my local hard drive failed with the 1064 msg. Copying the SAME text from the .sql file into the box ran without error.

[scratching head...]

Whatever, now its working.

- rob shearer

Hi Rob,

Sorry to hear that you are having issues too! At least you have things to the point where google says it's working. I can't even make it to that point yet. I'm going to go back over the many posts and see if I can find something that will make my code work. Wish me luck.

p.s. glad that you got it working!

[econcepts]

Oddly enough, when I opened up the .sql file in notepad and copied and pasted the text into the "query to be executed" box, it ran fine... and installed all the new stuff.

Weird.

uploading the file from my local hard drive failed with the 1064 msg. Copying the SAME text from the .sql file into the box ran without error.

[scratching head...]

Whatever, now its working.

- rob shearer

As you'll see by reading the forums, the best way to apply patches is to copy and paste the code into the Admin and run it that way (as you have done). The upload function doesn't always operate reliably.

Glad you got it working. :)