search for: mysql_adapt

...to get RoR working on a Centos server with WHM, Cpanel, etc. Everything seems OK and I am able to run the hello world apps however I am having major problems when I enable some database access ala the cookbook tutorials. Whether I run mongrel or webrick I am getting seg faults and/or traps in mysql_adapter.rb when I submit a form of data. Specifically I browse to www.mydomain.com:mongrelport/mycontroller/new and the correct form comes up ready for data entry. When I click Create to submit the data to the DB my browser fails on a "create" url, and the server gives up with a seg fault o...

Hello all! I''m a newbie to Rails and I''m trying to get things working on an old RH9 box. I was wondering if someone could help me troubleshoot a mysql_adapter.rb error? I set everything up and created a simple test app and then generated a scaffold for it. When I try to go to the main controller and list the data, I get the following error: ArgumentError... NULL pointer given The stack trace starts in my controller where it is trying to return the...

...ntent_sery'' doesn''t exist: SELECT * FROM content_sery LIMIT 1 /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in `execute'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:337:in `select'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:176:in `select_all''...

This is my first rails app with a legacy database and I''m having a terrible time getting the models set up correctly. I have an order table that has a primary field named order_number. I have a name table with a primary of item_number. These two tables are liked by the item_number and the order_number, but not as you might think. If the order_number is 2500, then each entry in

...y): Any idea why this happens? It''s rather intermittent and random, but I get this a few times a week. I''ve pasted a large section of the call stack below in case it helps. Thanks! Jeff /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:316:in `real_connect'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:316:in `connect'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:87:in `initialize...

...I love it!) I get when I load localhost:3000 into my browser and try to show the info about the application''s environment: Mysql::Error in Rails/infoController#properties And here''s the trace: /Library/Ruby/Gems/1.8/gems/activerecord-2.0.1/lib/active_record/ connection_adapters/mysql_adapter.rb:471:in `real_connect'' /Library/Ruby/Gems/1.8/gems/activerecord-2.0.1/lib/active_record/ connection_adapters/mysql_adapter.rb:471:in `connect'' /Library/Ruby/Gems/1.8/gems/activerecord-2.0.1/lib/active_record/ connection_adapters/mysql_adapter.rb:165:in `initialize'' /L...

...memory: SELECT COUNT(*) FROM comments WHERE (comments.listing_id = 2666) /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:180:in `execute'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:322:in `select'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in `select_one'...

...roups` ON `groups`.id = `user_groups`.group_id WHERE ((`user_groups`.user_id = 1)) Group Columns (2.0ms) SHOW FIELDS FROM `groups` Completed in 66ms (View: 32, DB: 5) | 200 OK [http://localhost/ processes] C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_a dapters/mysql_adapter.rb:576: [BUG] Segmentation fault ruby 1.8.6 (2008-08-11) [i386-mswin32] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.87- community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument 091116 1...

Hi, I am getting this error when i execute rake db:create:all /opt/gitorious/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:569: [BUG] unknown type 0x22 (0xc given) any clues ? -Manish -- Posted via http://www.ruby-forum.com/.

...atabase ''db_develoment'' (Mysql::Error) from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/ven?dor/m ysql.rb:150:in `real_connect'' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/con?necti on_adapters/mysql_adapter.rb:331:in `connect'' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/con?necti on_adapters/mysql_adapter.rb:88:in `initialize'' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/con?necti on_adapters/mysql_a...

...ppening. I decided to lower that number, making it 60. No more success. I installed gdb and the ruby macros to make sure i was in the mysql driver while hanging and sure enough, here is the top of the BT from GDB : /var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/mysql_adapter.rb:264:in `active?''", "/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract_adapter.rb:136:in `verify!''", "/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:256:in...

...s.name LIKE ''a%''includecourse)) from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_recor d/connection_adapters/abstract_adapter.rb:120:in `log'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_recor d/connection_adapters/mysql_adapter.rb:185:in `execute'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_recor d/connection_adapters/mysql_adapter.rb:337:in `select'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_recor d/connection_adapters/mysql_adapter.rb:1...

...B'' at line 1: CREATE TABLE categories (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(20), `description` text, `created_on` datetime(14), `updated_on` datetime(14)) ENGINE=InnoDB After executing the import with --trace option it looks like the problem is coming from mysql_adapter.rb file, where any reference to :timestamp is replaced by :datetime, but the ''datetime'' SQL command does not accept an argument (14)! PS: Another consequence of this error is that the table is dropped at the same time, that is not a good news! I propose the following patch:...

I just deployed my rails app to my production server. It''s all working locally, but when I switched it over to the production server (at dreamhost) I get this error: # Logfile created on Sun Aug 19 15:22:48 -0700 2007 by logger.rb/ 1.5.2.9 [19/Aug/2007:15:22:48 :: 1841] starting [19/Aug/2007:15:22:48 :: 1841] Dispatcher failed to catch: You have a nil object when you didn''t

...y/gems/1.8/gems/activerecord-1.15.3/lib/active_record/vendor/mysql.rb:506:in `command'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/vendor/mysql.rb:238:in `close'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:236:in `disconnect!'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3 /lib/active_record/connection_adapters/mysql_adapter.rb:231:in `reconnect!'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract_adapter.rb:93: in `v...

...000Field ''type'' doesn''t have a default value: INSERT INTO projects (`name`, `id`) VALUES (''Active Record'', 1) ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:78:in `log'' ./test/../lib/active_record/connection_adapters/mysql_adapter.rb:181:in `execute'' ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures'' ./test/../lib/active_record/fixtures.rb:283:in `each'' ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures'' ./test/../lib/active_record/fixtures.rb:2...

Hi, I just published the first version of a small tutorial I''ve written on Ajax and Rails. It is called "How to paginate, sort and search a table with Ajax and Rails" (sorry, I didn''t manage to find a longer title !) and is available at : http://dev.nozav.org/rails_ajax_table.html There is nothing really new in it, it''s rather a compilation and

...ance. --l Mysql::Error in Indicator#list Can''t connect to MySQL server on ''localhost'' (10061) RAILS_ROOT: ./script/../config/.. Application Trace | Framework Trace | Full Trace c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:316:in `real_connect'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:316:in `connect'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:87:in `initialize'...

...d=3664 port=3000 /!\ FAILSAFE /!\ Tue Jun 15 13:53:04 -0700 2010 Status: 500 Internal Server Error Access denied for user ''root''@''localhost'' (using password: NO) C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:619:in `real_connect'' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:619:in `connect'' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:203:in `i...

...: PROCEDURE vc.testsp can''t return a result set in the given context: call testsp()" I found out from here: http://bugs.mysql.com/bug.php?id=2658 that mysql needs the flag CLIENT_MULTI_RESULTS set if you want to be able to return result sets from stored procedures. The problem is that mysql_adapter.rb doesn''t pass the flag parameter to the mysql connect function. When I hacked it in there myself, things worked perfectly. Am I going to about this the wrong way? Even though things work fine now, I don''t want to have to hack this fix back in when new versions of rails are re...