error in sqlite3 table creation 'NSInternalInconsistencyException'

Question

I'm having a problem in creating table with sqlite3 , I created the database in the code but it gives an error : 'NSInternalInconsistencyException', reason: 'Could not create table'

I tried to review the code to find bugs but I couldn't find any. here is some of the code.

-(NSString *)filePath
{
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentationDirectory, NSUserDomainMask, YES);
    return [[paths objectAtIndex:0] stringByAppendingString:@"dbfile.sql"];
}


-(void)openDB
{
    if (sqlite3_open([[self filePath]UTF8String], &db) != SQLITE_OK)
    {
        sqlite3_close(db);
        NSAssert(0,@"Database Failed to Open");
    }else{
        NSLog(@"Database Opened !");
    }
}

-(void)createTable:(NSString *)tableName
        withField1:(NSString *)field1
        withField2:(NSString *)field2
        withField3:(NSString *)field3
        withField4:(NSString *)field4
{
    char *err;
    NSString *sql = [NSString stringWithFormat:
                     @"CREATE TABLE IF NOT EXIST '%@' ('%@'TEXT PRIMARY KEY, '%@' INTEGER, '%@' INTEGER, '%@' TEXT);",tableName,field1,field2,field3,field4];
    if (sqlite3_exec(db, [sql UTF8String], NULL, NULL, &err) != SQLITE_OK)
    {
        sqlite3_close(db);
        NSAssert(0,@"Could not create table");
    }else{
        NSLog(@"Table Created");
    }
}

and I import sqlite3.h but every time I run the simulator it crashes and gave me that error.

please help me,Thank you.

No. You're not. You're not creating the database from the code shown above. If you haven't included the database creation code, please make sure that your database exists at the path.. — Himanshu A Jadav, Feb 18 '14 at 06:51
And after the execution of code you can check whether DB is created or not. — Hemant Singh Rathore, Feb 18 '14 at 06:56

score 0 · Answer 1 · edited May 23 '17 at 12:10

0

copy db again in your xcode and check below link for copy database to iOS :

link 1

and than try to create tabels

edited May 23 '17 at 12:10

Community

1
1

answered Feb 18 '14 at 06:51

jayraj m.g.

625
5
18

score -1 · Answer 2 · edited Feb 18 '14 at 08:38

-1

-(NSString *)filePath
{
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentationDirectory, NSUserDomainMask, YES);
    return [[paths objectAtIndex:0] stringByAppendingString:@"/dbfile.sql"];
}

the path is not right

edited Feb 18 '14 at 08:38

Himanshu A Jadav

2,286
22
34

answered Feb 18 '14 at 06:57

Xianng

342
3
14

You are copy-pasting OPs code as answer. To comment on something in the code, consider posting a comment instead. – Amar Feb 18 '14 at 08:45

error in sqlite3 table creation 'NSInternalInconsistencyException'

2 Answers2