Simple Google Analytics - Support

[surf7.net]

Dear developer of this excellent mod,

Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0

The effected keys are

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Deletion of above keys will effect the proper functionality of Zen Cart.

[econcepts]

Dear developer of this excellent mod,

Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0

The effected keys are

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Deletion of above keys will effect the proper functionality of Zen Cart.

Thanks and glad you like the mod, however, you are incorrect in your thinking.

It appears you are not reading or understanding the SQL language provided in the install correctly.

If you look at the SQL code closely, you'll notice that the configuration group id variable is set during the SELECT statement, and is set to the specific value "WHERE configuration_group_title= 'Google Analytics Configuration';".

That group id differs between sites and the variable is set as such to properly remove the correct configuration values as needed (and if present).

A number of contributions use this same logic as it provides a means for users to install a module into an "open slot" without conflicting with other configuration group ids on their system.

This module is in use by myself on many sites, and thousands of other Zen Cart users (look in the downloads section) without any problems relating to "proper functionality of Zen Cart."

In fact, just to be sure, I tested your concept (I always test), and the patch works just fine without deleting the configuration keys you mentioned above. :)

[surf7.net]

Thanks and glad you like the mod, however, you are incorrect in your thinking.

It appears you are not reading or understanding the SQL language provided in the install correctly.

If you look at the SQL code closely, you'll notice that the configuration group id variable is set during the SELECT statement, and is set to the specific value "WHERE configuration_group_title= 'Google Analytics Configuration';".

That group id differs between sites and the variable is set as such to properly remove the correct configuration values as needed (and if present).

A number of contributions use this same logic as it provides a means for users to install a module into an "open slot" without conflicting with other configuration group ids on their system.

This module is in use by myself on many sites, and thousands of other Zen Cart users (look in the downloads section) without any problems relating to "proper functionality of Zen Cart."

In fact, just to be sure, I tested your concept (I always test), and the patch works just fine without deleting the configuration keys you mentioned above. :)

I have run this code again in phpmyadmin

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Google Analytics Configuration';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

and it indeed deleted:

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX
IH_VERSION (from Image Handler Addon)

My MYSQL version is 5.0.21 and the phpmyadmin is 2.8.1

I have run it again in MYSQL 4.1.22 and phpMyAdmin - 2.10.0.2. still the same problem.

Please note that, if run the above code in a database that has "Google Analytics Configuration" in configuration_group table, then the above will only delete the keys in configuration table with configuration_group_id equals to the Google Analytics configuration group ID.

OK I lost myself there.... anyway, the point is: if you run the above code for new installation of Google Analytics, then it will delete the 4 keys mentioned above.

Did you test run the code on a database already has Google Analytics installed?

I have reported this problem to other addon developer as well. So far, I managed to discover these addons are effected:

Google Sitemap
GOOGLE BASE FEEDER
Testimonials Manager
RSS Feed

Some have already releasing a fixed.

[econcepts]

Surf7,

By the way. I went to your site, and looked at your "Malaysia E-Commerce Solution". Then looked at your demo site at http://demo.easyweb.com.my/.

I noticed that no where on your "E-Commerce solution" services page nor on the Demo site do you give credit to or even mention the cart is Zen Cart.

If you are going to be using Zen Cart as your "e-commerce solution", I would recommend giving them credit where credit is due and not masking it as if it was your own custom solution. A lot of hard work goes into this cart through the great community of developers, and a lot of users spend a great deal of time making sure it works for others. It's only right to give credit to the team that created it and not make it look like it is your own.

Just a thought.

[surf7.net]

Surf7,

By the way. I went to your site, and looked at your "Malaysia E-Commerce Solution". Then looked at your demo site at http://demo.easyweb.com.my/.

I noticed that no where on your "E-Commerce solution" services page nor on the Demo site do you give credit to or even mention the cart is Zen Cart.

If you are going to be using Zen Cart as your "e-commerce solution", I would recommend giving them credit where credit is due and not masking it as if it was your own custom solution. A lot of hard work goes into this cart through the great community of developers, and a lot of users spend a great deal of time making sure it works for others. It's only right to give credit to the team that created it and not make it look like it is your own.

Just a thought.

Hi econcepts,

Please look properly at the bottom of left side bar of...

http://www.surf7.net/services/ecommerce/index.php
http://www.surf7.net/services/ecommerce/pricing.php
http://www.surf7.net/services/ecommerce/demo.php
http://www.surf7.net/services/ecommerce/client.php
http://www.surf7.net/services/ecommerce/order.php
http://www.surf7.net/services/ecommerce/resources.php

