#1  
Old 23rd October 2012, 01:05
MisterRichard MisterRichard is offline
Junior Member
 
Join Date: May 2009
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default apostrophe problem

Hi,

I have recently upgraded a debian server from 5.0 to 6.0 and also upgraded ISPConfig to version 3.0.46.

Since then I have notice I am unable to use apostrophe's (') when inserting into a mysql database.

I am expecting I have overwritten a PHP config file inadvertently, as apostrophes were working before this.

Any clues ?

Mister Richard.
Reply With Quote
Sponsored Links
  #2  
Old 23rd October 2012, 16:21
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Where do you get the error? In phpMyAdmin? What's the exact error message?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 23rd October 2012, 22:52
MisterRichard MisterRichard is offline
Junior Member
 
Join Date: May 2009
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Falko,

It's another CMS on the same box as ISPconfig that uses PHP and mysql, this error has only happened recently when editing any posts, I discovered the error only happens when there are apostrophes on the data being inserted.

'Error editing page: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left'/>'

Cheers,

Richard
Reply With Quote
  #4  
Old 23rd October 2012, 22:53
MisterRichard MisterRichard is offline
Junior Member
 
Join Date: May 2009
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

THis error is showing up when trying to submit the data inside the CMS.
Reply With Quote
  #5  
Old 24th October 2012, 20:30
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

Open your php.ini and check the values of magic_quotes_gpc, magic_quotes_runtime, and magic_quotes_sybase. they shold all be off, I guess.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending mails: fine > recive: bad Moundy General 1 19th June 2012 23:40
Courier Imap is not working HellMind General 5 12th April 2012 01:04
Strange email problem for one of my domains... any help appreciated paulrobert_a Installation/Configuration 5 9th August 2010 14:15
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
BIG Problem Postfix issue admins Installation/Configuration 11 13th November 2009 10:05


All times are GMT +2. The time now is 12:40.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.