Jump to content
Sign in to follow this  
Chemo

Live Data Feed base class+Froogle - only 1 query!

Recommended Posts

Hello everybody,

 

I've installed LiveDataFeed-baseclassWithFroogle-v1.1. Everything seems to work fine without problems. I just have one silly question that seems hard for me to understand. How do I setup the automated cron job? Do I suppose to make any changes in admin/cron.php? I know it seems funny but could somebody please explain me step by step how to set this up?

 

Highly appreciated. :blush:

Irina.

Share this post


Link to post
Share on other sites
Hello everybody,

 

I've installed LiveDataFeed-baseclassWithFroogle-v1.1. Everything seems to work fine without problems. I just have one silly question that seems hard for me to understand. How do I setup the automated cron job? Do I suppose to make any changes in admin/cron.php? I know it seems funny but could somebody please explain me step by step how to set this up?

 

Highly appreciated.  :blush:

Irina.

Sorry, I forgot to tell that I use a Windows server. Should I use Cron or Winat with Windows? Does LiveDataFeed-baseclassWithFroogle-v1.1 support Winat? There is a cron.php in admin. Should it be winat? And how do I setup the automated winat job?

 

many, many thanks. :rolleyes:

Irina.

Share this post


Link to post
Share on other sites

Hello,

 

Please disregard my two previous posts because no matter what should I use for Windows, I don't have a support for job scheduler on my domain.

I have a different kind of question. I have a Froogle Feed in my admin panel. It made it job great except for the pictures. Almost all of my pictures in catalog/images are .gif and in catalog/feeds they're file_name.gif.jpg and have a black background. How can I force it to save the images in either .gif or .jpg? And how can I change a background from black to white?

 

many thanks.

Irina.

Share this post


Link to post
Share on other sites

hi i just installed the contribution and got the most errors i have seen on os commerce coz i am new :)

 

Please help below is the error

 

Warning: getimagesize(/home/username/public_html/images/005a.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/003a.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/cONNECTOR2.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/cONNECTOR2.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/cONNECTOR2.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/images2_small.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/images2_small.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/images2_small.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/skart switch.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/skart switch.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/skart switch.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Humax Remote.JPG): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Noka Remote.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/remote_humax_f1.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/remote_samsung_9500.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/4plus.gif): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/4plus.gif): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/images[3].jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Humax 5400.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/FSMCI-6000.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/FS-CI-9800V2_small.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/metastar.gif): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Fortectstarultra.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/f2-1002.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/drag-inx.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/matrixreborn.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/realitycam.gif): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Matrix Revolutions.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/viaccess_cam.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/ZetaCam.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Xcam.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/SSLNB1.JPG): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/SSLLNB1.JPG): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/ESLLNB1.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/ESLNB1.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: fopen(/home/username/public_html/feeds/love_scent.txt): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 84

 

Warning: fwrite(): supplied argument is not a valid stream resource in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 85

 

Warning: fclose(): supplied argument is not a valid stream resource in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 86

Share this post


Link to post
Share on other sites
hi i just installed the contribution and got the most errors i have seen on os commerce coz i am new  :)

 

Please help below is the error

 

Warning: getimagesize(/home/username/public_html/images/005a.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/003a.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/cONNECTOR2.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/cONNECTOR2.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/cONNECTOR2.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/images2_small.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/images2_small.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/images2_small.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/skart switch.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/skart switch.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/skart switch.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Humax Remote.JPG): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Noka Remote.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/remote_humax_f1.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/remote_samsung_9500.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/4plus.gif): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/4plus.gif): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/images[3].jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Humax 5400.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/FSMCI-6000.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/FS-CI-9800V2_small.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/metastar.gif): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Fortectstarultra.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/f2-1002.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/drag-inx.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/matrixreborn.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/realitycam.gif): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Matrix Revolutions.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/viaccess_cam.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/ZetaCam.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/Xcam.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/SSLNB1.JPG): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/SSLLNB1.JPG): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/ESLLNB1.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(/home/username/public_html/images/ESLNB1.jpg): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: fopen(/home/username/public_html/feeds/love_scent.txt): failed to open stream: No such file or directory in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 84

 

