utf8_general_ci direct entry into send_sms table without urlencoding. set charset=UTF-8
On Wed, May 21, 2014 at 8:05 PM, Alvaro Cornejo <[email protected]>wrote: > Hi > > garbage on url... seems it is not recognizing url charset/encode > format. Have you urlencoded it before submitting to sqlbox? what > charset do you use when submitting info to sql and what charset is > defined on mysql table? > > Regards > > Alvaro > > |-----------------------------------------------------------------------------------------------------------------| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via > SMS y GPRS online > Visitenos en www.perusms.com > > > On Wed, May 21, 2014 at 3:49 AM, خان ابو زید <[email protected]> > wrote: > > Dear Member, > > > > I have installed kannel sqlbox from svn latest version. > > > > I have getting following error in sqlbox > > > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] ERROR: MYSQL: You have an error in your > SQL > > synta x; check the manual > that > > corresponds to your MySQL server version for the right > > syntax to use near '' at line 1 > > 2014-05-21 06:03:09 [3793] [1] ERROR: MYSQL: You have an error in your > SQL > > synta x; check the manual > that > > corresponds to your MySQL server version for the right > > syntax to use near ')' at line 1 > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage > detected > > (% d ) skipping. > > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, > > droppin g it! > > 2014-05-21 06:03:09 [3793] [1] ERROR: MYSQL: You have an error in your > SQL > > synta x; check the manual > that > > corresponds to your MySQL server version for the right > > syntax to use near '' at line 1 > > 2014-05-21 06:03:09 [3793] [1] ERROR: MYSQL: You have an error in your > SQL > > synta x; check the manual > that > > corresponds to your MySQL server version for the right > > syntax to use near ')' at line 1 > > > > -- > > Regards > > > > Khan Abuzaid > > Mob# :09664541886/9594092200 > > Mumbai > -- Regards Khan Abuzaid Mob# :09664541886/9594092200 Mumbai
