sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users

Hi Miguel,
I have tried running your code in the same exact way you displayed it, but I continue getting an error when trying to send POST requests to update the database with a new user (p.s. I use the same exact curl request stated in the README.md).
Find below the error:
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1997, in call
return self.wsgi_app(environ, start_response)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request
return self.view_functionsrule.endpoint
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/tests.py", line 88, in new_user
if User.query.filter_by(username=username).first() is not None:
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2755, in first
ret = list(self[0:1])
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2547, in getitem
return list(res)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2855, in iter
return self._execute_and_instances(context)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users [SQL: 'SELECT users.id AS users_id, users.username AS users_username, users.password_hash AS users_password_hash \nFROM users \nWHERE users.username = ?\n LIMIT ? OFFSET ?'] [parameters: ('kseniya', 1, 0)]

Make sure the db.create_all() call is running. If it is, then make sure your User model has been imported when db.create_all() run.

Hi Miguel,
Thanks for the quick reply.
I was wondering if you had some indicative code that runs the same framework on CQLalchemy, not SQLalchemy. My aim is to not store user data locally but remotely.
All the best,
Lorenz.

@lorenzmaresca Unfortunately I do not have any examples based on Flask-CQLAlchemy. Sorry.

@miguelgrinberg I have also the same issue running the exact files of the project. I also noticed db.create_all() in the code, it creates the db file but it seems there is no users table.
FLASK_APP = temp-auth.py
FLASK_ENV = development
FLASK_DEBUG = 0
In folder /Users/ali/GoogleDrive/Projects/CRM/crm-nlu
/anaconda3/bin/python -m flask run
 * Serving Flask app "temp-auth.py"
 * Environment: development
 * Debug mode: off
/anaconda3/lib/python3.6/site-packages/flask_sqlalchemy/__init__.py:794: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True or False to suppress this warning.
  'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
 * Running on http://<IP_ADDRESS>:5000/ (Press CTRL+C to quit)
[2019-04-10 11:21:49,498] ERROR in app: Exception on /api/users [POST]
Traceback (most recent call last):
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: users

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/anaconda3/lib/python3.6/site-packages/flask/app.py", line 2292, in wsgi_app
    response = self.full_dispatch_request()
  File "/anaconda3/lib/python3.6/site-packages/flask/app.py", line 1815, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/anaconda3/lib/python3.6/site-packages/flask/app.py", line 1718, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/anaconda3/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise
    raise value
  File "/anaconda3/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request
    rv = self.dispatch_request()
  File "/anaconda3/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/Users/ali/GoogleDrive/Projects/CRM/crm-nlu/temp-auth.py", line 70, in new_user
    if User.query.filter_by(username=username).first() is not None:
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2825, in first
    ret = list(self[0:1])
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2617, in __getitem__
    return list(res)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2925, in __iter__
    return self._execute_and_instances(context)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2948, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute
    return meth(self, multiparams, params)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
    context)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
    exc_info
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
    raise value.with_traceback(tb)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users [SQL: 'SELECT users.id AS users_id, users.username AS users_username, users.password_hash AS users_password_hash \nFROM users \nWHERE users.username = ?\n LIMIT ? OFFSET ?'] [parameters: ('miguel', 1, 0)] (Background on this error at: http://sqlalche.me/e/e3q8)

Following this article, my problem is solve using this:
@app.before_first_request
def create_tables():
    db.create_all()

in the main script instead of:
if __name__ == '__main__':
    if not os.path.exists('db.sqlite'):
        db.create_all()

@azarezade you could have also solved the issue by deleting your db.sqlite file, which would force the db.create_all() call to run from its original place.

@miguelgrinberg I tried and delete db.sqlite several time and restart the api, but it didn't solved the issue! I have also delete the whole project and clone it from github again!
Anyway, thanks.

Following this article, my problem is solve using this:
@app.before_first_request
def create_tables():
    db.create_all()

in the main script instead of:
if __name__ == '__main__':
    if not os.path.exists('db.sqlite'):
        db.create_all()

thank you! this works for me

Following this article, my problem is solve using this:
@app.before_first_request
def create_tables():
    db.create_all()

in the main script instead of:
if __name__ == '__main__':
    if not os.path.exists('db.sqlite'):
        db.create_all()

Thank you. This worked for me also!!

@azarezade you could have also solved the issue by deleting your db.sqlite file, which would force the db.create_all() call to run from its original place.

Hi Miguel. I tried this approach with Python 3.7 but it did not help. Just including db.create_all outside the name == 'main' condition is sufficient or as others have verified we can use @app.before_first_request . Don't really understand why this is happening though.

Following this article, my problem is solve using this:
@app.before_first_request
def create_tables():
    db.create_all()

in the main script instead of:
if __name__ == '__main__':
    if not os.path.exists('db.sqlite'):
        db.create_all()

Thank You. You saved my time.

Following this article, my problem is solve using this:
@app.before_first_request
def create_tables():
    db.create_all()

in the main script instead of:
if __name__ == '__main__':
    if not os.path.exists('db.sqlite'):
        db.create_all()

Thank You. I've been dealing with this issue for a few days, thank you.

Hi Miguel,
I have tried running your code in the same exact way you displayed it, but I continue getting an error when trying to send POST requests to update the database with a new user (p.s. I use the same exact curl request stated in the README.md).
Find below the error:
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1997, in call return self.wsgi_app(environ, start_response) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1985, in wsgi_app response = self.handle_exception(e) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1540, in handle_exception reraise(exc_type, exc_value, tb) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise raise value File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app response = self.full_dispatch_request() File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise raise value File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request return self.view_functionsrule.endpoint File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/tests.py", line 88, in new_user if User.query.filter_by(username=username).first() is not None: File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2755, in first ret = list(self[0:1]) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2547, in getitem return list(res) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2855, in iter return self._execute_and_instances(context) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 945, in execute return meth(self, multiparams, params) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement compiled_sql, distilled_params File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context context) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception exc_info File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise raise value.with_traceback(tb) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context context) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users [SQL: 'SELECT users.id AS users_id, users.username AS users_username, users.password_hash AS users_password_hash \nFROM users \nWHERE users.username = ?\n LIMIT ? OFFSET ?'] [parameters: ('kseniya', 1, 0)]

Hi Miguel,
I have tried running your code in the same exact way you displayed it, but I continue getting an error when trying to send POST requests to update the database with a new user (p.s. I use the same exact curl request stated in the README.md).
Find below the error:
File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1997, in call return self.wsgi_app(environ, start_response) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1985, in wsgi_app response = self.handle_exception(e) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1540, in handle_exception reraise(exc_type, exc_value, tb) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise raise value File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app response = self.full_dispatch_request() File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise raise value File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request return self.view_functionsrule.endpoint File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/tests.py", line 88, in new_user if User.query.filter_by(username=username).first() is not None: File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2755, in first ret = list(self[0:1]) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2547, in getitem return list(res) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2855, in iter return self._execute_and_instances(context) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 945, in execute return meth(self, multiparams, params) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement compiled_sql, distilled_params File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context context) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception exc_info File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise raise value.with_traceback(tb) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context context) File "/Users/lorenzmaresca/Desktop/Cloud Computing/CCLab/Mini Project/flask_venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users [SQL: 'SELECT users.id AS users_id, users.username AS users_username, users.password_hash AS users_password_hash \nFROM users \nWHERE users.username = ?\n LIMIT ? OFFSET ?'] [parameters: ('kseniya', 1, 0)]

Hello!
I had the same issue, and what i did to solve the problem was delete the db file and create another one (db.creat_all) and import the class again

Following this article, my problem is solve using this:
@app.before_first_request
def create_tables():
    db.create_all()

in the main script instead of:
if __name__ == '__main__':
    if not os.path.exists('db.sqlite'):
        db.create_all()

Thank You. I've been dealing with this issue for a few days, thank you.

ok

Following this article, my problem solved using this:
@app.before_first_request
def create_tables():
    db.create_all()

in the main script instead of:
if __name__ == '__main__':
    if not os.path.exists('db.sqlite'):
        db.create_all()

This Worked Thanks!!!


CLDC-1176: date hint text

https://digital.dclg.gov.uk/jira/browse/CLDC-1176

@Dan13L3 Full stops after hint text, correct?

@paulrobertlloyd for the hint text I used the GOVUK design system as reference:
https://design-system.service.gov.uk/patterns/dates/#asking-for-memorable-dates

The examples in the Design System are painfully inconsistent when it comes to formatting hint text. I think we settled on using full stops…

I think for error messages we've said no full stop at the end unless the message itself already has one (i.e. is more than 1 sentence). Should maybe be consistent with that?

amended to end with full stop

:shipit:

Let's wait for @Dan13L3 ?

@baarkerlounger @paulrobertlloyd @kiddhustle Error messages should be without a full stop, and hint text with (I think it helps differentiate it from sub headers, etc). But Paul's right: even GDS can't make its mind up :)


right-click should not impact text selection

Right now, when you have text selected that spans multiple lines, a right click removes the selected lines (but one).
Can we avoid this somehow?
I tried looking at onInteractionStart but that doesn't seem to contain enough information.

An interesting thing is that InteractiveViewer handles panning events on _InteractiveViewerState._receivedPointerSignal method and it does not check PointerEvent.buttons


