HELP! Site Down!

**Jeff_Mash** · 11 Sep 2007, 04:37 PM

Just tried to install the Simple Google Analytics add-on. Now the site is down. Reverted files and database back to previous version before the add on, but it's still getting the following errors:

(Seen when going to homepage HERE)

Warning: Variable passed to each() is not an array or object in /home/mjmmagic/public_html/store/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/mjmmagic/public_html/store/includes/classes/db/mysql/query_factory.php:114) in /home/mjmmagic/public_html/store/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/mjmmagic/public_html/store/includes/classes/db/mysql/query_factory.php:114) in /home/mjmmagic/public_html/store/includes/classes/seo.url.php on line 1247

Warning: Cannot modify header information - headers already sent by (output started at /home/mjmmagic/public_html/store/includes/classes/db/mysql/query_factory.php:114) in /home/mjmmagic/public_html/store/includes/classes/seo.url.php on line 1248

Warning: Cannot modify header information - headers already sent by (output started at /home/mjmmagic/public_html/store/includes/classes/db/mysql/query_factory.php:114) in /home/mjmmagic/public_html/store/includes/init_includes/init_templates.php on line 78

Warning: Cannot modify header information - headers already sent by (output started at /home/mjmmagic/public_html/store/includes/classes/db/mysql/query_factory.php:114) in /home/mjmmagic/public_html/store/includes/classes/seo.url.php on line 1247

**Jeff_Mash** · 11 Sep 2007, 04:39 PM

Do I need to clear some cache or something?

**Jeff_Mash** · 11 Sep 2007, 04:44 PM

Those errors posted above load on the top of the website.......the main content loads this on the main page:

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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLA
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20070911 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

**Jeff_Mash** · 11 Sep 2007, 05:05 PM

This definitely has to do with database caching. If I change the SQL_CACHE_METHOD from database to none in the configure.php, it works.

So how do I flush the SQL cache? I already went through phpMyAdmin and emptied the zen_db_cache table with no improvements.

**Jeff_Mash** · 11 Sep 2007, 05:09 PM

Here is the exact SQL file we ran through the admin which caused all of this. Let me know if it gives you any hints as to what could have messed this all up.

NOTE: Right now, we are still running with no cache in the configure.php because it's the only way to get it to work. We want to change this value back to "database" but we can't because of the errors mentioned above.

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;

