Printable Version of Topic

Click here to view this topic in its original format

Ventrino Forum for Walker Scripts _ Ventrino FAQ _ Why Does Output From Php Have \'s In It?

Posted by: Martyn Jun 14 2006, 06:34 PM

SYMPTOMS

I see \'s in SQL and HTMP output from PHP and it causes the SQL to error and the HTML to display incorrectly.

CAUSE

Your host has turned on "magic quotes". This is a feature of little value and only causes confusion. Consequently most hosting companies do not switch this feature on.

SOLUTION

There are three solutions:

1. Turn it off by adding the following to your .htaccess file:

CODE
php_flag magic_quotes_gpc off


2. Ask your host to switch it off in the PHP.ini file.

3. If your host blocks the use of .htaccess files (very few do) and will not change the PHP.ini so that magic quotes are NOT used then the only option is to switch hosting companies.

Posted by: Rich May 12 2007, 11:45 PM

Hi Martyn,
Thanks for your help. Now I have tried the .htaccess file once more with "php_flag magic_quotes_gpc off" added to the .htaccess file with no luck, I just get an internal server error plus a 500 error....
The \\\\\' have been in the files since I started day one but the disappearance of the ISB and the missing submit button happened quickly after I was playing around withe block editor and also I had a bit of a play around with the virtual page thingy. the ISB worked fine on both public and members pages before I played around with it.

I have installed the traffic exchange in another folder just to see if it works and it seems to , the only thing that doesn

Posted by: sunwest May 13 2007, 01:50 PM

Richard,

I have the same problem. I found a workaround that you can use. If you have phpMyAdmin on your site you can edit the block directly in the database.
After activating phpMyAdmin find the table vtp_blocks. You can edit out the \\\ directly from this table. Just delete them and then make sure the radio button marked Save is checked, and click the Go button. This will return your ISB block to the original.

Posted by: Rich May 13 2007, 02:06 PM

G\\\'Day sunwest,
Thanks for the info I thought it must have been in the database, I'm about to give it a try.
will let you know how I go.

Richard
P.S. the \\\ in G'Day are just a joke...hehe

Posted by: Rich May 13 2007, 09:58 PM

Thanks sunwest,
worked a treat and now the members are a happy bunch they can see all their stats.
Just have to sort out the emailer now.

Cheers
Rich

Posted by: alkaline May 13 2007, 10:06 PM

I have some of them in my site, I have changed hosting but have a few of those signs left. Some of them are making the "Report Site" feature in the members area not to work. Where in the database can I find this button? If thats where it is located ;-).. That way I can manually remove the signs.

Posted by: Rich May 14 2007, 01:29 AM

G'day alkaline,
That file is found in the same place and was very easy to fix just remove the \\\ in the small file and save(remove them from all the files) use sunwest's instructions.

QUOTE
I have the same problem. I found a workaround that you can use. If you have phpMyAdmin on your site you can edit the block directly in the database.
After activating phpMyAdmin find the table vtp_blocks. You can edit out the \\\ directly from this table. Just delete them and then make sure the radio button marked Save is checked, and click the Go button. This will return your ISB block to the original.


Rich

Posted by: Ken Athas Jul 26 2007, 06:38 PM

I am having the\\\\ issue in my emails.

Should magic quotes be on or off in the BCP?

Posted by: Rich Jul 26 2007, 08:23 PM

QUOTE (Ken Athas @ Jul 27 2007, 02:38 AM) *
I am having the\\\\ issue in my emails.

Should magic quotes be on or off in the BCP?

Hi Ken, once you fix up the database and if you server won't turn off the magic quotes(chances they won't) I have found a few small work arrounds to overcome the \\\\\ problem.
1. use ` instead of ' (that's the one just left of the number one key) works a treat.
2. remove all ' and " from any html you write (very easy just use the replace function in your html editor) what I do is replace the" just with a space and bingo it all works fine.

Hope this helps

Rich

Posted by: Ken Athas Jul 26 2007, 08:34 PM

QUOTE (Rich @ Jul 26 2007, 02:23 PM) *
Hi Ken, once you fix up the database and if you server won't turn off the magic quotes(chances they won't) I have found a few small work arrounds to overcome the \\\\\ problem.
1. use ` instead of ' (that's the one just left of the number one key) works a treat.
2. remove all ' and " from any html you write (very easy just use the replace function in your html editor) what I do is replace the" just with a space and bingo it all works fine.

Hope this helps

Rich



Hey Rich,

I'll give it a go. I tried changing the magic quote setting in BCP, that didn't do anything.

It's amazing how many times we use that little guy, isn't it?

LOL

Thanks!!

Posted by: Rich Jul 26 2007, 08:51 PM

QUOTE (Ken Athas @ Jul 27 2007, 04:34 AM) *
Hey Rich,

I'll give it a go. I tried changing the magic quote setting in BCP, that didn't do anything.

It's amazing how many times we use that little guy, isn't it?

LOL

Thanks!!


Hi Ken, Oh I forgot to tell you that I tried that on/off setting in the BCP and it made no differance either.
so from then on I`ve been using the little ` and if you need to do quote marks us two of them ``GREAT STUFF`` wouldn`t you say...lol

Rich

Posted by: Ken Athas Jul 27 2007, 02:47 AM

Rich,

I do agree....

The .htaccess thing did it for me...

Now Ill try the other site.... here goes nothing...

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)