Google Base Feeder Support Thread [OLD]

[ceegeeaar]

kitcorsa -

We had similar and found that altering the code, so passive mode was attemtped before port mode, allowed it to connect ok. It is the same with LPS feeder. I think it's just a firewall issue with the host.

Claire

[kitcorsa]

how do i change this???

i have contacted my hosts regarding this but no change yet.

i have 2 site as seen in my siggy and both on the same host and have there own seporate server. one site works one dont!! its really anoying having to manually upload.

[LaserGecko]

I've installed the .10 version. Still the same trouble with a manually uploaded file, however I am awaiting the results on the FTPed version.

Suddenly, it's not excluding my Gift Certificates category. The previous version was.

[ceegeeaar]

I posted on it before, have a look here..

http://www.zen-cart.com/forum/showth...aar#post445905

It is pretty much the same code in lps.php for the live product feeder ftp secion.

Hope it helps you!
Claire

[kitcorsa]

that worked Claire thank you very much.

update!

to turn passive mode on and off in the current version of google base on on lines 540 - 545 find the code:

		while ($attempt < 3 && !$success) { // two attempts, one with pasv off, one with on
			if ($attempt == 0) {
				ftp_pasv($cd, false); // on first attempt, turn pasv off
			} else {
				ftp_pasv($cd, true); // on second attempt, turn pasv on
			}

and replace with the following

		while ($attempt < 3 && !$success) { // two attempts, one with pasv off, one with on
			if ($attempt == 0) {
				ftp_pasv($cd, true); // on first attempt, turn pasv on
			} else {
				ftp_pasv($cd, false); // on second attempt, turn pasv off
			}

[NFM]

ceegeear

I just opened up lps.php and there is no code in there like that at all. I'd love to get this thing fixed but I can't find anything like that at all in there.

[kitcorsa]

NFM search the live code for

ftp_pasv($cd, true);

and/or

ftp_pasv($cd, false);

[NFM]

NFM search the live code for

ftp_pasv($cd, true);

and/or

ftp_pasv($cd, false);

I've found the first one....but I don't know what to do from there.

[d.bell222]

Hi there hope somone can help me.
i am trying to find how to install Base feeder.
I don't seem to be able to find any were.
Could someone help with a link or instructions.
It really getting fustrating.
Thanks

[SaMortensen]

I hope that someone can help me with this error message. I just installed the Froogle feeder and got this error message - or at least I assume it is an error:

: SQL error Unknown column 'p.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.knotnbauble.com/index.php?main_page=',pt.type_handler,'_info&currency=USD&products_id=' ,p.products_id) AS product_url, p.products_model AS prodModel, p.products_weight, p.products_type, m.manufacturers_name AS mfgName, m.manufacturers_id, p.products_id AS id, pd.products_name AS name, pd.products_description AS description, p.products_status AS prodStatus, FORMAT( IFNULL(s.specials_new_products_price, p.products_price),2) AS price, p.products_image AS image_url, pc.categories_id AS prodCatID, c.parent_id AS catParentID, cd.categories_name AS catName FROM zen_categories c, zen_categories_description cd, zen_products p, zen_products_description pd, zen_products_to_categories pc left join zen_manufacturers m on ( m.manufacturers_id = p.manufacturers_id ) left join zen_specials s on ( s.products_id = p.products_id AND ( (s.expires_date > CURRENT_DATE) OR (s.expires_date = 0) ) ) left join zen_product_types pt on p.products_type = pt.type_id WHERE p.products_price > 0 AND p.products_id=pd.products_id AND p.products_id=pc.products_id AND pc.categories_id=c.categories_id AND c.categories_id=cd.categories_id ORDER BY p.products_id ASC

I did change the "Manufacturer" name in the appropriate file so that it would show as "Artisan" on the main page but I don't know if that is why this error occured as I see there is a bunch of other stuff there that I can't even begin to understand.

Is there someone out there that does?
Thanks!

*In addition:
I did try to change the 'p.manufacturers_id' to 'p.artisans_id' in the froogle.php file just to see if it made a difference and it just gave me the same error only with 'p.artisans_id' as the error.