Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

The Feedmachine Solution


241 replies to this topic

#41 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 07 December 2009, 14:47

I've tried installing your earlier script and was unable to get it to work for whatever reason, so I've tried installing it again and when trying to run from command line it gets a segmentation fault after building the countries array. I find this very strange and it may be the exact problem that I had last time I tried using this contribution.

Our store has over 1000 products and there is nothing really special about the database that would cause the php session to crash out.

Any suggestions?

Quote

PHP Warning: gethostbyaddr(): Address is not a valid IPv4 or IPv6 address in *snip*/whos_online.php on line 45
PHP Warning: session_destroy(): Trying to destroy uninitialized session in *snip*/sessions.php on line 164
catalog path: *snip*
languages array built
currencies array built
taxes array built
countries array built
Segmentation fault


#42 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 07 December 2009, 15:25

After doing a good bit of pondering, I figured it had to be crashing out because of all of the products we have. So, I installed a default OSC store and installed the feedmachine solution, it successfully generated 27 products. So, this brings me to my next question, how can we get this to work with larger stores?

Thanks, Frank

#43 kamalboucetla

  • Community Member
  • 1 posts
  • Real Name:Kamal boucetla

Posted 08 December 2009, 12:35

Hello,

I've just installed this on oscommerce 2.2 and i'm getting this error message when I try and generate an upload feed:


Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory.


However, when i enable register_globals the entire site falls over with a http:500 server error.

Please could you advise on how to get around this?

Thanks,
Kamal

#44 clarry

  • Community Member
  • 10 posts
  • Real Name:Clare manley

Posted 09 December 2009, 16:35

Hi,

I am trying to get this working on a heavily modified version of oscommerce. Seems to all be ok but the feed is going to an https:// URL and we do not currently have an SSL certificate enabled on the site.

Web Location of your feeds
https://www.balloondelivery2u.co.uk/fm-feeds/

Can you let me know where I can change this configuration.

Thanks

#45 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 09 December 2009, 16:55

View Postclarry, on 09 December 2009, 16:35, said:

Hi,

I am trying to get this working on a heavily modified version of oscommerce. Seems to all be ok but the feed is going to an https:// URL and we do not currently have an SSL certificate enabled on the site.

Web Location of your feeds
https://www.balloondelivery2u.co.uk/fm-feeds/

Can you let me know where I can change this configuration.

Thanks

Just remove the s from the https... no longer secure.

#46 BillHurst

  • Community Member
  • 2 posts
  • Real Name:Bill Hurst

Posted 09 December 2009, 17:25

Hi,

We are currently using the Feedmachine to upload our products to Google Shopping. All is working well apart from one thing, we are using Salemaker to promote a 10% discount Christmas sale at the moment, and the Feedmachine does not find the correct, lowered price. I have had a go at fixing this myself, but must admit I'm not the best coder in the world! Do you know of a way that I could make this work for us please?

Many thanks in advance,
Bill

#47 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 09 December 2009, 17:53

marco?

#48 lech

  • Community Member
  • 135 posts
  • Real Name:Lech

Posted 09 December 2009, 18:51

Hey guys, I will reply shortly.

#49 clarry

  • Community Member
  • 10 posts
  • Real Name:Clare manley

Posted 09 December 2009, 20:36

Hi,

Thanks! Removing the S worked perfectly and the products are now live on google which is great but.... (always a but!) none of the pictures are uploading, not sure why, we have got a modified version if OSCommerce which has extra images but the feed is displaying a link to images that doesn't work so for example http://www.balloondelivery2u.co.uk/images/f350942921ee21ef5589bee91c4357f7.jpg The actual image can be seen here http://www.balloondelivery2u.co.uk/images/products/original/product-id-144.jpg

Any ideas how I can fix this?

Thanks

#50 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 09 December 2009, 21:15

View Postlech, on 09 December 2009, 18:51, said:

Hey guys, I will reply shortly.

Sweetness! I'm hoping you have a solution for large stores =)

View Postclarry, on 09 December 2009, 20:36, said:

Hi,

Thanks! Removing the S worked perfectly and the products are now live on google which is great but.... (always a but!) none of the pictures are uploading, not sure why, we have got a modified version if OSCommerce which has extra images but the feed is displaying a link to images that doesn't work so for example http://www.balloondelivery2u.co.uk/images/f350942921ee21ef5589bee91c4357f7.jpg The actual image can be seen here http://www.balloondelivery2u.co.uk/images/products/original/product-id-144.jpg

Any ideas how I can fix this?

Thanks

Glad I could help with the https thing, lech or someone with some experience with this script will have to chime in on your issue.

#51 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 09 December 2009, 21:31

Feedmachine pulls the image name from the products_image field in the database. Not sure how your modification gets the image name.