State "spotify-premium.0.player.playlist.trackNo" starts with 0 and not with 1

Hi,
I use adapter version 0.3.1 and the state "spotify-premium.0.player.playlist.trackNo" starts with 0 and not with 1 for showing the current playlist number: So if you select track #1 of the playlist, the state shows #0. Looks like the array value of the playlist is set into the state without incrementing by +1.
Thanks.
Workaround for HTML in vis:
{v:spotify-premium.0.playbackInfo.playlist.trackNo; Number(v)+1}

It's not a bug. The spotify-premium.0.playbackInfo.playlist.trackNo should show 0 for the first track. Also if you want to start playing the first track you have to put 0.
I will change the description of the state to descripe that it's 0-based and starts with 0.


listView is now showing on page [New to Flutter]

Hello I'm totally new to Dart lang.
I think my code needs to put the ListTile in a widget?
My issue error line is on : 82 Below Repo.
   builder: (BuildContext context, AsyncSnapshot snapshot){
Thanks in advance!
Repo : https://github.com/saadalti/Flutter-Drawer/blob/saadalti-patch-1/lib/pages/home_page.dart

Try setting the shrinkwrap to true
https://stackoverflow.com/questions/54007073/what-does-the-shrink-wrap-property-do-in-flutter
and the repo is change there is no
builder: (BuildContext context, AsyncSnapshot snapshot){

Try setting the shrinkwrap to true
https://stackoverflow.com/questions/54007073/what-does-the-shrink-wrap-property-do-in-flutter
and the repo is change there is no
builder: (BuildContext context, AsyncSnapshot snapshot){

Sorry New to Github, I fixed the link.
I'll check your solution if it will work.

Try setting the shrinkwrap to true
https://stackoverflow.com/questions/54007073/what-does-the-shrink-wrap-property-do-in-flutter
and the repo is change there is no
builder: (BuildContext context, AsyncSnapshot snapshot){

Sorry New to Github, I fixed the link.
I'll check your solution if it will work.

Didn't work I'll define more about the error in the real post.

Please ask questions like this on stackoverflow as we can't give individual support here.


fix(Admin/Service): merge ip list to service module

Deploy preview ready!
Built with commit 47f632301e35528624585b823f43ab2705ab4260
https://deploy-preview-360--mcslite.netlify.com

Deploy preview ready!
Built with commit 47f632301e35528624585b823f43ab2705ab4260
https://deploy-preview-360--mcs-lite-introduction.netlify.com

Deploy preview ready!
Built with commit 47f632301e35528624585b823f43ab2705ab4260
https://deploy-preview-360--mcs-lite-ui.netlify.com


Module installed but the bucket remains empty

Hi,
Thank you for sharing this plugin.
I've followed the README by installing then wrinting the configuration in plugins.js. I made sure Minio's keys are correct as well the all environment variables. Just to be sure, I've created a "folder" called "cms" in Minio. However, no upload goes to Minio. Everything remains on the FS. Is there something to enable somewhere?

My bad. I was testing on Stapi 4 :)


add okc# to user groups list

https://github.com/techlahoma/techlahoma/issues/58

Don't have time to do this before the town hall. That's jesse and ny top priority rn

Word. The main reason I'm going through all the GitHub issues is to collect
info that may come up in the Town Hall. If an overview of outstanding
issues isn't needed for the townhall then we'll just look over it at the
next board meeting.
On Mon, May 23, 2016 at 7:34 AM Amanda Harlin<EMAIL_ADDRESS>wrote:

Don't have time to do this before the town hall. That's jesse and ny top
priority rn
—
You are receiving this because you commented.
Reply to this email directly or view it on GitHub
https://github.com/techlahoma/techlahoma_lander/issues/25#issuecomment-220967660

If somebody can compile the info that we need to post for them I'd be happy to get it into the repo. The standard stuff we have for groups is something like this:
{
    "name": "okc ruby",
    "website": "http://okcruby.org",
    "logo_url": "/images/logos/okcruby.png",
    "twitter": "okcrb",
    "location": "prototek",
    "meetupdate": "2nd Thursday",
    "email"<EMAIL_ADDRESS>    "blurb": "OKC Ruby is focused on helping Oklahoma Rubyists to connect and share ideas. We hope you will join us."
  }

Msg'd @matthewreily on Slack. Will see what I can find on my own also.

{
"name": "okc#",
"website": "http://okcsharp.net/",
"logo_url": "",
"twitter": "okcsharp",
"location": "prototek",
"meetupdate": "1st Monday",
"email"<EMAIL_ADDRESS>"blurb": "OKC# is a .Net centric usergroup located in Oklahoma City, Oklahoma. Oklahoma City is an emerging technology hub with hundreds of .Net developers working in the area."
}
I stole the blurb from http://okcsharp.net/about/ and removed some redundancy.
Still need logo url.

Do you need a url or just a image file?

I think we need the image file. Ruby example url is internal.

Will this work?

Yep, that'll work!

Fixed in #27


what editor/theme is used for the screenshots in the docs?

like this one: http://vuejs.org/images/vue-component.png

Sublime Text with Solarized maybe?

Material Theme.
And please don't use issues to ask questions.


correct the haas200 hal uart.c format

[Detail]
Issue description:
the original format is not compliant to the rules of Alios Things
Rootcause:
Solution:
Requirement description:
Solution:
[Verified Cases]
Build Pass: haas200 py_engine_demo
Test Pass:
Change-Id: Ib277383448e57df34bd61d77f0640de6318a4c68
Signed-off-by: wangchengdong.wcd<EMAIL_ADDRESS>

 Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.You have signed the CLA already but the status is still pending? Let us recheck it.

感谢您提出的宝贵问题，我们有7x24小时服务的“HaaS百事通”客服系统，
您可以先尝试能否解决您的问题(https://haas.iot.aliyun.com/?ask=1&f=a2cre.b82925042)

如果“HaaS百事通”没有解决您的问题，请回复“人工支持”，我们会在工作日(10:00-12:00/14:00-18:00)10分钟内回复您。

start build

感谢提交 Pull Requests！
Thanks for submitting a pull request.

感谢提交 Pull Requests！
Thanks for submitting a pull request.

auto build success,number:19

autotest fail,number:791


added GetSchemaTable to datareader

This should allow to load DataTable from Reader.
https://github.com/Giorgi/DuckDB.NET/issues/65

@mikeTWC1984 Can you add a test that shows what issue this PR solves?

It lets loading reader data into datatable. Possible test is below.  Without GetSchemaTable method dt.Load(reader) would throw an exception.

    [Fact]
    public void LoadDataTable()
    {
        using var connection = new DuckDBConnection("DataSource=:memory:");
        connection.Open();

        var duckDbCommand = connection.CreateCommand();
        duckDbCommand.CommandText = "select 1 as num, 'text' as str, now() as tme";
        var reader = duckDbCommand.ExecuteReader();
        var dt = new DataTable()
        dt.Load(reader)
        dt.Rows.Count.Should().Be(1)
    }

Can you add that test to the PR?

Just added

just fixed missing semicolon

I see test failing because "now()" returns a timestamp with milliseconds, by some reason reader.GetDateTime method can't handle it.
If I use timestamp from literal without ms, (e.g. "TIMESTAMP '1992-09-20 20:38:40'") it works.
I can also get string value from "now" ( reader.GetString) and cast it to ts.

@mikeTWC1984 Yes, please replace now with some literal and create an issue for milliseconds issue.


Playing audio doesn't toggle play/pause icon on notification bar on Android devices

Hi,
Playing audio doesn't toggle play/pause icon on notification bar on all android devices.
I expected the notification bar to toggle to pause icon after calling AudioManager.instance.play(), but it still remains the play icon. The functionality of the button is correct if tapped on the notification bar, but calling from the function doesn't.
On iOS everything works fine.

I have the same issue: notification bar always has Play button active. The events are reported correctly in callbacks.


Fix cross-platform docker lock file generation

The apk upgrade command in the dockerBaseImageLockfileamd64 task would fail on a ARM64 machine (in emulation mode) with
#11 [stage-0 7/7] RUN --mount=type=bind,readonly,target=/mnt/ephemeral,source=ephemeral/docker apk upgrade
#11 0.128 fetch https://packages.cgr.dev/extras/x86_64/APKINDEX.tar.gz
#11 0.373 WARNING: opening from cache https://packages.cgr.dev/extras: No such file or directory
#11 0.373 fetch https://packages.wolfi.dev/os/x86_64/APKINDEX.tar.gz
#11 0.588 WARNING: opening from cache https://packages.wolfi.dev/os: No such file or directory
#11 0.588 ERROR: Not continuing due to stale/unavailable repositories.Use --force-missing-repositories to continue.
#11 ERROR: process "/bin/sh -c apk upgrade" did not complete successfully: exit code: 99

Adding the --no-cache parameter solves this, similar to #46.

Ill publish and bump


v1.6

New

[x] #3: Support for API Blueprint data structures.
[x] #31: Support for configuring specific resource groups from being compiled into API Blueprint files.

Updated documentation to reflect the new changes.


Publisher portal login page directs to error page when click on "Forgot Password"

Description
When click on the "Forgot password ?" link at the publisher login page of API Manager , it shows that "Page not working" with a 400 response code. When enter the same url next time on the browser it navigates to the intended page.
When checking the diff of the headers in the above 2 attempts, it seems that the "Referer" header value is missing in the initial attempt.
Steps to Reproduce

Go to the login page of the API Manager Publisher portal
click on "Forgot password ?"
you'll get a "Page not working" view with 400 response status code
when click enter on the same url, you'll be navigated to the intended forget password page

Affected Component
APIM
Version
4.3.0-m1
Environment Details (with versions)
Mac OS (M1)
Relevant Log Output
No response
Related Issues
No response
Suggested Labels
No response

Closing as the issue is not reproduced in the latest pack.


1577797 - call flag...Parse to prevent logging error

calling flag.CommandLine.Parse prevents "ERROR: logging before flag.Parse:
errors from glog (used by k8s' apiserver package) see
https://github.com/kubernetes/kubernetes/issues/17162#issuecomment-225596212
fixes: https://bugzilla.redhat.com/show_bug.cgi?id=1577797

before the change:
time="2018-08-02T17:09:55Z" level=debug msg="Creating k8s apiserver"
time="2018-08-02T17:09:55Z" level=info msg="Listening on https://[::]:1338"
time="2018-08-02T17:09:55Z" level=info msg="Ansible Service Broker Starting"
ERROR: logging before flag.Parse: I0802 17:09:55.506008       1 serve.go:89] Serving securely on [::]:1338
time="2018-08-02T17:12:25Z" level=debug msg="Unable to find originating origin header"
time="2018-08-02T17:12:25Z" level=info msg="Request: \"GET /automation-broker/v2/catalog HTTP/1.1\\r\\nHost: automation-broker.automation-broker.svc:1338\\r\\nAccept-Encoding: gzip\\r\\nUser-Agent: Go-http-client/1.1\\r\\nX-Broker-Api-Version: 2.13\\r\\n\\r\\n\""
time="2018-08-02T17:12:25Z" level=info msg="AnsibleBroker::Catalog"

after the change:
time="2018-08-02T20:19:41Z" level=debug msg="Creating k8s apiserver"
time="2018-08-02T20:19:41Z" level=info msg="Listening on https://[::]:1338"
time="2018-08-02T20:19:41Z" level=info msg="Ansible Service Broker Starting"
time="2018-08-02T20:22:08Z" level=debug msg="Unable to find originating origin header"
time="2018-08-02T20:22:08Z" level=info msg="Request: \"GET /automation-broker/v2/catalog HTTP/1.1\\r\\nHost: automation-broker.automation-broker.svc:1338\\r\\nAccept-Encoding: gzip\\r\\nUser-Agent: Go-http-client/1.1\\r\\nX-Broker-Api-Version: 2.13\\r\\n\\r\\n\""

Notice how it no longer prints:
ERROR: logging before flag.Parse: I0802 17:09:55.506008       1 serve.go:89] Serving securely on [::]:1338

Coverage remained the same at 40.562% when pulling b6b76fe7d6a89cbdb6b79b67936ad691561d4a6a on bz1577797 into f8ddaf2416849c19f3417ed64bc2577cf781805d on master.

Running the broker command seems to parse the args correctly:

broker --help prints out our help

$ ./broker --help
Usage:
  broker [OPTIONS]
Application Options:
  -c, --config=  Config File (default: /etc/ansible-service-broker/config.yaml)
  -v, --version  Print version information
Help Options:
  -h, --help     Show this help message

Running the broker without arguments attempts to look for the config file in the default location: /etc/ansible-service-broker/config.yaml

$ ./broker
============================================================
==           Creating Ansible Service Broker...           ==
============================================================
ERROR: Failed to read config file
open /etc/ansible-service-broker/config.yaml: no such file or directory

Running broker with a path for the config file attempts to use that parameter. In this case it doesn't exist.

$ ./broker -c /tmp/foo
============================================================
==           Creating Ansible Service Broker...           ==
============================================================
ERROR: Failed to read config file
open /tmp/foo: no such file or directory

Running to see the version parses it correctly and prints out the version as expected

$ ./broker -v
1.3.6

Ah I see what you did 👍 Nice job!


added warning for html.script

closes: #924
Checklist
Please update this checklist as you complete each item:

[ ] Tests have been included for all bug fixes or added functionality.
[ ] The changelog.rst has been updated with any significant changes.
[x] GitHub Issues which may be closed by this Pull Request have been linked.

@rmorshea does this fulfils the requirement?


JAVA-1664

Added GeoJson object model with enough functionality for use as query filters
Added GeoJson object model codecs (with only encoding support initially)
Added Filters.geoWithin, Filters.geoIntersects, Filters.near, Filters.nearSphere
JAVA-1664

cc @craiggwilson @rstam

Looking good.  Comments are:

I find the CRS parts confusing - why only 3 named systems?  Do we support different CRS systems, Does it impact storage internally and can you use multiple systems and query them?  Very confusing.

I found some error message to hard to decipher so suggested alternatives.

Groovy files seem to be missing newlines - you might want to tweak intellij to auto add on save.

Also, its much easier to use multiline strings rather than concatenate them in the tests ;)

Missing documentation!

I find the CRS parts confusing - why only 3 named systems?  Do we support different CRS systems, Does it impact storage internally and can you use multiple systems and query them?  Very confusing.
** Those are the three named systems that I found supported by the server.  The CRS names are stored by the server, but the only one that has any different effect from the default is STRICT_WINDING, and that one is only allowed on a query filter, not for stored documents.  And it does change the semantics of the query, according to the documentation.
I found some error message to hard to decipher so suggested alternatives.
** Will take a look
Groovy files seem to be missing newlines - you might want to tweak intellij to auto add on save.
** Found the setting and changed it.  Will fix.
Also, its much easier to use multiline strings rather than concatenate them in the tests ;)
** I did it this way because those strings were copied from our documentation, and IntelliJ added the newlines automatically
Missing documentation!
** Aware :)

