evereux / flicket Goto Github PK
View Code? Open in Web Editor NEWSimple ticket system using python flask
License: MIT License
Simple ticket system using python flask
License: MIT License
Hello,
I am facing the login error after successful run in my laptop,
I was export the user detail and use that detail as a credentials but error appearing "invalid salt".
I tried to convert tiny blob to text and try that way also but its not happening.
good morning,
You could tell me how to do to translate it into Italian or French thanks a lot
silvio
As of Flask-SQLAlchemy 3.0, all arguments to paginate are keyword-only.
File "application/flicket_admin/views/view_admin.py", line 85, in users
users = users.paginate(page, app.config['posts_per_page'])
TypeError: paginate() takes 1 positional argument but 3 were given
simply adding "page=" and "per_page=" keywords fixes this. There are several calls to paginate in different files with the same issue.
tried setting it up locally but getting errors relating to the packages? i saw that an issue already exists for jinja but markup also has an error. and time cannot import clock? python version 3.9.0 any advice would be great
Originally the ticket list was a table with headers where sorting had been implemented by adding clickable table headers.
After the UI changed, now there is one row with headers, but tickets itself are formatted in blocks instead table rows:
Personally I think it is not intuitive and may confuse lot of users.
So, probably better will be to use <select>
instead, like:
OR tabs, like:
I personally like tabs more, but we will be limited with space, so for many sorting options <select>
will be better choice.
I'm trying ti get your program up and running using Snowflake as the database and using the snowflake SQL-Alchemy connector(https://docs.snowflake.net/manuals/user-guide/sqlalchemy.html)
A couple of things I'm debugging in the program in case other people have similar issues. Snowflake does not support indexes so I edited out any lines with op.create_index in the migrations before source code control migration. I also edited the flicket_models and flicket_user files and removed index=True.
I also am not running into a new issue. It appears that SQLAlchemy only supports JSON in SQL in only a handful of databases (https://docs.sqlalchemy.org/en/13/core/type_basics.html#sqlalchemy.types.JSON) not in snowflake. So you may want to use something more standard instead of JSON in the migration code. I came across this that suggests using text? https://www.reddit.com/r/flask/comments/7vxfcp/ask_flask_error_using_json_with_sqlalchemy/ Not sure what the right solution is to modify the migration script(s) to get this bad boy up and running but any help would be appreciated!
I've also reached out to the developers of the snowflake connector as well :)
when I click on Download results as csv file gives as a result KeyError
KeyError: 'created_id'
Traceback (last most recent call)
"C: Python311 Lib site-packages flask app.py" file, line 2548, in
return self.wsgi_app(environ, start_response)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C: Python311 Lib site-packages flask app.py", line 2528, in wsgi_app
response = self-sufficiency(e)
^^^^^^^^^^^^^^^^^^^^^^^^
File "C: Python311 Lib site-packages flask app.py", line 2525, in wsgi_app
response = full shipping request ()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Thank you very much to those who can help me
Updating version in requirements.txt to 5.11 seems to work with light testing done.
Hi, i'm trying to deploy with nginx, but i get this error page: An unexpected error has occurred. I get this error page for every link.
Ubuntu 22.04
Python 3.10.12
DB SQLite
here is my nginx config:
server {
listen 80;
listen [::]:80;
server_name 127.0.0.1;
root /home/helpdesk/htdocs/helpdesk.com.br/flicket/application;
access_log /var/log/nginx/helpdesk_access.log;
error_log /var/log/nginx/helpdesk_error.log;
location ~ /.well-known {
auth_basic off;
allow all;
}
index index.html;
location /flicket/static/ {
alias /home/helpdesk/htdocs/helpdesk.com.br/flicket/application/flicket/static/;
expires max;
access_log off;
add_header Cache-Control "public";
}
location / {
include uwsgi_params;
uwsgi_read_timeout 3600;
uwsgi_pass 127.0.0.1:8000;
}
error_page 404 /404.html;
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root /path/to/your/error_pages;
}
}
Hi @evereux I have my mysql db created with xampp server.
url : localhost
port:80
when run this uri it redirects to localhost/phpmyadmin
I created a new database called flicket without any table.
Ran config_json.py and provided the below details.
[{"db_username": "root", "db_password": "", "db_url": "localhost", "db_port": "80", "db_name": "flicket", "SECRET_KEY": "l5y5MX+m3jNGIg52+9o0YbVUKGUrZ+Mo", "NOTIFICATION_USER_PASSWORD": "NMZjRGnC19H5n/IcylpP5GvveQIaj7G/"}](url)
when I run , python manage.py db init
(ticketsys) D:\Practice\flicket>python manage.py db init
Creating directory D:\Practice\flicket\migrations ... done
Creating directory D:\Practice\flicket\migrations\versions ... done
Generating D:\Practice\flicket\migrations\alembic.ini ... done
Generating D:\Practice\flicket\migrations\env.py ... done
Generating D:\Practice\flicket\migrations\README ... done
Generating D:\Practice\flicket\migrations\script.py.mako ... done
Please edit configuration/connection/logging settings in 'D:\\Practice\\flicket\\migrations\\alembic.ini' before proceeding.
when I run python manage.py db migrate
(ticketsys) D:\Practice\flicket>python manage.py db migrate
Traceback (most recent call last):
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\base.py", line 2262, in _wrap_pool_connect
return fn()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 294, in unique_connection
return _ConnectionFairy._checkout(self)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 751, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 483, in checkout
rec = pool._do_get()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\impl.py", line 237, in _do_get
return self._create_connection()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 299, in _create_connection
return _ConnectionRecord(self)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 428, in __init__
self.__connect(first_connect_check=True)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 630, in __connect
connection = pool._invoke_creator(self)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\default.py", line 453, in connect
return self.dbapi.connect(*cargs, **cparams)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\__init__.py", line 94, in Connect
return Connection(*args, **kwargs)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 327, in __init__
self.connect()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 597, in connect
self._get_server_information()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 966, in _get_server_information
packet = self._read_packet()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 656, in _read_packet
packet_header = self._read_bytes(4)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 702, in _read_bytes
CR.CR_SERVER_LOST, "Lost connection to MySQL server during query")
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 25, in <module>
manager.run()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\flask_script\__init__.py", line 417, in run
result = self.handle(argv[0], argv[1:])
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\flask_script\__init__.py", line 386, in handle
res = handle(*args, **config)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\flask_script\commands.py", line 216, in __call__
return self.run(*args, **kwargs)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\flask_migrate\__init__.py", line 95, in wrapped
f(*args, **kwargs)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\flask_migrate\__init__.py", line 215, in migrate
version_path=version_path, rev_id=rev_id)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\alembic\command.py", line 176, in revision
script_directory.run_env()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\alembic\script\base.py", line 427, in run_env
util.load_python_file(self.dir, 'env.py')
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\alembic\util\pyfiles.py", line 81, in load_python_file
module = load_module_py(module_id, path)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\alembic\util\compat.py", line 82, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 728, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "migrations\env.py", line 87, in <module>
run_migrations_online()
File "migrations\env.py", line 72, in run_migrations_online
connection = engine.connect()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\base.py", line 2193, in connect
return self._connection_cls(self, **kwargs)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\base.py", line 103, in __init__
else engine.raw_connection()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\base.py", line 2293, in raw_connection
self.pool.unique_connection, _connection
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\base.py", line 2266, in _wrap_pool_connect
e, dialect, self
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\base.py", line 1536, in _handle_dbapi_exception_noconnection
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\util\compat.py", line 383, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\util\compat.py", line 128, in reraise
raise value.with_traceback(tb)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\base.py", line 2262, in _wrap_pool_connect
return fn()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 294, in unique_connection
return _ConnectionFairy._checkout(self)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 751, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 483, in checkout
rec = pool._do_get()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\impl.py", line 237, in _do_get
return self._create_connection()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 299, in _create_connection
return _ConnectionRecord(self)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 428, in __init__
self.__connect(first_connect_check=True)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\pool\base.py", line 630, in __connect
connection = pool._invoke_creator(self)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\sqlalchemy\engine\default.py", line 453, in connect
return self.dbapi.connect(*cargs, **cparams)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\__init__.py", line 94, in Connect
return Connection(*args, **kwargs)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 327, in __init__
self.connect()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 597, in connect
self._get_server_information()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 966, in _get_server_information
packet = self._read_packet()
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 656, in _read_packet
packet_header = self._read_bytes(4)
File "C:\Users\manoj.sh\.conda\envs\ticketsys\lib\site-packages\pymysql\connections.py", line 702, in _read_bytes
CR.CR_SERVER_LOST, "Lost connection to MySQL server during query")
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query')
(Background on this error at: http://sqlalche.me/e/e3q8)
Please help me to resolve this problem, do we need to create tables manually??
Is there a setting for the ticket creation form to be public or anonymous?
Hi I ran pip install --upgrade Flask and it crashed
Hello I reinstalled with pip install -r requirements.txt
and it has resumed working but keeps going into Error when I click on Download results as csv file .
Can you give me a new file Requriments please or help me Thank you so much KeyError
KeyError: 'created_id'
Traceback (last most recent call)
File "C: Users slanfranco appdata Roaming Python Python311 site-packages flask app.py", line 2548, in
return self.wsgi_app(environ, start_response)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C: Users slanfranco appdata Roaming Python Python311 site-packages flask app.py", line 2528, in wsgi_app
response = self-sufficiency(e) raceback (most recent call last):
File "C:\Users\slanfranco\AppData\Roaming\Python\Python311\site-packages\flask\app.py", line 2548, in call
return self.wsgi_app(environ, start_response)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\slanfranco\AppData\Roaming\Python\Python311\site-packages\flask\app.py", line 2528, in wsgi_app
response = self.handle_exception(e)
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\slanfranco\AppData\Roaming\Python\Python311\site-packages\flask\app.py", line 2525, in wsgi_app
response = self.full_dispatch_request()
Where should I start looking to solve this:
jj:~/python/flicket:$ python manage.py db init
Traceback (most recent call last):
File "manage.py", line 7, in
from setup import RunSetUP
File "/home/jj/python/flicket/setup.py", line 10, in
from application import db, app
File "/home/jj/python/flicket/application/init.py", line 15, in
from application.flicket_api_v2.views import bp_api_v2
ImportError: No module named flicket_api_v2.views
I've noticed that the response times for the example application running at flicket.evereux.uk can be a bit slow. It is a cheap as chips VPS which is very slow just installing deb packages.
I'm going to move to another server this week.
Hello!
I'd like to know if there's anything in this app that can create a ticket and update it automatically, maybe with e-mails?
Thanks
Add feature to disable (not delete) a user.
https://flicket.readthedocs.io/en/latest/install.html#set-up
I'm trying to install flicket in a development environment but running step 6 crashes because there are some tables missing in the database. Step 5 is missing so I thought there's something I should do previously to running the set up?
Any help will be appreciated. Thanks in advance!
In editing a ticket, the code in edit.py is initializing with the current status in the form but the edit form has no status field - so there's an error triggered.
line 88 - edit.py: ticket.status_id = form.status.data
I think you must either comment this line or add the status field in the edit form.
When subscribing a user to a ticket an action isn't added showing users a new subscriber was added.
I do not like, that flicket session expires after 10 hours. I do a research and found, that it is because of tokens
and the process how API tokens are generated in def get_token(self, expires_in=36000)
and how staticmethod check_token(token)
is implemented.
Inside property method is_authenticated(self)
is:
if self.check_token(self.token) is None:
return False
This implementation results, that all sessions expire after 10 hours, at the same time API tokens expire.
In my opinion, it should be splitted, so API tokens have own expiration, and sessions own.
Based on how default class UserMixin
is implemented, property is_authenticated(self)
should always return True
.
At the moment I am not pulling my changes, as I have to investigate, if it is safe to always return True
and if get_token()
is correctly called everytime user is going to use API (AJAX calls). I can imagine, that it can result in situation, the page will be loaded on one day and user will start fill form with API calls on another day. The token will be already expired, so autocompletion will not work, but after page reload it will work, so for end user it will result in bad user experience.
Maybe, API can be authenticated by tokens, base auth and sessions too. So API calls from AJAX will work with session authentication, API calls from external apps will work with base auth or token auth. But in this case, the question is, if 10 hour expiration is what external app will like.
Probably someone else already did investigation and can help me speed up work.
Another possibly related issue:
Remember Me function is not implemented according documentation of Flask-Login, but instead uses direct session data assignment session['remember_me'] = form.remember_me.data
. Based on documentation remember
argument of login_user()
should be used (like login_user(user, remember=True)
).
Hey there!
I belong to an open source security research community, and a member (@ktg9) has found an issue, but doesn’t know the best way to disclose it.
If not a hassle, might you kindly add a SECURITY.md
file with an email, or another contact method? GitHub recommends this best practice to ensure security issues are responsibly disclosed, and it would serve as a simple instruction for security researchers in the future.
Thank you for your consideration, and I look forward to hearing from you!
(cc @huntr-helper)
Currently, if the folder permissions aren't correctly set the server throws an error that isn't helpful.
Provide better error message.
Add padding to flicket.css-> blockquote.
Hi evereux, hope you're well..
I've installed a fresh install and had some issue with the dependencies.
By installing with the requirements.txt, it installed flask-migrate 3.1.0, which has Flask-SQLAlchemy as a dependency (however I think it doesn't specify a version, and installed version 3.0.3) which then has SQLAlchemy as a dependency (which probably doesn't specify a version), and it ended up installing the latest version (SQLAlchemy 2.0.4). However this caused some issue with columns when running flask db update and was not able to run it at all.
I ended up downgrading Flask-SQLAlchemy to v2.5.1 and SQLAlchemy to v1.3.24 and now everything seems to run ok.
So it might be a good idea to update the requirements.txt and include these versions or the ones you are using to help newcomers?
Many thanks!
The current in work version 0.2.1 doesn't currently view nicely on mobile.
This will be improved.
When subscribing a non-existent user (i.e. user is not selected from pull down list) the ticket is no longer accessible and results in the following stack-trace:
Traceback (most recent call last):
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/app.py", line 2464, in __call__
return self.wsgi_app(environ, start_response)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/app.py", line 2450, in wsgi_app
response = self.handle_exception(e)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/app.py", line 1867, in handle_exception
reraise(exc_type, exc_value, tb)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/app.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/app.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/app.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask_login/utils.py", line 272, in decorated_view
return func(*args, **kwargs)
File "/home/evereux/python/projects/flicket/application/flicket/views/view_ticket.py", line 155, in ticket_view
return render_template('flicket_view.html',
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/templating.py", line 137, in render_template
return _render(
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/templating.py", line 120, in _render
rv = template.render(context)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/jinja2/environment.py", line 1090, in render
self.environment.handle_exception()
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/jinja2/environment.py", line 832, in handle_exception
reraise(*rewrite_traceback_stack(source=source))
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/jinja2/_compat.py", line 28, in reraise
raise value.with_traceback(tb)
File "/home/evereux/python/projects/flicket/application/flicket/templates/flicket_view.html", line 1, in top-level template code
{% extends "flicket_base.html" %}
File "/home/evereux/python/projects/flicket/application/flicket/templates/flicket_base.html", line 54, in top-level template code
{% block content %}{% endblock %}
File "/home/evereux/python/projects/flicket/application/flicket/templates/flicket_view.html", line 129, in block "content"
href="{{ url_for('flicket_bp.unsubscribe_ticket', ticket_id = ticket.id, user_id=s.user.id) }}"
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/flask/helpers.py", line 357, in url_for
rv = url_adapter.build(
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/werkzeug/routing.py", line 2177, in build
rv = self._partial_build(endpoint, values, method, append_unknown)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/werkzeug/routing.py", line 2054, in _partial_build
rv = self._partial_build(
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/werkzeug/routing.py", line 2067, in _partial_build
rv = rule.build(values, append_unknown)
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/werkzeug/routing.py", line 1038, in build
return self._build_unknown(**values)
File "<werkzeug routing>", line 1, in <builder:'/unsubscribe/<int:ticket_id>/<int:user_id>'>
File "/home/evereux/python/projects/flicket/env/lib/python3.8/site-packages/werkzeug/routing.py", line 1257, in to_url
value = self.num_convert(value)
jinja2.exceptions.UndefinedError: 'None' has no attribute 'id'
This is because the form does not validate the existence of the submitted user.
To fix the issue you'll need to delete the rows in the flicket_ticket_subscription
table that has the ticket_id of the broken ticket view and a NULL user_id.
SELECT * FROM `lowlife-flicket`.flicket_ticket_subscription WHERE user_id is NULL;
Also, delete the rows in the table flicket_ticket_action
where action = subscribed and the recipient_id is NULL.
SELECT * FROM `lowlife-flicket`.flicket_ticket_action WHERE action = 'subscribe' and recipient_id is NULL;
This will be fixed for 0.2.4 (released later today).
Hello,
I've had the folowing issue while running "manage.py db init"
python manage.py db init
...
from application.flicket.scripts.decorators import async
SyntaxError: invalid syntax
By changing the name of the 'async' function' in the decorators.py script and in the email.py, no more issue: The function is now "def send_async_email(f)" in decorators.py and @send_async_email in email.py.
I'm under Windows - python37 and using sqlite database.
It's working like a charm now and I've learned a lot in reading your code. thx.
The error is: "werkzeug.routing.BuildError: Could not build url for endpoint 'departments'"
when trying to run the upgrade command i get the following
qlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: boolean + boolean
I am getting below error. Trying to install on Ubuntu 18.04 LTS.
root@frr:/home/snag/flicket# python manage.py db upgrade
Traceback (most recent call last):
File "manage.py", line 7, in
from setup import RunSetUP
File "/home/snag/flicket/setup.py", line 10, in
from application import db, app
File "/home/snag/flicket/application/init.py", line 40, in
app.config.from_object('config.BaseConfiguration')
File "/usr/local/lib/python3.6/dist-packages/flask/config.py", line 174, in from_object
obj = import_string(obj)
File "/usr/local/lib/python3.6/dist-packages/werkzeug/utils.py", line 871, in import_string
import(import_name)
File "/home/snag/flicket/config.py", line 16, in
class BaseConfiguration(object):
File "/home/snag/flicket/config.py", line 93, in BaseConfiguration
check_db_connection(SQLALCHEMY_DATABASE_URI)
File "/home/snag/flicket/scripts/create_json.py", line 131, in check_db_connection
engine = create_engine(sqlalchemy_database_uri)
File "", line 2, in create_engine
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/deprecations.py", line 309, in warned
return fn(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/create.py", line 534, in create_engine
entrypoint = u._get_entrypoint()
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/url.py", line 645, in _get_entrypoint
cls = registry.load(name)
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 344, in load
"Can't load plugin: %s:%s" % (self.group, name)
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mysql.None
hello i would like to change the path of application/flicket/static/flicket_uploads
I would like to put it in a network path for example
w11test sharing kit how can I do ?
thank you very much
Before reporting an issue please:
When reporting an issue please provide the following information:
Hi
Master branch
From documentation - step 5
5. Upgrade the database using manage.py from the command line::
flask db upgrade
Where can I find manage.py ?
Thanks
I don't know really where to post this, but first off....
I love this project.
I work at a community college and because we're in a unique position we're only now starting to get our own infrastructure. This may definitely provide that! It looks very promising.
My one big concern is that there really is no 'built-in' solution for making this production ready at the level I need it.... however I do have a suggestion.
I have launched several Flask web apps and we use the Cherrypy projects production webserver Cheroot. It's a simple import and the configuration looks very similar to Flask's dev server.
Would anyone be interested in or has any reservations of me providing a 'fix' for this?
Allow the user to enter username or email address for logging in.
I've witnessed several times users trying to login with email address and not username.
is it possible to add time registration, like worked time?
I tried this in one of my created tickets, when replying and closing with a file attached (this case a 200bytes ish .txt file), the server will respond with the page error.
Actually, uploading a file in either way will cause the error.
Hi, is there any installation that allows the user only to view only tickets generated to his own department? and also to create tickets only to his departments? (maybe some users can have many deparments)
This is to handle several departments, but not allowing to everyone to see every ticket.
I have been testing flicket for some days, it´s works great and it is really simple.
Thanks!
Following the installation steps, when I run python manage.py db migrate
I receive the following error:
python manage.py db migrate
Traceback (most recent call last):
File "manage.py", line 27, in <module>
manager.run()
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/flask_script/__init__.py", line 417, in run
result = self.handle(argv[0], argv[1:])
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/flask_script/__init__.py", line 386, in handle
res = handle(*args, **config)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/flask_script/commands.py", line 216, in __call__
return self.run(*args, **kwargs)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/flask_migrate/__init__.py", line 95, in wrapped
f(*args, **kwargs)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/flask_migrate/__init__.py", line 215, in migrate
version_path=version_path, rev_id=rev_id)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/alembic/command.py", line 176, in revision
script_directory.run_env()
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/alembic/script/base.py", line 427, in run_env
util.load_python_file(self.dir, 'env.py')
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file
module = load_module_py(module_id, path)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/alembic/util/compat.py", line 82, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 728, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "migrations/env.py", line 87, in <module>
run_migrations_online()
File "migrations/env.py", line 70, in run_migrations_online
poolclass=pool.NullPool)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/__init__.py", line 498, in engine_from_config
return create_engine(url, **options)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/__init__.py", line 455, in create_engine
return strategy.create(*args, **kwargs)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 54, in create
u = url.make_url(name_or_url)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/url.py", line 229, in make_url
return _parse_rfc1738_args(name_or_url)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/url.py", line 288, in _parse_rfc1738_args
return URL(name, **components)
File "/home/tcouto/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/url.py", line 71, in __init__
self.port = int(port)
ValueError: invalid literal for int() with base 10: ''
What am I missing?
I am not able to run the upgrade database (or another command) due to the error ImportError: cannot import name 'escape' from 'jinja2'
.
I am using Python 3.9
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([WinError 10061] No connection could be made because the ta
rget machine actively refused it)")
i am facing this error and i dont know what to do, I am using Pycharm as IDE and i install all required files and doing as documentation said!
Help me!
Hi @evereux I have cloned the file and created a new env, ran pip install -r requirements.txt
. I faced two errors.
Collecting mimesis==2.1.0 (from -r requirements.txt (line 26))
Using cached https://files.pythonhosted.org/packages/ce/e8/f7a590bfa26d654d139e124dafb178fbd1133e86cc6773f1d5c031250689/mimesis-2.1.0.tar.gz
Complete output from command python setup.py egg_info:
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "c:\users\manoj.sh\appdata\local\temp\pip-install-iamijm\mimesis\setup.py", line 105, in <module>
with open('README.rst', 'r', encoding='utf-8') as f:
TypeError: 'encoding' is an invalid keyword argument for this function
I also tried replacing mimesis==2.1.0 to mimesis latest version.
this time.
Collecting mimesis (from -r requirements.txt (line 26))
Using cached https://files.pythonhosted.org/packages/fe/4f/2c636410653f79ceb41ee56e937adb1ff8c41d0cf649fc1df8796c1442d5/mimesis-3.1.0.tar.gz
Complete output from command python setup.py egg_info:
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "c:\users\manoj.sh\appdata\local\temp\pip-install-antvle\mimesis\setup.py", line 10, in <module>
from mimesis import (
File "mimesis\__init__.py", line 10, in <module>
from mimesis.providers import *
File "mimesis\providers\__init__.py", line 5, in <module>
from mimesis.providers.base import BaseProvider, BaseDataProvider
File "mimesis\providers\base.py", line 23
def __init__(self, seed: Seed = None) -> None:
^
SyntaxError: invalid syntax
due to these errors I completely removed mimesis from my requirements.txt and ran.
after installing requirements, I tried.
python setup.py install,
then
ract[chat_embed] final\flicket>python setup.py install
Traceback (most recent call last):
File "setup.py", line 10, in <module>
from application import db, app
File "D:\MANO\LEARNING\AI_PYTHON\CHATTERBOT\flask app eg[IMP]\flask-chatterbot -human_interact[chat_embed] final\flicket\application\__init__.py", line 16, in <module>
from application.flicket_api_v2.views import bp_api_v2
ImportError: No module named flicket_api_v2.views
Do you have any updated documentation for flicket to use. I see this flicket will help many people but people need a documentation to understand how it works. Thanks.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.