Results 1 to 10 of 10

Hybrid View

  1. #1
    Join Date
    Nov 2003
    Posts
    1,987
    Plugin Contributions
    15

    Default Re: Sql error when email button selected in Coupons

    The sql upgrade from 1301 to 1302 shows:
    # add ability to send newsletters to self
    INSERT INTO query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');
    Is that correct?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Sql error when email button selected in Coupons

    your includes/functions/audience.php is not up-to-date.
    .

    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
    Nov 2003
    Posts
    1,987
    Plugin Contributions
    15

    Default Re: Sql error when email button selected in Coupons

    You are are right, thanks DrByte!

    I knew I skipped some files, I wonder how many more I left out somehow

    Code:
        } elseif ( substr( $val, 0, 9) == '$SESSION:' ) {
          //return the value of the SESSION var indicated
          $param = str_replace('$SESSION:', '', $val);
          $val = $_SESSION[$param];
    And it also clarifies the mysterious $SESSION "var" :-)

 

 

Similar Threads

  1. v139h DB/SQL Error when using SQL Patch for Add Pages More Info Sidebox addon
    By maperr55 in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 5 Mar 2012, 09:32 PM
  2. No error when forced attribute not selected
    By nacnac in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 5 Aug 2011, 05:31 AM
  3. SQL syntax error in creating discount coupons
    By Del in forum Bug Reports
    Replies: 2
    Last Post: 6 Mar 2008, 02:50 PM
  4. No error when shipping method not selected
    By scrapper in forum Addon Shipping Modules
    Replies: 1
    Last Post: 15 Sep 2006, 12:45 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