Displaying 20 results from an estimated 20000 matches similar to: "sqlite3 SQL logic error or missing database"
2006 Mar 30
13
Trying Agile book, found problem
Pg. 57 of Agile asks you to create a scaffolding by typing in
ruby script/generate scaffold Product Admin
Instead of generating everything, it only gives me
exists app/controllers/
exists app/helpers/
exists app/views/admin
exists test/functional/
dependency model
exists app/models/
exists test/unit/
exists test/fixtures/
identical
2006 Jul 09
1
connecting to sqlite3
I''m having problems connecting to sqlite3.
Here is what my config file looks like:
development:
adapter: sqlite3
dbfile: /tmp/db/test.db
test:
adapter: sqlite3
dbfile: /tmp/db/test.db
Running migrations causes this error to be thrown:
g4:~/sites/rails/test smtlaissezfaire$ rake migrate
(in /Users/smtlaissezfaire/Sites/rails/test)
rake aborted!
no such file to load -- sqlite3
2006 Jun 15
6
Sqlite3 test fails in Rails app
Greetings:
I am using Sqlite3 database with my Rails app. When I try and run "rake
tests" for the app it always fails with the error:
** Invoke default (first_time)
** Invoke test (first_time)
** Execute test
** Invoke test:units (first_time)
** Invoke db:test:prepare (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:test:prepare
** Invoke
2016 Oct 20
2
queue_log/cel sqlite
On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <cervajs2 at gmail.com> wrote:
> i tested this
>
> # cat /etc/asterisk/extconfig.conf
> [settings]
> queue_log => sqlite3,cdrDb
>
> # cat /etc/asterisk/res_config_sqlite3.conf
> [cdrDb]
> dbfile = /var/lib/asterisk/realtime.sqlite3
>
> sqlite3 /var/lib/asterisk/realtime.sqlite3
>
> CREATE TABLE
2006 Aug 12
7
Override method in ActiveRecord
Hello,
there is a method ActiveRecord::Base#exists? . I would like to override
this method in a class ActiveRecord.
Could anyone tell me how to do it?
TIA
--
Posted via http://www.ruby-forum.com/.
2006 Mar 23
0
Rails 1.1RC1 corrupts my sqlite3 database
When I run TOT rails, my development sqlite3 database is corrupted
whenever Rails attempts to access it. I found this a couple of days
ago and reported it as <http://dev.rubyonrails.org/ticket/4330>. When
I backout changeset 3981, I cannot reproduce the corruption.
Has anyone else seen this problem? I''m running Mac OS X 10.4.5 with
Ruby 1.8.4. I also have reinstalled both swig and
2007 Nov 01
0
attach database in active record with sqlite3
Sqlite3 is capable of attaching multiple databases together so two or
more can be accessed with a single SQL query. Do AR and sqlite3-ruby
support this functionality? If not, is there a way to achieve similar
functionality?
Thanks,
Earle
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
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",
2006 Aug 17
0
Sqlite3 Update Problems
I have an Sqlite3 DB backing a Rails app, which was previously working
fine, but then my client called me up to say he couldn''t update his
site. The site works fine for any type of "select" type operations,
but not for any "update" type operations. I have tried all manner of
permissions, and even moved my symlinked db out of a shared directory
directly into the db
2008 May 03
2
sqlite3, inserting values in database
hi,
i have a small form of textfields and i need to add these informations
to a table in sqlite3 database. but i dont know how to do it. i mean
that its small address book program. and ''id'' from ''clients'' table has
to increments. i open database with : db = Database.open("data.db"), but
then i dont know what to do...
anyone can help?
--
Posted via
2009 Mar 16
0
Reading XML-file + saving to sqlite3 database
Hi!
I''m new with Ruby On Rails, so I don''t really know how I can get this
fixed.
As a result of a program, I''ve got +/- 20 XML files, and I would like
to import them to my sqlite3 database. Each XML-file having it''s own
table.
Now I think I need to read the xml-files first and process them later.
I''ve done some research and found REXML, but I
2006 Jul 25
3
+ camping 1.4.140 -- apache+fastcgi, lighttpd+fastcgi
Okay, I have tested mounting several of my apps under Lighttpd and Apache,
both running FastCGI. I''m going to explain the configuration, but first:
update.
gem install camping --source code.whytheluckstiff.net
== Mounting Root for Lighttpd+FastCGI ==
server.port = 3045
server.bind = "192.168.0.103"
server.modules = (
2013 Jun 09
0
db.c:329 ast_db_put: Couldn't execute statment: SQL logic error or missing database ??
I'm showing a lot of these on the console. I'm not using any database.
Where would this be coming from?
sean
2005 May 03
8
SQLite3 + RAM drive => 3 times faster unit tests
One problem I sort of always had with the ActiveRecord''s tight coupling
to the SQL backend is how slow it makes the unit tests. OK, there are
some ways to make it faster at a price of extra complexity (reusing the
fixtures, doing a rollback in the end of the test, etc), but still - it
is much slower than what I would like a unit test to be.
Today I had a very simple idea (why, oh why
2005 Jun 29
3
trouble with active record and sqlite
I am getting an error that I can''t figure out. I have a class called
Test with 3 fields, id, x, and y. When I do Test.new(''x''=>1,
''y''=>2).save, I get an error saying that id (my ''not null primary
key'') can''t be null. But isn''t active record supposed to deal with
setting that for me? Here''s the code
2006 Sep 26
1
Error while generating scaffold
Hello,
When I run the command:
"ruby script/generate scaffold Product Admin"
I receive the following error after the usual changed files info:
"Couldn''t find ''product'' generator"
The command is based on "Agile Web Application Development with Rails"
first edition on page: 57. Just to give some context to what I am
doing, I just created
2006 Feb 08
1
Save only inserts null instead of actual values
Hi,
whenever I try to save my form, rails only enters null values in my
database. I''m using sqlite, I thought that sqlite might be the problem,
but the problem remains when I switched to mysql. Here is my code:
controller:
class CollectionController < ApplicationController
def new
@collection = Collection.new
end
def create
if request.get?
redirect_to :action
2005 Dec 22
13
in-memory SQLite for testing
I am following the rails book, and arrived to the section about
testing. The test database is configured as:
test:
adapter: sqlite3
database: ":memory:"
and I get this error with the simple product test:
% ruby test/unit/product_test.rb
Loaded suite test/unit/product_test
Started
E/usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/
errors.rb:94:in
2006 Nov 04
0
gem install sqlite3-ruby error
when i install typo on debian, appear error like this, could you tee
me how to fix this bug?:
debian:~# gem install sqlite3-ruby
Need to update 4 gems from http://gems.rubyforge.org
....
complete
Select which gem to install for your platform (i486-linux)
1. sqlite3-ruby 1.1.0 (mswin32)
2. sqlite3-ruby 1.1.0 (ruby)
3. sqlite3-ruby 1.0.1 (mswin32)
4. sqlite3-ruby 1.0.1 (ruby)
5. sqlite3-ruby
2012 Feb 27
0
Rails 3.1 and SQLite3
I am getting this message when running my tests against RoR-3.1
.rvm/gems/ruby-1.8.7-p352/gems/activerecord-3.1.1/lib/active_record/
connection_adapters/abstract/connection_specification.rb:71:in
`establish_connection'': Please install the sqlite3 adapter: `gem
install activerecord-sqlite3-adapter` (sqlite3 is not part of the
bundle. Add it to Gemfile.)
However, I already have this in my