trouble using postgresql

[mking]

Hi Everyone,

SteerCMS looks interesting, and I'd like to get it running with
postgres.

I'm rather new to using symfony, so please excuse me if I simply have
something misconfigured, but it appears that steerCMS is generating
SQL such as:

DELETE FROM steercms_search_words WHERE steercms_search_words.MODEL_ID
= 1 AND steercms_search_words.MODEL = "steerCMSBlogPost"

Which fails in postgres because of the double quotes (instead of
single quotes) around the string.

Is steerCMS simply intended to be mySQL only?

thanks,
Martin

[Konny Zurcher]

Hi Martin,

This version, being an early Alpha Version, was tested thoroughly
with MySQL as one of the more used Databases.

More comprehensive tests with PostgreSQL and SQLight are not done yet.

The problem with the double quotes for PostreSQL is correct. Seems
also to be a general problem in Symfony too, at least to some extend
in some of the plugins.

If you find a general fix for it, we will test it and take it into
account for the next release of Steer CMS. There will be probably
more database dependencies then that for all the different database
types. Will need to check that out.

For the time being, if possible, you can run Steer CMS with MySQL.

Cheers,

Konny Zurcher
Steer CMS - Development Team