Apple Mach-O Linker Error sqlite3

Question

I got this error when building my apps. can anyone help me solve this problem?

I'm using swift and parse.com. thank you so much for your help!

since I can't post image, below I post the whole error message.

Undefined symbols for architecture i386:
  "_sqlite3_bind_blob", referenced from:
      -[PFSQLiteDatabase _bindObject:toColumn:inStatement:] in Parse(PFSQLiteDatabase.o)
  "_sqlite3_bind_double", referenced from:
      -[PFSQLiteDatabase _bindObject:toColumn:inStatement:] in Parse(PFSQLiteDatabase.o)
  "_sqlite3_bind_int64", referenced from:
      -[PFSQLiteDatabase _bindObject:toColumn:inStatement:] in Parse(PFSQLiteDatabase.o)
  "_sqlite3_bind_null", referenced from:
      -[PFSQLiteDatabase _bindObject:toColumn:inStatement:] in Parse(PFSQLiteDatabase.o)
  "_sqlite3_bind_parameter_count", referenced from:
      ___59-[PFSQLiteDatabase executeQueryAsync:withArgumentsInArray:]_block_invoke in Parse(PFSQLiteDatabase.o)
      ___57-[PFSQLiteDatabase executeSQLAsync:withArgumentsInArray:]_block_invoke in Parse(PFSQLiteDatabase.o)
  "_sqlite3_bind_text", referenced from:
      -[PFSQLiteDatabase _bindObject:toColumn:inStatement:] in Parse(PFSQLiteDatabase.o)
  "_sqlite3_close", referenced from:
      ___30-[PFSQLiteDatabase closeAsync]_block_invoke in Parse(PFSQLiteDatabase.o)
  "_sqlite3_column_blob", referenced from:
      -[PFSQLiteDatabaseResult dataForColumnIndex:] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_column_bytes", referenced from:
      -[PFSQLiteDatabaseResult dataForColumnIndex:] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_column_count", referenced from:
      -[PFSQLiteDatabaseResult columnNameToIndexMap] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_column_double", referenced from:
      -[PFSQLiteDatabaseResult doubleForColumnIndex:] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_column_int", referenced from:
      -[PFSQLiteDatabaseResult intForColumnIndex:] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_column_int64", referenced from:
      -[PFSQLiteDatabaseResult longForColumnIndex:] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_column_name", referenced from:
      -[PFSQLiteDatabaseResult columnNameToIndexMap] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_column_text", referenced from:
      -[PFSQLiteDatabaseResult stringForColumnIndex:] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_column_type", referenced from:
      -[PFSQLiteDatabaseResult objectForColumnIndex:] in Parse(PFSQLiteDatabaseResult.o)
      -[PFSQLiteDatabaseResult columnIndexIsNull:] in Parse(PFSQLiteDatabaseResult.o)
  "_sqlite3_errmsg", referenced from:
      -[PFSQLiteDatabase _errorWithErrorCode:] in Parse(PFSQLiteDatabase.o)
  "_sqlite3_finalize", referenced from:
      ___59-[PFSQLiteDatabase executeQueryAsync:withArgumentsInArray:]_block_invoke in Parse(PFSQLiteDatabase.o)
      ___57-[PFSQLiteDatabase executeSQLAsync:withArgumentsInArray:]_block_invoke in Parse(PFSQLiteDatabase.o)
      -[PFSQLiteStatement close] in Parse(PFSQLiteStatement.o)
  "_sqlite3_open", referenced from:
      ___29-[PFSQLiteDatabase openAsync]_block_invoke in Parse(PFSQLiteDatabase.o)
  "_sqlite3_prepare_v2", referenced from:
      ___59-[PFSQLiteDatabase executeQueryAsync:withArgumentsInArray:]_block_invoke in Parse(PFSQLiteDatabase.o)
      ___57-[PFSQLiteDatabase executeSQLAsync:withArgumentsInArray:]_block_invoke in Parse(PFSQLiteDatabase.o)
  "_sqlite3_reset", referenced from:
      -[PFSQLiteStatement reset] in Parse(PFSQLiteStatement.o)
  "_sqlite3_step", referenced from:
      ___57-[PFSQLiteDatabase executeSQLAsync:withArgumentsInArray:]_block_invoke in Parse(PFSQLiteDatabase.o)
      -[PFSQLiteDatabaseResult next] in Parse(PFSQLiteDatabaseResult.o)
ld: symbol(s) not found for architecture i386
clang: error: linker command failed with exit code 1 (use -v to see invocation)

The obvious starting point is: are you attempting to link to the sqlite3 library? If so, how? — Phillip Mills, Jan 10 '15 at 17:31

score 30 · Accepted Answer · answered Jan 24 '15 at 10:56

30

after trial and error, the answer is check all the framework again. it seems parse.com just made an update in this several months.

currently it need libsqlite3.dylib as on of it library.

if you find similar problem, firstly check the most updated requirement here: https://www.parse.com/apps/quickstart#parse_data/mobile/ios/native/existing

answered Jan 24 '15 at 10:56

Gibran

934
2
8
19

5

just in case Gibran's answer isn't clear, the fix is to go to the Build Phases -> Link Binary with Library section and add libsqlite3.dylib to the list of linked libraries – dave adelson Oct 01 '15 at 23:08
Note that right now we have ".tbd" libraries. http://stackoverflow.com/questions/31450690/why-xcode-7-shows-tbd-instead-of-dylib – Paweł Brewczynski Apr 14 '17 at 00:18

score 9 · Answer 2 · answered Dec 02 '15 at 19:50

9

I just had this happen too and @Gibran's answer put me on the right track. The one difference that I found using Xcode 7 and iOS 9 is that the libsqlite3.dylib has been replaced by libsqlite3.tbd

answered Dec 02 '15 at 19:50

julianwyz

3,104
1
29
34

score 4 · Answer 3 · edited Jan 14 '16 at 23:13

4

I've had this problem before. Just import libsqlite.dylib and libz.dylib from frameworks and your errors will disappear.

edited Jan 14 '16 at 23:13

Chris

3,210
1
33
35

answered May 29 '15 at 17:07

Niall Kehoe

416
5
17

score 2 · Answer 4 · edited May 23 '17 at 11:54

2

You can find answer there (you need to add frameworks to your project)

Link Errors with Parse.framework iOS

edited May 23 '17 at 11:54

Community

1
1

answered Jan 11 '15 at 12:13

moonvader

19,761
18
67
116

Apple Mach-O Linker Error sqlite3

4 Answers4

Linked

Related