It has Powered by [ZEN CART logo]

There is no requirement that I must put link to Zen Cart on every web store I created. However if view the source code, you can see...

<meta name="author" content="The Zen Cart&trade; Team and others" />
<meta name="generator" content="shopping cart program by Zen Cart&trade;, http://www.zen-cart.com eCommerce" />

To view source code of any web page, please follow these steps.

1. In Mozilla Firefox, go to View > Page Source or Ctrl + U
2. In Internet Explorer 7, go to Page > View Source

Please note that I am not selling Zen Cart but rather selling support services. I am not sure how do you come to conclusion that I am masking it as if it was my own custom solution. All my customers will see Zen Cart logo smack right on the top left when they login to their admin.

FYI, I did contribute to Zen Cart with my fair share of contributions. I also help out in discovering errors made my other developers like you. I hope you are not offended that I pointed out your errors. If you do, please let me know and I will not announce it in the forum.

Anyhow, great products.

P/S - If you discover errors in my contributions, please point it out to me. I'll be more than happy.

[econcepts]

No harm meant surf7, and thanks for your contributions to the community. :)

I also appreciate when errors in contributions are pointed out as that is one way of making the whole Zen Cart software better for all of us.

I just wanted other users to know that the error you pointed out in your original post is not an error at all and in fact the SQL syntax works just fine as is. It causes no issues with deleting improper key values from the core of zen cart stores.

I tested it before release, and just tested it again here before I posted the reply to make sure that is the case. If there was an error in the code, I certainly would correct it, however in this case there was none.

See you round the forums!

[surf7.net]

It causes no issues with deleting improper key values from the core of zen cart stores.

You mean these three keys PRODUCTS_OPTIONS_TYPE_SELECT, UPLOAD_PREFIX, TEXT_PREFIX are not deleted when you run the sql patch?

[econcepts]

You mean these three keys PRODUCTS_OPTIONS_TYPE_SELECT, UPLOAD_PREFIX, TEXT_PREFIX are not deleted when you run the sql patch?

Nope. Not at all. :)

Just for kicks. Tried it again here a third time, and they are not deleted. :)

[rhutchison]

My checkout success page is throwing out the following error in the footer:

Warning: main(includes/templates/patiotoys/checkout_success//google_analytics.php) [function.main]: failed to open stream: No such file or directory in /home/rhutchis/public_html/includes/templates/patiotoys/common/tpl_main_page.php on line 201

Warning: main(includes/templates/patiotoys/checkout_success//google_analytics.php) [function.main]: failed to open stream: No such file or directory in /home/rhutchis/public_html/includes/templates/patiotoys/common/tpl_main_page.php on line 201

Warning: main(includes/templates/patiotoys/checkout_success//google_analytics.php) [function.main]: failed to open stream: No such file or directory in /home/rhutchis/public_html/includes/templates/patiotoys/common/tpl_main_page.php on line 201

Fatal error: main() [function.require]: Failed opening required 'includes/templates/patiotoys/checkout_success//google_analytics.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rhutchis/public_html/includes/templates/patiotoys/common/tpl_main_page.php on line 201

I have gone back through the installation notes and, as near as I can tell, I have everything configured correctly. I'm collecting data in Analytics, I'm just having this problem with checkout_success

I'm running ZC 1.3.7 and the body tag for tpl_main_page is:

<body id="<?php echo $body_id . 'Body'; ?>"<?php if($zv_onload !='') echo ' onload="'.$zv_onload.'"'; ?>>

The included code at the bottom of tpl_main_page is:

<?php
require($template->get_template_dir('.php',DIR_WS_TEMPLATE, $current_page_base,'google_analytics') . '/google_analytics.php');
?>

The error tells me that this last bit of code is not picking up the fact that's it needs to look in the templates/patiotoys/google_analytics directory for the file.

I have an override directory with templates/patiotoys/checkout_success/tpl_footer.php that I need for my JAM affiliate software, which is likely the culprit.

One solution would be to copy the google_analytics.php file to a directory that the code at the end of tpl_main_page is looking in, but that seems a bit kludgey. Is there an elegant code solution for this?

Thanks,

Roger

[retrobec]

Hi, I'm trying to install the Simple Google Analytics right now. I've gotten through all the steps up until the install of the SQL patch. I'm in the Admin SQL Query Executer and am not sure how to actually do it. It wouldn't let me just upload the file you provided, so do I copy and paste the whole SQL document into the query frame, then hit send? I'm afraid to mess something up. I would really appreciate some further instructions.
Thanks!
-Becky