INSERT INTO configuration_group VALUES ('', 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

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

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'This number is the unique id you were given by Google when you registered for your Google Analytics account. For more hints and tips on how to use Google Analytics to increase sales from your store, visit <a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a> Enter your Google Analytics account number (starting with the "UA-") in the space provided below. ', @t4, 1, NOW(), NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'This element is used in conjunction with Google E-Commerce Tracking. It indicates how you want your "transactions" to be identified in your Analytics reports. Addresses consist of City,State, and Country. This information can help you determine locality of orders placed, shipped to, or billed to. For more hints and tips on how to use Google Analytics to increase sales from your store, visit <a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a> Which address type do you want to use for recording transaction information? ', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''customers'', ''delivery'', ''billing''),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'This optional tracking element is used in conjunction with Google E-Commerce Tracking. The Affiliation tag describes the affiliating store or processing site. It can be used if you have multiple stores (or web sites) in various locations and is used to track from which location a particular sale originated. For more hints and tips on how to use Google Analytics to increase sales from your store, visit <a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a> If you have one, enter your optional partner or store affiliation in the space provided below. ', @t4, 3, NOW(), NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'This tracking element is used in conjunction with Google Analytics E-Commerce tracking. It enables you to track which products perform better than others using either the Product ID, or the Product Model Number as a unique identifier. For more hints and tips on how to use Google Analytics to increase sales from your store, visit <a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a> Indicate which identifier you want to use to track product performance by selecting one of the options below.', @t4, 4, now(), now(), NULL, 'zen_cfg_select_option(array(''products_id'', ''products_model''),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate Conversion Tracking', 'GOOGLE_CONVERSION_ACTIVE', 'No', 'This element enables you turn on or off Google Conversion Tracking. Please Note: Conversion tracking is used to track the effectiveness of Google AdWords paid search campaigns. If you are not running any paid search campaigns, then you should leave this set to "No". If you are running Google AdWords (paid search) campaigns, then turning this on will place the proper conversion tracking code on your checkout success page and enable you to start tracking conversions. Turning this on requires you to enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" number shown in the next section. For more hints and tips on how to use Google Analytics to increase sales from your store, visit <a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a> Do you want to turn on Google AdWords Conversion Tracking? ', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), ');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Google AdWords Conversion Tracking Number', 'GOOGLE_CONVERSION_IDNUM', 'XXXXXXXXXX', 'If you activated Conversion Tracking in the previous section, then you must enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" shown in the space provided below. If you have activated Conversion Tracking, and do not enter your number below, tracking will not work. For more hints and tips on how to use Google Analytics to increase sales from your store, visit <a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a> Enter your AdWords Conversion Tracking ID Number below.', @t4, 6, NOW(), NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Google AdWords Language', 'GOOGLE_CONVERSION_LANG', 'en_US', 'Select the language to be used. The default is "English US". For more hints and tips on how to use Google Analytics to increase sales from your store, visit <a href="http://www.zencartoptimization.com" target="blank">ZenCartOptimization.com</a> Select your language below ', @t4, 7, NOW(), NOW(), NULL, 'zen_cfg_pull_down_google_languages(');

#################################################################
# Add Table for Language support with Google Conversion Tracking.
#################################################################
#
# Table structure for table 'google_analytics_languages'
#

DROP TABLE IF EXISTS google_analytics_languages;
CREATE TABLE google_analytics_languages (
languages_id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
code char(10) NOT NULL default '',
sort_order int(3) default NULL,
PRIMARY KEY (languages_id),
KEY idx_languages_name_zen (name)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Add data to new google language table
#

INSERT INTO google_analytics_languages VALUES ('','Chinese (simplified) - ???','zh_CN',1);
INSERT INTO google_analytics_languages VALUES ('','Chinese (traditional) - ???','zh_TW',2);
INSERT INTO google_analytics_languages VALUES ('','Danish - Dansk','da',3);
INSERT INTO google_analytics_languages VALUES ('','Dutch - Nederlands','nl',4);
INSERT INTO google_analytics_languages VALUES ('','English (Australia)','en_AU',5);
INSERT INTO google_analytics_languages VALUES ('','English (UK))','en_GB',6);
INSERT INTO google_analytics_languages VALUES ('','English (US)','en_US',7);
INSERT INTO google_analytics_languages VALUES ('','Finnish - suomi','fi',8);
INSERT INTO google_analytics_languages VALUES ('','French - Français','fr',9);
INSERT INTO google_analytics_languages VALUES ('','German - Deutsch','de',10);
INSERT INTO google_analytics_languages VALUES ('','Hebrew - ???','iw',11);
INSERT INTO google_analytics_languages VALUES ('','Italian - Italiano','it',12);
INSERT INTO google_analytics_languages VALUES ('','Japanese - ???','ja',13);
INSERT INTO google_analytics_languages VALUES ('','Korean - ???','ko',14);
INSERT INTO google_analytics_languages VALUES ('','Norwegian - Norsk','no',15);
INSERT INTO google_analytics_languages VALUES ('','Polish - polski','pl',16);
INSERT INTO google_analytics_languages VALUES ('','Portuguese (Brazil) - Português (Brasil)','pt_BR',17);
INSERT INTO google_analytics_languages VALUES ('','Portuguese (Portugal) - Português (Portugal)','pt_PT',18);
INSERT INTO google_analytics_languages VALUES ('','Russian - ???????','ru',19);
INSERT INTO google_analytics_languages VALUES ('','Spanish - Español','es',20);
INSERT INTO google_analytics_languages VALUES ('','Swedish - Svenska','sv',21);
INSERT INTO google_analytics_languages VALUES ('','Turkish - Türkçe','tr',22);

# --------------------------------------------------------

**Jeff_Mash** · 11 Sep 2007, 05:15 PM

This problem seems uncannily similar to the following bug report:
http://www.zen-cart.com/forum/showth...y.php+line+114

Although I don't understand how I can revert the database and files back to their previous versions and this error still persists. Any ideas?

**DrByte** · 11 Sep 2007, 10:30 PM

Looks like you've sorted it out ?

**econcepts** · 13 Sep 2007, 05:20 PM

I just happen to see this post here and wanted to quickly reply.

I have had the exact same issue when trying to install the Recover Carts module on a few sites (the new version) as well as one other mod.

Due to this, it doesn't look to be a direct result of the contribution itself (Simple Google Analytics), nor any other contribution as such, but rather a result of the database caching in 1.3.6 + that caused it.

Does that sound accurate to you Dr Byte?

**DrByte** · 13 Sep 2007, 05:50 PM

Definitely the caching issue. On a site with a lot of installed contributions, the caching of the configuration table entries was busting out the seams of the caching table in the database.

The fix is here:
http://www.zen-cart.com/forum/showth...357#post378357

**Brent2** · 5 Oct 2007, 02:29 AM

I have been using the analytics contrib for months now, and its been great. But I have just started an affiliate campaign with clixgalore.com and inserted their tracking code which was written for zencart.

But the test transaction is not being tracked. And I see an error at the bottom of my browser. When I click on it, it says:

Line: 25
Char: 1
Error: 'Total_Cost' is undefined
Code: 0
URL: https://my-website-inserted-here.com/cart/index.php?

Of coarse "my-website-inserted-here" has my actual website name inserted.

It seems that the analytics is preventing the tracking. I didn't see any error before. The best case scenario would be for me to keep the analytics code. So a fix would be great.
But also, in order to test things further, I would like to delete it to see if that helps with the affiliate code.
I removed the analytics from tpl_main_page, ran a transaction, but I still see the same error as above. Where is the code coming from and how do I delete it?
I thank you in advance any help you can give to the above questions.
Brent