i''ve fiddled with rails before but since i''ve just recieved
the book,
i was going thru the depot app. when ''instant gratification''
failed me
completely.
before starting the chapter, i installed the lastest version of ruby
and rails and, before that, installed the new mysql 4.1.14 for
windows, which i tested with mysql-front (did the old password thing,
all''s working, all''s swell).
then when i tried to scaffold the Product Admin (having created a
proper ''products'' table), i got a "Before updating
scaffolding from
new DB schema, try creating a tab
le for your model (Product)", which is usually related to rails
failing to map a Product model to a ''products'' database,
right?
well, not on my case. i have the database set, the table is set and
visible via Mysql-Front of phpmyadmin and ruby is connecting to Mysql,
otherwise the last error on the script/generate command would be
Access denied, etc, etc.
i tried then to update my mysql driver with gem update mysql and got this error:
Upgrading installed gems...
Attempting remote upgrade of mysql
Attempting remote installation of ''mysql''
Building native extensions. This could take a while...
ERROR: While executing gem ... (RuntimeError)
ERROR: Failed to build gem native extension.
Gem files will remain installed in c:/ruby/lib/ruby/gems/1.8/gems/mysql-
inspection.
ruby extconf.rb update mysql\nchecking for mysql_query() in mysqlclien
no
checking for main() in m.lib... yes
checking for mysql_query() in mysqlclient.lib... no
checking for main() in z.lib... no
checking for mysql_query() in mysqlclient.lib... no
checking for main() in socket.lib... no
checking for mysql_query() in mysqlclient.lib... no
checking for main() in nsl.lib... no
checking for mysql_query() in mysqlclient.lib... no
i made sure to install mysql 4.1.14 with the libraries... so i''m
pretty much stuck. maybe i should downgrade to mysql 4.0?
help!
spiceee.
never mind, downgraded to 4.0 and it pulled the trick. On 8/28/05, Spiceee <spiceee-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> i''ve fiddled with rails before but since i''ve just recieved the book, > i was going thru the depot app. when ''instant gratification'' failed me > completely. > > before starting the chapter, i installed the lastest version of ruby > and rails and, before that, installed the new mysql 4.1.14 for > windows, which i tested with mysql-front (did the old password thing, > all''s working, all''s swell). > > then when i tried to scaffold the Product Admin (having created a > proper ''products'' table), i got a "Before updating scaffolding from > new DB schema, try creating a tab > le for your model (Product)", which is usually related to rails > failing to map a Product model to a ''products'' database, right? > > well, not on my case. i have the database set, the table is set and > visible via Mysql-Front of phpmyadmin and ruby is connecting to Mysql, > otherwise the last error on the script/generate command would be > Access denied, etc, etc. > > i tried then to update my mysql driver with gem update mysql and got this error: > > Upgrading installed gems... > Attempting remote upgrade of mysql > Attempting remote installation of ''mysql'' > Building native extensions. This could take a while... > ERROR: While executing gem ... (RuntimeError) > ERROR: Failed to build gem native extension. > Gem files will remain installed in c:/ruby/lib/ruby/gems/1.8/gems/mysql- > inspection. > ruby extconf.rb update mysql\nchecking for mysql_query() in mysqlclien > no > checking for main() in m.lib... yes > checking for mysql_query() in mysqlclient.lib... no > checking for main() in z.lib... no > checking for mysql_query() in mysqlclient.lib... no > checking for main() in socket.lib... no > checking for mysql_query() in mysqlclient.lib... no > checking for main() in nsl.lib... no > checking for mysql_query() in mysqlclient.lib... no > > i made sure to install mysql 4.1.14 with the libraries... so i''m > pretty much stuck. maybe i should downgrade to mysql 4.0? > > help! > > spiceee. >
Try this: $ sudo gem install mysql -- --with-mysql-config If that doesn''t work try downloading the tarball of the mysql drivers and do this: extconf.rb --with-mysql-config HTH- -Ezra On Aug 28, 2005, at 4:40 PM, Spiceee wrote:> i''ve fiddled with rails before but since i''ve just recieved the book, > i was going thru the depot app. when ''instant gratification'' failed me > completely. > > before starting the chapter, i installed the lastest version of ruby > and rails and, before that, installed the new mysql 4.1.14 for > windows, which i tested with mysql-front (did the old password thing, > all''s working, all''s swell). > > then when i tried to scaffold the Product Admin (having created a > proper ''products'' table), i got a "Before updating scaffolding from > new DB schema, try creating a tab > le for your model (Product)", which is usually related to rails > failing to map a Product model to a ''products'' database, right? > > well, not on my case. i have the database set, the table is set and > visible via Mysql-Front of phpmyadmin and ruby is connecting to Mysql, > otherwise the last error on the script/generate command would be > Access denied, etc, etc. > > i tried then to update my mysql driver with gem update mysql and > got this error: > > Upgrading installed gems... > Attempting remote upgrade of mysql > Attempting remote installation of ''mysql'' > Building native extensions. This could take a while... > ERROR: While executing gem ... (RuntimeError) > ERROR: Failed to build gem native extension. > Gem files will remain installed in c:/ruby/lib/ruby/gems/1.8/gems/ > mysql- > inspection. > ruby extconf.rb update mysql\nchecking for mysql_query() in > mysqlclien > no > checking for main() in m.lib... yes > checking for mysql_query() in mysqlclient.lib... no > checking for main() in z.lib... no > checking for mysql_query() in mysqlclient.lib... no > checking for main() in socket.lib... no > checking for mysql_query() in mysqlclient.lib... no > checking for main() in nsl.lib... no > checking for mysql_query() in mysqlclient.lib... no > > i made sure to install mysql 4.1.14 with the libraries... so i''m > pretty much stuck. maybe i should downgrade to mysql 4.0? > > help! > > spiceee. > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-Ezra Zygmuntowicz WebMaster Yakima Herald-Republic Newspaper ezra-gdxLOakOTQ9oetBuM9ipNAC/G2K4zDHf@public.gmane.org 509-577-7732