:+1:

Addressed all comments except for reference documentation.

Added reference documentation of the Filters builder methods, include geospatial methods.

Currently failing checkstyle.

Looks great, I like the documentation.  Is it worth mentioning that the helpers don't validate the document that is built but rather build document as requested.

Do you mean that you can do:
and(new Document("field", new Document("$crazyOperator", 1)...)
and it will just send it to the server as is?  This will only happen if you leave the Filters world, and I don't show any examples of that yet.

Yes or an unsupported $not query etc..

In that case why not leave it as is?  Either way, the user will get an error reported, just by the server instead of the driver.

Thats fine, but a note in the documentation as well would hurt either.

Rebased and merged.


DSD-2264: allow users to pass pre-start script

No problems detected!

No problems detected!

:tada: This PR is included in version 2.2.0 :tada:
The release is available on GitHub release
Your semantic-release bot :package::rocket:


Feat/dwa

What type of PR is this? (check all applicable)

[ ] ♻ Refactor
[x] ✨ New Feature
[ ] 🐛 Bug Fix
[ ] 📝 Documentation Update
[ ] 👷 Example Application
[ ] 🧑💻 Code Snippet
[ ] 🎨 Design
[ ] 📖 Content
[ ] 🧪 Tests
[ ] 🔖 Release
[ ] 🚩 Other

Description

This PR adds Web5 connection converting it to a DWA.
Related Tickets & Documents

Resolves #66
Mobile & Desktop Screenshots/Recordings
https://github.com/user-attachments/assets/0d37001f-d1a1-47c3-bf6c-1efd7f3ec68c

Added code snippets?

[x] 👍 yes
[ ] 🙅 no, because they aren't needed

Added tests?

[ ] 👍 yes
[ ] 🙅 no, because they aren't needed
[ ] 🙋 no, because I need help

No tests? Add a note

Added to documentation?

[ ] 📜 readme
[ ] 📜 contributing.md
[ ] 📓 general documentation
[x] 🙅 no documentation needed

No docs? Add a note

[optional] Are there any post-deployment tasks we need to perform?
[optional] What gif best describes this PR or how it makes you feel?

Checking this out. Thanks for the contribution @Johnnyevans32

hi @leordev, have you had the time to look at the updates I made, if there are additional changes I need to make.

@Johnnyevans32 i tested and this is ready to go..the only thing that needs to be fixed before I approve and merge is the conflict on the pnpm lock file. Thank you!

@Johnnyevans32 i tested and this is ready to go..the only thing that needs to be fixed before I approve and merge is the conflict on the pnpm lock file. Thank you!

sorted now @blackgirlbytes

Hey @taniashiba ..after we remove the leaderboard action from github..we need to manually add ANOTHER 10 points for @Johnnyevans32 to the leaderboard because this PR he did two issues in one..a large and a medium. So instead of having 115..he would have 115 + 10 (from other PR) + 10 (from this PR) = 135


[enzyme-adapter-react-16] fix import

refs https://github.com/airbnb/enzyme/issues/2046

I've replaced this PR with the contents of #2048.


Undefined behavior was detected in the source code.

catimg/src/stb_image.h:1571:24: error: The left operand in a bitwise left-shift is negative.
  Undefined behavior (UB-CEB4).
   see C11 section 6.5.7:4 http://rvdoc.org/C11/6.5.7
   see C11 section J.2:1 item 52 http://rvdoc.org/C11/J.2
   see CERT-C section INT13-C http://rvdoc.org/CERT-C/INT13-C
   see CERT-C section MSC15-C http://rvdoc.org/CERT-C/MSC15-C
   see MISRA-C section 8.1:3 http://rvdoc.org/MISRA-C/8.1

catimg/src/sh_image.c:4:0:
catimg/src/stb_image.h: In function ‘stbi__gif_load_next’:
catimg/src/stb_image.h:5752:84: warning: unused parameter ‘req_comp’ [-Wunused-parameter]
 static stbi_uc *stbi__gif_load_next(stbi__context *s, stbi__gif *g, int *comp, int req_comp)
                                                                                ^

catimg/src/sh_utils.c: In function ‘read_stdin’:
catimg/src/sh_utils.c:45:14: warning: implicit declaration of function ‘fileno’ [-Wimplicit-function-declaration]
     int fd = fileno(stdin);
              ^

catimg/src/catimg.c:127:9: error: Incompatible pointer types in assignment or function call arguments.
  Constraint violation (CV-TEAS2).
   see C11 section <IP_ADDRESS>:1 http://rvdoc.org/C11/<IP_ADDRESS>
   see CERT-C section MSC40-C http://rvdoc.org/CERT-C/MSC40-C
   see MISRA-C section 8.1:1 http://rvdoc.org/MISRA-C/8.1
catimg/src/catimg.c: In function ‘main’:
catimg/src/catimg.c:138:21: warning: implicit declaration of function ‘usleep’ [-Wimplicit-function-declaration]
                     usleep(img.delays[frame - 1] * 10000);
                     ^

catimg/src/sh_color.h:39:1: error: Identifier color_map declared with incompatible types in different translation units.
  Undefined behavior (UB-TIN1).
   see C11 section 6.2.7:2 http://rvdoc.org/C11/6.2.7
   see C11 section J.2:1 item 15 http://rvdoc.org/C11/J.2
   see CERT-C section DCL23-C http://rvdoc.org/CERT-C/DCL23-C
   see CERT-C section DCL40-C http://rvdoc.org/CERT-C/DCL40-C
   see MISRA-C section 8.1:3 http://rvdoc.org/MISRA-C/8.1

catimg/src/sh_color.h:39:1: error: Multiple external definitions for color_map.
  Undefined behavior (UB-TIN2).
   see C11 section 6.9:5 http://rvdoc.org/C11/6.9
   see C11 section J.2:1 item 84 http://rvdoc.org/C11/J.2
   see CERT-C section MSC15-C http://rvdoc.org/CERT-C/MSC15-C
   see MISRA-C section 8.5:1 http://rvdoc.org/MISRA-C/8.5
   see MISRA-C section 8.8:6 http://rvdoc.org/MISRA-C/8.8
   see MISRA-C section 8.1:3 http://rvdoc.org/MISRA-C/8.1

catimg/src/sh_color.h:41:1: error: Multiple external definitions for yuv_color_map.
  Undefined behavior (UB-TIN2).
   see C11 section 6.9:5 http://rvdoc.org/C11/6.9
   see C11 section J.2:1 item 84 http://rvdoc.org/C11/J.2
   see CERT-C section MSC15-C http://rvdoc.org/CERT-C/MSC15-C
   see MISRA-C section 8.5:1 http://rvdoc.org/MISRA-C/8.5
   see MISRA-C section 8.8:6 http://rvdoc.org/MISRA-C/8.8
   see MISRA-C section 8.1:3 http://rvdoc.org/MISRA-C/8.1

Make sure you use cmake to compile catimg 🙂
It works correctly using latest clang

I was using cmake. However, I was analyzing your source code for behavior that is undefined according to the C standards. Your code may compile and work correctly in all human realizable test cases, however, to prove that it has certain properties in all possible cases, developers usually use the standard to create provable mathematical statements about their code. Please refer to the links provided in my report if you are interested in the standards that are broken in your code. Once you think that you corrected them, let me know and I will test them again if you desire.

Ok, in that case, I'm open to contributions if anybody wants to fix those


Modifying log contents in hadoop-tools/hadoop-aliyun/src/main/java/org/apache/hadoop/fs/aliyun/oss/AliyunOSSFileReaderTask.java

The following log line LOG.warn("Exception thrown when call shouldRetry, exception " + ex); evaluated against the provided standards: 1. The log line does include the exception as a parameter. 2. The log line does not include sensitive information. 3. The log message is concise, but not as informative as it could be. 4. The log message is for an exception, but is missing context such as what retry policy was being used and what the original exception was. Due to the violation of standards (3) and (4), we would recommend a code change to include more context in the log message.

Created by Patchwork Technologies.

👍 👍


fix(client): Allow to use Metric as a model name

Problem: even though built-in Metric type is placed in
a different namespace, type conflict still occurs: Delegate classes
are in the same namespace and can't refer to non-namespaced name.
Implements a tiny part of namespace overhaul proposal: introduces $Models namespace.
Ref #12469

Yes, we can.
Closing in favor of #20150


Compilation error due to warning

I tried to build it on OS X El Capitan but failed. I installed an updated Bison via brew.
CMake:
-- The CXX compiler identification is AppleClang <IP_ADDRESS>00072
...
-- Found BISON: /usr/local/bin/bison (found suitable version "3.0.4", minimum required is "2.4")
-- Found FLEX: /usr/bin/flex (found suitable version "2.5.35", minimum required is "2.5")

make:
.../lex.yy.cc:1213:16: error: function 'yyinput' is not needed and will not be emitted [-Werror,-Wunneeded-internal-declaration]
    static int yyinput (void)

It seems just a warning for an unused static function.
Besides, I failed building it on a clean Ubuntu also. There are lots of messages. Do you want me to paste them as another issue as well?

Yes please. I won't have time to look at it over the week-end, but I'll
have a look next week.
On Fri, Feb 5, 2016 at 1:11 PM Milo Yip<EMAIL_ADDRESS>wrote:

I tried to build it on OS X El Capitan but failed. I installed an updated
Bison via brew.
CMake:
-- The CXX compiler identification is AppleClang <IP_ADDRESS>00072
...
-- Found BISON: /usr/local/bin/bison (found suitable version "3.0.4", minimum required is "2.4")
-- Found FLEX: /usr/bin/flex (found suitable version "2.5.35", minimum required is "2.5")
make:
.../lex.yy.cc:1213:16: error: function 'yyinput' is not needed and will not be emitted [-Werror,-Wunneeded-internal-declaration]
static int yyinput (void)
It seems just a warning for an unused static function.
Besides, I failed building it on a clean Ubuntu also. There are lots of
messages. Do you want me to paste them as another issue as well?
—
Reply to this email directly or view it on GitHub
https://github.com/tunnuz/json/issues/8.


XLS files are not supported

Overview
I'm somewhat confused by this because I've seen XLS files work before. Maybe it's just an older version of the filetype that isn't supported.
I will share the file as soon as I get permission to release it into the public
Running a pipeline that uses tabulator with a xls file returns the error:
bcodmo_pipeline_processors.load

Traceback (most recent call last):

....

File "/home/conrad/.virtualenvs/laminar-server/lib/python3.7/site-packages/tabulator/stream.py", line 341, in open
self.__parser.open(source, encoding=self.__encoding)

File "/home/conrad/.virtualenvs/laminar-server/lib/python3.7/site-packages/tabulator/parsers/xlsx.py", line 70, in open
self.__bytes, read_only=not self.__fill_merged_cells, data_only=True)

