Error with Sqlite with old project

Moderator: Rathinagiri

Post Reply
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Error with Sqlite with old project

Post by sudip »

Hello,

I am trying to compile Sqlite project with HMG after a long time. I am getting some errors. Can anyone please help me?
With best regards.
Sudip

Error is as follows :
Harbour 3.2.0dev (r1506261250)
Copyright (c) 1999-2015, http://harbour-project.org/
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xb5): undefined reference to `sqlite3_close'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x193): undefined reference to `sqlite3_user_data'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x202): undefined reference to `sqlite3_value_type'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x27e): undefined reference to `sqlite3_result_error_code'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x297): undefined reference to `sqlite3_value_bytes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2a8): undefined reference to `sqlite3_value_blob'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2c8): undefined reference to `sqlite3_value_text'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2f7): undefined reference to `sqlite3_value_double'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x318): undefined reference to `sqlite3_value_int64'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x354): undefined reference to `sqlite3_result_int64'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x364): undefined reference to `sqlite3_result_null'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x39e): undefined reference to `sqlite3_result_text'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c3): undefined reference to `sqlite3_result_double'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x8d4): undefined reference to `sqlite3_libversion'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x8f4): undefined reference to `sqlite3_libversion_number'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x914): undefined reference to `sqlite3_sourceid'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x934): undefined reference to `sqlite3_initialize'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x954): undefined reference to `sqlite3_shutdown'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xa38): undefined reference to `sqlite3_extended_result_codes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xb0a): undefined reference to `sqlite3_errcode'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xbda): undefined reference to `sqlite3_extended_errcode'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xcaa): undefined reference to `sqlite3_errmsg'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xce3): undefined reference to `sqlite3_errstr'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xd13): undefined reference to `sqlite3_sleep'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xdda): undefined reference to `sqlite3_last_insert_rowid'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xe6f): undefined reference to `sqlite3_open'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xf58): undefined reference to `sqlite3_close'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1025): undefined reference to `sqlite3_open_v2'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x10f9): undefined reference to `sqlite3_close'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x12f5): undefined reference to `sqlite3_exec'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1307): undefined reference to `sqlite3_free'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1450): undefined reference to `sqlite3_prepare_v2'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1460): undefined reference to `sqlite3_finalize'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x14ca): undefined reference to `sqlite3_complete'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1537): undefined reference to `sqlite3_sql'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x15c3): undefined reference to `sqlite3_stmt_status'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1637): undefined reference to `sqlite3_stmt_readonly'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1697): undefined reference to `sqlite3_step'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x16f7): undefined reference to `sqlite3_clear_bindings'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1757): undefined reference to `sqlite3_reset'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x17b7): undefined reference to `sqlite3_finalize'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1863): undefined reference to `sqlite3_bind_blob'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1902): undefined reference to `sqlite3_bind_double'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1993): undefined reference to `sqlite3_bind_int'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1a3d): undefined reference to `sqlite3_bind_int64'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1aca): undefined reference to `sqlite3_bind_null'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1b78): undefined reference to `sqlite3_bind_text'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1c23): undefined reference to `sqlite3_bind_zeroblob'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1c97): undefined reference to `sqlite3_bind_parameter_count'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1d18): undefined reference to `sqlite3_bind_parameter_index'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1d9a): undefined reference to `sqlite3_bind_parameter_name'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1e8a): undefined reference to `sqlite3_changes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1f5a): undefined reference to `sqlite3_total_changes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1f97): undefined reference to `sqlite3_column_count'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x200b): undefined reference to `sqlite3_column_type'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x207b): undefined reference to `sqlite3_column_decltype'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x20eb): undefined reference to `sqlite3_column_name'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x215b): undefined reference to `sqlite3_column_bytes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x21d8): undefined reference to `sqlite3_column_bytes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x21e6): undefined reference to `sqlite3_column_blob'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x227b): undefined reference to `sqlite3_column_double'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x22eb): undefined reference to `sqlite3_column_int'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x235b): undefined reference to `sqlite3_column_int64'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x23d8): undefined reference to `sqlite3_column_bytes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x23e6): undefined reference to `sqlite3_column_text'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2538): undefined reference to `sqlite3_load_extension'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2561): undefined reference to `sqlite3_free'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2648): undefined reference to `sqlite3_enable_load_extension'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2748): undefined reference to `sqlite3_busy_timeout'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2878): undefined reference to `sqlite3_get_table'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2920): undefined reference to `sqlite3_free_table'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x294c): undefined reference to `sqlite3_free'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2b0c): undefined reference to `sqlite3_blob_open'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2b9e): undefined reference to `sqlite3_blob_reopen'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2bf7): undefined reference to `sqlite3_blob_close'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2c57): undefined reference to `sqlite3_blob_bytes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2d00): undefined reference to `sqlite3_blob_read'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2d44): undefined reference to `sqlite3_blob_bytes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2dfc): undefined reference to `sqlite3_blob_write'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2f0a): undefined reference to `sqlite3_get_autocommit'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2f43): undefined reference to `sqlite3_enable_shared_cache'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3060): undefined reference to `sqlite3_profile'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3180): undefined reference to `sqlite3_trace'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3376): undefined reference to `sqlite3_interrupt'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x347f): undefined reference to `sqlite3_busy_handler'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x34a2): undefined reference to `sqlite3_busy_handler'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x35d8): undefined reference to `sqlite3_progress_handler'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x35fa): undefined reference to `sqlite3_progress_handler'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x36ff): undefined reference to `sqlite3_commit_hook'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3722): undefined reference to `sqlite3_commit_hook'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x382f): undefined reference to `sqlite3_rollback_hook'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3852): undefined reference to `sqlite3_rollback_hook'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x395f): undefined reference to `sqlite3_set_authorizer'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3ae8): undefined reference to `sqlite3_backup_init'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3b8a): undefined reference to `sqlite3_backup_step'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3bd7): undefined reference to `sqlite3_backup_finish'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c17): undefined reference to `sqlite3_backup_remaining'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c57): undefined reference to `sqlite3_backup_pagecount'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c84): undefined reference to `sqlite3_memory_used'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3cb3): undefined reference to `sqlite3_memory_highwater'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3cd4): undefined reference to `sqlite3_threadsafe'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3da1): undefined reference to `sqlite3_status'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3f0c): undefined reference to `sqlite3_db_status'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x4056): undefined reference to `sqlite3_limit'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x4093): undefined reference to `sqlite3_compileoption_used'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x40c3): undefined reference to `sqlite3_compileoption_get'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x4250): undefined reference to `sqlite3_create_function'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2671): undefined reference to `sqlite3_reset_auto_extension'
C:/hmg/mingw/bin/../lib/gcc/i686-w64-mingw32/4.9.2/../../../../i686-w64-mingw32/bin/ld.exe: C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o): bad reloc address 0xc in section `.rdata'
C:/hmg/mingw/bin/../lib/gcc/i686-w64-mingw32/4.9.2/../../../../i686-w64-mingw32/bin/ld.exe: final link failed: Invalid operation
collect2.exe: error: ld returned 1 exit status
hbmk2[InfoBill]: Error: Running linker. 1
gcc.exe C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/infobill.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/acct.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/accyr.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/baltran.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/billprn.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/chalprn.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/comp.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/cust.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/custbal.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/custpmt.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/custprodsl.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/dbf_menu.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/dbtrled.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/figword.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/frmfind.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/hbvpdf.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/hbvpsup.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/osrpt.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/prod.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/prodslsum.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/sale.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/salereg.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/sql.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/utils.o C:/Users/Sudip/AppData/Local/Temp/hbmk_1opsot.dir/hbmk_gi4n3v.o C:/HMGProjects/InfoBill/_temp.o -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbmysql -lmysql -lhbtip -lhbsqlit3 -lsddodbc -lrddsql -lsddmy -lhbodbc -lodbc32 -lhbhpdf -lhbfimage -lhbpgsql -lhbnetio -lxhb -lpng -llibhpdf -lhbvpdf -lhbzebra -lhbextern -lhbdebug -lhbvm -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib -Wl,--end-group -oInfoBill.exe -LC:/hmg/harbour/lib/win/mingw -LC:/hmg/lib
With best regards,
Sudip
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Error with Sqlite with old project

Post by Rathinagiri »

This just means that libsqlite3.a is not included in the compiling/linking process.

Please add this line to your project .hbc file.

libs=sqlite3
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
Post Reply