Comments (6)
coleifer
commented on June 11, 2024
Please run in debug mode (-d) and share the traceback.
from sqlite-web.
VIRUXE
commented on June 11, 2024
OperationalError
sqlite3.OperationalError: Could not decode to UTF-8 column 'message' with text 'vou come�ar a levar as coisas pra la entao'
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 2213, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 2193, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 2190, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1486, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1484, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1469, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
File "/usr/local/lib/python3.9/site-packages/sqlite_web/sqlite_web.py", line 221, in inner
return fn(table, *args, **kwargs)
File "/usr/local/lib/python3.9/site-packages/sqlite_web/sqlite_web.py", line 476, in table_content
return render_template(
File "/usr/local/lib/python3.9/site-packages/flask/templating.py", line 151, in render_template
return _render(app, template, context)
File "/usr/local/lib/python3.9/site-packages/flask/templating.py", line 132, in _render
rv = template.render(context)
File "/usr/local/lib/python3.9/site-packages/jinja2/environment.py", line 1301, in render
self.environment.handle_exception()
File "/usr/local/lib/python3.9/site-packages/jinja2/environment.py", line 936, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/usr/local/lib/python3.9/site-packages/sqlite_web/templates/table_content.html", line 1, in top-level template code
{% extends "base_table.html" %}
File "/usr/local/lib/python3.9/site-packages/sqlite_web/templates/base_table.html", line 1, in top-level template code
{% extends "base_tables.html" %}
File "/usr/local/lib/python3.9/site-packages/sqlite_web/templates/base_tables.html", line 1, in top-level template code
{% extends "base.html" %}
File "/usr/local/lib/python3.9/site-packages/sqlite_web/templates/base.html", line 62, in top-level template code
{% block content %}{% endblock %}
File "/usr/local/lib/python3.9/site-packages/sqlite_web/templates/base_table.html", line 37, in block 'content'
{% block inner_content %}
File "/usr/local/lib/python3.9/site-packages/sqlite_web/templates/table_content.html", line 40, in block 'inner_content'
{% for row in query %}
File "/usr/local/lib/python3.9/site-packages/peewee.py", line 4583, in next
self.cursor_wrapper.iterate()
File "/usr/local/lib/python3.9/site-packages/peewee.py", line 4494, in iterate
row = self.cursor.fetchone()
from sqlite-web.
coleifer
commented on June 11, 2024
Did you use latin1 or some other encoding? That error would seem to indicate that your accented characters are not encoded using utf8.
If that's the case, we don't really bother supporting non-utf8, and I suggest updating your database to use utf8 instead.
from sqlite-web.
coleifer
commented on June 11, 2024
As you can see, we handle utf8-encoded unicode just fine. Here there are accented characters in the table name, the column name, and in a row of data:
from sqlite-web.
VIRUXE
commented on June 11, 2024
Data is being inserted directly from a SA-MP gameserver, which I think natively uses windows1252.
stock SendPrivateMessage(conversationId, playerId, message[]) {
new playerName[MAX_PLAYER_NAME], otherPlayerName[MAX_PLAYER_NAME];
GetPlayerName(playerId, playerName, MAX_PLAYER_NAME);
stmt_bind_value(stmt_InsertMessage, 0, DB::TYPE_INTEGER, conversationId);
stmt_bind_value(stmt_InsertMessage, 1, DB::TYPE_STRING, playerName);
stmt_bind_value(stmt_InsertMessage, 2, DB::TYPE_STRING, message);
stmt_execute(stmt_InsertMessage);stmt_InsertMessage = db_prepare(Database, "INSERT INTO conversation_messages (conversation_id, sender, message) VALUES (?, ?, ?);");
Goes directly from the game chat or dialog onto that statement.
from sqlite-web.
coleifer
commented on June 11, 2024
Yeah we're limited to utf8 at the present, unfortunately.
from sqlite-web.
Related Issues (20)
- Headless operation does not work HOT 4
- sqlite-web errors when trying to drop a column HOT 2
- Support multiple DB's HOT 4
- How to specify SQLITE_WEB_PASSWORD in k8s deploy? HOT 1
- admin password is not encrypted and it's not secure HOT 3
- peewee.OperationalError: unknown tokenizer: mozporter when opening Thunderbirds global-messages.sqlite HOT 1
- Docker Image for arm 64 HOT 1
- The switch from POST to GET for queries creates problems for queries with new lines inside the Home Assistant Addon HOT 15
- Forgotten DockerHub image HOT 3
- Bookmark drop down in query not visible on IOS devices HOT 2
- Log file is not created and logging is printed to console HOT 1
- Are other DB's planned? HOT 1
- Enabling foreign key constraints HOT 2
- Pagination styles HOT 1
- coleifer/sqlite-web on DockerHub seems not to be up to date HOT 3
- Serve sqlite-web in a flask end point HOT 1
- Large results are slow HOT 2
- Values are truncated HOT 1
- Disable hotkeys HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlite-web.