Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update da tabela orgao no banco de dados do SEI sem WHERE #93

Open
cainafeitosa opened this issue Jul 30, 2024 · 1 comment
Open

Update da tabela orgao no banco de dados do SEI sem WHERE #93

cainafeitosa opened this issue Jul 30, 2024 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@cainafeitosa
Copy link

cainafeitosa commented Jul 30, 2024

Nos casos de ter mais de um órgão cadastrado no banco de dados o script sobrescreve todos os registros na coluna de siglas com a sigla definida, ao invés de sobrescrever somente no id_orgao = 0.

\$conexao->executarSql(\"update orgao set sigla='$APP_ORGAO', descricao='$APP_ORGAO_DESCRICAO'\");"

Sugestão:

update orgao set sigla='$APP_ORGAO', descricao='$APP_ORGAO_DESCRICAO' where id_orgao=0

@cainafeitosa cainafeitosa changed the title Update da tabela orgao no banco de dados do SEI sem id_orgao Update da tabela orgao no banco de dados do SEI sem WHERE Jul 30, 2024
@marlinhares marlinhares self-assigned this Aug 2, 2024
@marlinhares marlinhares added the bug Something isn't working label Aug 2, 2024
@marlinhares
Copy link
Contributor

Opa,

Lançada uma correção para esse bug.
Está na release 3.5.2

https://github.com/spbgovbr/sei-docker/releases

Ou então usar a branch main

https://github.com/spbgovbr/sei-docker

Verifica se resolve pra vc

Abcs

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants