MySQL 5.6 OSX 10.6 and NB2.8 corrputs php code with "\"

[Ralcala]

Hi fellas iam newbie with NB2.8

Great dev tool but i just trying to reach out the next level on it…but i dont know whats happening with FC10 i just run fine and RHEL5 same thing but i cant belive it when I push the save buttpn on ADD ACTIVITY the php codes just CORRUPTS with "\" slash symbol and doesnt run anymore.

If i save it before and paste it DIRECTLY on phpMyAdmin and update the table field works fine. What a PAIN. dont you tihink?

BTW i edit my.cnf and #-ed the last row #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

its MySQL fault? please help me

Thanks guys

[massiws]

Ralcala, can you post an example of your code?

[Ralcala]

this is the code BEFORE save

$s = "CREATE TABLE #dataTable# ";
$s .= "SELECT id_avff_an, fecha_an, par_progr_an FROM an_anticipos ";
$s .= "WHERE fecha_an = '2013-10-31'";

nuRunQuery($s);

and this is the code AFTER save

$s = \"CREATE TABLE #dataTable# \";
$s .= \"SELECT id_avff_an, fecha_an, par_progr_an FROM an_anticipos \";
$s .= \"WHERE fecha_an = \'2013-10-31\'\";

nuRunQuery($s);

Really WEIRD i never face something like this…

BTW when use Report Builder and click on COPY CHANGES button the code is also corrupted too with "\"

[massiws]

Ralcala,
try to set magic_quotes_gpc = Off in php.ini file.

Max

[Ralcala]

When Max TALKS error GONES…..

Thank you Max and thank you for your time effort. really.

Just for the record my OSX is HACKintosh and dont know why php.ini.LESS no config loaded only defaults. WEIRD so i have to activate .htaccesss file and put there the directive for disable mq_gpc.

Greetings from MEXICO. i own you a HOT CHILI TACOS order when you came here. LOL.

[massiws]

i own you a HOT CHILI TACOS order when you came here.

OK: I record a memo on my agenda!