Stack Overflow
Stack Overflow

Questions tagged [sqlite3-ruby]

The low level SQLite3 library for Ruby. This should only be used for questions about using the low level interface directly.

The SQLite3 gem provides low level Ruby bindings to the SQLite3 embedded database.

You must have the SQLite engine installed in order to build this module.

Links:

214 questions
0
votes
1 answer

Rails - querying multiple fields with boolean values

I have a migration file written as such: class Character < ActiveRecord::Migration def change create_table :character_attributes do |t| t.string :character_name t.boolean :attr1, default: false, null: false t.boolean…
Xavier
  • 323
  • 3
  • 10
0
votes
0 answers

'Mysql2' is defined in database adapter, but its asking to add gem 'sqlite3'

I have recently upgraded rails to 4.2.X latest from 3.2.19. Also upgraded ruby to 2.2.2 from 1.9.2. When trying to run spec using $ rspec . command, I got this following error: Could not load native IDN implementation. …
Chiranjib Roy
  • 53
  • 6
0
votes
0 answers

nokogiri issues with ruby

I wanted to install Ruby on Rails to learn more about how to programming with Ruby on Rails as I know there is a demand for this web application framework. So, I downloaded the latest ruby and the dev kit for 64 bit which is present on the…
user3906716
0
votes
2 answers

Nil in Database for Ruby on Rails

I'm extremely new, and going through the basic ruby rails tutorial except tweaking it just to add some extra fields and renaming what it calls articles at contacts. Problem is, everything is fine, except all my data is being added in as NIL. Here is…
echa
  • 1
  • 2
0
votes
0 answers

SQLite3 Database won't load on Elastic Beanstalk

I'm a beginner programmer trying to deploy my first Rails App that uses a local sqlite3 db located at db/production.sqlite3 However, when I deploy it to Elastic Beanstalk, it doesn't seem to load since all my content (stored in the db) doesn't…
Pedro Moorcraft
  • 1
0
votes
1 answer

data_mapper: Can't save Time object

I am attempting to persist an object that has a Time-type field. On create, I attempt to set the sleep_value to a valid Time object but the save seems to fail silently (even though raise_on_save_failure is set to true). If I try to search for the…
JoeyC
  • 764
  • 11
  • 19
0
votes
1 answer

send invitation for user rails by adding user_id and page_id in a table

I am new to rails and I have a task asking me to let a page admin to send invitations for regular users to be admins with him I implemented the part to reply to the invitations but I am stuck in an error and please tell me if I am on the right way …
LSDrako
  • 63
  • 1
  • 8
0
votes
1 answer

Method for reseting all users in database with Ruby on Rails 4

So I've set up a new authentication process within my website using rails (rails version '4.2.0', sqlite3 database manager, ruby 2.1.1p76) on OSX Mavericks (yes, I still haven't updated yet!). The website as yet is still only local as I'm learning…
GCien
  • 2,221
  • 6
  • 30
  • 56
0
votes
0 answers

How to 'safely' back up SQLite3 in Rails?

I'm currently developing a small-scale web app using Rails, and have been looking into the best way to go about keeping backups of the database. I've decided to use SQLite3 for the database as it's small-scale enough that it makes sense (there will…
nuclearpidgeon
  • 341
  • 3
  • 8
0
votes
1 answer

Local install of sqlite3-ruby

On my current system i dont have root-access and i want to install sqlite3-ruby. I can compile it and i know how to set custom install-folder, but how does my ruby-installation can recognize/find that installed gem for usage? I tried prefix of my…
Skully
  • 485
  • 4
  • 13
0
votes
1 answer

How to remove the migration in my database?

I have been trying to use devise to make an authentication system for a blog that I am programming.When I try to view the blog, it says (Migrations are pending; run 'bin/rake db:migrate RAILS_ENV=development' to resolve this issue.), and when I run…
codigomonstruo
  • 1,081
  • 1
  • 11
  • 45
0
votes
0 answers

How to add a Rails migration to fix schema that isn't compatible with database

On my Mac, my Rails project is using SQLite3 with a 64-character index name. I need to work on it in an Ubuntu environment. However, when I try to run rake db:setup, I get an error that my 64-character named index is too long, that SQLite3 only…
at.
  • 50,922
  • 104
  • 292
  • 461
0
votes
2 answers

Building SQL3 db error

I am building a database of skills and in the beginning thinking that I would need a title param for them I added it as a required param. I would like to get rid of the title param all together so that I can just create new skills and a…
ZachyBear
  • 297
  • 3
  • 15
0
votes
1 answer

Rails app behaves differently on heroku vs development

In Application Controller I have 2 methods : def current_user @current_user ||= User.find_by_auth_token( cookies[:auth_token]) if cookies[:auth_token] rescue ActiveRecord::RecordNotFound end helper_method :current_user def pro_user …
user2511030
  • 515
  • 1
  • 4
  • 14
0
votes
1 answer

Can't initialize local server for my Rails apps

My rails apps have been freaking out on me lately. I start my local server by running "ruby script/server" like normal. The server starts, but when I try to access it via "http://localhost:3000/", it throws me a 500 error. This happens for all my…
funkymunky
  • 1,811
  • 3
  • 20
  • 22
1 2 3
…
14 15