Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Error binding parameter 22: type 'list' is not supported" when adding website using sqlite engine #1042

Open
AndhikaWB opened this issue Oct 12, 2024 · 1 comment

Comments

@AndhikaWB
Copy link

AndhikaWB commented Oct 12, 2024

  • Python 3.12
  • Windows 11 x64

My requirements.txt:

streamlit==1.39.0
llmware==0.3.7
# Progress bar
ipywidgets==8.1.5
# Web scraping
beautifulsoup4==4.12.3
lxml==5.3.0

My sample code:

from llmware.configs import LLMWareConfig
from llmware.models import ModelCatalog
from llmware.library import Library

# Set engine to save library data
LLMWareConfig().set_active_db('sqlite')

lib = Library().create_new_library(
    account_name = 'dhika',
    library_name = 'test_lib'
)

urls = [
    'https://en.tempo.co/read/1915490/prabowo-indifferent-to-gibrans-alleged-fufufafa-account-says-dasco',
    # More URLs after that
]

print(len(urls))

for url in urls:
    lib.add_website(
        url = url,
        # Don't search site recursively
        get_links = False
    )

Error result:

image

image

@AndhikaWB
Copy link
Author

AndhikaWB commented Oct 12, 2024

After a bit debugging, the error is caused by user_tags which is a list, but not supported by sqlite

user_tags = []

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant