close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

SS CMS error when pasting and updating pages

Thread began 7/20/2011 12:01 pm by nuhu.abdulkadir418811 | Last modified 7/21/2011 1:24 pm by Ray Borduin | 1270 views | 7 replies |

nuhu.abdulkadir418811

SS CMS error when pasting and updating pages

I get the error "Incorrect string value: '\xE2\x80\x9CBMG...' for column 'HistoryValue' at row 1" when pasting and updating pages using CMS installed via Site Sculptor.

Could someone please tell me how to resolve this problem?

Sign in to reply to this post

Jason ByrnesWebAssist

are you copying the content from Word?

if so make sure to use the paste From word toolbar icon to clean the content up.

the paste from world toolbar icon is the clipboard with the Word "W" logo.

Sign in to reply to this post

nuhu.abdulkadir418811

Done that and more already

Yes, I have posted from Word and its still giving the same error.

Pasted in Komodo Edit and changed the encoding on the file settings to UTF-8 and pasted in the CMS..... still giving error. Went to the database file (pcms2_contenthistory) via Navicat to the concerned under the HistoryValue column and pasted there .... still same problem (throws up error 1366). Checked with database encoding and selected UTF-8 Unicode/utf8_general_ci and still not working. Tried latin1/latin1_swedish_ci and still throws up the error.

I could have pulled off my hair (if I had any) by now and really do not know what else to try. When my client types the content in, it updates but pasting simply does not work.

Sign in to reply to this post

Jason ByrnesWebAssist

well, what is the content you are pasting?

Sign in to reply to this post

nuhu.abdulkadir418811

Pasting large document

Pasting website privacy policy (5 pages long)

Sign in to reply to this post

Jason ByrnesWebAssist

it's possible it may be to long to post into the content field.


try pasting it into a text file to clean the content up, then copying it from the text file then into Power CMS


you may also need to break it up into smaller pieces.

Sign in to reply to this post

nuhu.abdulkadir418811

Problem with certain characters

Tried again to paste from Komodo in bits and pieces and still didn't work.

Now tried in bits removing all the bullets and it worked. Strange that MySQL does not recognize bullets. Well, worked till I got to the last part (smallest chunk) of the document and still not working. Cant seem to identify what character(s) is causing this?

Since its the recognition of certain characters that's creating the problem, is there a way round this with MySQL?

Sign in to reply to this post

Ray BorduinWebAssist

It could have something to do with your charset definition either

1) on the html page
2) in the database itself
3) in the database connection

You could try adjusting those charsets to see if you could find one that works. The html page you can change the charset in a meta tag. The mysql database and tables have a query you can run on the database to change the charset, and the connection can be set with the mysql_set_charset() function (this is exposed in our dynamic connections extension if you don't want to figure out how and where to add it manually).

You could test if it is the database itself by seeing if you can enter those characters directly in the database using mysql myAdmin. Adjust the charset settings with code like:

alter database [enter your database name]charset=utf8;
ALTER TABLE pg1_gallery_images CONVERT TO CHARACTER SET utf8;

Then see if it works. Once it works in the database directly, then update the html page and connection to use the same charset.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...