Website crashes after installing paypal IPN

Hi

My website crashes after installing paypal IPN ZC 1.3.7. If I remove the PP IPN module, the website is OK.

When I mean crash, the website cannot display most of the thing on the website. SQl error and nothing works right.

What is wrong? I didnt change any code.:frusty:

Please help.

You may wish to upgrade to the Zen Cart v1.3.7.1 which has the current updates in it:
http://www.zen-cart.com/forum/showthread.php?t=69769

Hi Linda,

Ok thanks.
However the PP IPN works good on local host with testing using the sandbox. :wacko:

CJJUNE:

When I mean crash, the website cannot display most of the thing on the website. **SQl error and nothing works right.**Please do not post a problem without also posting the details ... such as the SQL error message that you get on your site.
We cannot magically guess the cause of the problem ...

Hi Dr Byte,

Sorry for not elaborating further.

After installating PP IPN with the patch dated 17 June my website cannot display any product listing from Home (no random new product display) and New Product. I can only navigate from 3 links and they are Home, New Product and Contact Us. Login is missing Sideboxes are missing.

After click Home the website display as per attached.

After click New Product the SQL error generated was this error below:-

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 '-0, MAX_DISPLAY_PRODUCTS_NEW' at line 10
in:
[SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 order by pd.products_name limit -0, MAX_DISPLAY_PRODUCTS_NEW]

The website crashed at most of the module. :frusty:

Try this:
http://www.zen-cart.com/forum/showpost.php?p=378357&postcount=3

Dear Dr Byte,

Thanks for the help.:clap:
Now my PP IPN works like beauty.
Does it mean i have to execute the SQL statements as a monthly routine thing to avoid such crashing problem?

CJJUNE:

Does it mean i have to execute the SQL statements as a monthly routine thing to avoid such crashing problem?

No -- those were necessary due to the large number of contributions and built-in modules you've installed/activated.

Those SQL statements will be built-in to the next release of Zen Cart, so you will not have to do them repeatedly.