php-activerecord
php-activerecord copied to clipboard
1.x not working with sqlite
If you try to connect to a sqlite db, you get a "table not found {table_name}" error.
show us the database structure.
@jardelsantana
create table transactions
(
id INTEGER,
account VARCHAR(4) not null,
amount_change FLOAT not null,
action VARCHAR(50) not null,
balance FLOAT
)
;
create unique index transactions_id_uindex
on transactions (id)
;
create table users
(
id INTEGER not null,
name VARCHAR(50) not null,
account VARCHAR(4) not null,
pin VARCHAR(4) not null,
balance FLOAT
)
;
create unique index users_id_uindex
on users (id)
;
create unique index users_account_uindex
on users (account)
;
The same script/structure works fine If I switch to MySQL.
@jardelsantana Do you know if there's any workaround to fix this? If you have some insight I can jump in the code and submit a pull request