Simple Google Analytics - Support

[econcepts]

Alan,

Which SQL patch are you using? There is one for "upgrading only", and one for "new (fresh) installs".

Let me know that and I'll take a look at that SQL syntax.

I've tested both here on a similar platform, and it works fine.

Again, let me know which patch you are using so I can look at that file.

Thanks!

By the way, the only report I have heard of (with SQL syntax in general) from PHP 4.x to 5.x is that in some cases, 5.x does not like items qualified as such '' and would rather them come across as 'NULL'.

That shouldn't be an issue with you though as you are on a 4.x version (and I have only heard it on a few 5.x version installs).

[alan_powerbrixx]

Eric,

Thanks for looking at this. Being a new install, I'm using the googleanalytics.sql file, using Admin > Tools > Install SQL Patches, and clicking Browse next to Upload File to browse to this file on my local disk. After that, the Upload button brings me to the error noted in the previous post.

[econcepts]

Alan,

Can you copy and paste the contents of the SQL patch into the Admin and run it that way (rather than upload).

Let me know how that works while I look into this one. I have a feeling that the upload function may be choking on a few of the quotes that are in the copy.

[econcepts]

Alan,

Ok, got it. Go ahead and download this version here (I'll upload later this eve to the Contribs section).

All I did was alter part of one of the lines for the SQL Syntax on the two files.

This should work for uploading and installing now. Let me know if you have any problems.

Thanks!

[alan_powerbrixx]

Yes, thank you, Eric,

That ran just fine. I got the message "39 statements processed", and now all the expected settings for Google Analytics including the conversion settings appear on the configuration menu.

Now I'll dive in and try setting it up. But since my GA account is already receiving data from my hand-inserted version, I probably won't know anything until I put it into production and wait to see if I continue to get the usual level of data. I'll also try a "Check Status" in GA, but I don't know if that will tell me anything at this point.

Again, many thanks!

[econcepts]

Great. Glad to hear that Alan. Yes, 39 Statements is correct for that patch.

I uploaded a patched version the other night to the Contributions section (with the only change being the updated SQL query).

[barricades]

Hi I wonder if anyone can offer me some suggestions.

I've installed the files and uploaded the sql patch as per the instructions (the only thing i did different was to rename the your_template folder and although it doesn't seem to say to do this in the read-me i've read elsewhere that i was right to do this)

The 39 statements thing appears when i ran the patch.

only thing is that no configuration->google analytics configuration appears in the config menu in my admin.

any ideas what is wrong. I've done everything else as far as i can see in the instructions.

Thanks by the way for the mod (hopefully i get it working :-) )