Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 30
  1. #11
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default Re: Fatal Error when purchasing Gift Certificate

    Quote Originally Posted by lat9 View Post
    When you view your admin's Tools->Server/Version Info, what shows in that upper area?
    What you described before

    MySQL Slow Query Log Status: On
    MySQL Slow Query Log File: server-slow.log
    MySQL Mode: STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, TRADITIONAL, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

  2. #12
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default Re: Fatal Error when purchasing Gift Certificate

    Quote Originally Posted by lat9 View Post
    The default value should be an integer 0 (as you see in your database). The issue is that not only PHP but also MySQL implementations are getting more strict, so you can no longer store '' (an empty string) and have it be magically converted to a 0 when the database field is set to contain an integer value.
    Of course it makes sense.
    Is it possible to "trick" the system to include a meaningless value in the instance of GC orders? Or perhaps replace the empty values with the customer's own info therefore eliminating the error?
    Just trying to figure out a different approach, that's all.

  3. #13
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    9,669
    Plugin Contributions
    73

    Default Re: Fatal Error when purchasing Gift Certificate

    Quote Originally Posted by mvstudio View Post
    Of course it makes sense.
    Is it possible to "trick" the system to include a meaningless value in the instance of GC orders? Or perhaps replace the empty values with the customer's own info therefore eliminating the error?
    Just trying to figure out a different approach, that's all.
    If you send me a copy of your version of /includes/classes/order.php to my direct email (if you don't have it, PM me), I'll give it a look.

  4. #14
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    9,669
    Plugin Contributions
    73

    Default Re: Fatal Error when purchasing Gift Certificate

    Quote Originally Posted by mvstudio View Post
    What you described before

    MySQL Slow Query Log Status: On
    MySQL Slow Query Log File: server-slow.log
    MySQL Mode: STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, TRADITIONAL, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION
    Does that show even after you've added that /admin/extra_datafiles file?

  5. #15
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    1,618
    Plugin Contributions
    5

    Default Re: Fatal Error when purchasing Gift Certificate

    interesting.... one of my test sites has the following:

    MySQL Mode: NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

    when i add the mode of traditional into the admin area as described in the patch above, the mode changes as follows:

    MySQL Mode: STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, TRADITIONAL, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

    which seems to be a more restrictive mode to operate.

    just an FYI.
    practice #socialdistancing #staysafe
    email is hard....
    help out with the green....

  6. #16
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default Re: Fatal Error when purchasing Gift Certificate

    Quote Originally Posted by lat9 View Post
    Does that show even after you've added that /admin/extra_datafiles file?
    Yes. I haven't removed the file you said to upload.
    M.Valenti
    Contemporary Artist - Entrepreneur
    http://www.manuelavalenti.com - http://www.byvalenti.com

  7. #17
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default Re: Fatal Error when purchasing Gift Certificate

    Quote Originally Posted by carlwhat View Post
    interesting.... one of my test sites has the following:

    MySQL Mode: NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

    when i add the mode of traditional into the admin area as described in the patch above, the mode changes as follows:

    MySQL Mode: STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, TRADITIONAL, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

    which seems to be a more restrictive mode to operate.

    just an FYI.
    I saw that https://dev.mysql.com/doc/refman/5.7...de_traditional

    "Before MySQL 5.7.4, and in MySQL 5.7.8 and later, TRADITIONAL is equivalent to STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION.

    From MySQL 5.7.4 though 5.7.7, TRADITIONAL is equivalent to STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION. The NO_ZERO_IN_DATE, NO_ZERO_DATE, and ERROR_FOR_DIVISION_BY_ZERO modes are not named because in those versions their effects are included in the effects of strict SQL mode (STRICT_ALL_TABLES or STRICT_TRANS_TABLES). Thus, the effects of TRADITIONAL are the same in all MySQL 5.7 versions (and the same as in MySQL 5.6). "

    Maybe that's why it isn't changing on my site (?).

  8. #18
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    1,618
    Plugin Contributions
    5

    Default Re: Fatal Error when purchasing Gift Certificate

    Quote Originally Posted by mvstudio View Post
    I saw that https://dev.mysql.com/doc/refman/5.7...de_traditional

    "Before MySQL 5.7.4, and in MySQL 5.7.8 and later, TRADITIONAL is equivalent to STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION.

    From MySQL 5.7.4 though 5.7.7, TRADITIONAL is equivalent to STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION. The NO_ZERO_IN_DATE, NO_ZERO_DATE, and ERROR_FOR_DIVISION_BY_ZERO modes are not named because in those versions their effects are included in the effects of strict SQL mode (STRICT_ALL_TABLES or STRICT_TRANS_TABLES). Thus, the effects of TRADITIONAL are the same in all MySQL 5.7 versions (and the same as in MySQL 5.6). "

    Maybe that's why it isn't changing on my site (?).
    perhaps. you can try:

    Code:
    define('DB_MYSQL_MODE', 'NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION');
    see if it changes, and if it does then see if it fixes your original GC error.

    if it does not change, then perhaps you host does not allow changing of the sql_mode, but that is pure conjecture on my part...

    good luck!
    practice #socialdistancing #staysafe
    email is hard....
    help out with the green....

  9. #19
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default Re: Fatal Error when purchasing Gift Certificate

    Quote Originally Posted by carlwhat View Post
    perhaps. you can try:

    Code:
    define('DB_MYSQL_MODE', 'NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION');
    see if it changes, and if it does then see if it fixes your original GC error.

    if it does not change, then perhaps you host does not allow changing of the sql_mode, but that is pure conjecture on my part...

    good luck!
    OMG!!! Yes!!! It worked!! And GC purchases go through as they should!! You're AWESOME!!! Thank you so much!!!!

  10. #20
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default Re: Fatal Error when purchasing Gift Certificate

    Spoke too soon. The button to release the GC is no where to be found. Can't release it at all.

 

 
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. v154 Checkout page doesn't load when purchasing a gift certificate
    By tk42one in forum General Questions
    Replies: 13
    Last Post: 2 May 2016, 11:20 PM
  2. Gift Certificates causing fatal error when applying a coupon to them
    By jrstaatsiii in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 5
    Last Post: 29 Jul 2009, 07:39 PM
  3. PayPal transactions fails when purchasing Gift Certificates only
    By shocker in forum PayPal Express Checkout support
    Replies: 0
    Last Post: 17 Jan 2009, 02:28 PM
  4. Gift Certificate configuration has left 'fatal error'
    By Mrsjprice in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 0
    Last Post: 14 Oct 2008, 05:46 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