Displaying 20 results from an estimated 61 matches for "sqlexception".
2008 Apr 09
1
rspec SQLException problem
...c 1.1.3 by doing this:
gem install rspec
and then in the root of my project, I did this:
ruby script/plugin install
svn://rubyforge.org/var/svn/rspec/tags/CURRENT/rspec_on_rails
And now, when I run a unit test (that worked before the rspec
installation), I''m getting the following errors:
SQLException: near ''of'': syntax error: DELETE FROM Copy of assignments
WHERE 1=1
and
SQLException: SQL logic error or missing database
I tried running rake db:test:clone, but that didn''t fix it.
Here''s the unit test file:
require File.dirname(__FILE__) + ''/../test_...
2009 Sep 30
3
SQLite3::SQLException: id may not be null
I am getting the following error using sqlite3. If I ran the same query
directly in sqlite3 client, the data is saved without error. Same is
happening for every table during inserts.
SQLite3::SQLException: sessions.id may not be NULL: INSERT INTO sessions
("updated_at", "session_id", "data") VALUES(''2009-09-30 02:28:45'',
''3461077be365d88468352a6172c27793'',
''BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo
SGFzaHsA...
2009 Apr 25
5
SQLite3::SQLException: unable to open database file
Hi.
I was trying to code same as the rails guide : getting started.
I could follow steps to 6.3 Working with Posts in the Browser.
(setting home page, creating a resource, running a migration)
After clicked create button, errors are occured.
SQLite3::SQLException: unable to open database file: INSERT INTO
"posts" ("name", "created_at", "title", "updated_at", "content") VALUES
(''123123123'', ''2009-04-25 22:23:51'', ''12312312'', ''2009-04-25...
2011 Apr 05
4
Rails 3.0.5 gives SQLite3::SQLException for the same code that works on 3.0.3
...The very same code that worked on
3.0.3 now gives error.
The code is:
def kategorialista
Kategoria.where(:elfogadva => TRUE).order("nev").collect {|s|
[s.nev, s.sefuri]}
end
It is in application_controller.rb with
helper_method :kategorialista
The error it gives on 3.0.5:
SQLite3::SQLException: no such table: kategoria: SELECT "kategoria".*
FROM "kategoria" WHERE "kategoria"."elfogadva" = ''t'' ORDER BY nev
Obviously there is no such table as kategoria, but there is
„kategorias” table in SQLite.
The relevant part of the schema, as...
2007 Oct 22
13
An error on edge at -r 2767
Morning,
Having done an svn up this morning all my specs are broken with the
following:
SQLite3::SQLException in ServiceConfig with minimum set of valid parameters
should return nil for the service path''
SQL logic error or missing database
C:/development/sandbox/prototypes/user_admin_client/config/../vendor/plugins/rspec_on_rails/lib/spec/rails/dsl/behaviour/rails_example.rb:17:in
`before_eval'...
2008 Mar 29
10
create new clientconfigs database
Hi, I''m upgrading from 23.2 to the latest and have "dbmigrate = true"
in my config.
When I try to run puppetd, I''m getting:
Could not migrate database: SQLite3::SQLException: no such table:
schema_info: SELECT version FROM schema_info
I''m perfectly blowing away my old db (by deleting /var/lib/puppet/
state/clientconfigs.sqlite3 ?), but I haven''t figured out how to
create a new db with the latest schema. I''ve tried re-running the
install.rb,...
2007 Dec 18
5
resource collection error
I''m seeing these in my logs on my puppetmaster:
puppetmasterd[4111]: Could not store configs: SQLite3::SQLException: SQL
logic error or missing database: DELETE FROM fact_values
WHERE "id" = 8
currently this is 0.24.0
relect from some previously collected resource that wasn''t cleaned up?
upgrade issue?
nothing to worry about?
that''s the only message I''m get...
2006 Mar 04
5
SQlite3 hoopup issues on mac os x
friends of the int-arweb.
what does this mean:
(in bold) ActiveRecord::StatementInvalid in Contact#create
SQLite3::SQLException: SQL logic error or missing database: INSERT
INTO contacts
Context:
this happened after I had finished setting up RoR as per the tutorial
at http://maczealots.com/tutorials/ruby-on-rails/
the database, is like, there. is there a nice ruby command like deal
to test if everything is hooked u...
2011 Jul 20
4
Setup database on new clone
I''ve just cloned my rails app onto another PC, and I''m having a
problem getting the database set up.
I''ve tried rake db:migrate, then db:create and also db:reset, but I
keep getting an SQLException "no such table". It seems this is due to
a line in an initializer which accesses one of my tables.
Why do the db:* tasks run the initializers ? Do I need to move any db
code out of initalizers - if so, where to ?
--
You received this message because you are subscribed to the Google Gr...
2007 Jun 02
2
Unit tests breaks with sqlite
...)
end
* and:
def self.down
drop_table :users
end
* rake db:migrate
* rake db:test:prepare
At this point, the 2 DBs are created correctly.
* rake test:units
The problem is that, but when I want to run a (any) test, I get a "SQL
logic error or missing database (SQLite3::SQLException). I can however
access the DB via the sqlite3 client/rails console without any
problem.
Here''s the exact error message I get:
Loaded suite C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rake-0.7.3/
lib/rake/rake_test_loader
Started
EC:/InstantRails/ruby/lib/ruby/gems/1.8/gems/sqlite3-...
2008 Mar 07
3
Boolean circles..
...t: "2008-03-07 12:52:35", updated_at:
"2008-03-07 12:52:35">
>> m = c.members.find(:first, :conditions => "is_active = 1")
=> nil
>> m = c.members.find(:first, :conditions => "is_active = true")
ActiveRecord::StatementInvalid: SQLite3::SQLException: no such column:
true: SELECT * FROM members WHERE (members.club_id = 1 AND
(is_active = true)) LIMIT 1
from /Library/Ruby/Gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:150:in
`log''
from /Library/Ruby/Gems/1.8/gems/activerecord-2.0.2/lib/ac...
2006 Jun 15
6
Sqlite3 test fails in Rails app
...loader.rb"
"test/functional/dispatcher_controller_test.rb"
Loaded suite
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake/rake_test_loader Started
E/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/errors.rb:94:in
`check'': SQL logic error or missing database (SQLite3::SQLException)
from
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/resultset.rb:76:in
`check''
from
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/resultset.rb:68:in
`commence''
from
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/resultset.rb:61:in
`initialize&...
2010 Oct 05
2
Is it possible to query on virtual attributes?
...method:
def full_name
self.first_name + " " + self.last_name
end
Is it possible for me to query on full_name and have rails match the
first_name and last_name fields?
I currently receive this error when I try, because full_name isn''t an
attribute in the database:
SQLite3::SQLException: no such column: full_name: SELECT
"people".* FROM "people" WHERE (LOWER(full_name) LIKE ''he
%'') ORDER BY full_name ASC LIMIT 10
--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To...
2006 May 11
2
Unit tests fail with sqlite3 and rails 1.1
...ute environment
** Execute db:test:prepare
** Invoke db:test:clone (first_time)
** Invoke db:schema:dump (first_time)
** Invoke environment
** Execute db:schema:dump
** Execute db:test:clone
** Invoke db:schema:load (first_time)
** Invoke environment
** Execute db:schema:load
rake aborted!
SQLite3::SQLException: object name reserved for internal use:
sqlite_autoindex_categories_1: CREATE UNIQUE INDEX
sqlite_autoindex_categories_1 ON categories (name)
/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/a...
2006 Dec 29
5
sqlite errors
Hello,
When I kick off SVN1992 with storeconfigs=yes, I get the following error:
err: Could not store configs: SQLite3::SQLException: SQL logic error
or missing database: INSERT INTO resources ("exported", "line",
"title", "host_id", "restype", "source_file_id") VALUES(NULL, 23,
''svnpkgadd-emacs-nox-etc'', NULL, NULL, NULL)
The database does exist, and...
2006 Mar 21
5
Order records based on number of children
Let''s say I have simple schema with two tables. The models are defined
like the folllowing:
class Parent < ActiveRecord::Base
has_many :children
end
class Child < ActiveRecord::Base
belongs_to :parent
end
Simple has_many relationship. Is there any way to order the results of
a Parent.find_all by the number of children the parent has? I can
sort with
sorted_parents =
2011 Apr 27
6
rubygems (LoadError)
I''m trying to set up a cron job with a runner that calls a method in one
of my models. I''m using javan''s whenever gem to do this and I''m running
CentOS on my server. Whenever the cron executes though I''m getting the
following error:
`require'': no such file to load -- rubygems (LoadError)
The method uses the ''mail'' and
2011 Jul 25
5
Arel quiz: complex queries with associations
...ll.map { |p| puts
"#{p.name} #{p.language.english_name}" }
how many people tweet in french?
> Person.where(:tweets => {:language_id => ''fr''}).count
(0.1ms) SELECT COUNT(*) FROM "people" WHERE "tweets"."language_id" =
0
SQLite3::SQLException: no such column: tweets.language_id: SELECT
COUNT(*) FROM "people" WHERE "tweets"."language_id" = 0
ActiveRecord::StatementInvalid: SQLite3::SQLException: no such column:
tweets.language_id: SELECT COUNT(*) FROM "people" WHERE
"tweets"."langu...
2008 Oct 04
1
Error in INSERT when using stored configs
Hello,
I''m having some trouble getting stored configs to work properly with
SQLite. During each run, the puppet master is reporting the following
error:
err: Could not store configs: SQLite3::SQLException: fact_values.value
may not be NULL: INSERT INTO fact_values ("updated_at",3 18:41:56'',
NULL, 3, 18)
I''m using Puppet 0.24.4 with Rails 1.2.6 and SQLite 3.3.6.
Can anybody point me in the right direction here?
Thanks.k
--~--~---------~--~----~------------~-------~--~-...
2011 Apr 26
1
problem populating table using rake db:fixtures:load
...in my test/fixtures directory. The command I''m
running is rake db:fixtures:load FIXTURES=stores.
The error message says that the file "st.yml" (i.e., not stores.yml)
can''t be found. If I save the data as st.yml and rerun the command I
get a different error:
SQLite3::SQLException: no such table: st: DELETE FROM "st" WHERE 1=1
Thanks for any suggestions.
--
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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.g...