Printable View
I've just checked my feed file with a text editor and the dates are showing correctly as 2006-10-19. How are you looking at your feed file? Eg. if you load it into Excel, Excel will change the date.
Have you looked in your Google Base admin to see if you have an error with any of the products in your feed?
Well I have two sites and the Flag one goes through perfectly..
My Suchatees one says it creates the txt file with no errors.. When i try to upload it to google, it says succesful, yet it doesnt show up on Google.. Then i tried to physically go in and add it to google using the upload feature and it says it uploaded fine, but when I wait a while and go back there, there is nothing, no date, no rejection, no items.. nothing..
If you look at your feed file with a text-editor (after generating it), are the dates correct?
Once you've uploaded a feed it can be a while before Google shows/processes it.
Are there any errors showing in your Google admin for the upload? Are they giving you errors about the dates?
Thats the thing, its not saying anything, whether it was accepted, or whether there are errors or nothing.. just shows the file name which is correct, and the rest is blank...
This mod seems to be installed correctly, I'm not getting any errors. But the feed file is empty :( I have the permissions set to 777 and even that doesn't work :(
is the "feed" folder set to 777 as well? if the file is writeable but the folder isn't.. it won't generate anything (pretty sure of that, could be wrong though)
I was just coming to post! I am a dummy lol, somehow I missed uploading the googlefroogle.php file to my main zen directory :blush: That file is definitely needed :lol:
what is the chmod function used for in this contribution? unfortunately I can't seem to get it to work on my new server since its not running phpsuexec (that i know of).. so it keeps throwing me warnings about chmod. It seems to work properly though.. just curious
The feed directory needs to be writable. But if it is left writable then it is easy for a hacker to drop files into the directory.
Toggling on/off the directory permissions whenever you generate the feed manually is not a big deal. But it is if you are constantly updating your product line, and/or creating and uploading the feed via a cron job.
Anyone with recommendations/solutions as to the feed directory permissions issue?
Woody
You don't need to be running PHPSuExec for the chmod function to work. It's purpose is to set the permissions on the feed *file* to 644 after the file has been written:Quote:
what is the chmod function used for in this contribution? unfortunately I can't seem to get it to work on my new server since its not running phpsuexec (that i know of).. so it keeps throwing me warnings about chmod
Maybe if you post the errors you're getting someone may be able to point you in the right direction. :smile:PHP Code:*chmod(DIR_FS_CATALOG . GOOGLE_FROOGLE_DIRECTORY . GOOGLE_FROOGLE_OUTPUT_FILENAME, 0644);
well the reason i ask is because currently the server isn't set up right.. we're redoing it at this moment actually to see if i can get phpsuexec installed. Right now "nobody" is trying to run the chmod script.. but the owner of the files its trying to chmod is "getyourg" or "root".. so its not working properly and throwing me warnings about how the chmod function isn't permitted.. i'm hoping once the server is redone that phpsuexec will FINALLY work properly.. it hasn't worked at all and i believe it was due to a few corrupt server files.. we backed up the server and completely wiped it and are redoing it from scratch
found out that phpsuexec only works when php runs as CGI... therefore CHMOD will not work for me since it runs under "nobody"..and my files are owned by my username. Since it doesn't matter too much that the file is to be chmodded, i will just ignore the warning :)
thanks!
Hi
I've installed GoogleFroogle successfully. And have gone through all step but Im stuck at the end.
I've also created the username and password with google base already.
Here is the steps I have completed :
**** Step 1 is OK ******
Froogle Data Feeder started 2006/11/07 15:01:32 Feed file - /home2/..bla..di..bla.../public_html/feed/froogle.txt Froogle File Complete In 0.803788 Seconds 92 Records
**** Step 2 is OK ******
Froogle Data Feeder started 2006/11/07 15:04:49 Feed file - /home2/..bla..di..bla.../public_html/feed/froogle.txt Upload started... Uploaded Successfully -r--r----- 1 ftp root 44973 Nov 7 12:04 froogle.txt Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp root 44973 Nov 7 12:04 froogle.txt
Upload ok!
But when I clicked to view Froogle Merchants FTP content, then I saw this
Froogle Merchants FTP content:
Connected to: uploads.google.com
/
total 0
I dont know why the FTP content 0 files.
I also tried to upload this manually via FTP program and it seemed to be uploaded successfully.
But I still see 0 file in uploads.google.com And I see nothing in froogle and still have 0 item.
Please suggest me what has gone wrong.
I would say that's quite normal - Your feed file often won't show up when you look at uploads.google.com just after submitting a feed. Then it might show up (briefly) before it's removed again for processing.
Providing your feed filename is named correctly it will have gone onto Google's system and will be awaiting processing. Give it a day or three and see what happens - especially if this is your first feed - Google will have to approve the feed.
Best not to submit any more until they email you to tell you the outcome of this feed otherwise you risk re-starting the approval process.
Just peek in your Googlebase admin area now and again - it should show up there eventually, plus they'll email you. They can be slow approving feeds sometimes - maybe due to maintenance work or updates to their system, or perhaps because they have a lot of feeds to approve.
You'll get there :smile:
Hi, I installed the googlefroogle mod and got it to run fine. But I noticed that my images were no longer showing up in Base and Froogle. So I checked the file that googlefroogle creates and it is adding two things to the image url. First it is saying that all my pics are in the images/large directory. I dont even use that directory. All my images are in the images/ dir. Secondly, it is attaching this to all my pics: _LRG.jpg so my the link to my image files looks something like this: abc/images/large/ring_LRG.jpg. I went through and deleted the offending parts and reuploaded the file to Base and it is working fine now. But how can i fix this problem? Anyone know why its doing this?
THanks
Jason Brim
I believe it's because google base wants the large picture for display so the module assumes you are using the proper format to display larger pictures which is to name your images as followsQuote:
Originally Posted by brimsjewelry
image.jpg goes in the normal /images/ directory
image_MED.jpg goes in the medium /images/medium/ directory
and image_LRG.jpg goes in the large /images/large/ directory
by using this method you make the call-up of your images compatible with all or most of the contributions for zencart.
i'm not sure how you would go about changing the google base contribution to suit your needs nor am i sure you would want to do that. i would suggest following the appropriate nomenclature and placement of your image files in zencart.
Quote:
Originally Posted by brimsjewelry
This might be the solution to your problem: http://www.zen-cart.com/forum/showpo...&postcount=186
Hi,Quote:
Originally Posted by BlessIsaacola
Thanks for the suggestion. But when I make this change to googlefroogle.php it starts looking for the images in the root directory. I'm not gonna worry about it. I'll just start uploading my images to the large folder.
Thanks again,
Jason
Well, apparently thats not going to work either. Now it's renaming the images i upload to the /large folder as: /large/large/image_LRG_LRG.jpg. I did have image handler 2 but i removed it from the database prior to trying this so I dont think thats the problem. I can work around this for the moment by editing the file in Excel but thats precisely the thing i wanted to get away from by using this mod.
Plus, this mod uploads the sale prices for my products while the froogle file generated by EasyPopulate does not; it only lists the regular prices.
I want this to work and I'll be glad for assistance.
Jason
WOOOHOOOO! I made a mistake reading the proposed solution. I only copied part of the substitute line in googlefroogle.php. SO i went back and did it again, the whole line this time, and it works!!!!
Thanks so much! Now I am a happy Zenner again!
:D:D:D:D
Jason
Jason.. out of curiosity, now when you create your feed file where does the image link go to? Just the images/ directory.. or to where IH2 makes the image? Thanks :)
It goes to the image directory. But I noticed that IH2 doesnt work beyond second tier categories(as far as enlarging the pics in the whats new box). Is this a known issue or is it just my store?
Jason
Thanks for your answer Pixxi. Fingers crossed then. I've been waiting for 4 days. Will see what happen next.Quote:
Originally Posted by Pixxi
one strange thing i noticed is that if you are uploading using the bulk uploads method on the google base site then the shipping field is not being accepted as generated by this mod.
it gives the following errorsI tried half a dozen times to correct this shipping field to live up to their specifications but nothing worked.Quote:
Shipping field was incorrectly specified - UPS
until...
if you FTP directly from zencart admin it accepts it fine. Anyone else have this problem?
mafiasam
I have just had to move my store from IXWebhosting to bluehost. Before the move the googlefroogle mod worked just fine. Now however it will not connect to the upload server and upload the feed file. I tried reinstalling it to no avail. Has anyone experienced this issue and had it resolved?
Jason
bluehost may have phpftp functions disabled.. may want to ask them about it
had to leave shipping options blank. it is not accepting any values i put in for shipping.Quote:
Originally Posted by mafiasam
try it in this format:Quote:
Originally Posted by mafiasam
US:Priority:7.99,CA:Global-Priority:9.99
Country:Type(nospaces):Price,Country:Type:Price,etc
My problem is I don't have set or flat shipping rates. My shipping rates depend entirely on weight and quantity so advertising a single shipping rate for my entire catalog through the admin is not accurate and therefore deceptive.Quote:
Originally Posted by getyourgameshere.com
Quote:
Originally Posted by mafiasam
I think you can advertise it without price - not positive.. so it would look something like this:
US:Priority, CA:Global-Express
something like that. I put mine as the prices above but those are a little bit higher than what most people normally get charged.. reason was the same thing as yours. Didn't want to be deceptive so I figured if I put extra on Froogle and someone came to the site to purchase, they would be happy to see shipping prices were a little lower :)
Plus, a lot of people don't see the actual page for it - they click the link and it leads straight to the site
Yep that's the problem. In fact, bluehost doesn't support phpftp. sigh...what to do?Quote:
Originally Posted by getyourgameshere.com
Does anyone know if there is a limitation to how many products googlefroogle can process. The mod is now timing our because we have more than 10k products. I looked in the error log and it bailed because is exceeded 60 seconds. I changed that to 120 seconds, it still did not complete the process but no error.
Any ideas?
Thanks!
Isaacola!
I add @set_time_limit(0); and do some optimization. Try this version.
v 1.2.13 25.11.2006 17:51
Thanks for the update. It did not fix my problem. The error message I received is pasted below: [Sat Nov 25 12:05:23 2006] [error] PHP Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 20972449 bytes) in /****/googlefroogle.php on line 131. I am going to change php.ini to memory_limit = 30M and see if that works.Quote:
Originally Posted by a_berezin
Geez, I used to have this set at 8M, then changed it to 20M for this mod when I first got the error and now is looking for more. This thing is memory hungry :)
How come this needs so much memory and Easy Populate generates the googlebase file just fine?
Thanks!
Andrew, I have exhausted my limited knowledge and I still cannot get this complete the process. The file hangs everytime before completing the creation of the frogle text file. The only thing that changed today is our product offering went from 5525 to 11,117. Any ideas?
Thanks!
BlessIsaacola!
I add some statistic to googlefroogle.php. You can see something interesting:
The basic time is spent by the following standard zen functions:Code:Execution time:
Function Execution time Percent
zen_froogle_fwrite 0.023367 0.52%
zen_froogle_sanita 0.061071 1.35%
zen_froogle_category_tree 0.128599 2.85%
$products->mySQL 0.082445 1.83%
zen_get_tax_rate(cached) 0.023425 0.48%
zen_get_products_actual_price 3.128807 69.35%
zen_add_tax 0.009057 0.2%
$currencies->value 0.007719 0.17%
zen_get_info_page 0.598652 11.84%
zen_href_link 0.026346 0.52%
main_product_image.php 0.366336 8.12%
zen_froogle_expiration_date 0.006011 0.13%
zen_froogle_get_category 0.019781 0.44%
Other 0.077633 1.72%
Total 4.511542 100%
Froogle File Complete In 4.511542 Seconds 116 Records
zen_get_products_actual_price - 69.35% (!!!)
zen_get_info_page - 11.84%
main_product_image.php - 8.12%
BlessIsaacola!
1. Use products_price_sorter field instead of function zen_get_products_actual_price;Quote:
Originally Posted by a_berezin
2. Use selected type_handler field instead of function zen_get_info_page;
Test this one.
It did not work. I got the following error:Quote:
Originally Posted by a_berezin
1054 Unknown column 'databaseDELETED.m.products_id' in 'on clause'
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 products p LEFT JOIN manufacturers m USING (manufacturers_id) LEFT JOIN products_description pd USING (products_id) LEFT JOIN 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 = 1 ORDER BY p.products_id ASC]
Please note that for security reasons, I have deleted the database name from the first line of the error.
Thanks!
OK! I replace USING by ON in sql. Test this one.
P.S. May be we goto e-mail talking?
I tried it again and there was no error on my screen but this error was generated in the server log: [Mon Nov 27 10:26:32 2006] [error] PHP Fatal error: Allowed memory size of 31457280 bytes exhausted (tried to allocate 20972893 bytes) in /folderNAME/googlefroogle.php on line 227 I used to have max memory limit for script set to 10MB and I have adjusted to 30MB for this mod and it is still not enough.Quote:
Originally Posted by a_berezin
Thanks!
Change @define('GOOGLE_FROOGLE_OUTPUT_BUFFER_MAXSIZE', 5*1024*1024); at line 45.
Quote:
Originally Posted by a_berezin
What should I change line 45 to?
Thanks!
!!!!!!!!!!!
Ok, I understand you :-(, use this file
Great Job Andrew!!!Quote:
Originally Posted by a_berezin
This version worked like a charm. Pasted below are the statistics:
Execution time:
Function Execution time Percent
zen_froogle_fwrite 3.548495 4.7%
zen_froogle_sanita 14.533300 19.24%
zen_froogle_category_tree 0.537313 0.71%
$products->mySQL 18.365177 24.31%
zen_get_tax_rate(cached) 0.323506 0.43%
zen_get_products_actual_price 0.539358 0.71%
zen_add_tax 1.002850 1.33%
$currencies->value 1.418785 1.88%
zen_get_info_page 0.310684 0.41%
zen_href_link 3.543491 4.69%
zen_froogle_image_url 14.736084 19.51%
zen_froogle_expiration_date 1.161325 1.54%
zen_froogle_get_category 5.183879 6.86%
Other 10.340200 13.69%
Total 75.544448 100%
Froogle File Complete In 75.544448 Seconds 11110 Records
Andrew, if I want to use the model as "id" instead of the product id do I changetoPHP Code:@define('GOOGLE_FROOGLE_OFFER_ID', 'id'); // id/model/false
? or where would I change that?PHP Code:@define('GOOGLE_FROOGLE_OFFER_ID', 'model'); // id/model/false
Thanks!
Wow! We have won!!! "We are the Champion"!!! Zen-cart is a magic! :clap:
If you install update_1_2_9.sql, then you can select OFFER_ID id/model/false in admin GoogleFroogle Configuration menu.
Okay! I hate to spoil our party :( There is a problem with the .txt that is generated. Although the completed file is about 8.3MB which will lead you to believe that everything is there. There is only one row of record. Instead of each product being on a separate, everything is on one row. It's like there's no tab to go to the next or something.
We just need the file generated to be on separate row (each row representing a record and we will be good).
I don't know what's causing this problem.
Thanks!
It not a problem! I know about that.
Download last version from my site.
Are you sure the version from your site is updated? It doesn't work. I am back to where we started using the version from your site.Quote:
Originally Posted by a_berezin
Thanks!
Last version is v 1.3.0 28.11.2006 2:23. Try once more. And check the version.
It is the same as http://www.zen-cart.com/forum/showpo...&postcount=243
I add only one "\n" to the end of output row.
What do you mean when you say "It doesn't work"? How "It doesn't work"?
Thank you so much! This one work flawlessly, the file is generated and everything looks good. I submitted it to google and now I just need to figure out why I am getting so many errors with Too Few Tabs. I did not have these errors before on the products that Google is rejecting.Quote:
Originally Posted by a_berezin
The is now finishing the process and generating a google base file so I am happy with that.
Could it be that I am getting these Too Few Tabs error because I am using model instead of product id for my offer_id?
Thanks!
Please download and test once more.
I cann't repeat that error :-( But on any case has cleaned a some code.
Please, e-mail me about results of your testing.
Andrew,
Thank you for the continued development work on this module :smile:
This may not be related to the problem BessIsaacola has reported, but isn't there still an unnecessary '\t' on the end of the feed?
For example:
Each line has a '\t' on the end - which means there will always be an extra (unnecessary) tab on the end of the feed, no matter which options are set in admin.PHP Code:$output = "title \t" .
"description \t" .
"link \t" .
"price \t" .
"image_link \t" .
"expiration_date \t" .
"label \t" .
"id \t" .
(GOOGLE_FROOGLE_IN_STOCK == 'true' ? "quantity \t" : '') .
(GOOGLE_FROOGLE_SHIPPING != '' ? "shipping \t" : '') .
(GOOGLE_FROOGLE_MANUFACTURER == 'true' ? "brand \t" : '') .
(GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW == 'true' ? "product_type \t" : '') .
(GOOGLE_FROOGLE_LANGUAGE_DISPLAY == 'true' ? "language \t" : '') .
(GOOGLE_FROOGLE_CURRENCY_DISPLAY == 'true' ? "currency \t" : '');
Shouldn't the "id \t" be simply "id", and the following '\t's be moved to the beginning of the optional feed lines, eg:
(And the same for the block of code from line 146 to line 159)PHP Code:$output = "title \t" .
"description \t" .
"link \t" .
"price \t" .
"image_link \t" .
"expiration_date \t" .
"label \t" .
"id" .
(GOOGLE_FROOGLE_IN_STOCK == 'true' ? "\t quantity " : '') .
(GOOGLE_FROOGLE_SHIPPING != '' ? "\t shipping" : '') .
(GOOGLE_FROOGLE_MANUFACTURER == 'true' ? "\t brand " : '') .
(GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW == 'true' ? "\t product_type" : '') .
(GOOGLE_FROOGLE_LANGUAGE_DISPLAY == 'true' ? "\t language" : '') .
(GOOGLE_FROOGLE_CURRENCY_DISPLAY == 'true' ? "\t currency" : '');
Has anyone successfully used this with SEFU? Although I am able to view a particular page based on the url output of this contrib, it's not the same url that I see for a product when I manually browse to the page on my site. I would prefer not to have too many urls different urls leading to the same page on my site, lest I'm punished for duplicate content.
Phid!
You are the first, who told me, that this GoogleFroogle not work with SEFU.
What SEFU you use?
phid, this mod works fine with Ultimate SEO v.2.103 i believe it is (latest version of Ultimate SEO at this time). There is another SEFU mod out there, and I'm not sure of compatibility of that.. maybe thats the one you're using?
Hello all,
I use the ex-Tim Kroger Breakmyzencart SEFU urls that have been updated by JeffD to be compatible with 1.3.6. I'm not saying that it won't work with it, just that I'd run the risk of having Google think I'm spamming with duplicate urls.
In the config area, when I set the "Show feed language = true", I get something like:
://www.mysite.com/pages-productinfo/product-204/language-en/my-product.html
in my url. While the link does lead to the product page, it's not the same url that appears when I just naturally browse to the page (like a search engine would normally). Here is how my url looks when I browse to the page manually:
://www.mysite.com/pages-productinfo/Mymerchandise-66_69/product-204/my-product.html
Now I can remove the language-en text by putting "Show feed language = false", but then I'll still be missing the "Mymerchandise-66_69". This text is from my sefu_defines.php file:
Here are the settings I had for the GoogleFroogle generated feed:Code:define('SEFU_CATEGORY_NAME', 'Mymerchandise');
Show Default Currency false
Default Currency USD
Show Offer ID model
Display quantity false
The shipping options available for an item
Show Manufacturer true
Show Product Type true
Product Type other
Show Feed Lanugage true
Feed Language English
Output File Name froogle.txt
Compress Feed File false
Ok! Don't use this module with "ex-Tim Kroger Breakmyzencart SEFU urls that have been updated by JeffD to be compatible with 1.3.6". I don't know how it works.
Well, let me know if you figure out a way to add a "Show Categories = true/false" option in the configuration area....that seems like something I could use.
When I start developing this mod, I use cPath in url, but later I have removed it at the request of the users.
No problem to add a "Show Categories = true/false" option.
Is the google/froogle mod compatible with Image Handler?
The feed I created is declined because the image links are wrong.
I'm using v 1.2.10 13.10.2006 0:18 on ZC136
Please help.
OK, I found post #186 and made that change. I assumed that had been put into the mod but now see it is a necessary custom change for Image Handler use.Quote:
Originally Posted by gonewild
I was finally ready to test the updated file but I got an error File "zc-contribution/GoogleFroogle.zip" not found in download directory...Quote:
Originally Posted by a_berezin
I am not ready
BlessIsaacola!
Sorry for delay. Test this one.
Andrew,
I would like to firstly thank you for all your hard work on this and your other contributions - it really is appreciated.
I have tried to install your contribution and firstly got an error in the SQL. Just for information, the error was a bracket at the beginning of the last line of the patch:
----------------------------
NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @t4, 20, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
-----------------------------
I simply added the braket at the beginning of the line and the statement was successfully processed.
----------------------------
(NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @t4, 20, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
-----------------------------
I then tried to set the perameters in admin and got the following errors when I clicked on both the change currency option:
Fatal error: Call to undefined function: zen_cfg_pull_down_currencies() in /htdocs/admin/configuration.php(192) : eval()'d code on line 1
and the feed language option:
Fatal error: Call to undefined function: zen_cfg_pull_down_languages_list() in /htdocs/admin/configuration.php(192) : eval()'d code on line 1
Have I done something wrong and will it effect the operation of the mod?
Many thanks again.
H
Hi BigMacYin,
Thank you. Fixed.Quote:
Originally Posted by BigMacYin
Check admin/includes/functions/extra_functions/googlefroogle.phpQuote:
Originally Posted by BigMacYin
Thanks Andrew, that did the trick and all is working now. I have now changed my FTP software!!
Kindest regards,
H
Hi again Andrew,
I have uploaded a feed to Google and it is live already - thanks again for your hard work.
Looking at my products, I noticed some of the images are missing so I looked at the feed and the URL to the images defaults to the large image directory but as I am using IH2 there are no large images in that folder. Is there a way that I can change the output of the code to write to my images folder rather than the large images directory?
Many thanks again.
Kindest regards,
Hamish
Please view post #186 of this thread - it outlines a fix for IH2Quote:
Originally Posted by BigMacYin
Thanks getyourgameshere.com, that worked perfectly - much appreciated.
Warmest regards,
H
Good morning.. For the last two days I have tried to upload my items again for this month.. I cant get my CRON job to work so I have been doing it manually myself.. Anyhow when I try to upload it I am getting the following failed message:
: /Warning: ftp_put() [function.ftp-put]: froogle.txt: Permission denied on server. (Overwrite) -r--r----- 1 ftp root 0 Dec 18 05:51 froogle.txt
Upload failed...
I just want to make sure it isnt something I have done, and maybe its Google.. Anyone else having any problems with them? I dont believe I have changed anything since my last upload.. Thanks..
Usually, when you get that error it means you have tried to upload your Froogle feed twice in the same day - Froogle only allows one upload, but whether that is once per midnight-to-midnight day, or once per 24 hour period is uncertain.
That error is what I got after trying to do it just once though..
lately i have been having the same error (i upload once every 2-3 days). I suspect this is a problem on Google's end.. because I can't even upload using my FTP client - it just says permission denied. Not sure whats going on with it but I can assure you its not the mod doing it.Quote:
Originally Posted by lhhgbh
Sometimes Google Base doesn't even accept my login credentials.. just don't understand it. Probably because its being pounded by the Christmas season and retailers trying to get up there on Google base :P
Just downloaded v.1.3.1 GoogleFroogle mod.
Analyzing the new googlefroogle.sql I discovered it did not contain SQL included in update_1_2_9.sql.
For example INSERTS for the following three configuration menu keys (as contained in update_1_2_9.sql):
do NOT appear in googlefroogle.sql.Code:'GOOGLE_FROOGLE_DIRECTORY'
'GOOGLE_FROOGLE_EXPIRATION_BASE'
'GOOGLE_FROOGLE_EXPIRATION_DAYS'
QUESTION: Do all fresh installs of v.1.3.1, after patching with googlefroogle.sql, then also need to be patched with update_1_2_9.sql ?????
If I am not mistaken it appears this same issue would apply for all mod versions since version 1.2.10
Or are those three configuration keys deprecated?
Woody
Hi Woody,
Excuse, my mistake - has forgotten to add it in googlefroogle.sql.:(
Fixed.
Thank you!
Thanks Andrew!
Woody
I diownloaded new version then ran uninstall.sql. Then googlefroogle.sqlQuote:
Originally Posted by a_berezin
Receive error during DB patch attempt (via phpmyadmin):
-WoodyCode:MySQL said:
#1136 - Column count doesn't match value count at row 17
Something wrong here:Quote:
Originally Posted by Woodymon
And maybe a mistake comma in descriptions on line 28 & 30.Code:(NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @t4, 2, now(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),
line 35: remove commas from description (or replace with dashes).
line 34-36: insert NOW() for date_added.
line 34: change now() to NOW() for last_modified.
After those fixes to googlefroogle.sql the DB successfully patched.
Attached is repaired googlefroogle.sql (for GoogleFroogle v.1.3.1)
Thanks. Fixed.
Thanks for updating Andrew.Quote:
Originally Posted by a_berezin
1. So everyone should now use googlefroogle.sql in Andrew's latest version (disregard my attachment above... forum moderator please delete that post).
UPDATE:
2. However I continue to have issue with the new googlefroogle.sql
Specifically:
Note that configuration_description above contains two commas and a semi-colon, which produces errors on importing into the database (at least it does for me).Code:(NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @t4, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),
The commas act as delimiters to separate the dB fields, and the semi-colon identifies the end of the SQL command. Maybe these characters need escaped? Maybe others don't have this issue?
I'm not SQL expert so I may be wrong on the above but the new SQL does not work for me.
If I remove the semi-colon and change the two commas to dashes, as in above description, then all is ok. At least it works for me.Code:'Expiration Date Base:<ul><li>now - add Adjust to current date </li><li>product - add Adjust to product date (max(date_added - last_modified - date_available))</li></ul>'
Not criticism just want to ensure all is ok with sql patch ;-)
3. Also if installing this new version of mod everyone be sure to upload the new /googlefroogle.php file. Although version id tag in the php file header remains the same, inspection of the file identified a new line of code (line 61):
WoodyCode:echo "Processing: Feed - " . (isset($_GET['feed']) && $_GET['feed'] == "yes" ? "Yes" : "No") . ", Upload - " . (isset($_GET['upload']) && $_GET['upload'] == "yes" ? "Yes" : "No") . NL;
No You are mistakenQuote:
Originally Posted by Woodymon
With what purpose you tell it? It is absolute nothing means!!! Now I have removed this line. What has changed?Quote:
Originally Posted by Woodymon
When I process the SQL, I observe errors with those commas and the semi-colon. When I remove the commas and semi-colon it imports fine. But no biggy. Just thought I'd report a workaround if others observed the same issue.[/QUOTE]Quote:
Originally Posted by a_berezin
Andrew, I suppose we have a language/communication barrier. Sorry if my words were confusing. I was not meaning to say there was any issue with the line of code. I was pointing out to everyone that the new version included a new line of code and thus people should be aware, to ensure they upload the new file. That was all. I have no idea why my comment would prompt you to now remove that new line of code ;-)Quote:
Originally Posted by a_berezin
Sorry that I was not or cannot be any more clear. Happy holidays!
Woody
a_berezin,
Thanks for a great contribution. I've added the model number to the feed because I needed it when I use the feed for other things. I also attached the changed file.
Pete
Oops goofed I put in model (which is reserved for car stuff) instead of model_number, its changed now.
iI have just upgraded Zen from 1.3.2 to 1.3.6 and noticed that my Google Froogle feeder SQL file that had been used to install 1.3.2 was 1_2_6. I have downloaded the latest version of this MOD but I am having problems.
I have not seen an upgrade path in this thread or in the instructions and doing what I thought was obvious did not work. (Replace the old files with the new and run the SQl scripts)
When I run 1_2_9 SQl script I get the following error:
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 'id', 'model', 'false'),' WHERE configuration_key='GOOGLE_FROOGLE
in:
[UPDATE configuration SET configuration_title='Offer ID', configuration_description='A unique alphanumeric identifier for the item - products_id code.
Based on products_id or products_model', set_function='zen_cfg_select_option(array('id', 'model', 'false'),' WHERE configuration_key='GOOGLE_FROOGLE_OFFER_ID';]
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.
and something similar on the 1_3_1 scripts.
Any help is appreciated.
ZEN 1.3.6
PHP 4.4.3
MySQL 4.1.14 on Windows 2003
CBO, you only get SQL errors when you do this, can I see the old sql file, I don't know where to find the old versions of googlefroogle.
Pete
Try running the full googlefroogle.sql rather than the version-specific ones - which are only partial SQL updates.
Remember to write down your Froogle settings first - the full SQL will drop (ie. delete) the current settings and create new ones which you will then need to edit in the config of the mod in admin.
You can get the latest version (v 1.3.1) from Andrew's site - see the link in his signature.
Here is the SQL file that I used...........Quote:
Originally Posted by kebeid
UPDATE configuration SET configuration_title='The shipping options available for an item', configuration_value='', configuration_description='The shipping options available for an item' set_function='' WHERE configuration_key='GOOGLE_FROOGLE_SHIPPING';
UPDATE configuration SET configuration_title='Display quantity', configuration_description='Display products quantity?' WHERE configuration_key='GOOGLE_FROOGLE_IN_STOCK';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIPPING_LOW';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_TO_DISPLAY';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_TO';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_FROM_DISPLAY';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_FROM';
Try running the full 'googlefroogle.sql'. :smile:
Did that as well...results in the following......Quote:
Originally Posted by Pixxi
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 'in:
[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.
I've installed the latest version of this mod (v1.3.1) several times on zen 1.3.6 using the full SQL without any errors.
See posts 281-284 (?) above by Woodymon - perhaps your server has the same issue, if it is server-related.
Or it might be due to you attempting to first run the partial SQL - in which case, you'll need to manually edit those inserts out (ie. delete them) in the configuration table.
Hmmm... it should work out fine, how did you install it, through the sql patches in the admin or through phpmyadmin?Quote:
Originally Posted by CBO
Pete
As per directions with the SQl install in admin.Quote:
Originally Posted by kebeid
I'm starting to wonder if Just dropping everything and reinstalling with this version would be ok. However, Im one of those wanna be SQL/PHP guys and have no rel idea what the table is that I need to drop so I can reinstall.
Don't drop the table cuz it has all your other config stuff so yea don't do that.
I don't know if you're up to doing this since its gonna take a long time, but you can look at the things referred to in the sql file and drop those rows from the config table then install the googlefroogle fresh.
Pete
OK, I dropped the rows and replaced all the files with the current set 1.3.1.Quote:
Originally Posted by kebeid
I reinstalled the reran the SQL script and reentered my data for froogle in the configuration area. Now, with this new install there seems to be a small issue remaining. Whenever I try and generate a new froogle file I get a pop up screen in my browser that is blank. The file is never created also after verifying the FEED dir to see if it was there..nothing. Could this be permissions causing this now? Either on the Feed dir or someplace else?
The pop-up window shows the result of the feed generation process (eg. xxx records ... success!). It can take a while if you have a lot of products, although this version is much faster than previous versions thanks to Andrew's optimisation efforts. But if you've less than 10k products and you've left it for a minute or so and it still hasn't completed then you probably have another problem.
The feed folder and file usually need to be 777 - the pop-up window will display a permissions error if the feed folder/file is not writeable, so it's unlikely to be that.
How many products do you have, and how long are you letting it run for?