Adding Content Generates an error

[razzam21]

I haven't tracked down exactly why but I have identified a problem.  The problem is that when adding content to CMSMS 1.5.1  that has the word select before the word from in the content an error is thrown and nothing is saved.  I am trying to decifer why but I know what is causing it.  If I remove either the select or the from it will save but if both are in there and in the proper order it will not save.  I am not entirely sure why as I can add the content to mysql directly.  I will continue to look for a fix to this problem.

[RonnyK]

razzam21,

are you trying to execute some SQL, or inserting plain text, that has the words "select" and "from" inside the text....
Or could you paste the data you put in the content in a reply, for reproduction purposes....


Ronny

[razzam21]

I am trying to put it as text in the document.  In order to demonstrate this error here is some text that should causes the error for me.  The word select is in the first line and the from is in the last line.  The two don't have to be that close just in that order.  If you reverse the order (for example putting the first sentence last) it will save.  I tried to track down why and at present I am still not sure.



You have been selected. 
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam cursus, pede eu volutpat pellentesque, nibh lorem ornare justo, et ornare tortor felis ut diam. Sed laoreet nunc non elit. Maecenas pede. Maecenas in ipsum a nisi vestibulum vestibulum. Duis velit. Cras in ante. Nulla consequat sagittis dui. Nunc scelerisque dolor vitae urna. Quisque sed nibh et purus tincidunt accumsan. Donec iaculis nulla a magna euismod suscipit.
Nunc ante mi, convallis ut, sodales non, venenatis vel, neque. Cras dapibus. Suspendisse porta augue nec metus. Vestibulum orci quam, blandit in, mollis ullamcorper, rhoncus id, dolor. Etiam metus tortor, feugiat eget, faucibus quis, blandit elementum, enim. Proin dapibus. Nulla et est. Suspendisse ipsum. Pellentesque convallis risus sed tellus. Nunc quis pede. Proin nec purus. Nulla ut tortor in nunc elementum pellentesque. Morbi felis felis, tempus ac, rhoncus sit amet, fringilla congue, erat. Mauris orci mauris, gravida non, semper sit amet, viverra eu, ligula. Mauris sit amet libero. Phasellus elit velit, iaculis et, faucibus et, venenatis sed, elit. In auctor, pede luctus malesuada pulvinar, pede neque interdum ligula, at consequat eros dui quis tortor. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.
Donec a metus quis metus rutrum ultrices. Nullam a ipsum. Pellentesque pellentesque, ipsum sed congue condimentum, nunc sem consequat leo, non semper magna est at neque. Quisque et elit. Phasellus augue. In mauris. Sed bibendum tristique nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Curabitur massa neque, adipiscing quis, euismod et, sodales ac, massa. Vestibulum sit amet massa. Vivamus ultrices. Aliquam velit. In vitae orci. Phasellus accumsan, sem non volutpat dignissim, ligula quam auctor sapien, at commodo mauris ante ac neque.
Fusce nec orci eget ligula mattis posuere. Nullam felis. Donec consequat, odio a aliquam imperdiet, tellus sem tempus orci, sed fringilla mauris quam ut massa. Phasellus turpis arcu, interdum at, interdum nec, pulvinar eget, metus. Sed auctor tempus turpis. Nullam nisl ipsum, lobortis et, feugiat ac, pretium ut, enim. Vestibulum aliquam nulla nec tellus. In at magna. Pellentesque vitae diam a sapien ultricies sodales. Maecenas sollicitudin ornare pede. Praesent elementum urna non pede. Sed ut urna. Etiam tortor velit, pellentesque congue, rhoncus vehicula, laoreet blandit, eros. Phasellus sed ipsum non lorem accumsan hendrerit. Cras lobortis. Cras vestibulum mauris eu urna. Nam rhoncus neque in leo. Quisque rhoncus ante id tellus.
Mauris in mi. Fusce vestibulum nisi varius magna. Pellentesque nulla. Aliquam viverra velit id nunc. Maecenas vitae purus. Sed elit sapien, vulputate vel, iaculis a, vehicula laoreet, ante. Ut non diam. Nam tellus metus, scelerisque sed, porta sit amet, vehicula eget, massa. Curabitur risus nunc, tincidunt nec, lacinia eget, porta nec, nibh. Integer nec est in turpis ultricies dapibus.
from a long list of users to fix this problem.

[calguy1000]

Myself, and two others have tried to reproduce this problem, with text like

'you can select this data from the database'....
and other variations and have not been able to generate an error.

[tyman00]

I can't replicate the issue in 1.5.1. I tried the exact text you pasted above.

http://screencast.com/t/hgxJQD5R

[razzam21]

Thanks for the assistance.

I have had this problem occur on two different web sites that I have build.  In both cases I download the latest version of CMS Made Simple at the time (which happened to be 1.5.1 "San Juan") and on both sites I am having a problem.  Does that mean it  is a configuration error? 

On both sites I followed the install and then started adding content and the error happened.

[RonnyK]

razzam,

if you want, can you PM me a login, to one of the sites, to see what the backend is doing....

Preferably an account with the english language set.

Ronny

[razzam21]

Here are the two screen shots of the text that I am entering and the error screen I am getting.

Before:
http://www.screencast.com/users/razzam2 ... 3affb8e527

After:
http://www.screencast.com/users/razzam2 ... 24bc411d0d

[razzam21]

I have tried with all of the browsers that I have access to.

IE - 8, 7, 6
FireFox - PC 3, PC 2, Mac 3
Opera - 9
Safari - PC 3, MAC 3