mrf345 / fqm Goto Github PK
View Code? Open in Web Editor NEWA web based queue management system built with Python Flask, Bootstrap and jQuery.
Home Page: https://fqms.github.io
License: Mozilla Public License 2.0
A web based queue management system built with Python Flask, Bootstrap and jQuery.
Home Page: https://fqms.github.io
License: Mozilla Public License 2.0
Hi,
after the "Major refactoring for init" commit some error comes up:
ERROR: flake8 3.7.9 has requirement pycodestyle<2.6.0,>=2.5.0, but you'll have pycodestyle 2.3.1 which is incompatible. ERROR: flake8 3.7.9 has requirement pyflakes<2.2.0,>=2.1.0, but you'll have pyflakes 1.5.0 which is incompatible.
P.S: I really appreciate your job!
[2020-06-04 11:58:12] "GET /repeat_announcement/True HTTP/1.1" 302 691 0.121707
My POS thermal printer is add successfully tested. Im using Black copper bc85 series printer but when i click on a task in touch screen it generate this error
Traceback (most recent call last):
****File "E:\SSQM\SSQM\app\views\core.py", line 122, in serial
ip=current_app.config.get('LOCALADDR'))
TypeError: print_ticket_windows() missing 1 required positional argument: 'l'
and secreen return to home page
please hep me out
"Error: you must have available printer, to use printed"
FQM give this error when trying to print the ticket. tried different Epson and Posiflex printers but nothing worked. can anyone help me? test print comes without any issues and the printer is shared with the same name.
Hey.
Your Project ist quite great!
Is there any possibility to get a german language inclueded?
Or is there the possibility to only play the notification sound without the text-to-speech?
When i disable the text-to-speech there is also nno notification sound.
Is there any help for me?
When changing touch screen title color in customizing menu the touch screen not working.
ERROR [app.main] Exception on /video [POST]
Traceback (most recent call last):
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request
return self.view_functionsrule.endpoint
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/Users/Ernesto/FQM/app/helpers.py", line 136, in decorated
return function(*args, **kwargs)
File "/Users/Ernesto/FQM/app/views/customize.py", line 117, in video
media_record = data.Media.get(form.video.data)
AttributeError: type object 'Media' has no attribute 'get'
werkzeug.exceptions.InternalServerError: 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
Please add announcement in Urdu language.
ERROR [flask.app] Exception on /video [POST]
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.7/dist-packages/flask/_compat.py", line 35, in reraise
raise value
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/local/lib/python3.7/dist-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/root/FQM/app/helpers.py", line 136, in decorated
return function(*args, **kwargs)
File "/root/FQM/app/views/customize.py", line 117, in video
media_record = data.Media.get(form.video.data)
AttributeError: type object 'Media' has no attribute 'get'
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.7/dist-packages/flask/_compat.py", line 35, in reraise
raise value
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/local/lib/python3.7/dist-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/root/FQM/app/helpers.py", line 136, in decorated
return function(*args, **kwargs)
File "/root/FQM/app/views/customize.py", line 117, in video
media_record = data.Media.get(form.video.data)
AttributeError: type object 'Media' has no attribute 'get'
Dear developer,
Recently No sound problem has been arise again. I am using your latest version of FQM 0.4.3 It was ok few days ago. What could be the problem. Please give me a clue.
branching of #13 , reported issue with resetting offices:
Hello,am interested to know if there is a version of this repository for version 3 of python
Hi , I try to setup on Mint 19 xfce 32 Bit unsuccessfull .
Wich are the OS requirements ?
Hello Mohamed
I would like to ask one question about logic:
I've notice that when a new ticket is created, it is"preassigned" to an office.
This become a problem when there are more office that do the same task, and maybe one office work ""faster"".
I've see that in the last commit you've done i'm able to pull a ticket preassigned to another office, but, in the display screen will continue to call that ticket i've pulled in the office was preassigned to that.
Could be possible to "disable" the preassignment of the office when a task is common to more or to all offices? (es: Ticket A102,B102,c102)
or, in case this is not possible, could be possible, when the ticket is pulled from an operator, to make the display call and show the office that in fact called the ticket and not the office was preassigned to that?
Thank you so much for reading this and for the answer,
Below there is a GoogleDrive link where you can download a .ZIP with my full FQM Folder (that i've builded myself)
https://drive.google.com/file/d/1aVCZKIvC8NNg6HNHV9cg--CZ7IMRxqri/view?usp=sharing
Best Regards
Matteo
This happens when FQM is running and the PC hosting FQM suddenly shutdown. You will no longer be able to run the exe file and will come up with a script error. I have to re-extract the entire zip file. Replacing the exe file alone won't salvage the app. I have no idea as to what script is causing the error.
After recent administrate.user_u
refactoring, updating operator's office is not persisting:
https://github.com/mrf345/FQM/blob/master/app/views/administrate.py#L217-L221
the executable file is being blocked by Symantec Endpoint Protected for suspecting as a virus.
how can i change the font size on printed ticket?
After do some modifications, how you create a new .exe?
How to customize the code for windows user I want to display the 5 office in one screen or on screen display but the con, cot, cott stream code I can't find where is it declared, if I'm not wrong this is with the exe file in python code? Can you help me about this issue?
ERROR [sqlalchemy.pool.impl.NullPool] Exception during reset or similar
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 671, in _finalize_fairy
fairy._reset(pool)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 858, in _reset
pool._dialect.do_rollback(self)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 502, in do_rollback
dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473601966560 and this is thread id 281473656197136.
ERROR [sqlalchemy.pool.impl.NullPool] Exception closing connection <sqlite3.Connection object at 0xffffae106c70>
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 671, in _finalize_fairy
fairy._reset(pool)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 858, in _reset
pool._dialect.do_rollback(self)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 502, in do_rollback
dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473601966560 and this is thread id 281473656197136.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 261, in _close_connection
self._dialect.do_close(connection)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 508, in do_close
dbapi_connection.close()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473601966560 and this is thread id 281473656197136.
Hi,
We're trying to use a regular USB printer for testing purpose before purchasing a POS printer, but that doesn't seems to work. Is there any way we can test the printing functionality using a regular printer, like a universal POS driver?
Thanks
Exception raised:
Traceback (most recent call last):
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask/app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask/app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask/app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask/_compat.py", line 35, in reraise
raise value
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/home/mrf3/Projects/FQM/app/helpers.py", line 135, in decorated
return function(*args, **kwargs)
File "/home/mrf3/Projects/FQM/app/views/customize.py", line 665, in alias
strue=data.Slides_c.query.first().status
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/jinja2/asyncsupport.py", line 76, in render
return original_render(self, *args, **kwargs)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/jinja2/_compat.py", line 37, in reraise
raise value.with_traceback(tb)
File "/home/mrf3/Projects/FQM/templates/alias.html", line 8, in top-level template code
{%- from "sb_cust.html" import sb_cust with context %}
File "/home/mrf3/Projects/FQM/templates/base.html", line 278, in top-level template code
{% set tra = message and translate(message, 'en', [defLang]) %}
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask_googletrans/__init__.py", line 150, in translate
src
AttributeError: 'str' object has no attribute 'text'
Traceback (most recent call last):
File "/root/FQM/app/views/core.py", line 132, in serial
printer = assign(int(ticket_settings.vendor), int(ticket_settings.product),
ValueError: invalid literal for int() with base 10: ' '
Greeting Mohamed, I hope everything is well with you. We're having an issue with the Queue Management System, where for some tasks when the operator tries to pull the next ticket he/she gets the message that says " Error: no tickets left to pull from" We had a similar issue in the past, and you've guided me through certain steps to fix the issue, which involved using SQLlight plugin to change some values in the database. Unfortunately, I forgot those steps. Can you please help with this? Any way to prevent this error from happening in the first place?
Thanks
In many small businesses, the implementation of queue management has been tried to simplify as much as possible.
Its basic components are:
A number dispenser with a pre-printed roll of numbered tickets, which the customer picks up the moment they arrive at the store. Detaill
Push buttons / button to update the number to attend, on the shift screen.
FQM, with some changes to its workflow, could also meet the needs of these small businesses.
How can I help implement this idea?
Regardless of the decision to accept this issue or not, a good job is being done with this project :-)
[Spanish / Español]
En muchos negocios pequeños, la implantación de una gestión de colas se ha intentado simplificar al máximo.
Sus componentes básicos son:
Un dispensador de números con un rollo preimpreso de tiques numerados, que el cliente retira en el momento que accede al local. Detalle
Pulsadores para actualizar el número a atender, en la pantalla de turnos.
FQM, con algunos cambios en su flujo de trabajo, también podría cubrir las necesidades de estos pequeños comercios.
¿Cómo puedo ayudar a implementar esta idea?
Independientemente de la decisión de aceptar o no este issue, se está haciendo un buen trabajo con este proyecto :-)
When you click on Multimedia page to upload content like logo and videos, as soon as you click the link it sign you out and says "[Error: something wrong, or the page is non-existing.]"
>>> add operator_id(integer) to table offices table on data.sqlite
>>> edit data.py on Office class
class Office(db.Model):
__tablename__ = "offices"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Integer, unique=True)
timestamp = db.Column(db.DateTime(), index=True, default=datetime.utcnow)
prefix = db.Column(db.String(2))
operator_id = db.Column(db.Integer)
def __init__(self, name, prefix, operator_id):
self.name = name
self.prefix = prefix
self.operator_id = operator_id
>>> edit /template/user_update.html
>>> add this lines after line "59"
<br>
{{ render_field(form.offices, class="form-control") }}<br>
<br><br>
I am getting the below error while running command "python3 run.py"
qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found.
This application failed to start because no Qt platform plugin could be initialized. Reinstalling the application may fix this problem.
Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vnc, wayland-egl, wayland, wayland-xcomposite-egl, wayland-xcomposite-glx, webgl, xcb.
Aborted (core dumped)
Please help me to fix this.
Hi,
I'd like to know if is it possible to start the application
when i generate ticket from printer by clicking task on touch screen my display screen is not update and console generate this error again and again
Traceback (most recent call last):
File "C:\Users\Basit\AppData\Local\Programs\Python\Python36\lib\site-packages\flask\app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "C:\Users\Basit\AppData\Local\Programs\Python\Python36\lib\site-packages\flask\app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Users\Basit\AppData\Local\Programs\Python\Python36\lib\site-packages\flask\app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\Basit\AppData\Local\Programs\Python\Python36\lib\site-packages\flask_compat.py", line 35, in reraise
raise value
File "C:\Users\Basit\AppData\Local\Programs\Python\Python36\lib\site-packages\flask\app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Users\Basit\AppData\Local\Programs\Python\Python36\lib\site-packages\flask\app.py", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "C:\Users\Basit\Downloads\FQM-master\app\views\core.py", line 340, in feed
) if current_ticket else empty_text
AttributeError: 'Serial' object has no attribute 'ticket'
Hi, thanks for your project!
I've installed FQM on Raspberry PI 3+, running in cli mode with:
python3 run.py --cli --ip 192.168.7.100 --port 3790 --quiet
It works well but I have two problems:
While a display screen is opened, the whole system is too slow; python use the 90-100% of CPU! It's normal? There are some min requirements?
I've installed a POS printer, and the test page from CUPS is ok. But in FQM, after a button service is pressed, the page loops forever, even if the python process uses 2-3% of CPU. Where is the problem?
Thanks!
Roberto
First I have to say Great Project.
What would be the procedure to modify the existing templates or is this very difficult. I have very limited python knowlage but I don't think that would be a problem. I have 0.6 running on Windows with the .zip download, works great. I can switch to linux if a recomplie is necessary.
Richard
hi sir how do i fix the errors in index.html for python 3.5:
{{ cssify('static/css/main.less') }}
{{ cssify('static/css/spacing.less')}}
thanks :)
"from lanuages"
--> change to "languages"
in files ->
[core.py, printer.py, ex_functions.py]
Traceback (most recent call last):
File "/Users/Ernesto/FQM/app/printer.py", line 131, in listp
for ll in usb.core.find(find_all=True, custom_match=find_class(7)):
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/usb/core.py", line 1263, in find
raise NoBackendError('No backend available')
usb.core.NoBackendError: No backend available
ERROR [sqlalchemy.pool.impl.NullPool] Exception during reset or similar
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 671, in _finalize_fairy
fairy._reset(pool)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 858, in _reset
pool._dialect.do_rollback(self)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 502, in do_rollback
dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473743909344 and this is thread id 281473798139920.
ERROR [sqlalchemy.pool.impl.NullPool] Exception closing connection <sqlite3.Connection object at 0xffffb4912030>
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 671, in _finalize_fairy
fairy._reset(pool)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 858, in _reset
pool._dialect.do_rollback(self)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 502, in do_rollback
dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473743909344 and this is thread id 281473798139920.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 261, in _close_connection
self._dialect.do_close(connection)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 508, in do_close
dbapi_connection.close()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473743909344 and this is thread id 281473798139920.
I have uploaded a dingdong.wav and select it as a notification sound but its not working. I am not getting any sound on display when i pull a ticket. Please help me out with this problem. Thanks
Raised Exception:
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: strict_pulling
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "run.py", line 8, in <module>
run_app()
File "/home/mrf3/Projects/FQM/app/__init__.py", line 47, in run_app
interface()
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/click/core.py", line 700, in __call__
return self.main(*args, **kwargs)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/click/core.py", line 680, in main
rv = self.invoke(ctx)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/click/core.py", line 873, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/click/core.py", line 508, in invoke
return callback(*args, **kwargs)
File "/home/mrf3/Projects/FQM/app/__init__.py", line 29, in interface
app = bundle_app()
File "/home/mrf3/Projects/FQM/app/main.py", line 102, in bundle_app
create_db(app, testing=app.config.get('TESTING'))
File "/home/mrf3/Projects/FQM/app/main.py", line 95, in create_db
not testing and database_upgrade(directory=MIGRATION_FOLDER)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask_migrate/__init__.py", line 95, in wrapped
f(*args, **kwargs)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/flask_migrate/__init__.py", line 280, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/command.py", line 254, in upgrade
script.run_env()
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/script/base.py", line 425, in run_env
util.load_python_file(self.dir, 'env.py')
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
module = load_module_py(module_id, path)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/util/compat.py", line 64, in load_module_py
module_id, path).load_module(module_id)
File "<frozen importlib._bootstrap_external>", line 407, in _check_name_wrapper
File "<frozen importlib._bootstrap_external>", line 907, in load_module
File "<frozen importlib._bootstrap_external>", line 732, in load_module
File "<frozen importlib._bootstrap>", line 265, in _load_module_shim
File "<frozen importlib._bootstrap>", line 696, in _load
File "<frozen importlib._bootstrap>", line 677, in _load_unlocked
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 96, in <module>
run_migrations_online()
File "migrations/env.py", line 90, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/runtime/environment.py", line 836, in run_migrations
self.get_context().run_migrations(**kw)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/runtime/migration.py", line 330, in run_migrations
step.migration_fn(**kw)
File "/home/mrf3/Projects/FQM/migrations/versions/f4efa0d99d19_.py", line 21, in upgrade
op.add_column('settings', sa.Column('strict_pulling', sa.Boolean(), nullable=True))
File "<string>", line 8, in add_column
File "<string>", line 3, in add_column
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/operations/ops.py", line 1551, in add_column
return operations.invoke(op)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/operations/base.py", line 318, in invoke
return fn(self, operation)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/operations/toimpl.py", line 123, in add_column
schema=schema
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/ddl/impl.py", line 172, in add_column
self._exec(base.AddColumn(table_name, column, schema=schema))
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/alembic/ddl/impl.py", line 118, in _exec
return conn.execute(construct, *multiparams, **params)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
return meth(self, multiparams, params)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1050, in _execute_ddl
compiled,
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
e, statement, parameters, cursor, context
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 128, in reraise
raise value.with_traceback(tb)
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "/home/mrf3/Projects/FQM/installiation/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: strict_pulling
[SQL: ALTER TABLE settings ADD COLUMN strict_pulling BOOLEAN]
(Background on this error at: http://sqlalche.me/e/e3q8)
Pulling this one out of #104
[2020-06-04 10:43:53,834] ERROR in app: Exception on /video [POST]
Traceback (most recent call last):
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/_compat.py", line 35, in reraise
raise value
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/Users/Ernesto/FQM/app/helpers.py", line 136, in decorated
return function(*args, **kwargs)
File "/Users/Ernesto/FQM/app/views/customize.py", line 117, in video
media_record = data.Media.get(form.video.data)
AttributeError: type object 'Media' has no attribute 'get'
Traceback (most recent call last):
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/_compat.py", line 35, in reraise
raise value
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/Users/Ernesto/FQM/app/helpers.py", line 136, in decorated
return function(*args, **kwargs)
File "/Users/Ernesto/FQM/app/views/customize.py", line 117, in video
media_record = data.Media.get(form.video.data)
AttributeError: type object 'Media' has no attribute 'get'
I can not enable Audio Notification.
Hi,
We have a serious problem, where it shows that there are pending tickets in a specific office, but when the operator pulls a ticket he or she gets the message "no tickets left to pull from"!! any solution!? This is kinda of an urgent matter, thanks
Good day,
Please assist as when i pull a ticket on the FQM system it displays the next name but it does not announce it.... there is no audio.
Please help...
ERROR [sqlalchemy.pool.impl.NullPool] Exception during reset or similar
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 671, in _finalize_fairy
fairy._reset(pool)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 858, in _reset
pool._dialect.do_rollback(self)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 502, in do_rollback
dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473743909344 and this is thread id 281473798139920.
ERROR [sqlalchemy.pool.impl.NullPool] Exception closing connection <sqlite3.Connection object at 0xffffb48a7ab0>
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 671, in _finalize_fairy
fairy._reset(pool)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 858, in _reset
pool._dialect.do_rollback(self)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 502, in do_rollback
dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473743909344 and this is thread id 281473798139920.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/pool/base.py", line 261, in _close_connection
self._dialect.do_close(connection)
File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 508, in do_close
dbapi_connection.close()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 281473743909344 and this is thread id 281473798139920.
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.