Printable View
Quote:
Originally Posted by ccn1
How many seconds did the feed generation run for?
30 seconds is usually the minimum timeout on a server - but you should manage a lot more than 1444 products in 30 seconds.
Take a look in your admin->tools->server info and search for 'timeout' - see what is set and report back.
Hey Pixxi,
Thanks for the reply, I have had a look and found the following related to timeout:
Timeouts Connection: 300 - Keep-Alive: 15
Keep-Alive timeout=15, max=100
mysql.connect_timeout 60 60
default_socket_timeout 60 60
Is this what you meant ?
Thanks
Chris
I was having issues with mine as well. I solved my googlefroogle timeout problem by making changes in my php.ini configuration file to the following:
max_execution_time = 300
max_input_time = 90
memory_limit = 32M
Just installed the Froogle Feeder onto a new Zen install. Everything went smoothly with no errors or anything.
When I create my feed I get this:
Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/03/01 12:51:37
Feed file - /home/bhstore/public_html/feed/froogle.txt
Processing: Feed - Yes, Upload - No
and my froogle.txt is empty. Also I noticed that no ending time is listed which I have seen in other posts.
Would this mean that the process is timing out? Store has close to 7500 products listed so I could understand if this is the case. I do have access to my php.ini file but would not know which settings to adjust.
Any assistance would be greatly appreciated.
Please help.
I’m running ZC 1.3.7 after installation of your GoogleFroogle feed module I'm missing step 4. Go to Admin->Tools>Google Froogle Feeder; completely. I do not have GoogleFroogle feeder under my tools menu at all. I did install all the patches and then googlefroogle.sql I also moved all the other files in my store's root directory.
Your help is much appreciated.
Thanx in advance.
Mike.
ITGuru, I just installed it and the menu came up.
However I had to make sure that all the files installed. I don't know why they didn't just ftp as normal but they didn't.
Check the admin files as well. Ftp from the contribution folders.
Now I have a problem with the sql part of the install, I'll do a new post on it.
I'm getting the following error. Any ideas?
Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/03/01 18:09:55
Feed file - /home/birdoasi/public_html/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
Processing: Feed - Yes, Upload - 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 'ORDER BY p.products_id ASC' at line 10
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id ASC]
My php.ini is already has these settings, still no luck.Quote:
Originally Posted by BlessIsaacola
I thought I figured out my problem.
I installed the update 1.3.3.sql file instead of the googlefroogle.sql file. Duh!
So I tried the uninstall.sql and it seemed to work, but when I try to install the googlefroogle.sql flie I get that dang 1064 error again.
There's an 'uninstall.sql' file in the mod - make a note of your Froogle settings then run that via phpmyadmin (or whatever SQL client you're using).
Then run the full googlefroogle.sql install.
Then report back.