Warning: fwrite(): supplied argument is not a valid stream resource in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 85

 

Warning: fclose(): supplied argument is not a valid stream resource in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 86

I had the same problem when I've installed this contrib. You need to make sure you've specified the correct path to your directories. You have two different paths:

 

/home/username/public_html/images/005a.jpg and

/homepages/42/d125170818/htdocs/admin/includes/classes/feed.php

 

Which one is correct?

Go to Server Info from your admin section and there you'll find the full path to your oscommerce.

Share this post


Link to post
Share on other sites
I had the same problem when I've installed this contrib. You need to make sure you've specified the correct path to your directories. You have two different paths:

 

/home/username/public_html/images/005a.jpg and

/homepages/42/d125170818/htdocs/admin/includes/classes/feed.php

 

Which one is correct?

Go to Server Info from your admin section and there you'll find the full path to your oscommerce.

 

Thanks a lot error fixed but i got another error which is :

 

Warning: getimagesize(): Read error! in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(): Read error! in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(): Read error! in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

Warning: getimagesize(): Read error! in /homepages/42/d125170818/htdocs/admin/includes/classes/feed.php on line 185

 

 

the error was after when i installed header tags Contribution Number 207 but the error shows in froogle contribution 2425 and my heaser tags is working fine.

 

Help please

Share this post


Link to post
Share on other sites

Hi, what setting would I need in the feed.php for the product urls with Chemos ultimate seo with rewrite since the standard setting product_info.php/id/ doesn't work. Thanks :)

Share this post


Link to post
Share on other sites

I managed to fix the problem with the urls by using seo_redirect but how do I set up the cron file. The installation instruction dont make much sense to me for this bit.

Share this post


Link to post
Share on other sites
I managed to fix the problem with the urls by using seo_redirect but how do I set up the cron file. The installation instruction dont make much sense to me for this bit.

 

 

Could anyone please explain how to get round the wrong URL problem caused by the SEO contrib?

Share this post


Link to post
Share on other sites

Hi Chemo,

 

Thank you for your contrib, woks like a charm.

 

How Can I include the prices with taxes (setup in oscommerce, not as an add), and how to convert price in EUR as default from the shop the USD or another currency?

 

Best regards,

 

Marc


osCommerce 2.2 MS2 in 6 languages

TVA Intracomm

Numbers of visitors online

Who's online Enhancement

....

Share this post


Link to post
Share on other sites

Yes I do, go on Froogle and type Manix Condom, you will see products from my website: Le Roi de la Capote

 

Cheers B)


osCommerce 2.2 MS2 in 6 languages

TVA Intracomm

Numbers of visitors online

Who's online Enhancement

....

Share this post


Link to post
Share on other sites

the headers are in a diffrent order then from the ones on the google exsample feed, will froogle still allow it?

Share this post


Link to post
Share on other sites

i am getting this error, can someone help me?

 

File completed: info_glovertechnology_com.txt

Connected to hedwig.google.com, for user zandory

 

Warning: ftp_put(): info_glovertechnology_com.txt: Permission denied on server. (Overwrite) in /home/gloverte/public_html/catalog/admin/froogle.php on line 344

hedwig.google.com: FTP upload has failed!

Share this post


Link to post
Share on other sites

Hi,

 

since most of the people who get getimagesize() error on line 185 is not specifically to the image path, there is one more reason and that if the product image file name is empty.

 

in admin/include/classes/feed.php

 

