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 '"HTML"' at line 1 :: UPDATE customers SET customers_email_format = "HTML"; ==> (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.
Bookmarks