OwenP 0 Posted August 6, 2006 Hi, I have this contribution working great on one of my sites, but I added it to another and I'm getting this error: ": SQL error SELECT command denied to user: '*****@localhost' for table 'categories'| catInfo = SELECT categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id" Anyone know what's up? All the login details are correct etc. I've compared the file to my other one. I can't figure out why this won't work. Thanks in advance. Share this post Link to post Share on other sites
Guest Posted August 6, 2006 Hi, I have this contribution working great on one of my sites, but I added it to another and I'm getting this error: ": SQL error SELECT command denied to user: '*****@localhost' for table 'categories'| catInfo = SELECT categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id" Anyone know what's up? All the login details are correct etc. I've compared the file to my other one. I can't figure out why this won't work. Thanks in advance. MySQL is blocking access to the SELECT command to that user on the selected database. Update permissions on the user to enable SELECT for the database. Normally can be done in phpMyAdmin or webhost control panel. Share this post Link to post Share on other sites
Guest Posted August 7, 2006 This started happening to me after there was an update on my server. I called iPowerWeb, told them what the problem was, thay changed something, and it works like a charm. Problem is, they wont tell me what they did! >_< i talked to RJ at iPowerWeb and he said it was due to a firewall blocking outgoing connections on non-standard ports(port 21 not standard? :blink: )but he allowed it and it works like it used to. Share this post Link to post Share on other sites
Mike14017 0 Posted August 8, 2006 Hi Can anybody tell me how to add a category code to each of my items. I need to do a feed to Shopzilla and they tell me I need to add "22,000,4002" (Being the category code) to each item. I have looked through the forum but can't find an answer. Regards Mike Share this post Link to post Share on other sites
Gil_e_n 4 Posted August 8, 2006 Hi. I just installed this and am getting this error: Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110) in /home/public_html/admin/froogle.php on line 349 Warning: ftp_put(): Type set to I. in /home/public_html/admin/froogle.php on line 349 uploads.google.com: FTP upload has failed! I feel I should point out that I only have 35 products in the file I'm trying to send, making the timing out more confusing. Does anyone know why this would be happening? Always BACK UP your files and your database before making any changes. Before asking questions, check out the Knowledge Base. Check out the contributions to see if your problem's solved there. Search the forums. Useful threads: Store Speed Optimization How to make a horrible shop Basics for design change How to search the forums Useful contributions: Easypopulate Fast, Easy Checkout Header Tag Controller Share this post Link to post Share on other sites
Guest Posted August 8, 2006 Hi. I just installed this and am getting this error: Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110) in /home/public_html/admin/froogle.php on line 349 Warning: ftp_put(): Type set to I. in /home/public_html/admin/froogle.php on line 349 uploads.google.com: FTP upload has failed! I feel I should point out that I only have 35 products in the file I'm trying to send, making the timing out more confusing. Does anyone know why this would be happening? I think it's google's server not responding. Share this post Link to post Share on other sites
chongordon 0 Posted August 9, 2006 File completed: Warning: ftp_login(): Login incorrect. in /home/woofwoof/public_html/english3/admin/froogle.php on line 325 FTP connection has failed! Attempted to connect to uploads.google.com for user abc Script timer: 3.425860 seconds. i fixed it ! the problem was password, i changed the google password to case sensitive.... my original password wasnt sensitive enough ! hehe.. But i have another problem beachglassdirect.com . File completed: Connected to uploads.google.com, for user abc Warning: ftp_put(): 'STOR': command not understood. in /home/woofwoof/public_html/english3/admin/froogle.php on line 348 uploads.google.com: FTP upload has failed! i couldnt find " STOR " in the code Puppy Clothes by WoofWoofLand Share this post Link to post Share on other sites
Guest Posted August 9, 2006 File completed: Warning: ftp_login(): Login incorrect. in /home/woofwoof/public_html/english3/admin/froogle.php on line 325 FTP connection has failed! Attempted to connect to uploads.google.com for user abc Script timer: 3.425860 seconds. i fixed it ! the problem was password, i changed the google password to case sensitive.... my original password wasnt sensitive enough ! hehe.. But i have another problem beachglassdirect.com . File completed: Connected to uploads.google.com, for user abc Warning: ftp_put(): 'STOR': command not understood. in /home/woofwoof/public_html/english3/admin/froogle.php on line 348 uploads.google.com: FTP upload has failed! i couldnt find " STOR " in the code Weird. I think 'STOR' has something to do with FTP. Can you post all of the FTP code from the script (omitting all personal info). Maby it has to be sent in Binary instead of ASCII. Share this post Link to post Share on other sites
Guest Posted August 9, 2006 Uploads the local source file to the FTP server and saves it as the destination file. This function sends a "STOR" command to the server, the user must have write permissions on the FTP server for this function to work. Possible transferMode s are FTP_BINARY and FTP_ASCII. The source and destination parameters may be absolute filesystem paths or may be relative to the current directory on the appropriate end (the local current directory for the destination, or the remote current directory for the source). What I got from Google about STOR Maby turning on ftp_pasv would help. Share this post Link to post Share on other sites
Gil_e_n 4 Posted August 9, 2006 Thanks. I still haven't gotten it working, but at least I know where to look. Always BACK UP your files and your database before making any changes. Before asking questions, check out the Knowledge Base. Check out the contributions to see if your problem's solved there. Search the forums. Useful threads: Store Speed Optimization How to make a horrible shop Basics for design change How to search the forums Useful contributions: Easypopulate Fast, Easy Checkout Header Tag Controller Share this post Link to post Share on other sites
Guest Posted August 9, 2006 hello, even though my shop is strongly edited, i think the mistake is within my settings. i only receive the first produkt with the id 1 when i create my outfile :( Share this post Link to post Share on other sites
darkvader 0 Posted August 15, 2006 (edited) Hi, Does anyone know what can cause this error? Warning: ftp_put(): php_connect_nonb() failed: No route to host (65) The error happens when I try to run the latest Froogle Feeder 1.63 It said it happen on line 410 of the froogle.php which looks like this: ftp_pasv ( $conn_id, true ) ; // upload the file $upload = ftp_put( $conn_id, $ftpdestinationfile, $ftpsourcefile, FTP_ASCII ); Thanks in advance :thumbsup: Edited August 15, 2006 by darkvader Share this post Link to post Share on other sites
Guest Posted August 15, 2006 (edited) Caused by a firewall. Enable outgoing connections to the account being used. Hi, Does anyone know what can cause this error? Warning: ftp_put(): php_connect_nonb() failed: No route to host (65) The error happens when I try to run the latest Froogle Feeder 1.63 It said it happen on line 410 of the froogle.php which looks like this: ftp_pasv ( $conn_id, true ) ; // upload the file $upload = ftp_put( $conn_id, $ftpdestinationfile, $ftpsourcefile, FTP_ASCII ); Thanks in advance thumbsup.gif Edited August 15, 2006 by beachglassdirect.com Share this post Link to post Share on other sites
FlyingMonkey 0 Posted August 15, 2006 hello, even though my shop is strongly edited, i think the mistake is within my settings.i only receive the first produkt with the id 1 when i create my outfile :( Edits to your site should have no impact on the feed. Sorry for the lack of support; my job has been keeping me busy. I will update the Feeder within the next week and a half to use Google's new feed specifications. -Calvin Most likely your question has been answered, please do a search first. Share this post Link to post Share on other sites
cinolas 8 Posted August 15, 2006 Thank you! I have been eagerly awaiting your update, hopefully including a fix for the encoding issue :) Thanks again ! Share this post Link to post Share on other sites
Guest Posted August 16, 2006 thx in advance, i can't await... Share this post Link to post Share on other sites
Guest Posted August 24, 2006 Hi thanks for the contribution! All functions well and i get my *.txt file. But can some one tell me how you get this *.txt file converted into the format that froogle supports Tab-delimited, RSS 2.0, RSS 1.0, Atom 1.0, Atom 0.3 Share this post Link to post Share on other sites
Guest Posted August 24, 2006 Hi thanks for the contribution! All functions well and i get my *.txt file. But can some one tell me how you get this *.txt file converted into the format that froogle supports Tab-delimited, RSS 2.0, RSS 1.0, Atom 1.0, Atom 0.3 The *.txt file is Tab-delimited. It is compatable with Frooge/Google base. Share this post Link to post Share on other sites
coolcl 0 Posted August 28, 2006 (edited) Second post, the first one ended up in the wrong place...sorry. Hi, I have been using the contribution since it got out and it has been great, but since Google has changed Froogle to Froogle base I am now getting errors when I upload the text file. Here's an example "Hurry! There�s only a few left!" The error explanation from Froogle is this one "Your bulk upload contains an invalid UTF-8 character. If you are using Notepad to save your file, please select "Save As" and then select "ANSI" or "UTF-8" in the "Encoding" options. What do I have to change or modified to solve this issue? Thank you all! CL Edited August 28, 2006 by coolcl Share this post Link to post Share on other sites
FlyingMonkey 0 Posted September 2, 2006 I have a new feeder for the Google specification.... just gotta finish up the documentation. Most likely your question has been answered, please do a search first. Share this post Link to post Share on other sites
Guest Posted September 2, 2006 excellent Calvin, does this get around the encoding issues ? lol will save me manually editing each and every item in my store ;) Share this post Link to post Share on other sites
FlyingMonkey 0 Posted September 3, 2006 (edited) excellent Calvin, does this get around the encoding issues ?lol will save me manually editing each and every item in my store ;) could you copy and paste some non utf8 text that causes issues? or provide a link where i can download some. Edited September 3, 2006 by FlyingMonkey Most likely your question has been answered, please do a search first. Share this post Link to post Share on other sites
ambition13 0 Posted September 4, 2006 (edited) I am using this mod and getting an empty generated file with just the column headers. I have copied the sql statement into php myadmin and am getting "emtpy result set". My store does not have any categories or manufacturers defined, is this a possible reason for the query coming up empty? Edited September 4, 2006 by ambition13 Share this post Link to post Share on other sites
Mary-at-Milton 0 Posted September 4, 2006 Thanks Calvin. Am also waiting in anticipation :) for the new upgrade (Googlebase). Mary-Ann Chief Cook and Bottlewasher Jack-of-All-Trades Running 2.2MS2 Share this post Link to post Share on other sites
FlyingMonkey 0 Posted September 6, 2006 (edited) Google Base / Froogle Data Feeder v1.00 Released By: Calvin K E-Mail: calvink@conceptualnetworking.com ------------------------ Date: September 6, 2006 Description: Creates and automatically sends a data feed to Google Base and Froogle using Google's new unified feed specification. This Google Data Feeder, handles product duplicates, specials(if available), currency conversion, tax support, html descriptions, full category trees, and automatic upload. In addition, the Google Data Feeder supports advance feeds. With the advance feed option enabled and the "instock" field enabled, it will create a feed with all of the products. Without the advance feed option enabled, it will only submit in stock items. The Google Data Feeder is based on my stable Froogle Data Feeder. Forum Thread: http://forums.oscommerce.com/index.php?sho...088&st=1633 (aka FlyingMonkey on the forums) Contribution Link: http://www.oscommerce.com/community/contributions,4513 Edited September 6, 2006 by FlyingMonkey Most likely your question has been answered, please do a search first. Share this post Link to post Share on other sites