Find the line function checkimage ($imagename) {

most probably at line 180-182 select the text till the bottom and replace with the code below.

 

Do not forget to backup

 

 
// Function Checkimage


function checkimage ($imagename) {  
if (!is_dir($this->feedimagepath)) { @mkdir($this->feedimagepath,0777); @chmod($this->feedimagepath,0777); }
$image = $this->imagepath . rawurlencode($imagename); 
$newimage = $this->feedimagepath . rawurlencode($imagename);  
// modified to check if the imagename is blank to fix the error getimagesize() on line 185
if ($imagename!=""){
   $size = getimagesize($image);
   $width  = $size[0];
   $height = $size[1];
   $type   = $size[2];
}
   switch ($type) {
   case 1:
    $feedimagename = rawurlencode($imagename) . '.JPG';
 break;
   case 2;
   case 3;
    $feedimagename = rawurlencode($imagename);
     break;
   }    
   if ($this->autoenlarge){
   if (!is_file($this->feedimagepath . $feedimagename)) {
   $this->imageresize($this->imagepath . rawurlencode($imagename), $this->feedimagepath . rawurlencode($imagename));
   return $this->feedimageurl . $feedimagename;  
   }
   else {
    return $this->feedimageurl . $feedimagename;
      }
 } //autoenlarge
 else {
   return $this->imageurl . rawurlencode($imagename);
  }    
}
}
?>

Edited by aitsglobal

Share this post


Link to post
Share on other sites

Fix for those who are having problem with SEO safe url turned on / off or applied any mod for SEO here is a small fix:

 

edit line number 52 in admin/includes/classes/feed.php

Existing line 52

var $producturl = 'http://yourdomain.com/product_info.php/id/';//make sure you use the URL version of your store. This example is for search engine safe URL's ON.

 

Replace Replace with

 

	
var $producturl = 'http://www.yourdomain.com/product_info.php?products_id=';
//make sure you use the URL version of your store. This example is for search engine safe URL's ON.
//replace

 

I just changed: /id/ to ?products_id=

 

This works for me.

Share this post


Link to post
Share on other sites

I installed this great contrib and everything works fine. However, when I click "View TXT Version" from admin, I get the following error:

 

Warning: Cannot modify header information - headers already sent by (output started at /home/******/public_html/admin/includes/classes/feed.php:193) in /home/******/public_html/admin/includes/classes/feed.php on line 115

Warning: Cannot modify header information - headers already sent by (output started at /home/******/public_html/admin/includes/classes/feed.php:193) in /home/******/public_html/admin/includes/classes/feed.php on line 116

Warning: Cannot modify header information - headers already sent by (output started at /home/******/public_html/admin/includes/classes/feed.php:193) in /home/******/public_html/admin/includes/classes/feed.php on line 117

Warning: Cannot modify header information - headers already sent by (output started at /home/******/public_html/admin/includes/classes/feed.php:193) in /home/******/public_html/admin/includes/classes/feed.php on line 118

Warning: Cannot modify header information - headers already sent by (output started at /home/******/public_html/admin/includes/classes/feed.php:193) in /home/******/public_html/admin/includes/classes/feed.php on line 119

Warning: Cannot modify header information - headers already sent by (output started at /home/******/public_html/admin/includes/classes/feed.php:193) in /home/******/public_html/admin/includes/classes/feed.php on line 120

 

Could anyone please explain why I'm getting this error?

Would appreciate any help.

 

Thanks in advance.

Share this post


Link to post
Share on other sites

I got froogle data feed to work on one of my stores but I am having problems with a different one.. and I didn't know how to search for the answer.

 

I have a store where the database name are like

 

peacem_categories instead of categories

peacem_products instead of products

etc.....

 

and I don't understand enoght of the calling the databate talble to change it in the froogle.php

 

$sql = "
SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url,
products_model AS prodModel, products_weight,
manufacturers.manufacturers_name AS mfgName,
manufacturers.manufacturers_id,
products.products_id AS id,
products_description.products_name AS name,
products_description.products_description AS description,
products.products_quantity AS quantity,
products.products_status AS prodStatus,
FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price,
CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url,
products_to_categories.categories_id AS prodCatID,
categories.parent_id AS catParentID,
categories_description.categories_name AS catName
FROM categories,
categories_description,
products,
products_description,
products_to_categories

left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id )
left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) )

WHERE products.products_id=products_description.products_id
AND products.products_id=products_to_categories.products_id
AND products_to_categories.categories_id=categories.categories_id
AND categories.categories_id=categories_description.categories_id
ORDER BY
products.products_id ASC
";


$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

Thank you very much

noppie

Edited by noppie

