search

soartech / jsoar

Pure Java implementation of the Soar cognitive architecture.
http://soartech.github.com/jsoar/
BSD 3-Clause "New" or "Revised" License
53 stars 19 forks source link

Error: While initializing smem ... SQL error or missing database #108

Closed KRaizer closed 7 years ago

KRaizer commented 7 years ago

Hello, I am getting the following error when running a simple "hello world" JSOAR program:

Error: While initializing smem: Failed to prepare statement 'SELECT tsh_a.symbol_type AS attr_type, tsh_a.s_id AS attr_hash, vcl.symbol_type AS value_type, vcl.s_id AS value_hash, vcl.soar_letter AS value_letter, vcl.soar_number AS value_num, vcl.value_lti_id AS value_lti FROM ((smem_augmentations w LEFT JOIN smem_symbols_type tsh_v ON w.value_constant_s_id=tsh_v.s_id) vc LEFT JOIN smem_lti AS lti ON vc.value_lti_id=lti.lti_id) vcl INNER JOIN smem_symbols_type tsh_a ON vcl.attribute_s_id=tsh_a.s_id WHERE lti_id=?': [SQLITE_ERROR] SQL error or missing database (ambiguous column name: lti_id)

I tried setting smem off like this: smem --set learning off But nothing changed.

Am I missing something?

Regards,

Klaus

marinier commented 7 years ago

Can you send the file(s) you are using for your hello world program? Also, what OS and jsoar version are you using?

Thanks, Bob

From: KR [mailto:notifications@github.com] Sent: Sunday, April 9, 2017 11:35 AM To: soartech/jsoar jsoar@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [soartech/jsoar] Error: While initializing smem ... SQL error or missing database (#108)

Hello, I am getting the following error when running a simple "hello world" JSOAR program:

Error: While initializing smem: Failed to prepare statement 'SELECT tsh_a.symbol_type AS attr_type, tsh_a.s_id AS attr_hash, vcl.symbol_type AS value_type, vcl.s_id AS value_hash, vcl.soar_letter AS value_letter, vcl.soar_number AS value_num, vcl.value_lti_id AS value_lti FROM ((smem_augmentations w LEFT JOIN smem_symbols_type tsh_v ON w.value_constant_s_id=tsh_v.s_id) vc LEFT JOIN smem_lti AS lti ON vc.value_lti_id=lti.lti_id) vcl INNER JOIN smem_symbols_type tsh_a ON vcl.attribute_s_id=tsh_a.s_id WHERE lti_id=?': [SQLITE_ERROR] SQL error or missing database (ambiguous column name: lti_id)

I tried setting smem off like this: smem --set learning off But nothing changed.

Am I missing something?

Regards,

Klaus

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/soartech/jsoar/issues/108, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAgp3B25-kfIsnO7PdOY7TmMs-fgoKL6ks5ruPqlgaJpZM4M4Dvv.

KRaizer commented 7 years ago

Hello, thanks for you help.

Here is a zip with the files I'm using:

SoarAgent.zip

I'm in a windows system, and to compile it I run:

javac -cp ".;*;" SoarAgent.java

And to run it I use:

java -cp ".;*;" SoarAgent

If I don't add "sqlite-jdbc-3.16.1.jar" as well, it produces the following error:

Error: While initializing smem: Failed to load database driver class: org.sqlite .JDBC Error: While initializing smem: Failed to load database driver class: org.sqlite .JDBC

AlexNickels commented 7 years ago

Klaus,

The easiest solution for now is to simply not include the sqlite-jdbc-3.16.1.jar. You will still see an error appear in the console, but it will be much shorter and it will not impact the running of the agent.

Longer term, I think I know what causes this and I have an in-house fix for it. I will plan on releasing it sometime in the near future. Alex Nickels

KRaizer commented 7 years ago

Ok, I'll do that then. Thanks!!