Answered Unable to edit documents after upgrade of MySQL to 5.1

315 Posts

BBloke Reply #1, 12 years, 6 months ago

Hi All,
I've recently upgraded mysql from 5.0 to 5.1. I've noticed that whenever I try and edit a resource in Evo I get the following error:

« MODX Parse Error »
MODX encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Incorrect integer value: 'publishedon' for column 'publishedon' at row 1 »

with the full SQL:

SQL > UPDATE `valbruna`.`modx_site_content` SET `introtext` = '',`content` = '
teste

',`pagetitle` = 'test2',`longtitle` = '',`type` = 'document',`description` = '',`alias` = 'test2',`link_attributes` = '',`isfolder` = '0',`richtext` = '1',`published` = '1',`pub_date` = '0',`unpub_date` = '0',`parent` = '0',`template` = '15',`menuindex` = '36',`searchable` = '1',`cacheable` = '0',`editedby` = '1',`editedon` = '1395662679',`publishedon` = 'publishedon',`publishedby` = 'publishedby',`contentType` = 'text/html',`content_dispo` = '0',`donthit` = '0',`menutitle` = '',`hidemenu` = '0',`alias_visible` = '1' WHERE id='585'

The field publishedon has a value pulishedon rather than an integer.

I stuck as to why this has happening. I'm running apache 2.2.25 and PHP 5.3.28 with Mysql 5.1.73.

Would anyone be able to help?

This question has been answered by BBloke. See the first response.

BBloke

discuss.answer
- 315 Posts
BBloke Reply #2, 12 years, 6 months ago

I didn't look hard enough on the forums. The answer was "strict mode". I've turned it off and all is well.

Sorry to be a bother.
BBloke