> Alchemy is not working yet with postgresql. We are working on it and will have it with the next release (2.2), that we plan to release in the next couple of days.

> You can try using the master branch from github:

> gem 'alchemy_cms', :git => 'git://github.com/magiclabs/alchemy_cms' (http://github.com/magiclabs/alchemy_cms')

> But the 'alchemy_spree' gem is not yet alchemy 2.2 compatible, so this will propably not work.

> The crashing while uploading pictures are caused mostly because of a faulty ImageMagick installation. Try to reinstall with --disable-openmp option.

> I never tried alchemy on heroku, so I can't say anything about it. But like I said, we currently working on postgresql compatibilty. So this will propably fix this.

> Greetings

> Thomas
> magic labs*

> > I am just experimenting at present.
> > I am impressed by the potential I can see with this system.
> > I have been using Radiant which is good but not on Rails 3 yet.
> > I have a Spree shop set up and used the 'alchemy_spree' gem.

> > gem 'alchemy_cms', '~> 2.1.5'
> > gem 'alchemy_spree'

> > I was using postgresql in development but the migrations in alchemy
> > didn't play nicely with that so I converted to sqlite3 then all seems
> > to work ok but uploading images on my Mac crashed. So I pushed the app
> > to Heroku and pushed the db to Heroku where it is converted to
> > Postgresql.
> > All seemed to work ok but when I go to pages is states that my
> > language tree doesn't exist. Checking languages tab my language 'en'
> > is there and the only language.
> > Trying to create a new language tree seems to hang the system. So
> > pushing past that. If I specifically try to edit a page I get this:

> > Error: PG::Error: ERROR: syntax error at or near "." LINE
> > 1: ...my_elements"."page_id" = 3 AND (`alchemy_elements`.`page_id`...
> > ^ : SELECT "alchemy_elements".* FROM "alchemy_elements" WHERE
> > "alchemy_elements"."page_id" = 3 AND (`alchemy_elements`.`page_id` IS
> > NOT NULL) ORDER BY position

> > and in the log

> > 2012-05-01T04:36:57+00:00 app[web.1 (http://web.1)]: ActiveRecord::StatementInvalid
> > (PG::Error: ERROR: syntax error at or near "."
> > 2012-05-01T04:36:57+00:00 app[web.1 (http://web.1)]: LINE 1: ...pages"."layoutpage"
> > IS NULL)) AND (`alchemy_pages`.`parent_i...
> > 2012-05-01T04:36:57+00:00 app[web.
> > 1]: ^
> > 2012-05-01T04:36:57+00:00 app[web.1 (http://web.1)]: : SELECT "alchemy_pages".* FROM
> > "alchemy_pages" WHERE "alchemy_pages"."urlname" = 'about' AND
> > "alchemy_pages"."language_id" = 1 AND (("alchemy_pages"."layoutpage"
> > IN ('f') OR "alchemy_pages"."layoutpage" IS NULL)) AND
> > (`alchemy_pages`.`parent_id` IS NOT NULL) LIMIT 1):

> > So any ideas?

> > Thanks