SQL Statement update and sms you

[garyww]

We tried installed the "SMS You" - Order Notifications by SMS updated version. But when we ran

the sql and successful insert to the configuration table. But the following update SQL statement

when we tried to run it, it occurs error.

On the admin panel, configuration> email option. Indeed, the email option was preloaded

when we first time installed the OSC r2.2

Also, we plugin the at the configuration> email option. Once we placed an order at the OSC,

I then haven't received any SMS as well. As we already registered in clickatell.com

of Clickatell central API

 

 

Send SMS true

Send SMS true

SMS Originator XXXX ONLINE

SMS API ID WGXXXX

SMS API Userid PETER

SMS API Password XXXXX

SMS Destination 9XXXXX

SMS Message New Order Placed at EP

 

 

 

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

 

ERROR: Unclosed quote @ 203

STR: `

SQL: update `configuration_group` set `configuration_group_title` = 'Email/SMS notifications', `configuration_group_description` = 'General setting for E-Mail transport and HTML E-Mails & SMS settings' where `configuration_group_title = 'E-Mail Options'

 

 

SQL query:

 

update `configuration_group` set `configuration_group_title` = 'Email/SMS notifications', `configuration_group_description` = 'General setting for E-Mail transport and HTML E-Mails & SMS settings' where `configuration_group_title = 'E-Mail Options'

 

MySQL said:

 

#1054 - Unknown column 'configuration_group_title = 'E-Mail Options'' in 'where clause'

 

[ Back ]

[♥geoffreywalton]

Looks like a quote is missing

 

update `configuration_group` set `configuration_group_title` = 'Email/SMS notifications', `configuration_group_description` = 'General setting for E-Mail transport and HTML E-Mails & SMS settings' where `configuration_group_title = 'E-Mail Options'

 

update `configuration_group` set `configuration_group_title` = 'Email/SMS notifications', `configuration_group_description` = 'General setting for E-Mail transport and HTML E-Mails & SMS settings' where `configuration_group_titlexxxxxxxxxxxxxxxxxxxxxx = 'E-Mail Options'

 

update `configuration_group` set `configuration_group_title` = 'Email/SMS notifications', `configuration_group_description` = 'General setting for E-Mail transport and HTML E-Mails & SMS settings' where `configuration_group_title` = 'E-Mail Options'