Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15
  1. #11
    Join Date
    Jun 2016
    Location
    Minneapolis, MN
    Posts
    37
    Plugin Contributions
    0

    Default Re: db Execute issue

    Ok so I put in:
    PHP Code:
    require('includes/application_top.php'); 
    on my test site...didn't work same errors.

    Well since you said all it should on the index.php anyways, I put it on the main index.php and I get a 500 error but nothing in the log file.

    Then I moved the code below the
    after the header is included.
    It loads at least by get the typical PHP error warning and the log has the same errors.

  2. #12
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,918
    Plugin Contributions
    13

    Default Re: db Execute issue

    please post the complete file and the resulting error log.

    this really should not be that hard to figure out.

    best.
    author of square Webpay.
    mxWorks now has Apple Pay and Google Pay. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

  3. #13
    Join Date
    Jun 2016
    Location
    Minneapolis, MN
    Posts
    37
    Plugin Contributions
    0

    Default Re: db Execute issue

    never mind it's not throwing an error but I'm not sure it's working correctly!!
    Last edited by tmpinsnty; 20 Apr 2018 at 04:13 PM. Reason: started working

  4. #14
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,918
    Plugin Contributions
    13

    Default Re: db Execute issue

    unless you have made other changes, its not working correctly, although probably not throwing errors.

    please refer to my 1st response to this thread:

    https://www.zen-cart.com/showthread....44#post1344744

    if you have not addressed the situation with regards to db objects v fields, you will always be at case 1, $markup+1 will always evaluate to 2.

    you can create the following file and perhaps you can see what i mean when you execute this script:

    Code:
    <?php
    
    require('includes/application_top.php');
    
    $markup = $db->Execute("SELECT configuration_value FROM configuration WHERE configuration_key = 'TEST';");
    
    switch ($markup) {
        case 1: //no rounding
            echo '1111111111----->';
            echo ($markup + 1);
            break;
        case 2: //nearest $0.99
            echo '222222222';
            break;
        case 3: //nearest $1.00
            echo '3333333333';
            break;
    }
    print_r($markup);
    best.
    author of square Webpay.
    mxWorks now has Apple Pay and Google Pay. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

  5. #15
    Join Date
    Jun 2016
    Location
    Minneapolis, MN
    Posts
    37
    Plugin Contributions
    0

    Default Re: db Execute issue

    Thanks for everything, I was able to get everything working and then some.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v154 Tax Variable Undefined In GV Module
    By PaulRRogers in forum Bug Reports
    Replies: 0
    Last Post: 4 Mar 2015, 10:16 PM
  2. v150 $db-Execute() issue with fields... Please please please help.
    By Ooba_Scott in forum General Questions
    Replies: 11
    Last Post: 3 Oct 2012, 09:36 AM
  3. Possible IE9/session variable issue?
    By pfabrick in forum General Questions
    Replies: 1
    Last Post: 11 May 2011, 10:00 PM
  4. Undefined Notice: Use of undefined constant
    By TheOracle in forum Bug Reports
    Replies: 0
    Last Post: 6 May 2007, 06:33 PM

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