Peace is possible.. Please don't give up.

 

"War is --the old betraying the young"

Share this post


Link to post
Share on other sites

Hello,

 

I've added a Model to my Froogle list. Now it shows "URL Name Model Description Price Image Category".

It aligns ok in admin/froogle.php and shows up in View HTML Version, but not in View TXT Version, it doesn't appear there. What did I miss?

My another problem is with my pictures. Almost all of my pictures in catalog/images are .gif and in catalog/feeds they're file_name.gif.jpg and have a black background. How can I change a background from black to white and have pictures saved in either .gif or .jpg?

 

Thanks a lot.

Irina.

Share this post


Link to post
Share on other sites

Hello,

 

I installed this great contrib and successfully uploaded my feed file to Froogle once before. Since then I have been adding new products and disabled others. Now I need to update my product listings on Froogle. Unfortunately, I've been trying to upload my updated feed file to Froogle but I'm getting this error:

 

Warning: ftp_put(): *********.txt: Permission denied on server. (Overwrite) in /home/*******/public_html/admin/includes/classes/feed.php on line 75

The FTP upload has FAILED!

 

Here's the corresponding line (line 75) in admin/includes/classes/feed.php:

 

$upload = ftp_put($conn, $this->targetfilename, $this->savefilename, FTP_BINARY);

 

 

Am I missing something? It's a live shop here and I desperately need to update my froogle file. Please help!

 

Thanks in advance.

 

Shams

Share this post


Link to post
Share on other sites

Hi,

 

Does anybody have any suggestion on how can I add Model to my .txt version of Froogle feed?

 

Thanks in advance.

Irina.

Share this post


Link to post
Share on other sites
Hello,

 

I installed this great contrib and successfully uploaded my feed file to Froogle once before. Since then I have been adding new products and disabled others. Now I need to update my product listings on Froogle. Unfortunately, I've been trying to upload my updated feed file to Froogle but I'm getting this error:

 

Warning: ftp_put(): *********.txt: Permission denied on server. (Overwrite) in /home/*******/public_html/admin/includes/classes/feed.php on line 75

The FTP upload has FAILED!

 

Here's the corresponding line (line 75) in admin/includes/classes/feed.php:

 

$upload = ftp_put($conn, $this->targetfilename, $this->savefilename, FTP_BINARY);

Am I missing something? It's a live shop here and I desperately need to update my froogle file. Please help!

 

Thanks in advance.

 

Shams

Just a suggestion: try to upload your feed by connecting directly to hedwig.google.com through ftp with your username and password.

About your warning: is it any way that you've already uploaded your feed to Froogle prior this one? The reason I'm asking is your warning says: Overwrite. So, may be there is already a file being uploaded?

Share this post


Link to post
Share on other sites

Hi all,

 

I'm getting an email from the Cron Daemon at our hosting company with the following in the body:

 

<br />

<b>Warning</b>: session_start(): Cannot send session cookie - headers already sent in <b>/home/lolli2/public_html/admin/includes/functions/sessions.php</b> on line <b>77</b><br />

<br />

<b>Warning</b>: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/lolli2/public_html/admin/includes/functions/sessions.php:77) in <b>/home/lolli2/public_html/admin/includes/functions/sessions.php</b> on line <b>77</b><br />

<br />

<b>Warning</b>: main(includes/languages/english/): failed to open stream: No such file or directory in <b>/home/lolli2/public_html/admin/includes/application_top.php</b> on line <b>136</b><br />

<br />

<b>Warning</b>: main(includes/languages/english/): failed to open stream: No such file or directory in <b>/home/lolli2/public_html/admin/includes/application_top.php</b> on line <b>136</b><br />

<br />

<b>Warning</b>: main(): Failed opening 'includes/languages/english/' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in <b>/home/lolli2/public_html/admin/includes/application_top.php</b> on line <b>136</b><br />

 

Anyone know why this might be happening?

 

We currently are uploading products to Shopzilla, so I just copied and pasted the Froogle code, changed "froogle" to "shopzilla" and commented out the froogle code in the cron.php file.

 

Thanks!

 

Chris B.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×