search.search_by_cpe_like -> "apsw.SQLError: no such column: vers"

[4FunAndProfit]

Hello !

When i run this code with version appthreat-vulnerability-db[all]==6.4.0 :

download_image(config.VDB_DATABASE_URL, config.DATA_DIR)
cves = search.search_by_cpe_like(cpe, True)

I have the following error:

res = conn.execute(query, args)
File "src/cursor.c", line 1086, in APSWCursor_execute.sqlite3_prepare_v3

apsw.SQLError: no such column: vers

Is there a problem with the query in vdb/lib/search.py in search_by_cpe_like ?

Thanks a lot in advance!

[prabhu]

Could you confirm if you have the latest vdb sqlite as well? We introduced a breaking change in 6.4.x.

[4FunAndProfit]

Hello @prabhu

Thanks for your reply!

I think this was not pushed into tag 6.4.0 :

see :

On version 6.4.0 it installs by default v6 and not v6.4.x

[prabhu]

Good find! Apologies, I wasn't aware. Could you use the master branch for now? Will try to release 6.4.1 this week.

[4FunAndProfit]

Thanks @prabhu ! i will wait for 6.4.1 then :)

thanks a lot!

[prabhu]

v6.4.1 has been released.