cancel
Showing results for 
Search instead for 
Did you mean: 

Can't save CMS page/block due to # in the content

Can't save CMS page/block due to # in the content

Mysql: 5.6.21

 

When I try to save a block or page, if the content has a # in it the save failes (no error it just doesn't save).

 

The problem I'm sure stems from the fact that in mysql the # is used as a comment break so:

 

insert into table values ('This is some content # with a hash in the middle');

 

fails because it is interpreted as

 

insert into table values ('This is some content

 

and everything that follows after that is seen just as a comment on the query.

 

Banging my head against a brick wall on this for ages now so any help would be appreciated.

1 REPLY

Re: Can't save CMS page/block due to # in the content

@BigLarry

 

Have you upgraded your Magento store from an old version?

Found something useful, please give "Kudos" or "Accept as Solution" for Token of Appreciation.
Free Magento Extensions : https://magecomp.com/free-magento-extensions.html