[solved] Error importing CMSMS templates

[nlindq]

I have a fresh installation of CMSMS 1.2.3 running on RHEL4 with php 4.3.9 and PostgreSQL 8.1.x.

Filesystem permissions are wide open for the directories listed in the installation instructions.

Whenever I try and import any of the XML theme or theme template files from the CMSmS themes site using the Theme Manager, I receive the following error:

DEBUG: ERROR: invalid input syntax for integer: "f"

Error!

Could not create the template definition

New stylesheets with the theme name show up in the stylesheets section, but none of the graphics are imported and no templates.

If I check the /uploads directory on the filesystem, the theme names are displayed, and there are a few graphics and .JS files.

This happens with all the themes I've tried.

[Pierre M.]

Hi PostgreSQL users,

Thanks a lot for sharing this.

Brett, could you please submit your patches in the forge by filing a bug report with attached solution ? Your code would go mainstream to all pgusers.

Pierre M.

[nlindq]

Various modules and a few core DB items are slightly broken in Postgres at the moment.  I just fixed them all today.

Your error is the expectation that an INSERT with a VALUE in one of the columns of '' is the same as integer zero.  It's not.

First fix, lib/classes/class.content.inc.php around line 1045:

[....]

Thanks very much!  That did the trick.  I'll look forward to the patch with the rest of the fixes, and I'll definitely make use of the PostgreSQL debug technique you outlined.

[nilson]

This error also occurs in cmsms v.1.2.4 on Debian Etch using PostgreSQL 8.3 and PHP 5.2.5-3. However, the bugfixes posted by bvroc do the trick.

Thanks a lot,
nilson