Google Base Feeder Support Thread [OLD]

[mfreund]

any news on my issue?

[kelvyn]

WARNING: There is a conflict between Query Cache 1.6 (download / official forum / zen support thread) and Google Base Feeder ( download / official forum / zen support thread )

It took quite a few hours as well as support tickets to my host who gave up in the end! But starting from a clean install this morning, and putting things back one by one, I've arrived at the answer this afternoon :)

Anyway, when Query Cache is installed, and when trying to generate a product feed for Google, the error is:

Google Base Feeder v1.7.4 started 2009/05/06 01:04:05
Feed file - /home/xxx/public_html/party-store/feed/frolic_base_products.xml
Processing: Feed - Yes, Upload - No
0 
in:
[select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from products_attributes where products_id = '3820' and attributes_display_only != '1' and attributes_price_base_included='1' and options_values_price > 0 order by options_id, price_prefix, options_values_price]
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = '6937d0f20ee9cbdec967fbc59e8ff2a0']

and sometimes it also says:
2008 MySQL client ran out of memory

Given that Query Cache is so good for the customer side, is it OK just to either remove it from the admin side, or somehow tell the Google Froogle (Base) feeder no to use it?
Thanks!

[countrycharm]

WARNING: There is a conflict between Query Cache 1.6 (download / official forum / zen support thread) and Google Base Feeder ( download / official forum / zen support thread )

It took quite a few hours as well as support tickets to my host who gave up in the end! But starting from a clean install this morning, and putting things back one by one, I've arrived at the answer this afternoon :)

Anyway, when Query Cache is installed, and when trying to generate a product feed for Google, the error is:

Google Base Feeder v1.7.4 started 2009/05/06 01:04:05
Feed file - /home/xxx/public_html/party-store/feed/frolic_base_products.xml
Processing: Feed - Yes, Upload - No
0 
in:
[select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from products_attributes where products_id = '3820' and attributes_display_only != '1' and attributes_price_base_included='1' and options_values_price > 0 order by options_id, price_prefix, options_values_price]
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = '6937d0f20ee9cbdec967fbc59e8ff2a0']

and sometimes it also says:
2008 MySQL client ran out of memory

Given that Query Cache is so good for the customer side, is it OK just to either remove it from the admin side, or somehow tell the Google Froogle (Base) feeder no to use it?
Thanks!

I had query cache installed a while back but I ran into some problems with it with other modules. You are right about it conflicting with goggle_base also. I installed query cache to see if I would get the same error message and it showed the same error. I don't use query cache no longer so I can not help you there. I do use Simple Cache which does about the same thing and it does not conflicts with google_base.

[kelvyn]

I had query cache installed a while back but I ran into some problems with it with other modules. You are right about it conflicting with goggle_base also. I installed query cache to see if I would get the same error message and it showed the same error. I don't use query cache no longer so I can not help you there. I do use Simple Cache which does about the same thing and it does not conflicts with google_base.

Thanks for the info - although, the words "simple cache" are like a bad joke in my head now - anything but simple! I'll try again to figure out the instructions in the morning. Meanwhile, for anyone wanting to remove Query Cache:

rm admin/includes/auto_loaders/config.query_cache.php
rm admin/includes/classes/query_cache.php
rm admin/includes/classes/db/mysql/query_factory.php
rm admin/includes/extra_configures/query_cache.php
rm includes/auto_loaders/config.query_cache.php
rm includes/classes/query_cache.php
rm includes/classes/db/mysql/query_factory.php
rm includes/extra_configures/query_cache.php
rm includes/functions/functions_categories.php

then replace from original Zen install files:

includes/classes/db/mysql/query_factory.php
includes/functions/functions_categories.php
admin/includes/classes/db/mysql/query_factory.php

Hope this helps someone!