Textpattern CMS support forum
- Plugin Author
- From: Below the Manson-Nixon line
- Registered: 2004-06-02
- Posts: 97
[issue] mysql5 article save problem when comments disabled globally
I recently moved my local staging server and in the process updated to the latest mysql. I found I couldn’t update or create articles in an imported txp database, but everything worked fine on a new txp install.
Skipping over my tedious search for an answer, here’s the short of it:
mysql threw this error for all article save attempts: <code>Out of range value adjusted for column ‘Annotate’ at row 1</code>. Because I have comments turned off in the imported db, Annotate (NOT NULL int(2)), is being set to an empty string, which in previous mysql versions was quietly converted to the default value.
FWIW, this is mysql 5.0.16-nt-log on win2k with <code>sql-mode=“STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”</code> (what the mysql Server Instance Config Wizard sets up by default).
Enabling comments in Admin > Preferences, even if they are disabled per article on the Write tab, allows everything to work normally. Likewise, disabling <code>STRICT_TRANS_TABLES</code> allows the sloppy SQL when comments are again disabled globally.
Edit: btw, this is Txp 4.0.2
Last edited by takshaka (2005-12-12 02:16:40)