Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2007
    Posts
    139
    Plugin Contributions
    0

    Default 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.

    Please help.

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Website crashes after installing paypal IPN

    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
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Apr 2007
    Posts
    139
    Plugin Contributions
    0

    Default Re: Website crashes after installing paypal IPN

    Hi Linda,


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

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Website crashes after installing paypal IPN

    Quote Originally Posted by CJJUNE View Post
    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 ...
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Apr 2007
    Posts
    139
    Plugin Contributions
    0

    Default Re: Website crashes after installing paypal IPN

    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:-

    [FONT=&quot]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][/FONT]


    The website crashed at most of the module.
    Attached Images Attached Images  

  6. #6
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Website crashes after installing paypal IPN

    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    Apr 2007
    Posts
    139
    Plugin Contributions
    0

    Default Re: Website crashes after installing paypal IPN

    Dear Dr Byte,

    Thanks for the help.
    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?

  8. #8
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Website crashes after installing paypal IPN

    Quote Originally Posted by CJJUNE View Post
    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.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. PayPal IPN - Website Payments Standard
    By nosnappyname in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 12 Feb 2009, 01:23 AM
  2. PayPal IPN - Website Payments Standard
    By breck in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 1 Jun 2008, 08:40 PM
  3. Website Crashes After Login or Checkout
    By baddjuju in forum General Questions
    Replies: 13
    Last Post: 8 Nov 2007, 04:57 AM
  4. ZenCart crashes upon return to site after PayPal payment
    By mhaggag in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 15 Sep 2006, 08:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR