I'm running into this as well. Have you been able to resolve it?
I'm running into this as well. Have you been able to resolve it?
FOREIGN KEY constraint failed (Code: 7500)sqlite3 locally) and the actual 'library' itself used by embedders doesn't show that.FOREIGN KEY constraint failed (Code: 7500)sqlite3X [ERROR] not authorizedPRAGMA journal_mode = MEMORY;
PRAGMA synchronous = OFF;
PRAGMA foreign_keys = OFF;
PRAGMA ignore_check_constraints = OFF;
PRAGMA auto_vacuum = NONE;
PRAGMA secure_delete = OFF;
#=====================================================================
#
# Quran Translation
# Name: Pickthall
# Translator: Mohammed Marmaduke William Pickthall
# Language: English
# ID: en.pickthall
# Last Update: September 4, 2010
# Source: Tanzil.net
#
#=====================================================================
# CREATE DATABASE IF NOT EXISTS `quran`
# USE `quran`;
DROP TABLE IF EXISTS `en_pickthall`;
CREATE TABLE `en_pickthall` (
`index` INTEGER NOT NULL ,
`sura` INTEGER NOT NULL default '0',
`aya` INTEGER NOT NULL default '0',
`text` text NOT NULL,
PRIMARY KEY (`index`)
);
INSERT INTO `en_pickthall` (`index`, `sura`, `aya`, `text`) VALUES
(1, 1, 1, 'In the name of Allah, the Beneficent, the Merciful.'),
(2, 1, 2, 'Praise be to Allah, Lord of the Worlds,'),
(3, 1, 3, 'The Beneficent, the Merciful.'),
(4, 1, 4, 'Master of the Day of Judgment,'),
(5, 1, 5, 'Thee (alone) we worship; Thee (alone) we ask for help.'),
(6, 1, 6, 'Show us the straight path,'),CREATE TABLE
user (
id TEXT NOT NULL PRIMARY KEY,
username TEXT NOT NULL,
email TEXT NOT NULL,
password_hash TEXT NOT NULL,
created_at INTEGER NOT NULL,
updated_at INTEGER NOT NULL
);
CREATE TABLE
session (
id TEXT NOT NULL PRIMARY KEY,
expires_at INTEGER NOT NULL,
user_id TEXT NOT NULL,
FOREIGN KEY (user_id) REFERENCES user (id)
);