File "/home/conrad/.virtualenvs/laminar-server/lib/python3.7/site-packages/openpyxl/reader/excel.py", line 313, in load_workbook
data_only, keep_links)

File "/home/conrad/.virtualenvs/laminar-server/lib/python3.7/site-packages/openpyxl/reader/excel.py", line 124, in __init__
self.archive = _validate_archive(fn)

File "/home/conrad/.virtualenvs/laminar-server/lib/python3.7/site-packages/openpyxl/reader/excel.py", line 96, in _validate_archive
archive = ZipFile(filename, 'r')

File "/usr/lib/python3.7/zipfile.py", line 1225, in __init__
self._RealGetContents()

File "/usr/lib/python3.7/zipfile.py", line 1292, in _RealGetContents
raise BadZipFile("File is not a zip file")

zipfile.BadZipFile: File is not a zip file

When I tried inside the python interpreter to use openpyxl library to load the file from path I got the more clear error:
>>> from openpyxl import load_workbook

>>> wb = load_workbook(filename="/path/to/xls_problem.xls")
Traceback (most recent call last):
...
    raise InvalidFileException(msg)
openpyxl.utils.exceptions.InvalidFileException: openpyxl does not support the old .xls file format, please use xlrd to read this file, or convert it to the more recent .xlsx file format.
>>>

Can we update the XLSX parser to fall back to xlrd when it's an XLS file?

Please preserve this line to notify @roll (lead of this repository)

xls_problem.xls.txt
Here's the file - just make sure to remove the .txt ending

Hi @cschloer,
the file works fine with tabulator:
from tabulator import Stream

with Stream('tmp/issue301.xls', sheet='Fig. 1') as stream:
     print(stream.read())
