Page 1 of 1

StaticPages, PostgreSQL, and Empty Values

Posted: Fri Oct 28, 2005 5:06 am
by Tom - Daai Tou Laam
Using StaticPages plugin 3.06 and PostgreSQL, the creation of new pages fails if "Perform Markup Transformations" is set to "No"

The INSERT INTO serendipity_staticpages fails as 'markup' field is a '' instead of an int. Should it be set to '0' for a No?

The 'pageorder' field is also '', though that doesn't create a failure.

Updates on Blank Values

Posted: Fri Oct 28, 2005 11:42 am
by Tom - Daai Tou Laam
So the datatype defined in the serendipity_event_staticpage.php for these is boolean, but the datatype for the postgresql table serendipity_staticpages is smallint instead of boolean.

And I'm having issues being able to update the initial staticpage from the web if I go from a 'true' to a 'false' value on any of the booleans as the UPDATE statement fails with a the 'false' value becoming a '' when it makes it to the sql call.

Re: StaticPages, PostgreSQL, and Empty Values

Posted: Fri Oct 28, 2005 11:55 am
by garvinhicking
Thanks for notifying me about this! I hopefully fixed this issue in version 3.07 of the plugin!

Regards,
Garvin