mrf345 / fqm Goto Github PK

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.]"

Please add announcement in Urdu language.

how can i change the font size on printed ticket?

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.

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 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 :)

"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.

After do some modifications, how you create a new .exe?

Hi,
I'd like to know if is it possible to start the application

• from CLI passing parameters (eg IP, language, port)?
• without having Xorg installed ? (Linux only)

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

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'

2020-02-27 19:55:08.655894 #####****

and secreen return to home page

please hep me out

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.

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.

I can not enable Audio Notification.

Currently harmless, but can result in instability in other platforms:

Hello,am interested to know if there is a version of this repository for version 3 of python

[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'

In many small businesses, the implementation of queue management has been tried to simplify as much as possible.

Its basic components are:

1. A number dispenser with a pre-printed roll of numbered tickets, which the customer picks up the moment they arrive at the store. Detaill

2. A basic shift screen. 1, 2, 3

3. 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:

1. Un dispensador de números con un rollo preimpreso de tiques numerados, que el cliente retira en el momento que accede al local. Detalle

2. Una pantalla de turno básica. 1, 2, 3

3. 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 :-)

• TTS announcement caching causes system failure when announcement is disabled:

• Prefix is missing display screen tickets:

the executable file is being blocked by Symantec Endpoint Protected for suspecting as a virus.

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

Hi,
after the "Major refactoring for init" commit some error comes up:

1. During ./installer.sh --install:
   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!

"from lanuages"
--> change to "languages"
in files ->
[core.py, printer.py, ex_functions.py]

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

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.

• A ticket's task name is swapped with the number in display screen. Caused by recent core refactoring:

Pulling this one out of #104

• System failure when loading cached translation while not having an internet connection

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'

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:

1. 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?

2. 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

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 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.

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

• Migration fails if the database file doesn't exist:

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)

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?

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

[2020-06-04 11:58:12] "GET /repeat_announcement/True HTTP/1.1" 302 691 0.121707

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

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

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: ' '

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'

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.

branching of #13 , reported issue with resetting offices:

Hi , I try to setup on Mint 19 xfce 32 Bit unsuccessfull .

Wich are the OS requirements ?

Management sidebar counters are display inconsistent numbers when switching from office to office:

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.

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