# [['Year', 'Month', 'Site', 'Coral cover %', 'SE coral cover', 'Lobe density mean', 'SE lobe density', 'N quadrats', 'Mean lobe size (cm)', 'SE lobe size (cm)', 'N (lobes)'], [1988, 3, 'Tektite', 32.8, 2.8, 35.8, 6, 30, 67.8, 2.94, 805], ...]

I think the problem that you need to set xls format or not to specify format at all (will be detected). And it looks like here - https://github.com/BCODMO/laminar-web/issues/464 - xls and xlsx are merged as one format.
Please re-open if it didn't help

So what I mean:
with Stream('tmp/issue301.xls') as stream: # good
with Stream('tmp/issue301.xls', format='xls') as stream: # good
with Stream('tmp/issue301.xls', format='xlsx') as stream: # error

thanks, that worked!


cuda in transformers backend?

The transformers backend does not appear to use the GPU.
I could not get any of the settings such as cuda: true or device: cuda to work. In the code, I could not see any of these options being used in the backend, either, yet.
Maybe copy the relevant lines from the diffusers backend?
https://github.com/mudler/LocalAI/blob/9482acfdfc502fcbf29efa7a4feda045d768f95a/backend/python/diffusers/backend_diffusers.py#L223-L233

The transformers backend does not appear to use the GPU. I could not get any of the settings such as cuda: true or device: cuda to work. In the code, I could not see any of these options being used in the backend, either, yet. Maybe copy the relevant lines from the diffusers backend?
https://github.com/mudler/LocalAI/blob/9482acfdfc502fcbf29efa7a4feda045d768f95a/backend/python/diffusers/backend_diffusers.py#L223-L233

good point - it was not hooked as I could not test it as well. please feel free to take a stab at it

I think this issue has been addressed https://github.com/mudler/LocalAI/blob/master/backend/python/transformers/transformers_server.py#L91, looks like we can close it, but please correct me if I missed something @mudler


compute_val_loss parser action to store_true

Either the argument should be named "--no-val-loss" or something like this and have a store_false action, or be named "--compute-val-loss" and have a store_true action. Second option is more coherent with the fact that providing a validation set is optional.
See this issue

Thank you! But could you change the PR to pull to fizyr/keras-retinanet? :P

@hgaiser oopsie, my bad, I change this


Columns - Add a column to link PipeTests to HeatTraces

Expected outcome

A column to see the PipeTests that are present on a HT cable that is due to have Rework:

There should also be a pull through column into the main page that lists pipetests
Business Value / Developer Experience

can then align rework with PipeTests.
Acceptance Criteria

[ ] next to any heat trace, there is any associated PipeTests
[ ] A list of Pipetests in the main sheet that relate to the HTs found

THis is not useful. PT are finished by this point


strange behavior with int in DF

This is something that has been diving me nuts for a couple of hours, so I decided to mention this.
When I create a dataframe as a class property and append rows as shown in the code below,
the 'int' type of 'id' field is being returned as float when accessed with .ix or .xs method:

from pandas import DataFrame,Index
import numpy as np

class tst(object):
    def __init__(self):
        self._header = ['id','bid','ask','last'] # columns of the _data table
        self._data = DataFrame()

    def add(self,symbol):
        ''' add a row to dataframe '''
        data = dict(zip(self._header,[1,np.nan,np.nan,np.nan]))
        row = DataFrame(data, index = Index([symbol]))

        self._data = self._data.append(row[self._header]) # append data and set correct column order

    def __repr__(self):
        return str(self._data)

t = tst()
t.add('AAA')
t.add('BBB')

print t._data['id']['AAA'] # int (like it should)!
# this is where it goes wrong:
print t._data.ix[0,0] # float!
print t._data.xs('AAA') # float again!

What you get is not so strange, when one keeps in mind that:

numpy is used to store the data.
np.NaN is a float64
when indexing, cross-section a DataFrame, what is returned

In [117]: header = ['id','bid','ask','last']

In [118]: data = dict(zip(header,[1,np.nan,np.nan,np.nan]))

In [119]: df = DataFrame(data, index = Index(['AAA']), columns=header)

In [120]: df
Out[120]:
     id  bid  ask  last
AAA  1   NaN  NaN  NaN

In [122]: df['id']
Out[122]:
AAA    1
Name: id

In [123]: df['id'].values.dtype
Out[123]: dtype('int64')

In [124]: row = DataFrame(data, index = Index(['BBB']))

In [125]: df = df.append(row)

In [126]: df
Out[126]:
     ask  bid  id  last
AAA  NaN  NaN  1   NaN
BBB  NaN  NaN  1   NaN

In [127]: df['id'].values.dtype
Out[127]: dtype('int64')

In [129]: df.ix['AAA']
Out[129]:
ask     NaN
bid     NaN
id      1.000
last    NaN
Name: AAA

In [130]: df.ix['AAA'].values.dtype
Out[130]: dtype('float64')

In [131]: df.ix['AAA']['id']
Out[131]: 1.0

In [132]: df['id']['AAA']
Out[132]: 1

Well, I did consider your point about internal numpy representation, but the following code functions exactly as expected.
Still, can't find the cause of the discrepancy.
I'm trying to write a data model for pyqt to enable viewing dataframe through a gui widget, which I'm planning to contribute to this project. The problem at this moment is that in some cases (as above) the wrong data type is getting passed to the gui.

In [21]: data = {'int':[1,2,3],'float':[1.5,2.5,3.5],'string':['a','b','c']}

In [22]: df = DataFrame(data, index=Index(['AAA','BBB','CCC']))[['int','float','string']]

In [23]: df
Out[23]:
     int  float  string
AAA  1    1.5    a
BBB  2    2.5    b
CCC  3    3.5    c

In [24]: df.ix[0,0]
Out[24]: 1

In [25]: df.xs('AAA')
Out[25]:
int       1
float     1.5
string    a
Name: AAA

In [26]: df.ix['AAA']['int']
Out[26]: 1

It may help if you look at the dtype used to store the data.
Because of the string column, if you extract a row of a dataframe it will be stored as object, leaving the int colum as int.
In [25]: df = pandas.DataFrame(data, index=pandas.Index(['AAA','BBB','CCC']), columns=['int','float','string'])

In [26]: df
Out[26]:
     int  float  string
AAA  1    1.5    a
BBB  2    2.5    b
CCC  3    3.5    c

In [27]: df.ix[0,0]
Out[27]: 1

In [28]: df.ix['AAA']['int']
Out[28]: 1

In [29]: df.ix['AAA']
Out[29]:
int       1
float     1.5
string    a
Name: AAA

In [30]: df.ix['AAA'].values.dtype
Out[30]: dtype('object')

