StaticPages, PostgreSQL, and Empty Values

[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.

[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.

[garvinhicking]

Thanks for notifying me about this! I hopefully fixed this issue in version 3.07 of the plugin!

Regards,
Garvin