Not sure how technical you are, but what *I* would do is look at my product_info.php file, do a search for the image mod you have and figure out how to get the image query from there to work in the feedmachine.php file in admin/. Either way, I find it quite strange that the URL in the feed has that random looking stuff as the image name.

Edited by frankc420, 09 December 2009, 21:33.


#52 exca

  • Community Member
  • 24 posts
  • Real Name:yunanto

Posted 10 December 2009, 01:35

hii im very newbi.
i ha dinstall this feed
when i push generate , there sukses

Google Product Search Simple Configuration
------------
update status: feed updated as part of a force update
upload trigger status: feed upload not triggered because feed upload is disabled
upload status: feed was not uploaded(0)

now, i need explain..
why not upload? and how must tod do?
and how to use this feed? must sign on google? or just we left on my web?

#53 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 10 December 2009, 03:14

View Postexca, on 10 December 2009, 01:35, said:

hii im very newbi.
i ha dinstall this feed
when i push generate , there sukses

Google Product Search Simple Configuration
------------
update status: feed updated as part of a force update
upload trigger status: feed upload not triggered because feed upload is disabled
upload status: feed was not uploaded(0)

now, i need explain..
why not upload? and how must tod do?
and how to use this feed? must sign on google? or just we left on my web?

If the contribution was installed correctly, you should be able to go into admin and flag the FTP field to yes, then fill in the information for the ftp site (which google provides). If you have not signed up for the account on google yet, the link is here: http://www.google.com/intl/en_us/products/submit.html

Hope that helps!

#54 lech

  • Community Member
  • 135 posts
  • Real Name:Lech

Posted 10 December 2009, 13:17

I apologise - in that case no. I assumed the relevant database structure was the same for CRE Loaded.

View Postmisa, on 01 December 2009, 20:48, said:

am getting this error then:

cycle: 1

products array built
1054 - Unknown column 'po.language_id' in 'on clause'

SELECT *
FROM products_attributes pa LEFT JOIN products_options po ON pa.options_id = po.products_options_id
LEFT JOIN products_options_values pov ON pa.options_values_id = pov.products_options_values_id AND po.language_id = pov.language_id
WHERE pa.products_id BETWEEN 11 AND 375

TEP_DB_ERRORR


#55 lech

  • Community Member
  • 135 posts
  • Real Name:Lech

Posted 10 December 2009, 14:25

Just a note to say I have just uploaded version 5.02 which fixes the FTP On/Off selection bug* in Feedmachine Admin. (*Changing the On/Off flag worked, but it did not display the current selection when loading Feedmachine Admin.)

#56 lech

  • Community Member
  • 135 posts
  • Real Name:Lech

Posted 10 December 2009, 14:30

Hi Frank,

Do you have access to your server's configuration? If you do then try to increase the memory limit in PHP.

Unfortunately the problem appears to be occurring as early as when the categories are being loaded.

View Postfrankc420, on 07 December 2009, 15:25, said:

After doing a good bit of pondering, I figured it had to be crashing out because of all of the products we have. So, I installed a default OSC store and installed the feedmachine solution, it successfully generated 27 products. So, this brings me to my next question, how can we get this to work with larger stores?

Thanks, Frank


#57 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 10 December 2009, 14:36

View Postlech, on 10 December 2009, 14:30, said:

Hi Frank,

Do you have access to your server's configuration? If you do then try to increase the memory limit in PHP.

Unfortunately the problem appears to be occurring as early as when the categories are being loaded.

I've increased it to over a gig, no different unfortunately.

#58 lech

  • Community Member
  • 135 posts
  • Real Name:Lech

Posted 10 December 2009, 14:49

Have you tried restarting your server/services, upgrading php and mysql?

I don't think this is inherently a fault with Feedmachine, which has been used to generate feeds with tens of thousands of products.

View Postfrankc420, on 10 December 2009, 14:36, said:

I've increased it to over a gig, no different unfortunately.


#59 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 10 December 2009, 15:07

View Postlech, on 10 December 2009, 14:49, said:

Have you tried restarting your server/services, upgrading php and mysql?

I don't think this is inherently a fault with Feedmachine, which has been used to generate feeds with tens of thousands of products.

Yeah, I just downloaded the latest release of php and compiled it standalone. Running the script from command line right now, been running for about 3 minutes, before it would crap out at about 1 minute, so far so good? :)

Would it be possible, if this works, to have the admin section run a system command to do the generate instead of using the apache php version? I know I'm asking for alot.

#60 frankc420

  • Community Member
  • 39 posts
  • Real Name:Frank Collette
  • Location:Jackson, MS

Posted 10 December 2009, 15:45

Script ran for 2400 seconds and timed out, increased to 10000 and running again. That's 45 minutes at 2400 seconds!