Now if you create a new DataFrame without the string column, and extract a row dtype is float64, which is similar as in the very first example (1 and np.Nan`s).
In [35]: df = df[['int', 'float']]

In [36]: df
Out[36]:
     int  float
AAA  1    1.5
BBB  2    2.5
CCC  3    3.5

In [37]: df.ix['AAA']['int']
Out[37]: 1.0

In [38]: df.ix['AAA'].values.dtype
Out[38]: dtype('float64')

In [39]: df.ix['AAA']
Out[39]:
int      1.0
float    1.5
Name: AAA

If you index carefully, you`ll get the dtype you want.
In [46]: df
Out[46]:
     int  float  string
AAA  1    1.5    a
BBB  2    2.5    b
CCC  3    3.5    c

In [47]: df['int'].values.dtype
Out[47]: dtype('int64')

In [48]: df['int']
Out[48]:
AAA    1
BBB    2
CCC    3
Name: int

In [49]: df['float'].values.dtype
Out[49]: dtype('float64')

In [50]: df['string'].values.dtype
Out[50]: dtype('object')

Thanks Lodargo, I was indeed able to fix this issue in by first slicing through the column and then picking the row.
Maybe it would be a good idea to implement this behavior on lower level when a single element is called through .ix[row,col]


xsimd: 11.1.0 -> 11.2.0

Changes: https://github.com/xtensor-stack/xsimd/compare/11.1.0...11.2.0
Description of changes

Things done

Built on platform(s)

[x] x86_64-linux
[ ] aarch64-linux
[ ] x86_64-darwin
[ ] aarch64-darwin

For non-Linux: Is sandboxing enabled in nix.conf? (See Nix manual)

[ ] sandbox = relaxed
[ ] sandbox = true

[ ] Tested, as applicable:

NixOS test(s) (look inside nixos/tests)
and/or package tests
or, for functions and "core" functionality, tests in lib/tests or pkgs/test
made sure NixOS tests are linked to the relevant packages

[ ] Tested compilation of all packages that depend on this change using nix-shell -p nixpkgs-review --run "nixpkgs-review rev HEAD". Note: all changes have to be committed, also see nixpkgs-review usage
[ ] Tested basic functionality of all binary files (usually in ./result/bin/)
23.11 Release Notes (or backporting 23.05 Release notes)

[ ] (Package updates) Added a release notes entry if the change is major or breaking
[ ] (Module updates) Added a release notes entry if the change is significant
[ ] (Module addition) Added a release notes entry if adding a new NixOS module

[x] Fits CONTRIBUTING.md.

Patches will need tweaking.
applying patch /nix/store/anjpq66c2ycs1gpl2yqhrzc46cpf3srs-disable-exp10-test.patch
patching file test/test_xsimd_api.cpp
Reversed (or previously applied) patch detected!  Assume -R? [n]
Apply anyway? [n]

Looking.

Proposed patch updates as https://github.com/NixOS/nixpkgs/pull/271937.


[Crosswalk-16][wrt] Update test script for 64bits support

Sync tests from Crosswalk-17 with commit 006e9f3e6c2183cb0e4656a398fe5578857
usecase-wrt-auto-tests:
Impacted TCs num(approved): New 0, Update 15, Delete 0
Unit test Platform: Android Crosswalk Canary 16.45.421.0
Android test result summary: Pass 15, Fail 0, Block 0
wrt-packertool-android-tests:
Impacted tests(approved): new 0, update 190, delete 0
Unit test platform: Crosswalk Project for Android 16.45.421.0
Unit test result summary: pass 176, fail 14, block 0
wrt-manifest-android-tests:
Impacted tests(approved): new 0, update 266, delete 0
Unit test platform: Crosswalk Project for Android 16.45.421.0
Unit test result summary: pass 266, fail 0, block 0
wrt-security-android-tests:
Impacted tests(approved): new 0, update 4, delete 0
Unit test platform: Crosswalk Project for Android 16.45.421.0
Unit test result summary: pass 4, fail 0, block 0
wrt-packertool2-android-tests:
Impacted tests(approved): new 0, update 38, delete 0
Unit test platform: Crosswalk Project for Android 16.45.421.0
Unit test result summary: pass 38, fail 0, block 0
wrt-manifest2-android-tests:
Impacted tests(approved): new 0, update 14, delete 0
Unit test platform: Crosswalk Project for Android 16.45.421.0
Unit test result summary: pass 14, fail 0, block 0
https://crosswalk-project.org/jira/browse/XWALK-5557

LGTM


Banner for incomplete translations

Problem
Currently, if a wp.org Rosetta site is only partially translated, especially if the % translated is low, like 1, or 2%, or the translation threshold is high  but not for key UI elements like the navigation, users might think there's something wrong with the site, their browser, or other issues when they attempt to navigate to a localized site.
Solution
We should implement the banner Learn uses to make incomplete translations clear to the user. Learn uses data from the rest api to accomplish this: https://github.com/WordPress/learn/pull/202/files#diff-ddff3385c614ff999459619af1b876da8a6de11f0a5f0a774453db8d9bec1e5bR39-R52

I've tried to implement this banner, but I got stuck on implementation details:
The translation status API does not have a CORS header, so it is only possible to get the json from the WordPress.org theme.
I tried to create the following process:

Schedule a daily API call from the Openverse WordPress.org child theme and save the result as a json file.
With every emitLocale in the WP.org Openverse theme, additionally send the translation status info from the json file.
Use the NotificationBanner.vue component to show the translation percentage for current locale.
But the problem is that I don't know how to do the first part in PHP.

Can we get the translation percentages in Node using a script like i18n:get-translation-frac? This way we can keep a dynamically generated list of translation percentages in the code at build time and show the banner at run time.


fix(action) fix the conditions of the volume expand action

Signed-off-by: Siye Wang<EMAIL_ADDRESS>

LGTM, as a future refactor consider creating these functions in a helper/util.
This way you only have a central place to modify whether a certain action is valid.
It also cleans up the UI code files, since isVolumeExpandable is expressive enough to communicate the intent and if the details are required a single click is all that is needed to look at them :)
bool isVolumeExpandable(volume) {
// do the state == detached check
// do the scheduling check
// whatever other check might be necessary
}

Than for the usage you can just negate that functions result
disabled: !isVolumeExpandabale(selected)
bulk:
disabled: !(selectedRows.length >0 && selectedRows.all(isVolumeExpandable))

Thank you for your help. If I get a chance to refactor I will extract the public judgment methods like you said, not only modifying the expand volume but also the other actions.
longhorn-ui does needs a lot of refactoring (because it is still front-end paging and there are many unreasonable places). I'll ask yasker if he can give me some time to refactor the ui after the backend api is refactored.


How can I make template & get template id on mgs91

How can I make template & get template id on mgs91

Refer to their docs.


Question: How come stepmodule this expr in updateForOp cause evaluating LibState?

I'm debugging Repl's pureEval by running _testAccounts,
=======Debug output============

:continue
Stopped in Pact.Repl.updateForOp, /home/al/Downloads/pact-master/src/Pact/Repl.hs:204:48-63
_result :: LibState = _
v :: LibState = LibState (GHC.MVar.MVar _) (Tx _ Commit ....) _ []
203    mode <- use rMode
204    op <- liftIO $ modifyMVar mv $ \v -> return (set rlsOp Noop v,view rlsOp v)
205    case op of
:force v
v = LibState
(GHC.MVar.MVar _)
(Tx
(Info
(Just
(Code (Data.Text.Internal.Text _ 0 12),Parsed
(Text.Trifecta.Delta.Directed
(Data.ByteString.Internal.PS
0x000000423e5fd100
(GHC.ForeignPtr.PlainPtr _) 0 31)
10 0 311 0)
12)))
Commit Nothing)
Nothing []
:t rlsOp
rlsOp :: Functor f => (LibOp -> f LibOp) -> LibState -> f LibState
:stepmodule
Stopped in Pact.Repl.doTx, /home/al/Downloads/pact-master/src/Pact/Repl.hs:229:20-35
_result :: Eval LibState (Pact.Types.Lang.Term Name) = _
228      Commit -> return $ void $ evalCommitTx i
229    pureEval i (e >> return (tStr "")) >>= \r -> forM r $ _ -> do
230      case t of
============

The process stopped in "set rlsOp Noop v", but the :stepmodule made the evaluation of LibState happened, what's the reason?
I don't understand this expression:
op <- liftIO $ modifyMVar mv $ \v -> return (set rlsOp Noop v,view rlsOp v),
From my current understanding, set rlsOp as Noop and then view rlsOp would always make op as Noop.
I must miss something.
Please help to explain.

Hi, please feel free to email<EMAIL_ADDRESS>if you have questions about the code. We need to keep issues focused on actual production issues, so please do not open issues for various questions.

OK, sorry about that.


Extract useful info from cypher remove, set, unwind

What changes were proposed in this pull request?
as title
Why are the changes needed?
First step of DeCypher
Does this PR introduce any user-facing change?
No
How was this patch tested?
Not yet

CI failed


Easy way to stop an deployed engine

Can anyone tell me how stop an runned and deployed engine unlike killing its proceses ?

would this doc https://docs.prediction.io/deploy/ helps?

When I run "pio deploy" until other engine run I has error that port 8000 are busy and engine stops. In second time its OK. Redeploy script actually doing same things.
Is more easy and quickly way  to do that?

running "pio deploy"  on the same engine will automatically undeploy the existing one and deploy the new one of this engine to use latest model.
if you want to deploy multiple engines (say engine2) at the same time, you can specify different ports so they don't conflict.
In particular, what you are trying to achieve?

I need regulary retrain and redeploy my engine.
Here wat I recive when try to deploy engine while it runs
[INFO] [MasterActor] Undeploying any existing engine instance at http://<IP_ADDRESS>:8000
[ERROR] [MasterActor] Another process might be occupying <IP_ADDRESS>:8000. Unable to undeploy.
[ERROR] [TcpListener] Bind failed for TCP channel on endpoint [/<IP_ADDRESS>:8000]
[WARN] [HttpListener] Bind to /<IP_ADDRESS>:8000 failed
[ERROR] [MasterActor] Bind failed. Retrying... (2 more trial(s))
[ERROR] [TcpListener] Bind failed for TCP channel on endpoint [/<IP_ADDRESS>:8000]
[WARN] [HttpListener] Bind to /<IP_ADDRESS>:8000 failed
[ERROR] [MasterActor] Bind failed. Retrying... (1 more trial(s))
[ERROR] [TcpListener] Bind failed for TCP channel on endpoint [/<IP_ADDRESS>:8000]
[WARN] [HttpListener] Bind to /<IP_ADDRESS>:8000 failed
[ERROR] [MasterActor] Bind failed. Retrying... (0 more trial(s))
[ERROR] [TcpListener] Bind failed for TCP channel on endpoint [/<IP_ADDRESS>:8000]
[WARN] [HttpListener] Bind to /<IP_ADDRESS>:8000 failed
[ERROR] [MasterActor] Bind failed. Shutting down.

And previously running engine stops too
[INFO] [MasterActor] Stop server command received.
[INFO] [MasterActor] Server is shutting down.
[INFO] [HttpListener] Unbound from /<IP_ADDRESS>:8000

How I can stops engine from shell script? Or wat I doing wrong ?

do you have other process using port 8000?
I just tried the following:
deploy similarity engine in terminal1:
$ pio deploy
...
[INFO] [MasterActor] Undeploying any existing engine instance at http://<IP_ADDRESS>:8000
[WARN] [MasterActor] Nothing at http://<IP_ADDRESS>:8000
[INFO] [HttpListener] Bound to /<IP_ADDRESS>:8000
[INFO] [MasterActor] Engine is deployed and running. Engine API is live at http://<IP_ADDRESS>:8000.

