Skip to content

Need to update to unicode strings for SQLite db #1

@303sec

Description

@303sec
('moving template file:', /tmp/1590440904.md.tmp', 'to', '')
('[+] Creating new tag:', 'my_bugs')
Traceback (most recent call last):
  File "/data/home/.local/bin/noted", line 11, in <module>
    load_entry_point('yourpackage', 'console_scripts', 'noted')()
  File "/data/home/.local/lib/python2.7/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "/data/home/.local/lib/python2.7/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
  File "/data/home/.local/lib/python2.7/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/data/home/.local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/data/home/.local/lib/python2.7/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/data/personal_toolkit/noted/noted.py", line 157, in add_item
    db.add_item(item_to_add)
  File "/data/personal_toolkit/noted/tagmodule/tagdb.py", line 89, in add_item
    cursor.execute('INSERT INTO info (title, details, category, refs, file, time_created) VALUES (?, ?, ?, ?, ?, ?)',(item_dict['title'].strip(), item_dict['details'].strip(), item_dict['category'].strip().lower(),','.join(item_dict['refs']), item_dict['savefile'], ts))
sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions