search

facebookarchive / Facebook-For-OpenCart

Facebook Ads integration with OpenCart
Other
72 stars 54 forks source link

There is an error with Facebook Ads Extension setup ocStore 2.3.0.2.3 #106

Open DeniDay opened 5 years ago

DeniDay commented 5 years ago

Good evening! After installing the module, there is a large load on the database and the site gives 500 error until you remove the module. What is the problem?

Version ocStore 2.3.0.2.3. And how to create XML by crown? My site: prizma-ua.com

There is an error with Facebook Ads Extension setup. Click on Facebook Ads Extension, Manage Settings, go to Advanced options and click on Delete Settings to restart the setup. Please contact Facebook via our Github if this error keeps showing.

DeniDay commented 5 years ago

http://prntscr.com/mlor77 log

shue249 commented 5 years ago

@DeniDay Thank you for the feedback.

  1. How many products do you have on your website?
  2. Where do you encounter the 500 error? Will you be able to share a snapshot of your webserver error log for that 500 error?
DeniDay commented 5 years ago

@shue249

  1. More 15 000
  2. http://prntscr.com/mlor77 log (snapshot)
  3. Why there is no cron, so the system would not be loaded?
shue249 commented 5 years ago

@DeniDay Thank you for the feedback.

The reason for the problem is most likely due to the large number of products on your OpenCart server. When you completed the initial setup of Facebook Ads Extension, the plugin will attempt to retrieve out all the products in order to generate the catalog feed file and send to Facebook. The retrieval of all products is done in batches of 100, but even so, it may still overload your system resulting in possible out of memory.

A few things we can suggestion.

  1. Adjust the batch size from 100 to 1000 - https://github.com/facebookincubator/Facebook-For-OpenCart/issues/81
  2. Setting products which are no longer in use to enable=0 (disabled) - https://github.com/facebookincubator/Facebook-For-OpenCart/issues/72
  3. What type of web hosting are you using? Is it a shared hosting service? Is there any chance for you to increase the RAM size?
DeniDay commented 5 years ago

@shue249 I have got a server

But, I have not problem with any modules, which I use for import/export on any sites. If I turn on your module, that my sites 10 min gives 500 error and I gives them:

> 
> There is an error with Facebook Ads Extension setup. Click on Facebook Ads Extension, Manage Settings, go to Advanced options and click on Delete Settings to restart the setup.
> Please contact Facebook via our Github if this error keeps showing.

May be I take you login and pas?

shue249 commented 5 years ago

@DeniDay Are you using MYSQL database? If so, can you try to increase the wait_timeout and max_allowed_packet variables of your MYSQL server.

You can refer to the section "Syncing of OpenCart products to Facebook catalog" in our FAQ - https://github.com/facebookincubator/Facebook-For-OpenCart/blob/master/FAQ.md

DeniDay commented 5 years ago

@shue249 I need ocmod from you, which uploads on Facebook the price not from the admin panel, but the one that the user sees already on the site. Since I have a module that charges the brand, depending on the group of customers: wholesale or retail.

shue249 commented 5 years ago

@DeniDay Can you help us to create another ticket on this price issue and share some screenshots to illustrate your requirement. Perhaps you can use few products as an example.