Comments (2)
I cannot replicate.
Here is the table you provided
Dropping the test1
column
This is working fine and the column is dropped successfully:
from sqlite-web.
Weird, now I can't reproduce it either. I can get an "internal server error" page if I try to drop the only row in a table tho.
[2023-09-06 05:07:02,478] ERROR in app: Exception on /test/drop-column/ [POST]
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/peewee.py", line 3197, in execute_sql
cursor.execute(sql, params or ())
sqlite3.OperationalError: near ")": syntax error
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/flask/app.py", line 2525, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.10/dist-packages/flask/app.py", line 1822, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.10/dist-packages/flask/app.py", line 1820, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.10/dist-packages/flask/app.py", line 1796, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
File "/usr/local/lib/python3.10/dist-packages/sqlite_web/sqlite_web.py", line 248, in inner
return fn(table, *args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/sqlite_web/sqlite_web.py", line 347, in drop_column
migrate(migrator.drop_column(table, name))
File "/usr/local/lib/python3.10/dist-packages/playhouse/migrate.py", line 886, in migrate
operation.run()
File "/usr/local/lib/python3.10/dist-packages/playhouse/migrate.py", line 164, in run
self._handle_result(method(*self.args, **kwargs))
File "/usr/local/lib/python3.10/dist-packages/playhouse/migrate.py", line 155, in _handle_result
result.run()
File "/usr/local/lib/python3.10/dist-packages/playhouse/migrate.py", line 164, in run
self._handle_result(method(*self.args, **kwargs))
File "/usr/local/lib/python3.10/dist-packages/playhouse/migrate.py", line 158, in _handle_result
self._handle_result(item)
File "/usr/local/lib/python3.10/dist-packages/playhouse/migrate.py", line 153, in _handle_result
self.execute(result)
File "/usr/local/lib/python3.10/dist-packages/playhouse/migrate.py", line 149, in execute
self.migrator.database.execute(node)
File "/usr/local/lib/python3.10/dist-packages/peewee.py", line 3210, in execute
return self.execute_sql(sql, params, commit=commit)
File "/usr/local/lib/python3.10/dist-packages/peewee.py", line 3194, in execute_sql
with __exception_wrapper__:
File "/usr/local/lib/python3.10/dist-packages/peewee.py", line 2970, in __exit__
reraise(new_type, new_type(exc_value, *exc_args), traceback)
File "/usr/local/lib/python3.10/dist-packages/peewee.py", line 191, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.10/dist-packages/peewee.py", line 3197, in execute_sql
cursor.execute(sql, params or ())
peewee.OperationalError: near ")": syntax error
from sqlite-web.
Related Issues (20)
- Headless operation does not work HOT 4
- Encoding HOT 6
- 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.