I'm having an issue where I can't seem to get Racket to run the right version of sqlite3. At least, I'm assuming that's the problem because the syntax error below occurs in an older version but not the current version of sqlite3. My Terminal command path has the correct version. What can I do to make sure Racket is using the right version?
Here's the full error message. RUNNING reset_dbs.rkt rows are: '(#hash((data . #hasheq((base_dir . "/tmp/biomantica"))) (name . "filesystem"))) SQL: INSERT INTO config ( name, data ) VALUES ($1,$2) ON CONFLICT DO NOTHING vals: '("filesystem" "{\"base_dir\":\"/tmp/biomantica\"}") query-exec: near "ON": syntax error error code: 1 context...: /Applications/Racket/collects/db/private/sqlite3/connection.rkt:457:0: handle-status* /Applications/Racket/collects/db/private/sqlite3/connection.rkt:413:8 /Applications/Racket/collects/db/private/sqlite3/connection.rkt:216:4: prepare1* method in connection% /Applications/Racket/collects/db/private/generic/../../../racket/private/more-scheme.rkt:261:28 [repeats 1 more time] /Applications/Racket/collects/db/private/generic/functions.rkt:90:0: compose-statement /Applications/Racket/collects/db/private/generic/functions.rkt:148:0: query-exec /Users/fingal/code/bmtc_dev/app/db/tests/db_test_utils.rkt:103:8: for-loop "/Users/fingal/code/bmtc_dev/app/network/reset_dbs.rkt": [running body] temp37_0 for-loop run-module-instance!125 perform-require!78 -- You received this message because you are subscribed to the Google Groups "Racket Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to racket-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/racket-users/C399A6BF-6FDE-49AD-9053-08F0F3FBD49A%40biomantica.com.