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

Bug: SQL error when renaming bank statement #17476

Closed
WimpyMan opened this issue May 3, 2021 · 0 comments
Closed

Bug: SQL error when renaming bank statement #17476

WimpyMan opened this issue May 3, 2021 · 0 comments
Labels
Bug This is a bug (something does not work as expected)

Comments

@WimpyMan
Copy link
Contributor

WimpyMan commented May 3, 2021

Bug

SQL error when renaming bank statement

Environment

  • Version: 13.0.2
  • OS: Debian 10
  • Web server: Apache/2.4.46 (Debian)
  • PHP: PHP 7.4.16
  • Database: psql (PostgreSQL) 13.2 (Debian 13.2-1)
  • URL(s): /dolibarr/compta/bank/releve.php?account=1

Expected and actual behavior

When clicking on the pencil button, and changing the name, nothing happens.
It should change the name.

The logs indicate:

LOCATION:  errorMissingColumn, parse_relation.c:3504 (DB_ERROR_NOSUCHFIELD)
2021-05-03 17:11:38 ERR     10.0.10.56      DoliDBPgsql::query SQL Error usesavepoint = 0
2021-05-03 17:16:59 ERR     10.0.10.56      DoliDBPgsql::query SQL Error query: UPDATE llx_bank SET num_releve = "2021/01" WHERE num_releve = "2021/1" AND fk_account = 1
2021-05-03 17:16:59 ERR     10.0.10.56      DoliDBPgsql::query SQL Error message: ERROR:  42703: column "2021/1" does not exist
LINE 1: ...ank SET num_releve = "2021/01" WHERE num_releve = "2021/1" A...

Running the SQL command in the PostgreSQL cli, the issue becomes clear: The string value should be between single quotes ', and not double quotes ".

Steps to reproduce the behavior

See previous point

@WimpyMan WimpyMan added the Bug This is a bug (something does not work as expected) label May 3, 2021
eldy added a commit that referenced this issue May 3, 2021
FIX #17476 releve.php: Fix SQL statement
@eldy eldy closed this as completed in 7065450 May 3, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug This is a bug (something does not work as expected)
Projects
None yet
Development

No branches or pull requests

1 participant