I discovered the reason.
execute the code of googlefroogle.sql will update some records in table configuration, so our web page can not display properley.
but I do not know how to solve it. anybody can help me?
Printable View
I discovered the reason.
execute the code of googlefroogle.sql will update some records in table configuration, so our web page can not display properley.
but I do not know how to solve it. anybody can help me?
I do not know what is the reason.
my zencart is v1.3.7 I have integrated with ultimate seo module.
after I installed GFF1.6.7
the webpage error. the infromation is below:
Quote:
Warning: Variable passed to each() is not an array or object in /home/public_html/includes/classes/db/mysql/query_factory.php on line 121
anybody can help me?Quote:
Warning: Division by zero in /home/mallmain/public_html/includes/classes/split_page_results.php on line 76
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 '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '136' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]
I have found the answer to our CRON problem which may just help others, even though it may just be something to do with our server.
The instructions for the CRON command show:
which failed consistently for us; however, simply adding single quotesCode:GET http://domain/googlefroogle.php?feed=yes&upload=yes&type=products
finally brought success.Code:GET 'http://domain/googlefroogle.php?feed=yes&upload=yes&type=products'
I think the requirement for the quotes is due to the multiple instructions within the command.
So, I completely removed all files and and uninstalled and then reuploaded all files and reinstalled sql and then it said:
thanks,Quote:
1062 Duplicate entry 'GOOGLE_BASE_ZERO_QUANTITY' for key 2
in......
Eric
I'm experiencing some problems with the feeder. I recently tried to upload a new feed but the feed was rejected because it was missing the UPC field. I turned on the auction feilds and now I get the following error:
I tried a upgrade to 1.6.8, but still get the error. Any idea what I need to do to get things working agian??PHP Code:
Google Base Feeder v.1.6.8 02.08.2008 22:33:59 started 2008/02/26 18:14:29
Feed file - /home/moesperf/public_html/feed/prommotion_moesperformance_com_products.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_upc' in 'field list'
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, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition, p.products_category FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.products_type = 1 OR p.products_type = 4 OR p.products_type = 2 OR p.products_type = 5 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_last_modified DESC]
I just wnated to see if there was an update or mod for this? I have GCO and still have to go in and modify each item to turn on GCO as a payment option to get the checkout badge to appear. When the feeder uploads to Google, it overwrites the configuration and I have to do it again. I'm sure that I am either overlooking something, or have not configured something right. Any help would be appreciated.
this is according to google:
If you'd like to use Google Base-hosted item pages and accept Google Checkout for items in a data feed, simply add "GoogleCheckout" as a payment option under the payment_accepted attribute. Don't include the link attribute. If you do, your listing will direct buyers to your website, instead of a Google Base-hosted page that displays the Google Checkout Buy button.
If you're already using Google Checkout on your website, include "Google Checkout" as a payment option under the payment_notes attribute. In this case, you should include the link attribute, as users will be directed to your Google Checkout-integrated website.
I am using the Level 2 Zen Google Checkout module. So the second statement should apply.
still getting this error please help
upload not working through my fireplace site. bathroom site works fine.
Warning: ftp_put() [function.ftp-put]: Transfer complete. in /home2/public_html/googlefroogle.php on line 547
Second attempt (passive mode on): Upload Failed
Still having issues with the feeder... This time I tried v1.6.10 on a FRESH install with no mods, same error:
Can someone please tell me whats going on?? I never knew how much froogle adds to our sales untill this :DPHP Code:
Google Base Feeder v.1.6.10 02.28.2008 12:13:59 started 2008/03/01 04:02:37
Feed file - /home/pmlcover/public_html/feed/pmlcovers_products.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_upc' in 'field list'
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, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition, p.products_category FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.products_type <> 3 AND p.product_is_call <> 1 AND p.product_is_free <> 1 AND pd.language_id = 1 ORDER BY p.products_last_modified DESC]
Install AUCTION SITE ATTRIBUTES to add the UPC and ISBN fields to your products admin page.
I have installed the newest version of google base feeder and configured it.
When I try to create the feed I get this error
can you tell me where I went wrong?Code:Warning: array_pop() [function.array-pop on line ]: The argument should be an array in /home2/shabecom/public_html/craft-patterns-online.com/googlefroogle.php158
many thanks
that got distorted in the quote box, should read:
Warning: array_pop() [function.array-pop]: The argument should be an array in /home2/shabecom/public_html/craft-patterns-online.com/googlefroogle.php on line 158
still getting the error, please someone help, i cant see an error on the code,
Google Base Feeder v.1.6.7 05.12.2007 12:53:59 started 2008/03/03 04:20:22
Feed file - /home2/fire/public_html/feed/google_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
First attempt (passive mode off): Upload Failed
Warning: ftp_put() [function.ftp-put]: Entering Passive Mode (72,14,200,3,50,75) in /home2/fire/public_html/googlefroogle.php on line 547
Second attempt (passive mode on): Upload Failed
Upload failed...
My FTP account isn't active yet, but when I try to upload the file manually, I get "We didn't understand the header (first) row of your file. Please make sure you're using valid attribute names."
Any ideas?
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
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.
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.
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
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:
and replace with the followingCode: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
}
Code: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
}
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.
NFM search the live code for
ftp_pasv($cd, true);
and/or
ftp_pasv($cd, false);
Actually...I had that backwards....I found the one that said false...I switched it to true and it still didn't work.
i know the live product engione is not as "stable" as the google base engine and there is offen a problem with uploading to microsoft not just through the admin but actally throught an ftp program like filezilla, ive tried a feu times through there online version and offen uploads have taken hours then failed, i belive its a problem with live.
ill install it again on my sites and see if i get an error. There is live support thread and will reply on there.
ive noticed reading through google base informaton on the google base site that you can upload ratings through an rss feed or uploaded files.
so if people leave a rating and review on my site and when i run my google base feeder do these ratings get passed to google and displayed???
If you open up googlefroogle.php, you can see all of the outputs that are included in the file.
Hi numinix
next time you stop by this thread could you please let me know why I receive this when creating the feed?
Warning: array_pop() [function.array-pop]: The argument should be an array in /home2/shabecom/public_html/craft-patterns-online.com/googlefroogle.php on line 158
thanks much!
I move my site to a new host and upgraded from 1.3.0 to 1.3.8a and changed templates I didn't know what verson of google-analytics I had so I down loaded a new install and did an upgrade this is what I get when I run the SQL upgrade.
What do it meam.
1062 Duplicate entry 'GOOGLE_CONVERSION_ACTIVE' for key 2
in:
[INSERT INTO zen_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.
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:frusty::frusty:
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:
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.Quote:
: 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¤cy=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
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.
Are you using MYSQL 5?
Numinix,
If that response was for me, I'm thinking it is version 5, I host with BlueHost and the information I obtained from the database page for this specific database is:
Now if that isn't what you need, please give me a hint at where to find the version of MySQL would be located.Quote:
Server version: 5.0.45-community-log
Protocol version: 10
Server: Localhost via UNIX socket
5.0.45-community-log
version comment MySQL Community Edition (GPL)
version compile machine x86_64
version compile os unknown-linux-gnu
wait timeout 60
Thanks.
Oh and if the response was not for me, please disregard this response.
Yes, mine is a version 5 - so does that mean this will be something I will be unable to use unless my host upgrades? Or does someone know how to work around this issue?Quote:
Numinix Posted: In ADMIN->SERVER VERSION you can see everything nicely laid out.
Anyways, seems to be bugs with MYSQL5.
It means a lot of scripts will have to be updated to use a different SQL query command. I'll look into it in the future but cannot say when.
my sites are running mysql 5 and ive got no problems!!
I just downloaded and installed the latest version 1.6.8, and my question is regarding the "sql updates" folder that came with the installation files. Am I supposed to install each sql updates in that folder? Or do I only install the one sql file that is outside of the folder: update_1_6_8.sql? It would seem that I'm supposed to install all of them otherwise why would they be included. But just want to make sure.
Thanks,
Brian
That depends, are you installing a fresh copy or upgrading from a previous version?
If you are upgrading, then you need to run the sql patches for all version between your old version and the new version. The patch outside of the previous_sql_patches folder is the current sql patch to upgrade from the version exactly previous to the current version (i.e. v1.6.7).
I love this contribution, but I'm having trouble getting it to work with Google base. I always get an "Upload Failed" message when I try to manually upload the output of googlefroogle.php indicating that something was wrong with the XML format.
Is anyone else having this problem?
Thanks!
I noticed that special characters (such as the German ä,ü,ö) are not processed when creating the XML file. The language is set to English, but some products and manufacturers names contain these characters.
They may have been removed as they will cause XML parsing errors.
UTF-Charachters don't cause parsing errors and a look at the german google base shows me it is supported.
I checkeded out the code and the following command on line 461 is the culprit:
A quick fix for umlauts would be something like:PHP Code:
$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?]", "", $str);
I'm testing this out, but there must be some easier way to filter out the "bad stuff" but still keep all the UTF-8 goodness.PHP Code:
$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?äÄöÖüÜß]", "", $str);
Sorry to bug you numinix about all the lanuage issues. I have the same thing as this person had, yet when I set the language to english only, it still parses out all the rest.
I checked the code andis set to 1, which is correct. However my XML file still contains all the other languages. Any tips?PHP Code:
$languages->fields['languages_id'];
I've made some minor changes in the latest version, hopefully it will make a difference.
I have installed this mod and I can't get the products to show up on google.
The SQL installed correctly and the google base tab shows up under tools in the admin.
When I create the feed it processes correctly and when I upload the feed it says it uploaded successfully. My feed folder has data in it.
What about the settings at google. Do I need to change the following:
Encoding
UTF-8 Latin-1
Delimiter
Tab (\t) Pipe (|) Tilde (~)
What should these be set to?
My web address is: https://myshop.internationalcoffeeandbeverage.com/secure
The file should be registered as .xml
In the feed file it is an .xml file but I'm having to go into my file system and copy the contents from within the folder, open notepad and save as a text file. I then manually upload to google. My products are getting published that way but I can't get them published using google base ftp from within the admin. It tells me the products upload ok but they never show up in google base. I have rechecked my ftp settings and all the settings are correct. I'm on a dedicated server and my host allows ftp transfers.
It sounds like you just need to tell google to expect an xml file rather than a txt file.
Ok, hopefully I can find some help with this...
I have version 1.6.8 installed and running (kinda)...
When I create a product feed all I get is a text file without any extension (not xml and no "_products.xml" on the end)
I have been making this work by calling the file "froogle.txt" and uploading that to Google...
But now they need the unique product ID in the file - I do have this turned on in the configuration, but it just won't show up in the text file... any ideas on what's going on? (the two problems may be related - but even if I can get the txt file to work would be great)
I am running zencart 1.3.8 - I have also uninstalled and reinstalled the mod to no avail - always get the same results...
Any help would be appreciated.
I use zencart1.38a, and Google Base Feeder 1.6.11,but I got this erorr
PHP Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /home/www/www.xxx.com/data/googlefroogle.php on line 452
Line 452 should be:
PHP Code:
$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "\t" => "", " " => "");
I found the problem, Google Base Feeder comflict with wordpress on zencart!
I finally got it work, but still have a question.
I set Compress Feed File to true, but the feed still show up in xml ext
When I set up a cron job to get the the googlefeeder file, I get this error:
Also, when I try to do the Create/Upload Feed through the zen cart admin, 90% of the time it'll do this:Quote:
500 EOF when chunk header expected
http://jitbid.com/images/googlefeeder1.JPG
to
http://jitbid.com/images/googlefeeder2.JPG
http://techawave.jitbid.com/techawave/googlefroogle.php
A word to the wise: Update Google Product Search (daily)
I have a catalog of products that hasn't changed much in a month or two. I've been busy on other projects. Because nothing changed i didn't update/submit froogle feed.
I used to be one of the first products listed for common searches. I go back and lo and behold I was DROPPED!
So, lesson learned. Do the cron job task mentioned on the admin page and this won't happen to you.
Postscript: I resubmitted after being dropped and all my reviews came back and it looks like my position was restored. I was re-listed about 24hrs after I resubmitted.
Live and learn!
ok. I have updated to the latest version of google feeder (11). And I am still having issues uploading. I can manually do it, but not from the web interface. Eventually I will cron job it.
When I upload products a pop-up window opens and reads:
Google Base Feeder v.1.6.11 03.27.2008 00:05:59 started 2008/04/02 07:52:42
Feed file - /home/content/i/n/k/inkuyo/html/feed/googlebasehd_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
in the lower left it is processing for a little bit, then reads done. Nothing ever uploads and I get no errors. Any ideas?
I have another question too. On another site I updated to the latest feeder and now only 269 products exported to my xml file instead of the over 1000 products. Any ideas?
The previous versions had duplicate products. The latest version will only ever use one products_id. Before products with attributes were showing up multiple times as identical duplicates since the feeder did not alter anything for the attributes. The change was added to help with timeouts since the duplicates are just eating up more of the cpu.
Hi...
I am based in the UK and have to display prices in google with TAX (Vat) added.
My output works fine but the price shown in the XML does not include TAX so from experience Google will kick the feed out.
I'm hoping I have an admin setting problem.
I can see from your coding in googlefroogle that you have worked on this.
Any idea what the problem might be...
I've fixed it by turning in admin > Config > My Store > display prices with tax to true.
I then had to turn it back to off after I had created the XML file.
Is there a VAT attribute for Google UK? If so you could use that to display the VAT percentage.
Ok Guys - i'm approaching this point at the minute....
:lamo:
I had an older version of the feeder installed which uploaded from the admin interface a text file to googlebase fine.
I decided to uninstall that older version and reinstall the latest version. It will create my feed for (currently) 388 products - no sweat.
The issue i'm having is when i click the upload bit. I have registered the feed with Gbase, as i had done before and given it a name of richtone_products.xml which matches the file generated in /feeds
The upload pop up window just goes white for a long period before giving me
Now, my server would allow me to upload a .txt file yesterday, so i'm assuming there should be no problem with uploading via admin an .xml file.Code:Second attempt (passive mode on): Upload Failed
Google Base Feeder v.1.6.11 03.27.2008 00:05:59 started 2008/04/04 14:26:55Feed file -
Upload failed...
Looking in googlebase it appears, as expected at this stage, that the "Last upload date & status" section just says "None".
Anything you can think of in case i've just not thought of something would be fantastic.
Bit gutted - worked a treat before and am giving myself a serious does of the if it aint broke don't fix it blues.
Thanks in advance guys
Rich
Which version were you using previously?
Looks like it's not even making the first attempt... with passive mode off.
i'm having some problems with the install...
first of all i installed the sql updates by mistake, before installing the googlefroogle.sql , and when i tried to install that now i get this error
under the Google Base Feeder Configuration, i have 3 things:Quote:
1062 Duplicate entry 'GOOGLE_BASE_ADDRESS' for key 2
in:
[INSERT INTO zcart_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Google Base FTP Username', 'GOOGLE_FROOGLE_USERNAME', 'ftp_username', 'Enter your Google Base FTP username', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base FTP Password', 'GOOGLE_FROOGLE_PASSWORD', 'ftp_password', 'Enter your Google Base FTP password', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Store Address', 'GOOGLE_BASE_ADDRESS', 'http://www.domain.com', 'Enter your website address', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Store Description', 'GOOGLE_BASE_DESCRIPTION', '', 'Enter a short description of your store', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Auction Site Attributes', 'GOOGLE_BASE_ASA', 'false', 'Activate Auction Site Attributes?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:
* now - add Adjust to current date;
* product - add Adjust to product date (max(date_added, last_modified, date_available))
', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'), (NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('), (NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'id', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'UPC\', \'ISBN\', \'false\'),'), (NULL, 'Show Quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Include Zero Quantity', 'GOOGLE_BASE_ZERO_QUANTITY', 'false', 'Include products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Shipping Options', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your default condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),'), (NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 13, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?
default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('), (NULL, 'Magic SEO URLs', 'GOOGLE_BASE_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'domain', 'Set the name of your froogle output file', @configuration_group_id, 19, NOW(), NULL, NULL), (NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL), (NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Tax Region', 'GOOGLE_FROOGLE_TAX_REGION', 'Tax applicable regions', 'Enter the tax region', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Show Tax Region', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display Tax Region?', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Max products', 'GOOGLE_FROOGLE_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Starting Point', 'GOOGLE_BASE_START_PRODUCTS', '0', 'Start at which entry (not product_id)?
Default=0', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Pickup', 'GOOGLE_FROOGLE_PICKUP', 'do not display', 'Local pickup available?', @configuration_group_id, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\', \'do not display\'),'), (NULL, 'Included Categories', 'GOOGLE_BASE_POS_CATEGORIES', '', 'Enter category names separated by commas
(i.e. computers,software,televisions)
Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Excluded Categories', 'GOOGLE_BASE_NEG_CATEGORIES', '', 'Enter category names separated by commas
(i.e. computers,software,televisions)
Leave blank to deactivate', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Show Weight', 'GOOGLE_BASE_WEIGHT', 'false', 'Include products weight?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Weight Units', 'GOOGLE_BASE_UNITS', 'pounds', 'What unit of weight measure?
pounds OR kilograms', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'pounds\', \'kilograms\'),'), (NULL, 'Product Type', 'GOOGLE_BASE_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, or full-path as product_type?', @configuration_group_id, 34, NOW(), NULL, 'zen_cfg_select_option(array(\'top\', \'bottom\', \'full\'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Google Base FTP Username
Google Base FTP Password
Google Base Server
i assume there are suppose to be other things here and that aren't.
unfortunately i didn't back up my database first for this (ughh, oops) but can anyone help me from here ?!
You may want to get a professional to remove the entries from the configuration table, or do it yourself.
All of the Google Base Feeder configurations start with GOOGLE_BASE or GOOGLE_FROOGLE
Use PHPMYADMIN.
In the main googlefroogle.php file (v1.33), copy the function ftp_file_upload() function towards the bottom of the script and replace the same function in the latest Google Base Feeder.
In my next version I will get rid of the automatic looping and instead add a feature so that the admin can choose PASV on or off.
Hi
Installed this great mod for the first time tonight here in the UK and think that I have followed everything to the last letter but when I try to upload the feed I get this:
Google Base Feeder v.1.6.11 03.27.2008 00:05:59 started 2008/04/07 00:03:19
Feed file - /home/ragdisk/public_html/feed/pleasuredisc_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Login failed:
Connected to: uploads.google.com
Upload failed...
I can't think that it is far away but please could you help me get it working?
Thanks
Rob
As an additional piece of info which may be related, I did upload the xml file manually to google (from within google) and although it says the upload was successful using this method if I click on the details link it shows a whole list of errors:
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
9
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
18
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
25
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
26
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
30
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
39
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
46
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
47
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
51
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
60
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
67
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
68
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
72
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
81
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
88
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
89
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
93
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
102
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
109
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
110
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
114
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
123
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
130
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
131
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
135
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
144
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
151
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
152
Any ideas??
:)
Rob
Rob
Hello from the UK too.
I think you may have 3 problems as I just solved the issues you had.
Firstly the file needs to be a .xml in the google base setup menu. Not .txt. If you make it a .txt then it will not be recognised and you will have loots of syntax errors reported.
Be careful if you rename a file to .xml from .txt I have had prob with it not 'really' being recognised as .xml ; so create it correctly first time.
I had issues with 'googlecheckout' errors ( my GCO is installed but not active - however GB feeder seems to want to include it anyway and it fails) so I did a search and replace for the GCO xml lines - quite simple.
finally even if you ask for the fine gooolebase.xml you may get products_gooblebase.xml. If you have registered google.xml as your feed, then the upload from zc will fail.
I still cannot get the upload to work from inside zc (the gco lines still have to be removed) but I did at last get a feed to work, and its better than doing it by hand !!!
Gary
Secondly the
I have looked but didn't find and answer yet.
From Tools->Google Base Feeder..
I can create the product feed. However, when I go to "view" the product feed.. it is empty. No title, no description...no products.
If I download the .xml file and open it in a text editor, I can see the data though.
Has anyone had this problem with Google Base Feeder.
I am using the latest version, but the old version wasn't working either.
thanks,
ok .. to add to my last post..
In my browser, the feed is empty.. no title no description nothing.
But, if I view source everything is there.. title, itmes, everything.
So it just isn't displaying in my browser.
Any ideas?
[FONT=Times New Roman]I just installed is contribution[/FONT]
[FONT=Times New Roman]Install seems to have went fine[/FONT]
[FONT=Times New Roman]My site has over 2000 products, but the feed only shows 380?[/FONT]
[FONT=Times New Roman]Is there a time out setting or something that I’m missing?[/FONT]
:frusty:
thanks
the total changes each time i run it!!??????
Timeouts are addressed in the documentation as well as about 100 times throughout the thread...
yes, I found the time-out setting in the docs, I guess I was hoping there was another cause, and solution to the problem. my sites are hosted on a shared server, and I do not think i have access to change those settings
:(
I just installedthe Google feed mod, set up my FTP info.
When I go into tools, Google Database Feeds and click in the links to upload a feed, a small window opens up but it is empty.
Wondering what I'm doing wrong.
Had to change the categories filter function as the original was not working - the foreach was falling over every time on the first integer in the array, only filtering for the category and none of the others.
Function inside the public_html/googlefroogle.php
Code:function numinix_categories_check($categories_list, $products_id, $charge) {
if ($categories_list == ''){
if ($charge == 1) {
return true;
} elseif ($charge == 2) {
return false;
}
}
else
{
$categories_array = split(",",$categories_list);
reset($categories_array);
while (list(, $category_id) = each($categories_array)) {
if (zen_product_in_category($products_id, $category_id)) {
return true;
return false;
}
}
}
}
Whatup people thanks for all your help...I noticed on http://www.numinix.com besides Google Base Feeder, there is also the RSS Feed module.
Can the RSS Feed module be used to add products to google base as well as other sites that take product fees by RSS?
If I can just install that, then that's the way I think I"d like to go.
Thanks!
No the RSS Feed module does not support Google Base, nor does it create an exported file for uploading.
I installed this about 3 months and has been running smoothly. Now I am also getting these errors. Is this because of the above code change?
PHP Code:
Error Bad data Line #
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
18
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
33
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
108
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
273
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
378
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
393
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
618
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
723
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
873
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
888
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
903
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
978
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1233
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1248
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1314
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1653
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1683
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1713
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1743
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1758
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1803
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1953
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2028
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2133
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2253
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2268
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2283
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2328
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2343
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2613
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2628
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2643
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2658
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2673
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2688
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2718
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2838
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2853
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2868
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2883
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2898
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2919
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2928
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2934
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2943
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2949
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2958
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2964
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2973
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2979
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
2988
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3009
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3018
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3024
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3033
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3039
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3048
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3054
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3063
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3078
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3093
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3108
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3243
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3258
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3288
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3348
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3588
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3603
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3663
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3693
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3723
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3753
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
3813
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4008
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4293
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4563
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4638
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4653
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4668
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4713
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4728
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4758
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4788
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4818
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4908
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4923
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5118
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5358
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5478
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5493
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5508
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5523
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5703
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5718
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5778
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5853
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5868
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
5883
We didnt understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
No, but you should be using the latest version regardless:
http://www.numinix.com/index.php?mai...roducts_id=756
I’m at the latest version
I Create Product Feed
It finished with out any errors
Google Base File Complete In 42.681044 Seconds 3130 Records
I upload it to google, with no error, but it only shows Processed:380
?????