Questions tagged as 'sqlite3'

Tagged questions
2
answers

Problems trying to save to "POST"="no-such-table" database Django / Python

I'm following a course in Python and Django, and the problem starts when the course version is 1.1.2 and mine is 1.8.2 I was able to generate a form to save "Events", but when I click submit, it returns the following error: OperationalE...
asked by 05.06.2015 / 07:01
2
answers

Subqueries with SELECT statement in Sqlite

I need to return two values in my query and I do not know if it's possible to do this in a single select ... I wanted a better explanation to understand how to do a subselect in Sqlite. I have the following fields: CREATE TABLE [LANCAMENTO]...
asked by 17.10.2017 / 14:51
1
answer

Size occupied on disk by a table in SQLite

In Oracle, when we want to know how much a table occupies disk we can query the dba_segments dictionary. SELECT segment_name, segment_type, bytes/1024/1024 MB FROM dba_segments WHERE segment_type='TABLE' and segment_name='<nome-tabel...
asked by 10.06.2016 / 20:40
1
answer

How to check if a SQLite3 Database is valid?

I was testing and seeing what happens if the android create a database with wrong input values. For example, if I inadvertently typed NOOT instead of NOT or INTEGET instead of INTEGER, I expected SQL to point to a return error saying that the...
asked by 25.02.2018 / 21:15
1
answer

SQLite - too many levels of trigger recursion

I'm getting the error below when I try to insert into SQLite.    Error while executing SQL query on database 'BDTEST': too many levels of trigger recursion Creating the table CREATE TABLE INSTANCES ( ID INTEGER NOT NULL PRIMARY KEY AUTO...
asked by 23.10.2017 / 15:48
1
answer

Error in sqlite3 foreign or foreigin

I created a database in sqlite3 in version 3.9.2 and had problems with the foreign key. alter table table_01 add column tab_2 integer foreign key references table_02(id); // Esse deu erro de sintaxe no foreign key alter table ta...
asked by 14.02.2016 / 01:50
1
answer

Call to undefined function transliterator_transliterate () in php 5.512 using wampserver 2.5

I'm studying SQLITE3 and PHP and checking an example of the PHP Manual appeared the following error: Fatal error: Call to undefined function transliterator_transliterate() Example: link I installed PEAR in Wamp but the error continues...
asked by 16.10.2015 / 03:09
1
answer

NodeJS + sqlite3: error getting information from Select

I'm learning nodeJS. I'm trying to integrate it into Sqlite3, but when trying to read a database information the following error is being generated: /home/ubuntu/workspace/node_modules/sqlite3/lib/trace.js:28...
asked by 25.07.2014 / 16:40
1
answer

Django - Error saving to Database

The data is not being saved in the Database and Django is not generating Error, but when I create an object of Livro and try to save by the shell it returns me the following error:    ValueError: invalid literal for int () with base 10...
asked by 13.05.2014 / 22:50
0
answers

External database is not loading on android [closed]

I need to make an application Android that accesses a servidor , downloads .s3db and queries about downloaded files. I can usually download to data/data/meu-pacote/databases/ and I can also do operations on those files...
asked by 07.06.2015 / 15:34