Page 1 of 1

serendipity_event_staticblocks

Posted: Fri Apr 20, 2007 1:57 pm
by JWalker
Hi,

Here is what I received, when updated an entry template
(don't mind international characters, these are Cyrillic letters).

Done: The new settings have been saved at 14:49:52
ERROR:

Code: Select all

UPDATE serendipity_staticblocks SET id='7', title='Íîâà âåðñèÿ mm.nn', type='template', body='

Ïóñêàíå íà íîâà âåðñèÿ â ðåäîâíî ïðîèçâîäñòâî.

Âåðñèÿ : mm.nn (ñòàðà âåðñèÿ mm.nn)
SVN ðåâèçèÿ : nn, nnnnnn/tags/mm.nn

Îñíîâàíèå

Òóê ñå îïèñâàò ïðè÷èíèòå çà ïóñêàíåòî íà âåðñèÿòà.

Ïðîìåíè

Òóê ñå îïèñâàò ïðîìåíèòå íàïðàâåíè îò ïðåäèøíàòà äî íîâàòà âåðñèÿ.

', extended='', template='plugin_staticblock.tpl', apply_markup='', author='', authorid='2', last_modified='1143202683', timestamp='1143202683' WHERE id='7'

/ Out of range value adjusted for column 'apply_markup' at row 1
The template remains unchanged nevertheless the message 'Done: The new settings have been saved at 14:49:52'. It seems some database error happened here...

Then I tried to insert new template and the result is:

Code: Select all

ERROR:

INSERT INTO serendipity_staticblocks (type,title,body,extended,template,apply_markup,timestamp,last_modified,authorid,author) values ('template', 'new one for test', 'This is new one.\r\n', '\r\n', 'plugin_staticblock.tpl', '', '1177070161', '1177070161', '2', '')

/ Out of range value adjusted for column 'apply_markup' at row 1
My blog is not visible to the public, so if someone here put some hints I'll try to cure the situation by myself.

Re: serendipity_event_staticblocks

Posted: Fri Apr 20, 2007 2:13 pm
by garvinhicking
Hi!

Which database are you using?

Regards,
Garvin

Re: serendipity_event_staticblocks

Posted: Fri Apr 20, 2007 2:15 pm
by garvinhicking
Hi!

Just committed a fix that should get it to work on pgsql.

Regards,
Garvin

Posted: Fri Apr 20, 2007 2:30 pm
by JWalker
MySQL 5.0.27-community-nt

Posted: Mon Apr 23, 2007 5:51 pm
by JWalker
The patch works with MySQL, and of course, the plugin is 'serendipity_event_includeentry' ... :o I didn't read what I had written.