open another terminal 2, in the same engine folder, i run
$ pio deploy
...
[INFO] [MasterActor] Undeploying any existing engine instance at http://<IP_ADDRESS>:8000
[WARN] [HttpListener] Bind to /<IP_ADDRESS>:8000 failed
[ERROR] [MasterActor] Bind failed. Retrying... (2 more trial(s))
[INFO] [HttpListener] Bound to /<IP_ADDRESS>:8000
[INFO] [MasterActor] Engine is deployed and running. Engine API is live at http://<IP_ADDRESS>:8000.

while terminal 1 then show:
[INFO] [MasterActor] Stop server command received.
[INFO] [MasterActor] Server is shutting down.
[INFO] [HttpListener] Unbound from /<IP_ADDRESS>:8000

This can help
you can use ip:port/stop
http://stackoverflow.com/questions/32886550/how-to-undeploy-the-prediction-io-model


Streaming Text Input for TTS with Output as a Streaming Audio Buffer

I need to process streaming text input for text-to-speech (TTS) and receive the response as a streaming audio buffer with minimal latency. Is there any documentation available on how to achieve this? I tried accessing the documentation, but the GitHub link appears to be broken:
GitHub Link

this is fixed now, for streaming output see #2541

Closed as fixed.


feat: simple example for the BigQueryWrite API

I didn't walk through the steps. If you would like me to do that, I would be happy to.
I notice the samples in this repo do not have BUILD files. should we add them?

.p7-358517206116-cd10a88a-7740-4403-a8fd-979f3bd7fe1c.


Unhandled Exception in AskInConversationAsync: System.InvalidOperationException

