search for: sql_auto_is_nul

...erly For the life of me, I don''t see what I''m doing wrong. On the ISP site, I set the log level to debug and compared the log files from both the test (Windows XP) and production (CentOS) environments. The only difference I could find is that in the CentOS production log, I see a SQL_AUTO_IS_NULL message in the log file. I can''t figure out what this means and am not sure how relevant it is. Any suggestions are appreciated. Should I do something special with the routes? Below are the two log files. ==================== test environment log file that works (Windows XP) ===========...

hi , in my logs i see that: Completed in 1480ms (View: 267, DB: 90) | 200 OK [http://192.168.2.9/xyz/99] SQL (1.4ms) SET NAMES ''utf8'' SQL (0.7ms) SET SQL_AUTO_IS_NULL=0 Processing xyzsController#images to gif (for 192.168.2.3 at 2010-10-28 15:22:35) [GET] Parameters: {"id"=>"loading"} ActionController::UnknownAction (No action responded to images. then to stop the error, i created an action plus view, although it doesnt get rendere...

...getting when I try to run my rspec tests: Spec::Rails::DSL::HelperEvalContextController: missing default helper path spec/rails/dsl/helper_eval_context_helper Spec::Rails::DSL::ViewExampleController: missing default helper path spec/rails/dsl/view_example_helper [4;36;1mSQL (0.000138) [0;1mSET SQL_AUTO_IS_NULL=0 [4;35;1mSQL (0.000095) BEGIN [4;36;1mSite Columns (0.003708) [0;1mSHOW FIELDS FROM sites [4;35;1mSQL (0.000174) ROLLBACK Here is the portion for the test database from the database.yml file: test: adapter: mysql database: mydb_test username: root password: socket: /tmp/mys...

Hi, I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 server with little success. Has anyone been able to do this? If so, what issues did you have to overcome to get this to work? Also, is this a combination that you would recommend for a production site, or is it all too new and untested? The latest issue I''m stuck on right now is with the mysql-connector-

...solved to the "show" action of the controller with id="resetpwd" as below Processing UsersController#show (for 127.0.0.1 at 2009-04-30 21:05:13) [GET] Parameters: {"id"=>"resetpwd"} SQL (0.0ms) SET NAMES ''utf8'' SQL (0.0ms) SET SQL_AUTO_IS_NULL=0 In the script/console when I list all the routes, here is a subset of what I get GET /users/:id/ {:controller=>"users", :action=>"show"} GET /users/:id.:format/ {:controller=>"users", :action=>"show"} That may explain w...

...#39;'m getting the following error while connecting to mysql using activerecord-jdbcmysql-adapter (1.0.2). Rails 3.0.1. ActiveRecord::JDBCError: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().: SET SQL_AUTO_IS_NULL=0 This occurs not matter what application I run it in to e.g. rake, rails console, or from my app. Here''s the trace while running it from rake: jruby -S rake db:schema:dump --trace (in /Users/MJW/Sites/test_app) ** Invoke db:schema:dump (first_time) ** Invoke environment (first_time) *...

...b contains: get ''login'' => ''session#new'' post ''login'' => ''session#create'', :as => :login GET /login works fine: Started GET "/login" for 127.0.0.1 at 2010-02-20 17:45:49 SQL (0.3ms) SET SQL_AUTO_IS_NULL=0 Processing by SessionController#new as HTML Rendered session/new.html.haml within layouts/application.html.haml (77.9ms) Completed in 85ms (Views: 84.1ms | ActiveRecord: 0.2ms) with 200 However POST /login gives the following error: Started POST "/login" for 127.0.0.1 at 2010-02-2...

...th unexpected rollbacks using cucumber 0.3.0. My feature-file looks like Scenario: Create Valid Item Given I start and the step is Given /^I start$/ do get "/items" end In my log/test.log I get SQL (0.2ms) SET NAMES ''utf8'' SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.1ms) BEGIN Processing ItemsController#index (for 127.0.0.1 at 2009-04-19 20:54:08) [GET] Item Load (0.2ms) SELECT * FROM `items` Rendering template within layouts/application Rendering items/index Completed in 41ms (View: 30, DB: 1) | 200 OK [http://www.example.com/items]...

...or 127.0.0.1 at 2009-04-09 10:44:32) [GET] Filter chain halted as [:authenticate] rendered_or_redirected. Completed in 16ms (View: 16, DB: 0) | 401 Unauthorized [http:// localhost/secrets] [4;36;1mSQL (0.0ms) [0m [0;1mSET NAMES ''utf8'' [0m [4;35;1mSQL (0.0ms) [0m [0mSET SQL_AUTO_IS_NULL=0 [0m Processing SecretsController#index (for 127.0.0.1 at 2009-04-09 10:44:35) [GET] Rendering template within layouts/secrets Rendering secrets/index Completed in 811ms (View: 811, DB: 0) | 200 OK [http://localhost/ secrets] host/secrets] [4;36;1mSQL (0.0ms) [0m [0;1mSET NAMES ''u...

...e => true ) and And this is how it is processed Processing StreamsController#download (for 127.0.0.1 at 2010-09-22 12:32:10) [GET] Parameters: {"id"=>"6596"} <-[4;36;1mSQL (0.0ms)?[0m ?[0;1mSET NAMES ''utf8''?[0m <-[4;35;1mSQL (0.0ms)?[0m ?[0mSET SQL_AUTO_IS_NULL=0?[0m <-[4;36;1mStream Columns (15.0ms)?[0m ?[0;1mSHOW FIELDS FROM streams?[0m <-[4;35;1mStream Load (0.0ms)?[0m ?[0mSELECT * FROM streams WHERE (streams.id = 6596) ?[0m <-[4;36;1mCACHE (0.0ms)?[0m ?[0;1mSELECT * FROM streams WHERE (streams.id = 596) ? ?[0m Sending X-Sendfile header d...

...Still I am not able to get the pdf. I am not getting any error in log file. My log file is:- "Processing AccountController#customer_report (for 127.0.0.1 at 2009-04-27 13:19:34) [GET] [4;36;1mSQL (0.0ms) [0m [0;1mSET NAMES ''utf8'' [0m [4;35;1mSQL (0.0ms) [0m [0mSET SQL_AUTO_IS_NULL=0 [0m [4;36;1mCustomer Load (0.0ms) [0m [0;1mSELECT * FROM `customers` [0m Rendering account/customer_list [4;35;1mCustomer Columns (0.0ms) [0m [0mSHOW FIELDS FROM `customers` [0m Rendering account/customer_list Sending data CustomerReport.pdf Completed in 422ms (View: 0, DB: 0) | 200...

Using my application i can able to save a new record into my db but i cannot update a existing record into my db. using update query i can able to update my records. but using update_attributes it doesnot update my records. even i cant find any errors in logs or something. throughout my application i can able to save a new record but unable to update my existing records. actually i have changed

...ly when i downloding files,mongrel rendering things, Processing StreamsController#download (for 127.0.0.1 at 2010-09-27 16:50:47) [GET] Parameters: {"id"=>"6655"} ?[4;36;1mSQL (0.0ms)?[0m ?[0;1mSET NAMES ''utf8''?[0m ?[4;35;1mSQL (0.0ms)?[0m ?[0mSET SQL_AUTO_IS_NULL=0?[0m ?[4;36;1mStream Columns (0.0ms)?[0m ?[0;1mSHOW FIELDS FROM `streams`?[0m ?[4;35;1mStream Load (0.0ms)?[0m ?[0mSELECT * FROM `streams` WHERE (`streams`.`id` = 6655) ?[0 Completed in 78ms (View: 0, DB: 0) | 200 OK [http://src/streams/download/6655] It is when i am trying to download 2...

...ted in 1500ms (DB: 47) | 302 Found [http://127.0.0.1/users] Processing UsersController#show (for 127.0.0.1 at 2009-01-08 00:27:19) [GET] Parameters: {"id"=>"34"} [4;35;1mSQL (0.1ms) [0m [0mSET NAMES ''utf8'' [0m [4;36;1mSQL (0.1ms) [0m [0;1mSET SQL_AUTO_IS_NULL=0 [0m [4;35;1mUser Columns (0.9ms) [0m [0mSHOW FIELDS FROM `users` [0m [4;36;1mUser Load (0.3ms) [0m [0;1mSELECT * FROM `users` WHERE (`users`.`id` = 34) [0m Rendering users/show === as all of you can see == INSERT INTO `users` (`name`, `avatar_file_name`, `avatar_file_size`, `creat...

...ils 2.2.2. Processing DomainsController#show to xml (for 127.0.0.1 at 2009-04-03 16:41:38) [GET] Parameters: {"format"=>"xml", "action"=>"show", "id"=>"test6", "controller"=>"domains"} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Account Columns (3.6ms) SHOW FIELDS FROM `accounts` Domain Columns (1.8ms) SHOW FIELDS FROM `domains` Domain Load (0.8ms) SELECT * FROM `domains` WHERE (`domains`.`domainname` = ''test6'') LIMIT 1 I would expect to see a final confirmation of the HTTP status code, bu...

...- community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument 091116 16:38:29 18 Connect ruote@localhost on rw2_development 18 Query SET NAMES ''utf8'' 18 Query SET SQL_AUTO_IS_NULL=0 18 Statistics 091116 16:38:30 18 Query SHOW FIELDS FROM `users` 18 Query SELECT * FROM `users` WHERE (`users`.`id` = 1) LIMIT 1 18 Query SELECT `groups`.* FROM `groups` INNER JOIN `user_groups` ON `groups`.id = `user_groups`.group_id WHERE ((`user_...

Hi friends, i''m usgin the edge version because i need eager loading on polymorphic associations support, but i see this: Message.find(:first, :include => :owner) #This generate this query: SQL (0.000072) SET SQL_AUTO_IS_NULL=0 Message Load (0.000389) SELECT * FROM `messages` User Load (0.001070) SELECT * FROM `users` WHERE (users.id IN (1,2)) And this Message.find(:first, :include => :owner, :limit => 1) generate this: Message Load (0.000460) SELECT * FROM `messages` LIMIT 1 User Load (0.000318)...

Hi, Have you an idea about this error message when i run the rake db:migrate command under Aptana ? rake aborted! NoMethodError: undefined method `ord'' for 0:Fixnum: SET SQL_AUTO_IS_NULL=0 Thanks Here My Config : Windows XP PRO SP2 Wamp 2.0 Aptana 2.0.4 RubyGems 1.3.5 Ruby 1.8.6 -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to ruby...

...orking through the example given in the excellent book "Asterisk: The Definite Guide". I'm using Asterisk 1.4.19 and MySQL 5.1.58. I've configured the ODBC bit and in my GeneralLog on MySQL I can see the asterisk user connecting and sending a few SQL statements, such as "SET SQL_AUTO_IS_NULL = 0". After connecting, the asterisk user never sends another SQL statement, at least nothing that shows up in the General log. Asterisk is running as root. I've deleted the musiconhold.conf file from /etc/asterisk Testing odbc from command line ( there is a difference from what the boo...

I''m new in RoR:) I have controller and view (/app/controllers/greeting_controller.rb and /app/views/greeting/index.rhtml /.erb/.html.erb - doesn''t match). greeting_controller.rb source: class GreetingController < ApplicationController def index @message = "Hello world!" end end index.rhtml source: <html>