I import my DB SQLite using Taifun Extension but don't open the data base

Please help me to fix this error


From your blocks it does not look like you are using my sqlite extension… did you rename the extension?

The database must be in sqlite format. How did you create the database?

Did you try a Google search for “sqlite malformed database schema”?

When exactly you get that error? After executing the select statement?

How does your data in table estaciones look like?

Taifun

you: From your blocks it does not look like you are using my sqlite extension… did you rename the extension?
me: Yes
you: The database must be in sqlite format. How did you create the database?
me: I created the database with SQLiteStudio V3.3.3
What is the database administrator that you recommend?

you: Did you try a Google search for “sqlite malformed database schema”?
me: Yes but I didn’t found a solution

you:When exactly you get that error? After executing the select statement?
me: Yes, after executing tehr SELECT statement

you: How does your data in table estaciones look like?
me:
CREATE TABLE estaciones (
Id_Estc INT (11) NOT NULL,
Nomb_Estc VARCHAR (10) NOT NULL,
Desc_Estc VARCHAR (80) NOT NULL,
Esta_Estc TINYINT (1) DEFAULT ‘1’,
RFac_Estc VARCHAR (20) DEFAULT NULL,
RRan_Estc VARCHAR (60) DEFAULT NULL,
Id_Vehi INT (11) NOT NULL,
Id_Sucu INT (11) NOT NULL DEFAULT ‘0’,
Actu_Estc DATETIME,
PRIMARY KEY ( Id_Estc )
);

Data
1 ERK171 ERK-171 1 900088876554333333 1 Hasta 1000 19 0 2022-04-30 09:28:18

my guess is that the format of one or more of the records is incorrect … check the default values of each row… also does a default of “Null” make sense… let me suggest to remove that defaults…
EDIT: also you define the default of an int column as ‘1’ which is a string, isn’t it? same for default ‘0’…
for int columns it makes more sense to set the default as 1 or 0, doesn’t it?..

Taifun

Thanks, my problem was in all the tables that used the boolean type, I was using the value True, instead of 1. My database has 17 tables, I entered one by one with SQLiteStudio Modifying Boolean values, and other types of fields like INT for INTEGER and VARC for VARCHAR. and it is working fine

1 Like