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
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
MySQL 5.6 OSX 10.6 and NB2.8 corrputs php code with "\"
-
- Posts: 11
- Joined: Fri Aug 16, 2013 4:14 pm
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: MySQL 5.6 OSX 10.6 and NB2.8 corrputs php code with "\"
Ralcala, can you post an example of your code?
-
- Posts: 11
- Joined: Fri Aug 16, 2013 4:14 pm
Re: MySQL 5.6 OSX 10.6 and NB2.8 corrputs php code with "\"
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 "\"
$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 "\"
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: MySQL 5.6 OSX 10.6 and NB2.8 corrputs php code with "\"
Ralcala,
try to set magic_quotes_gpc = Off in php.ini file.
Max
try to set magic_quotes_gpc = Off in php.ini file.
Max
-
- Posts: 11
- Joined: Fri Aug 16, 2013 4:14 pm
Re: MySQL 5.6 OSX 10.6 and NB2.8 corrputs php code with "\"
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.
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.
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: MySQL 5.6 OSX 10.6 and NB2.8 corrputs php code with "\"
OK: I record a memo on my agenda!Ralcala wrote:i own you a HOT CHILI TACOS order when you came here.