# Historico: erros "Unread result found" abaixo = bug antigo (dois SELECT no mesmo cursor sem ler o primeiro).
# Correcao aplicada em app.py em api_casa_listar_itens (um SELECT por vez + cursor buffered=True).
# Se voltar erro novo, aparece apos esta linha. Reinicie o app para carregar o app.py atualizado.

============================================================
2026-05-13 18:24:46 [api_casa_listar_itens]
nropedido=100
id_cliente_session=2001
request.args={'modo': 'recuperacao', 'origem': 'DELIVERY'}
InternalError: InternalError(-1, 'Unread result found', None)
Traceback (most recent call last):
  File "C:\Users\user\Desktop\Projetos_em_andamento\_Mexendo\LojaOnline\app.py", line 1049, in api_casa_listar_itens
    cur.execute(
    ~~~~~~~~~~~^
        """
        ^^^
    ...<6 lines>...
        (nropedido, id_cliente, origem_req),
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Python313\Lib\site-packages\mysql\connector\cursor.py", line 538, in execute
    self._connection.handle_unread_result()
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
  File "C:\Python313\Lib\site-packages\mysql\connector\connection.py", line 1548, in handle_unread_result
    raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found


============================================================
2026-05-13 18:27:16 [api_casa_listar_itens]
nropedido=100
id_cliente_session=2001
request.args={'modo': 'recuperacao', 'origem': 'DELIVERY'}
InternalError: InternalError(-1, 'Unread result found', None)
Traceback (most recent call last):
  File "C:\Users\user\Desktop\Projetos_em_andamento\_Mexendo\LojaOnline\app.py", line 1089, in api_casa_listar_itens
    cur.execute(
    ~~~~~~~~~~~^
        """
        ^^^
    ...<6 lines>...
        (nropedido, id_cliente, origem_req),
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Python313\Lib\site-packages\mysql\connector\cursor.py", line 538, in execute
    self._connection.handle_unread_result()
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
  File "C:\Python313\Lib\site-packages\mysql\connector\connection.py", line 1548, in handle_unread_result
    raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found