[solved] Unwanted backslashes after upgrade to mysql 5

Wert · Post by **Wert** » Fri Mar 12, 2010 3:25 pm

Support Request Template
What version of phpBB are you using? phpBB 3.0.7-PL1
What is your board's URL? n/a
Who do you host your board with? Hostrocket
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? No
Is registration required to reproduce this issue? Yes
What version of phpBB3 did you update from? phpBB 3.0.7
What styles do you currently have installed? Prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
When did your problem begin? Problem began when my host upgraded mysql and php (from 4 to 5). Used procedure to run proper sql queries to fix database for mysql 5.
Please describe your problem.

Currently, an additional backslash is added before any quote or double quote.
For instance:
He's becomes He/'s.

Also, upon edit, any backslash, becomes two backslashes. This is making my forums pretty much unusable.

This happens with stock theme (prosilver) and happens everywhere (thread titles, posts, etc.)
Generated by SRT Generator ($Rev: 3777 $)

Oleg · Post by **Oleg** » Fri Mar 12, 2010 3:54 pm

magic_quotes_runtime that refuse to be turned off?

Try instructions here.

Wert · Post by **Wert** » Fri Mar 12, 2010 4:07 pm

Here is my php 5 information pertaining to magic quotes.

Code: Select all

PHP Version 5.2.13

                       Local Value     Master Value
magic_quotes_gpc	    Off           	 On
magic_quotes_runtime	Off	         Off
magic_quotes_sybase	Off	         Off

I will try the following to see if I get any results.

If access to the server configuration is unavailable, use of .htaccess is also an option. For example:

php_flag magic_quotes_gpc Off

Has anyone with this problem had any luck with the .htaccess method?

Oleg · Post by **Oleg** » Fri Mar 12, 2010 9:50 pm

Looks like your magic quotes are off already.

I don't have any serious ideas but some things you could try:

1. Install a fresh copy of phpbb and see if it exhibits the same behavior.

2. Check whether quotes are added on input or rendering. Enter a post normally and check its data in the database; do you have backslashes before quotes?

Wert · Post by **Wert** » Sat Mar 13, 2010 7:25 am

Installed a fresh copy of the latest (new database, new db user, etc.) and behavior still exhibits. This tells me it's not my old database, but rather either something not happening in phpBB or a conflict with my hosts new mysql 5 settings.

Wert · Post by **Wert** » Sat Mar 13, 2010 9:13 am

Problem is resolved.

It was indeed "magic quotes" and my host was able to make the adjustment to turn them off and now all seems well.

Many thanks to everyone who assisted in getting this fixed for me.

advertisements