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

sqlite3.OperationalError: unrecognized token:

Hello I new in the sqlite world and here is my problem. Trying to fix a twitter bot an error occured. Here is the code to modify and the error. Tell me if you need the entire code or other informations def CreateTables(user): connexion =…
Hugo361
  • 1
  • 1
0
votes
1 answer

rails server failed to start, win10

After installing windows railsinstaller-3.4.0 (from here) followed the steps creating blog application in rails then tried to start server by command $ bin/rails server but failed with message Could not find gem 'turbolinks (~> 5) x86-mingw32' in…
Amrit Pariyar
  • 101
  • 2
  • 10
0
votes
3 answers

Ruby on Rails Database Query with Ruby Variable

This is the current code for my query.. <% property_id = params[:property] %> <%= property_name = Hotel.find_by_sql(' SELECT name FROM hotels ') %> I want to be able to add something like WHERE hotel_id == property_id But…
Haha
  • 278
  • 2
  • 10
0
votes
1 answer

Rails App Display Button/Link Depending on Users["rank"]

Okay so the goal of this question is for me to figure out how I can display components on a view depending on the Users attributes stored in my database. I'm new to rails so figuring out how to work with data will help me better grasp the…
Haha
  • 278
  • 2
  • 10
0
votes
1 answer

Error loading the 'sqlite3' Active Record adapter, Ruby on Rails error Win10 64bit

Before I reload my localhost:3000 webpage it says this: $ rails s => Booting Puma => Rails 6.0.1 application starting in development => Run `rails server --help` for more startup options *** SIGUSR2 not implemented, signal based restart…
Ethan Middleton
  • 1
  • 2
0
votes
0 answers

Ruby on Rails app on Heroku crashes on startup

The app works fine in local host, and also uploads to Heroku just fine. The crash error is ":in `block (2 levels) in replace_gem': Error loading the 'sqlite3' Active Record adapter. Missing a gem it depends on? sqlite3 is not part of the bundle. Add…
William Spear
  • 36
  • 5
0
votes
2 answers

Issue with SQLite gem when installing Ruby on Rails

Error installing sqlite3, failed to build native gem extension. Running on Windows 10. Following a codeacademy tutorial, I successfully installed Ruby on Rails (ruby version : 2.3.3p222 (2016-11-21 revision 56859) [i386-mingw32) (rails version :…
C. Evans
  • 1
0
votes
2 answers

Ruby on Rails SQLite3::NotADatabaseException (file is encrypted or is not a database)

I am afraid something really bad happened while I was messing around with my RAILS app. It was working fine, and I am not sure what I did, but I get the following error: Started GET "/" for 127.0.0.1 at 2011-03-30 02:20:15 -0500 Processing by…
railslearner
  • 1,761
  • 2
  • 14
  • 18
0
votes
1 answer

Setting up SQLite without copying and pasting application file to every project directory

I am revisiting an old bootcamp course to refresh my memory and doing things locally vs. on the Cloud9 development environment. I'm confused because I've downloaded SQLite per the downloads page and saved it to a folder under C:\sqlite. I can load…
michjo
  • 407
  • 2
  • 17
0
votes
1 answer

undefined method 'execute' for nil:NilClass

I am making a tool in ruby which can interact with databases. I am using amalgalite as an adapter for sqlite3. Code: require 'amalgalite' # this is class RQuery class RQuery def db_open(db_name) @db = Amalgalite::Database.new "#{db_name}.db" …
vbhv
  • 31
  • 7
0
votes
1 answer

How to make an input to search from database based on select option in Rails 5

So I have a form where in an input (type: text) and a select option one next to each other. I want to be able when choosing an option from the select option (either "search from your food" or "search food") to search from the corresponding table in…
Alexander Bogdanov
  • 94
  • 1
  • 11
0
votes
1 answer

Rails NoSuchColumn error on INNER joins

I've been working on a rails application but recently I encountered this error and I have no idea why it's happening, it only happens in my development environment, in production it works just fine. It involves querying data from an inner join,…
IvanHid
  • 669
  • 7
  • 25
0
votes
4 answers

Sqlite3 error message

Hey, I've recently been having trouble properly installing my Sqlite3 gem. I've already tried installing sqlite3, followed by sqlite3-ruby and I keep getting an error message. Can anyone tell me what I need to do to correct this? Here's the error…
theGrayFox
  • 921
  • 1
  • 10
  • 22
0
votes
0 answers

how do i save large amount of data into DB using DataMapper

Im trying to insert into the database but sinatra throws this error DataObjects::ConnectionError at / database is locked at line Name.create(babyname: name ,year1900: results[0] ,year1910: results[1] ,year1920: results[2] ,year1930:…
msc
  • 67
  • 8
0
votes
1 answer

Creating an ActiveRecord database for a webcrawler. Having issues adding index

I'm working on a three part program for a webcrawler program for school. My first step is to just create the database using activerecord and knowing that it will be queried later using sqlite3. The database actually does get created with my…
Chuck Smithson
  • 83
  • 7
1 2 3
…
14 15