Skip navigation
Currently Being Moderated

Problem Updating Content

Jun 13, 2012 10:54 PM

Hi

 

I have a problem which I cannot understand how to solve.

 

I have a text area (which uses a YUI rich-text editor) and before I uploaded my site to the internet there were no problems (after submitting the text it would update the database everytime without problem - regardless of the content)

 

Now, however (after uploading website and database), it seems that with certain inputs the query won't run properly. I have tried emptieing the field and typing some text and adding some photos (which works fine).

But some of the records just won't update (unless I clear them completely).

And even if I delete all the text for a record and paste a simple text document (from Microsoft word) it won't run the query without error.

 

I checked to see if it was the size. But this doesn't seem to be the case.

I checked to see if it was the images. But images don't seem to be the cause.

I tried changing the query around and rewriting it but to no success.

 

Can anyone think what the problem is? Perhaps (after copying) the tags all get messed up and causes some errors?

 

Thank you very much,

 

Chris

 
Replies
  • Currently Being Moderated
    Jun 14, 2012 10:14 AM   in reply to cripaustin

    >it won't run the query without error.

     

    and the error is......

     

    Very often, problems like this are caused by characters that the DBMS can't handle, or need to be escaped.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points