Hey all,
I have been experiencing weird, random errors ever since the 1.0.2 release. When adding content and then saving documents I get weird changes to the icons in the tree. Sometimes the icons will disappear and other times it will change the content type (most of the time to xml/rss). Other times the document won’t even save and I get this error:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' richtext=1, published=1, pub_date=1267155257, unpub_date=0, parent=10, template' at line 2 »
SQL: UPDATE `db318382909`.`sol_site_content` SET introtext='', content='
[PRESS LISTINGS GO HERE]
', pagetitle='Press', longtitle='Press', type='document', description='', alias='press', link_attributes='', isfolder=, richtext=1, published=1, pub_date=1267155257, unpub_date=0, parent=10, template=8, menuindex='4', searchable=1, cacheable=1, editedby=1, editedon=1268258962, publishedon=publishedon, publishedby=publishedby, contentType='text/html', content_dispo='0', donthit='0', menutitle='Press', hidemenu='0' WHERE id=14;
Any ideas why I’m getting these problems. Oh, and just to ease your minds about various server configurations I’ve had this happen on various versions of PHP, MYSQL, and APACHE. I don’t think it has to do with the server. But, not saying it isn’t either. It just seems like the problem is something to do with the core and how it saves the document. I’ve had to go into the database multiple times and manually change the content type. Sometime I’ll go in there and see entries that look like this: "tex----------243948576" or "text/html-----------2348762965" very odd or it will be completely blank. Someone else has to have experienced this, because this has happened on at least four different installations of evo 1.0.2 - upgrades and fresh installs.
EDIT: I just noticed that when using "Save + Continue Editing" it hasn’t had any weird side effects. I thought that was interesting, but it’s annoying to have to select that each time unnecessarily.
MODX Staff
☆ A M B ☆