VS Code Version: Version: 1.85.1
OS Version: Windows_NT x64 10.0.19045
Logs:
[Conversations Error] [Conversations] Unhandled exception in AskInConversationAsync: System.InvalidOperationException: Operation is not valid due to the current state of the object.
at Conversations.Abstractions.RawResponse.CreateResponse(CompletionResponseStatus status) in D:\a_work\1\s\src\Conversations.Abstractions\Parsing\RawResponse.cs:line 88
at Conversations.Abstractions.StreamingParser.RunnerAsync(CancellationToken cancellation) in D:\a_work\1\s\src\Conversations.Abstractions\Parsing\StreamingParser.cs:line 116
at Conversations.Kernel.DefaultConversation.BuildCompletionResponseAsync(IntentExecutionContext request, LLMResponse result, CancellationToken cancellationToken) in D:\a_work\1\s\src\Conversations.Kernel\DefaultConversation.cs:line 422
at Conversations.Kernel.DefaultConversation.AskAsync(CopilotRequest request, ActiveInteractions activeInteractions, IContextProviders context, CancellationToken cancellation) in D:\a_work\1\s\src\Conversations.Kernel\DefaultConversation.cs:line 175
at Microsoft.VisualStudio.Conversations.Service.ServiceTarget.AskInConversationAsync(CopilotSessionId sessionId, CopilotRequest request, ActiveInteractions activeInteractions, CancellationToken cancellation) in D:\a_work\1\s\src\Conversations.Service.Implementation\ServiceTarget.cs:line 144
[CopilotSessionProvider Error] Error on conversation request (CorrelationId: 6b700ad1-5382-49d3-9f03-0339af25c276): StreamJsonRpc.RemoteInvocationException: Operation is not valid due to the current state of the object.
at StreamJsonRpc.JsonRpc.d__151`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.VisualStudio.Copilot.CopilotSession.d__36.MoveNext()
RPC server exception:
System.InvalidOperationException: Operation is not valid due to the current state of the object.
at Conversations.Abstractions.RawResponse.CreateResponse(CompletionResponseStatus status) in D:\a_work\1\s\src\Conversations.Abstractions\Parsing\RawResponse.cs:line 88
at Conversations.Abstractions.StreamingParser.RunnerAsync(CancellationToken cancellation) in D:\a_work\1\s\src\Conversations.Abstractions\Parsing\StreamingParser.cs:line 116
at Conversations.Kernel.DefaultConversation.BuildCompletionResponseAsync(IntentExecutionContext request, LLMResponse result, CancellationToken cancellationToken) in D:\a_work\1\s\src\Conversations.Kernel\DefaultConversation.cs:line 422
at Conversations.Kernel.DefaultConversation.AskAsync(CopilotRequest request, ActiveInteractions activeInteractions, IContextProviders context, CancellationToken cancellation) in D:\a_work\1\s\src\Conversations.Kernel\DefaultConversation.cs:line 175
at Microsoft.VisualStudio.Conversations.Service.ServiceTarget.AskInConversationAsync(CopilotSessionId sessionId, CopilotRequest request, ActiveInteractions activeInteractions, CancellationToken cancellation) in D:\a_work\1\s\src\Conversations.Service.Implementation\ServiceTarget.cs:line 144
at Microsoft.VisualStudio.Conversations.Service.CopilotServiceContainer.AskInConversationAsync(CopilotSessionId conversationId, CopilotRequest request, ActiveInteractions activeInteractions, CancellationToken cancellationToken) in D:\a_work\1\s\src\Conversations.Service.Implementation\CopilotServiceContainer.cs:line 252

Steps to Reproduce:
This only happens in visual studio 2022 (community edition), never has happened in vscode until now. I tried sending this prompt in github copilot chat: "im wondering is it possible to make a Radzen Server applications function he same like how MVC does, sending the fully rendered html?" in the chat it returns:

I'm not sure what causes this? For example i tried fixing the prompt or rewording it, sometimes fixes the issue like I simply added a same prompt again but I fixed my typo at "function he same" I added a T for the, resent it and it answers fine. However if i close the current chat session and open a new one and send the same exact prompt again, the same error happens, with the same log attached. This has happened multiple times today, and its really making things frustrating.

Please report VS issues via VS' built-in Feedback Tool.


Rebuild jaeger-ui if the tree does not match any tag exactly

The previous behavior resulted in the prebuild upstream package being downloaded, even if the local tree has any changes, whether they are commited or not. This broke our internal build that has some patches applied. See:

https://github.com/jaegertracing/jaeger/pull/4251#issuecomment-1608393236

Let's use a more strict approach and only use the prebuild package if the tag is exact and does not contain any extra changes.

@bobrik could you elaborate a bit how your internal build is setup? Do you have a fork of both Jaeger and Jaeger-UI.

Yes, we have patches for both jaeger and jaeger-ui internally, so we build our own binaries for deployment.

I wonder if it makes more sense for you to have an option that can be passed to make that will skip the tag check & download and always go with full rebuild.

The only scenario where I can see it being useful is you want to rebuild with a changed environment (like node version), everything else should be covered by this change already. For this a bit more finessing might be required (I remember needing to nuke node_modules to make it build for me) and if you are in that territory, you probably can run yarn build directly.
I can add make rebuild-ui that would pass an env variable to ./scripts/rebuild-ui.sh to skip the download, but I'm not sure if it's something anyone would actually use.


feat: object factory source object parameter

Codecov Report

Merging #147 (8dace2d) into main (647ea24) will increase coverage by 0.19%.
The diff coverage is 92.18%.

@@            Coverage Diff             @@
##             main     #147      +/-   ##
==========================================
+ Coverage   90.03%   90.22%   +0.19%
==========================================
  Files          81       86       +5
  Lines        2598     2669      +71
  Branches      325      338      +13
==========================================
+ Hits         2339     2408      +69
+ Misses        185      184       -1
- Partials       74       77       +3

Impacted Files
Coverage Δ

src/Riok.Mapperly/Helpers/SymbolExtensions.cs
85.71% <62.50%> (-9.29%)
:arrow_down:

...tFactories/GenericTargetObjectFactoryWithSource.cs
80.00% <80.00%> (ø)

...s/ObjectFactories/SimpleObjectFactoryWithSource.cs
80.00% <80.00%> (ø)

...tors/ObjectFactories/GenericSourceObjectFactory.cs
85.71% <85.71%> (ø)

...bjectFactories/GenericSourceTargetObjectFactory.cs
92.85% <92.85%> (ø)

...Builder/NewInstanceObjectPropertyMappingBuilder.cs
85.71% <100.00%> (ø)

...appings/NewInstanceObjectFactoryPropertyMapping.cs
100.00% <100.00%> (ø)

...tors/ObjectFactories/GenericTargetObjectFactory.cs
100.00% <100.00%> (ø)

...perly/Descriptors/ObjectFactories/ObjectFactory.cs
100.00% <100.00%> (ø)

...escriptors/ObjectFactories/ObjectFactoryBuilder.cs
100.00% <100.00%> (ø)

... and 4 more

:mega: We’re building smart automated test selection to slash your CI/CD build times. Learn more


Improvementrequest

Hi Phillip!
Is it possible to add a block to raise an event when the distance ist lower than a specified distance?
PS: Sorry, don´t know how to add the improvement Label.

@MKleinSB Technically possible, yes. Challenging from the usability perspective. Let's see if we can find a good solution.
Behaviour
What would be the behavior you expect? When exactly should the event be triggered? Should it be triggered once when the distance is lower for the first time? Multiple times?
Event Block
An event block can come without a parameter.
e.g. onDistanceLessThan10Cm(action)
Or with an enumeration parameter.
e.g. onDistanceLessThan(makerbit.distance10cm, action)
Which values would we need? 5, 10, 15, 20, 25, 50, 100, 150, 200?

@philipphenkel
Einmal dachte ich als Bewegungsmelder d.h. jemand geht in einer bestimmten Distanz an einem interaktiven Plakat vorbei --> Der makerbit startet mp3file oder sonstirgendetwas. Dann bräuchte man alles was näher als 1,5m, 1m und 50cm ist.
Zweite Anwendung: unkompliziertere Abfrage wie isultraschallless wenn man mit einem Fahrzeug fährt.   D.h. 5, 10, 15, 20, 30 cm wären meiner Meinung nach dafür geeignet.

Sounds reasonable. From my experience with kids, I agree that event handling is indeed much easier to use.
I will have a look after Easter and come with a proposal.
@HyperDuino Any thoughts?

Implemented and released with version 1.0.5

Philipp,
I was trying to use the debug mode of the new release of MakeCode, and
it seems to be broken.
Here is the program: https://makecode.microbit.org/#pub:_K8geioFF5hvK
But when I step through, it says "no variables" even though "light" is
right there in the code.
Before I report this as an issue, is there something obvious that I'm
doing wrong?
Roger

Same for me. I don't see variables in MakeCode debug mode as long as I stay with blocks. It works in JavaScript. It's either not yet completely implemented or a bug.

Works for me. Click the red poin for watch the variables.

I clicked on the dot to make it red in my original program (https://makecode.microbit.org/_LsfKaXTebYRR)

Why do I have to make a new variable light2 to get variables to show? Why did "x" work in one program without having the red dot set, but the variable light did not?

ok, I get it now about the dots.  That's a break point for the debugger.
I don't see why light2 works, but light doesn't.


Fix depreciated constant POWER_VOLT_AMPERE_REACTIVE, add german translation

POWER_VOLT_AMPERE_REACTIVE is a deprecated constant which will be removed in HA Core 2025.9, replaced with UnitOfReactivePower.VOLT_AMPERE_REACTIVE

thanks!

Thank you! I think you can close Issue #309.


FPGA: Issue with .aocx bitstream parser

The following statement is not true,
https://github.com/intel/intel-device-plugins-for-kubernetes/blob/v0.29.0/pkg/fpga/bitstream/aocx.go#L31-L32
and parsing FPGA binaries fails (unnecessarily) in many cases:
https://github.com/intel/intel-device-plugins-for-kubernetes/blob/v0.29.0/pkg/fpga/bitstream/aocx.go#L175-L178

In modern AOCX files you've got, what does this field contain? Can you share (e.g. privately) some of example aocx files where it fails parsing?

intel_a10gx_pac.tar.gz OpenCL BSP (19.2-57)

bringup/aocxs/pac_a10.aocx: 63b3779b8bdd4f039ceb0301181d6aef

intel_s10sx_pac.tar.gz OpenCL BSP (19.2-57)

bringup/aocxs/pac_s10.aocx: 63b3779b8bdd4f039ceb0301181d6aef
bringup/aocxs/pac_s10_usm.aocx: 18b79ffa2ee54aa096ef4230dafacb5f

Downloads > oneAPI : https://www.intel.com/content/www/us/en/software-kit/661712/intel-quartus-prime-pro-edition-design-software-version-19-2-for-linux.html


Update blockscout image version to support private transactions

Current blockscout version v4.0.0 doesn't support private transaction, a fix was added on v4.1.3. The docker image for consensys/blockscout was updated accordingly, but the provided DATABASE_URL, without the port, fails to initialize.

 Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.You have signed the CLA already but the status is still pending? Let us recheck it.

Hi @Asafkbalink
I have tried this out and get the following error:

23:01:27.221 [info]  == Running<PHONE_NUMBER>1504 Explorer.Repo.Migrations.AddImplementationName.change/0 forward

23:01:27.221 [info]  alter table smart_contracts

23:01:27.222 [info]  == Migrated<PHONE_NUMBER>1504 in 0.0s
2022-07-27T23:01:33.956 application=tzdata [info] tzdata release in place is from a file last modified Fri, 22 Oct 2021 02:20:47 GMT. Release file on server was last modified Wed, 16 Mar 2022 13:36:02 GMT.
2022-07-27T23:01:36.796 application=que [info] [Que] Booting Que
2022-07-27T23:01:36.797 application=que [info] [Que] Booting Server Supervisor for Workers
2022-07-27T23:01:36.860 [notice] Application explorer exited: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
    ** (EXIT) an exception was raised:
        ** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: "ssl not available", postgres: nil, query: nil}}
            (explorer 0.0.1) lib/explorer/chain/events/listener.ex:15: Explorer.Chain.Events.Listener.init/1
            (stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
            (stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
            (stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
2022-07-27T23:01:36.862 [notice] Application con_cache exited: :stopped
2022-07-27T23:01:36.862 [notice] Application spandex_ecto exited: :stopped
2022-07-27T23:01:36.863 [notice] Application que exited: :stopped
2022-07-27T23:01:36.863 [notice] Application ex_utils exited: :stopped
2022-07-27T23:01:36.863 [notice] Application memento exited: :stopped
2022-07-27T23:01:36.864 [notice] Application mnesia exited: :stopped
2022-07-27T23:01:36.864 [notice] Application prometheus_ecto exited: :stopped
2022-07-27T23:01:36.865 [notice] Application prometheus_ex exited: :stopped
2022-07-27T23:01:36.865 [notice] Application prometheus exited: :stopped
2022-07-27T23:01:36.865 [notice] Application quantile_estimator exited: :stopped
2022-07-27T23:01:36.867 [notice] Application postgrex exited: :stopped
2022-07-27T23:01:36.867 [notice] Application nimble_csv exited: :stopped
2022-07-27T23:01:36.867 [notice] Application poison exited: :stopped
2022-07-27T23:01:36.867 [notice] Application math exited: :stopped
2022-07-27T23:01:36.868 [notice] Application ecto_sql exited: :stopped
2022-07-27T23:01:36.868 [notice] Application db_connection exited: :stopped
2022-07-27T23:01:36.868 [notice] Application connection exited: :stopped
2022-07-27T23:01:36.869 [notice] Application ecto exited: :stopped
2022-07-27T23:01:36.869 [notice] Application dataloader exited: :stopped
2022-07-27T23:01:36.869 [notice] Application comeonin exited: :stopped
2022-07-27T23:01:36.869 [notice] Application briefly exited: :stopped
2022-07-27T23:01:36.869 [notice] Application bcrypt_elixir exited: :stopped
2022-07-27T23:01:36.869 [notice] Application tesla exited: :stopped
2022-07-27T23:01:36.870 [notice] Application runtime_tools exited: :stopped
** (Mix) Could not start application explorer: Explorer.Application.start(:normal, []) returned an error: shutdown: failed to start child: Explorer.Chain.Events.Listener
    ** (EXIT) an exception was raised:
        ** (MatchError) no match of right hand side value: {:error, %Postgrex.Error{connection_id: nil, message: "ssl not available", postgres: nil, query: nil}}
            (explorer 0.0.1) lib/explorer/chain/events/listener.ex:15: Explorer.Chain.Events.Listener.init/1
            (stdlib 3.17) gen_server.erl:423: :gen_server.init_it/2
            (stdlib 3.17) gen_server.erl:390: :gen_server.init_it/6
            (stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3

I've fixed this in v 0.0.74 - Blockscout 4.1.5-beta and appears it needs an ECTO_USE_SSL=false env var as well now


Please VideocallAdapter too

For chat now have already adapter, can team build videocalladapter please

Hello @lordmen99. Yes, we are going to create videocall adapter approximately at the end of the first quarter of the year.

Great, i try integration with latest sdk, but make me confius. can help me with simple code for videocall??

Sure. What is your problem?

i want add, when user click icon videocall will direct make videocall . i try use already code, need load opponent etc.. its make too long.

You may have a look at Q-mun app. There are also implemented video calls peer to peer.


Confusing message about "type applications should start with a type atom"

I get the following error message from elm-make (0.16) when compiling the code following that.
-- TYPE MISMATCH ------------------------------------------------------ Main.elm

The type annotation for `update` does not match its definition.

17│ update : Users -> Action -> Users
             ^^^^^^^^^^^^^^^^^^^^^^^^
The type annotation is saying:

    Users -> Action -> Users

But I am inferring that the definition has this type:

    elm-make: type applications should start with a type atom

module Main (..) where

type alias Users =
  { users : List User
  }

type alias User =
  { name : String
  }

type Action
  = X (Result () List)

update : Users -> Action -> Users
update model action model =
  case action of
    X result ->
      case result of
        Ok users ->
          Users (List.map2 (+) model.users users)

That line with List.map2 is wrong but the error message is little help in determining that.
I have not been able to reproduce the problem with any program smaller than the above.

To me, that's not an issue of a confusing message. It's a proper compiler bug. See https://github.com/elm-lang/elm-compiler/issues/1326.

This case does have an error message very similar to that compiler issue. Should I close this issue and just leave it linked from that one?

I think that would make sense, yes.
Additionally, I just now realized that your code is not (only?) wrong in the List.map2 line. The first line of the update definition is bad in its own way:
update model action model =

Note the two parameters with same name. So this is also relevant: https://github.com/elm-lang/elm-compiler/issues/809.

For the record, it wasn't my code. I was helping someone who posted their uncompilable code as a Gist. We got that working but the original version caused the error message above.