[RESOLVED] Misbehaving database

azurian

Hi. ANY help or suggestions would be appreciated. This is driving me mad.
I have a PHP and MySQL driven forum. It was working fine until my host moved to a new server. Now, unless the message left by users is very short, nothing is added to the database. For example, I can leave a message with 'Test' as the message, but if I try to add a sentance, the whole thing is ignored. The database field, named appropriately enough, "Message" is a text field.

Does any one have any ideas as to what could have happened?

trexx

are you sure it depends on the length of the message? my first guess is, that it's because of different magic_quotes_gpc settings on the old and new host. so try entering sentences with and without quotes.

then you should turn on all error output. if your query fails you'll get an error message. add some debug-output to your code to see the query your script executes, copy & paste it to phpMyAdmin or the command line and execute it directly in your database.

azurian

Thanks for your quick reply.
I have just tested again, and it makes no difference whether or not there are quotes or spaces in the message. Short - one word messages - are added perfectly, whereas longer messages of about 3 sentances are not added. There are no error messages. It just does not work. Very strange

trexx

mh, try to find out exactly how many chars you can enter and save... have you tried to output a query that fails? maybe you could post it here.

azurian

Thanks trexx. I really do appreciate your help.

I think I am starting to narrow down the problem. It seems that messages containing a single quote ' are being blocked. As you suspected, it has nothing to do with the length of the message. Do you think I need to ask my hosting company to change some of their settings? If so, which one(s)?

trexx

as i said before, it's the magic_quotes_gpc option in the php.ini g

http://www.phpbuilder.com/manual/ref.info.php

azurian

Thank you. I have contacted my hosting company with the advice you have suggested. I will feedback when I have an answer.

azurian

Thank you again. My hosting company has changed the settings you suggested and everything is working fine now. 😃