Comments (7)
It's working fine for me on Linux Mint and Python 3.10.
Set up a virtual environment per the installation instructions and install the requirements in requirements.txt.
If you're still having a problem show me the output of pip freeze
.
from flicket.
HI , i just upgrade wtforms , manually to a version more actualized , and this error go away , but i found a new
problem when i try to save the config of system mail:
InterfaceError
sqlalchemy.exc.InterfaceError: (sqlite3.InterfaceError) Error binding parameter 7 - probably unsupported type.
[SQL: UPDATE flicket_config SET mail_server=?, mail_use_tls=?, mail_use_ssl=?, mail_username=?, mail_password=?, mail_default_sender=?, mail_ascii_attachments=?, posts_per_page=?, allowed_extensions=?, application_title=?, auth_domain=? WHERE flicket_config.id = ?]
[parameters: ('', 0, 0, 'xxxxxxxxxxxxx', 'xxxxxxxxxx', '', 0, (50,), ('txt, log, pdf, png, jpg, jpeg, gif, msg, doc, docx, ppt, pptx, xls, xlsx',), ('Flicket',), '', 1)]
(Background on this error at: https://sqlalche.me/e/20/rvf5)
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
The above exception was the direct cause of the following exception:
File "/home/bruno/.local/lib/python3.10/site-packages/flask/app.py", line 2213, in call
return self.wsgi_app(environ, start_response)
File "/home/bruno/.local/lib/python3.10/site-packages/flask/app.py", line 2193, in wsgi_app
response = self.handle_exception(e)
File "/home/bruno/.local/lib/python3.10/site-packages/flask/app.py", line 2190, in wsgi_app
response = self.full_dispatch_request()
File "/home/bruno/.local/lib/python3.10/site-packages/flask/app.py", line 1486, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/bruno/.local/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request
rv = self.dispatch_request()
File "/home/bruno/.local/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
File "/home/bruno/.local/lib/python3.10/site-packages/flask_login/utils.py", line 290, in decorated_view
return current_app.ensure_sync(func)(*args, **kwargs)
File "/usr/lib/python3/dist-packages/flask_principal.py", line 199, in _decorated
rv = f(*args, **kw)
File "/home/bruno/Flask/flicket-master/application/flicket_admin/views/view_config.py", line 62, in config
db.session.commit()
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/scoping.py", line 598, in commit
return self._proxied.commit()
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1969, in commit
trans.commit(_to_root=True)
File "", line 2, in commit
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1256, in commit
self._prepare_impl()
File "", line 2, in _prepare_impl
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1231, in _prepare_impl
self.session.flush()
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 4312, in flush
self._flush(objects)
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 4447, in _flush
with util.safe_reraise():
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 4408, in _flush
flush_context.execute()
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute
rec.execute(self)
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 85, in save_obj
_emit_update_statements(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 909, in _emit_update_statements
c = connection.execute(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context
return self._exec_single_context(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context
self._handle_dbapi_exception(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/home/bruno/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
from flicket.
Set up a virtual environment per the installation instructions and install the requirements in requirements.txt.
If you're still having a problem show me the output of pip freeze.
In your flicket folder:
sudo apt install python3.10-venv
python3 -m venv venv
activate the virualenv
source venv/bin/activate
install the requirements
pip install -r requirements.txt
Then run flask.
Learn about pythons virtual environments. Really simple once you've done it once or twice. It's the single most common thing that trip people up with this. Installing all kinds of python packages of various versions globally and then wondering why X application won't work.
from flicket.
ps if you then still have a problem show me a screenshot of what you're submitting.
from flicket.
My apologies here ... it seems there is indeed a bug when using the SQLite database. I'll look into this ...
from flicket.
The problem was the file application/flicket_admin/views/view_config.py
. A few of the form field lines had commas at the end turning the data into a tuple. For some reason MySQL and PostGres figured out my stupidity and handled it correctly.
Anyways, latest version fixes this. Sorry for any trouble!
from flicket.
from flicket.
Related Issues (20)
- Asking questions / reporting issues
- Errors subscribing a non-existent user. version =< 0.2.3 HOT 1
- restrict access to create and view tickets by department HOT 1
- Found a possible security concern HOT 10
- Installation time error - sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mysql.None HOT 2
- Execution error HOT 3
- Setup issue
- postgres
- paginate not working with flask-SQLAlchemy 3.0 HOT 4
- plotly version in requirements.txt causes error HOT 4
- Incompatible SQLAlchemy version HOT 2
- Creation of anonymous ticket HOT 2
- You could tell me how to do to translate it into Italian or French HOT 9
- Download results as a csv file . gives as a result KeyError KeyError: 'created_id' HOT 3
- Error when I click on Download results as csv file HOT 1
- change the path of application/flicket/static/flicket_uploads HOT 3
- Nginx configuration help HOT 2
- Setup question - manage.py HOT 4
- SAWarning: implicitly coercing SELECT object to scalar subquery HOT 3
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 flicket.