{"action":"created","issue":{"url":"https://api.github.com/repos/crystal-lang/crystal-sqlite3/issues/10","repository_url":"https://api.github.com/repos/crystal-lang/crystal-sqlite3","labels_url":"https://api.github.com/repos/crystal-lang/crystal-sqlite3/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/crystal-lang/crystal-sqlite3/issues/10/comments","events_url":"https://api.github.com/repos/crystal-lang/crystal-sqlite3/issues/10/events","html_url":"https://github.com/crystal-lang/crystal-sqlite3/issues/10","id":168756914,"number":10,"title":"undefined reference to `sqlite3_close_v2'","user":{"login":"boatmon0","id":377449,"avatar_url":"https://avatars.githubusercontent.com/u/377449?v=3","gravatar_id":"","url":"https://api.github.com/users/boatmon0","html_url":"https://github.com/boatmon0","followers_url":"https://api.github.com/users/boatmon0/followers","following_url":"https://api.github.com/users/boatmon0/following{/other_user}","gists_url":"https://api.github.com/users/boatmon0/gists{/gist_id}","starred_url":"https://api.github.com/users/boatmon0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boatmon0/subscriptions","organizations_url":"https://api.github.com/users/boatmon0/orgs","repos_url":"https://api.github.com/users/boatmon0/repos","events_url":"https://api.github.com/users/boatmon0/events{/privacy}","received_events_url":"https://api.github.com/users/boatmon0/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2016-08-01T22:27:02Z","updated_at":"2016-08-02T20:15:47Z","closed_at":null,"body":"Hello, I'm new to crystal, I see some reference to this problem, but I don't see what I might need to do to work around the problem.  From what I see, the version of sqlite3 and the driver are not compatible.  What is a working combination?  I simply pasted the sample from this git into a text file and attempted to run.  \r\n\r\nSQLite35858Connection.o: In function `*SQLite3::Connection#do_close:Int32':\r\nSQLite3::Connection:(.text+0x403): undefined reference to `sqlite3_close_v2'\r\ncollect2: error: ld returned 1 exit status\r\n\r\nError: execution of command failed with code: 1: `cc -o \"/home/eugene/workspace/harvest/harvest\" \"${@}\"  -rdynamic  -lsqlite3 -lpcre -lgc -lpthread /opt/crystal/src/ext/libcrystal.a -levent -lrt -ldl -L/usr/lib -L/usr/local/lib`\r\n\r\n```crystal\r\nrequire \"db\"\r\nrequire \"sqlite3\"\r\n\r\n\r\nmodule Harvest\r\n  # TODO Put your code here\r\n   puts \"Hello\"\r\ndb = DB.open \"sqlite3://data.db\" \r\n  db.exec \"create table contacts (name string, age integer)\"\r\n  db.exec \"insert into contacts values (?, ?)\", \"John Doe\", 30\r\n\r\n#  args = [] of DB::Any\r\n#  args << \"Sarah\"\r\n#  args << 33\r\n#  db.exec \"insert into contacts values (?, ?)\", args\r\n\r\n#  puts \"max age:\"\r\n#  puts db.scalar \"select max(age) from contacts\" # => 33\r\n\r\n#  puts \"contacts:\"\r\n#  db.query \"select name, age from contacts order by age desc\" do |rs|\r\n#    puts \"#{rs.column_name(0)} (#{rs.column_name(1)})\"\r\n#    # => name (age)\r\n#    rs.each do\r\n#      puts \"#{rs.read(String)} (#{rs.read(Int32)})\"\r\n#      # => Sarah (33)\r\n#      # => John Doe (30)\r\n   db.close\r\n```"},"comment":{"url":"https://api.github.com/repos/crystal-lang/crystal-sqlite3/issues/comments/237029584","html_url":"https://github.com/crystal-lang/crystal-sqlite3/issues/10#issuecomment-237029584","issue_url":"https://api.github.com/repos/crystal-lang/crystal-sqlite3/issues/10","id":237029584,"user":{"login":"boatmon0","id":377449,"avatar_url":"https://avatars.githubusercontent.com/u/377449?v=3","gravatar_id":"","url":"https://api.github.com/users/boatmon0","html_url":"https://github.com/boatmon0","followers_url":"https://api.github.com/users/boatmon0/followers","following_url":"https://api.github.com/users/boatmon0/following{/other_user}","gists_url":"https://api.github.com/users/boatmon0/gists{/gist_id}","starred_url":"https://api.github.com/users/boatmon0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boatmon0/subscriptions","organizations_url":"https://api.github.com/users/boatmon0/orgs","repos_url":"https://api.github.com/users/boatmon0/repos","events_url":"https://api.github.com/users/boatmon0/events{/privacy}","received_events_url":"https://api.github.com/users/boatmon0/received_events","type":"User","site_admin":false},"created_at":"2016-08-02T20:15:47Z","updated_at":"2016-08-02T20:15:47Z","body":"Sorry, dumb user.  I had never used sqlite3 always mysql.  I just googled how to install sqlite3 and this was the first reference.  So what is my easiest path back to sanity?"}}
{"actor":{"display_login":"boatmon0"}}