errors on heroku

104 views
Skip to first unread message

bruce

unread,
May 1, 2012, 12:52:52 AM5/1/12
to Alchemy CMS
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]: ActiveRecord::StatementInvalid
(PG::Error: ERROR: syntax error at or near "."
2012-05-01T04:36:57+00:00 app[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]: : 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


Thomas von Deyen

unread,
May 1, 2012, 2:51:15 AM5/1/12
to alche...@googlegroups.com
Hi Bruce.

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'

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*

Bruce Davison

unread,
May 1, 2012, 2:54:55 AM5/1/12
to alche...@googlegroups.com
Thomas thanks
ImageMagick on Heroku is OK images upload as they should
alchemy_spree no big deal for now.
I look forward to release (2.2)
Thanks again

-- 
Bruce Davison
Sent with Sparrow

Reply all
Reply to author
Forward
0 new messages