[solved] Unwanted backslashes after upgrade to mysql 5

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Wert
Former Team Member
Posts: 3676
Joined: Tue Jul 03, 2001 8:33 pm
Location: Sacramento, CA
Name: Chris Aguilar

[solved] Unwanted backslashes after upgrade to mysql 5

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 $)
Last edited by ric323 on Sat Mar 13, 2010 9:51 am, edited 2 times in total.
Reason: Topic icon changed
Chris Aguilar - AKA "Wert"

Oleg
Former Team Member
Posts: 1221
Joined: Sat Jan 30, 2010 4:42 pm
Location: NYC
Contact:

Re: Unwanted backslashes after upgrade to mysql 5

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

magic_quotes_runtime that refuse to be turned off?

Try instructions here.
Participate in phpBB development: Get involved | Issue tracker | Report a bug | Development board | [url=irc://chat.freenode.net/phpbb-dev]Development IRC chat[/url]
My stuff: mindlinkgame.com

Wert
Former Team Member
Posts: 3676
Joined: Tue Jul 03, 2001 8:33 pm
Location: Sacramento, CA
Name: Chris Aguilar

Re: Unwanted backslashes after upgrade to mysql 5

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?
Chris Aguilar - AKA "Wert"

Oleg
Former Team Member
Posts: 1221
Joined: Sat Jan 30, 2010 4:42 pm
Location: NYC
Contact:

Re: Unwanted backslashes after upgrade to mysql 5

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?
Participate in phpBB development: Get involved | Issue tracker | Report a bug | Development board | [url=irc://chat.freenode.net/phpbb-dev]Development IRC chat[/url]
My stuff: mindlinkgame.com

Wert
Former Team Member
Posts: 3676
Joined: Tue Jul 03, 2001 8:33 pm
Location: Sacramento, CA
Name: Chris Aguilar

Re: Unwanted backslashes after upgrade to mysql 5

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.
Chris Aguilar - AKA "Wert"

Wert
Former Team Member
Posts: 3676
Joined: Tue Jul 03, 2001 8:33 pm
Location: Sacramento, CA
Name: Chris Aguilar

Re: Unwanted backslashes after upgrade to mysql 5

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. :D
Chris Aguilar - AKA "Wert"

Locked

Return to “[3.0.x] Support Forum”

Who is online

Users browsing this forum: Exabot [Bot], Google [Bot] and 90 guests