Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Location
    Dayton, Ohio
    Posts
    672
    Plugin Contributions
    0

    Default PHP Fatal Error: Email setting via PHP my Admin

    I was installing a paid plugin (Responsive Email Templates v1.2).

    The instructions on this plugin say:
    HTML Code:
    1. Go to Admin - Tools - Install SQL Patches and run this code:
    UPDATE customers SET customers_email_format = "HTML";
    I did this and after hitting the send button I got a blank page with an error. I hit the back button and the admin came back. But I just tried to send an email and my e-mail page went totally blank. No errors.

    I then went into my logs and see these errors:
    HTML Code:
    12-Sep-2016 08:20:19 America/Chicago] Request URI: access42/sqlpatch.php?action=execute, IP address: HIDDEN
    #1  trigger_error() called at [/mypath/includes/classes/db/mysql/query_factory.php:167]
    #2  queryFactory->show_error() called at [/mypath/includes/classes/db/mysql/query_factory.php:139]
    #3  queryFactory->set_error() called at [/mypath/includes/classes/db/mysql/query_factory.php:266]
    #4  queryFactory->Execute() called at [/mypath/access42/sqlpatch.php:304]
    #5  executeSql() called at [/mypath/access42/sqlpatch.php:672]
    
    [12-Sep-2016 08:20:19 America/Chicago] PHP Fatal error:  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 '&quot;HTML&quot' at line 1 :: UPDATE customers SET customers_email_format = &quot;HTML&quot;; ==> (as called by) /mypath/access42/sqlpatch.php on line 304 <== in /mypath/includes/classes/db/mysql/query_factory.php on line 167
    Obviously the SQL query I applied was not good. How can I reverse this? I know nothing about applying PHP Queries other than following instructions.
    Building a better web, one site at a time: Dayton Web Design

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: PHP Fatal Error: Email setting via PHP my Admin

    You could try using single-quotes for the value in that SQL query:
    Code:
    UPDATE customers SET customers_email_format = 'HTML';

  3. #3
    Join Date
    Apr 2007
    Location
    Dayton, Ohio
    Posts
    672
    Plugin Contributions
    0

    Default Re: PHP Fatal Error: Email setting via PHP my Admin

    That's it! As far as the blank page after trying to submit e-mail from contact page, the reason was I uploaded the module template files from that same add-on which was for v1.4. Meaning the Responsive Email Templates v1.2 e-mails are not compatible with zen 1.5.5a. So I re-uploaded all the original e-mail files and now the contact page works nicely.

    Thank you.
    Building a better web, one site at a time: Dayton Web Design

 

 

Similar Threads

  1. v154 PHP Fatal error Call-time pass-by-reference - tpl_yahootreemenu.php
    By RubenZ in forum Upgrading to 1.5.x
    Replies: 3
    Last Post: 6 Feb 2015, 05:24 PM
  2. v150 PHP Fatal error: Out of memory in includes/modules/attributes.php
    By donnyb in forum General Questions
    Replies: 0
    Last Post: 6 Apr 2012, 12:15 AM
  3. Mail via PHP gives email error
    By moenanie in forum General Questions
    Replies: 7
    Last Post: 29 Aug 2011, 09:40 PM
  4. Fatal Error on my Admin/login.php page
    By terrancesmith98 in forum General Questions
    Replies: 11
    Last Post: 9 Jul 2009, 02:16 AM

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