[Radiant] setup_database error

[Carlos Gonzalez]

Jose,

I had a similar problem a few days ago. I found out that some
connection problem with the database are due to the Ruby MySQL
bindings.

Maybe you can get an answer for your problem here:
http://wiki.rubyonrails.com/rails/pages/Mysql+Connection+Problems

- Carlos

2006/10/5, jlopez at hpcf.upr.edu <jlopez at hpcf.upr.edu>:
> Hi,
>
> In response to Bodhi.
>
> Im running mysql  Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686)
> using readline 4.3.
>
> I viewed the file
> /ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor
> d/connection_adapters/mysql_adapter.rb but I didn't see the version.
>
> How can I get its version?
>
>
> I've installed Ruby 1.8.5, Gems 0.9.0, Rails 1.1.6, and Radiant 0.5.2
>
>
> Jose.
>
>
> >
> > On Oct 5, 2006, at 12:28 PM, jlopez at hpcf.upr.edu wrote:
> >
> >> Hi,
> >>
> >> I'm having an installation problem with Radiant.
> >
> > <snip>
> >
> >> Creating tables...
> >> -- drop_table("config")
> >> -- create_table("config", {:force=>true})
> >> FAILED
> >> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/
> >> activerecord-1.14.4/lib/active_record/connection_adapters/
> >> abstract_adapter.rb:120:in
> >> `log': Mysql::Error: Lost connection to MySQL server during query:
> >> CREATE
> >> TABLE config (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
> >> `key`
> >> varchar(40) DEFAULT '' NOT NULL, `value` varchar(255) DEFAULT '')
> >> ENGINE=InnoDB (ActiveRecord::StatementInvalid)
> >
> > ^^^^^ Last line is your problem, ActiveRecord::StatementInvalid. I
> > think it means that the database didnt understand the command that
> > rails sent to it.
> >
> > Could you give us some more info about your system? What version of
> > mysql are you running? And what ruby-mysql adapter? I think I
> > remember reading that one of the ruby-mysql adapters is broken, but I
> > only have experience with Postgresql and SQLite.
> >
> > Bodhi
> > _______________________________________________
> > Radiant mailing list
> > Post:   Radiant at lists.radiantcms.org
> > Search: http://radiantcms.org/mailing-list/search/
> > Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
> >
>
> _______________________________________________
> Radiant mailing list
> Post:   Radiant at lists.radiantcms.org
> Search: http://radiantcms.org/mailing-list/search/
> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>


-- 
-------------------------------------------------
Carlos David González Abraham
www.gonzalez-abraham.com.mx