Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Posts
    4
    Plugin Contributions
    0

    application error mysql_query INSERT products, Question

    Greetings Zen Heads,

    I created a PHP form which creates new products in zen-cart. I used this zen-cart wiki link to reference which tables need to be populated:

    http://www.zen-cart.com/wiki/index.p...rting_products

    I was able to populate the tables by running a few INSERT QUERIES, however, I'm running into a problem when validating the data inside the "online catalog".

    SCENARIO 1: If I create a new product in category-ONE using my new PHP form, while viewing the "online catalog", then clicking on category-ONE, I get a blank page, instead of seeing the category page with the newly populated product.

    SCENARIO 2: Then after, If I create a new product in category-ONE using the "zen cart admin", while viewing the "online catalog", then clicking on category-ONE, I see the products created by my new PHP form AND the "zen cart admin".

    Can someone help me figure out what piece of code I'm missing from SCENARIO 2 which fixes the "blank page" error I'm getting with SCENARIO 1?

    Any help would be greatly appreciated.

    Thanks and have a great day,

    HighJump

  2. #2
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: mysql_query INSERT products, Question

    Quote Originally Posted by HighJump View Post
    ... I get a blank page, instead of seeing the category page with the newly populated product.
    FAQ on troubleshooting blank pages: https://www.zen-cart.com/tutorials/index.php?article=82
    .

    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.

  3. #3
    Join Date
    Oct 2008
    Posts
    4
    Plugin Contributions
    0

    Default Re: mysql_query INSERT products, Question

    Dr Byte,

    Thanks for providing the link.

    I tried using the "Debug Error Logging Utility" method by coping the enable_error_logging.php to it's respective folders. However, even after giving 0777 permission to the cache folder, a log file has yet to be generated.

    I tried the second method which asks to create a configure.php file. This method worked and I am currently reading through the long list of debugging results.

    Another troubleshooting method I will try is to install a fresh copy of zen-cart, leave everything default, and try my INSERT PRODUCT PHP FORM on a fresh installation of zen-cart.

    Any other ideas?

    Thanks and Take Care,

    HighJump

  4. #4
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: mysql_query INSERT products, Question

    Ignore all the notice, warnings in the debug. You should only look at the "fatal errors"
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

 

 

Similar Threads

  1. v152 mysql_query
    By RodG in forum Bug Reports
    Replies: 4
    Last Post: 21 Dec 2013, 02:09 PM
  2. mysql_query question.
    By cleverpork in forum General Questions
    Replies: 7
    Last Post: 23 Nov 2011, 05:55 AM
  3. database question: insert new users, orders
    By rebusB in forum General Questions
    Replies: 9
    Last Post: 21 Nov 2011, 04:24 AM
  4. Disabled Products show up in New Products for (insert month)
    By LadyMorgana in forum Setting Up Specials and SaleMaker
    Replies: 33
    Last Post: 16 Feb 2010, 12:54 AM

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