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.

Sign up for GitHub

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

Jump to bottom

Broken Quotation and Bills management #16143

Closed
ajussak opened this issue Feb 2, 2021 · 0 comments
Closed

Broken Quotation and Bills management #16143

ajussak opened this issue Feb 2, 2021 · 0 comments
Labels
Bug This is a bug (something does not work as expected)

Comments

@ajussak
Copy link
Contributor

ajussak commented Feb 2, 2021 •
edited

Bug

Date: 20210202101758
Dolibarr: 13.0.0 - https://www.dolibarr.org
Niveau de fonctionnalités: 0
PHP: 7.3.26
Server: Apache/2.4.46 (Unix)
OS: Linux 8ee38bcddffc 5.4.79-v7l+ #1373 SMP Mon Nov 23 13:27:40 GMT 2020 armv7l
UserAgent: Mozilla/5.0 (X11; Linux x86_64; rv:85.0) Gecko/20100101 Firefox/85.0

Url sollicitée: /comm/propal/card.php?id=34&action=classifybilled&socid=12
Referer: https://dolibarr.wascar.net/comm/propal/card.php?id=34&save_lastsearch_values=1
Gestionnaire de menu: eldy_menu.php

Modules/Applications: user, propal, contrat, ticket, ficheinter, supplier_proposal, tax, prelevement, banque, projet, automicroent, comptabilite, multicurrency, facture, fournisseur, resource, societe
Type gestionnaire de base de données: pgsql
Requête dernier accès en base en erreur: UPDATE llx_ecm_files SET ref = '17d9735d7cb16ba0b08dfb9dae3baf15', label = '03d0a684e91f155be6fd07deb1964af2', share = null, entity = 1, filename = 'PR2007-0030.pdf', filepath = 'propale/PR2007-0030', fullpath_orig = '', description = '', keywords = null, cover = null, position = 1, gen_or_uploaded = 'generated', extraparams = null, date_c = '2020-07-17 14:20:58', fk_user_m = 1, acl = null, src_object_id = 34, src_object_type = 'propal' WHERE rowid=193
Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHFIELD
Information sur le dernier accès en base en erreur: ERROR: 42703: record "new" has no field "date_m"\nCONTEXT: PL/pgSQL function update_modified_column_date_m() line 1 at assignment\nLOCATION: exec_assign_value, pl_exec.c:5199

Environment

  • Version: [13.0]
  • OS: [Debian 10]
  • Web server: [Apache/2.4.46]
  • PHP: [PHP 7.3.26]
  • Database: [PostgreSQL 12.5 (Debian 12.5-1.pgdg100+1)]
  • URL(s): [/comm/propal/card.php?id=34&action=classifybilled&socid=12]

Steps to reproduce the behavior

Trying to classify a quote as billed or validate an bill or quote
@ajussak ajussak added the Bug This is a bug (something does not work as expected) label Feb 2, 2021
@ajussak ajussak changed the title Broken Quotation management Broken Quotation and Bills management Feb 2, 2021
eldy added a commit that referenced this issue Feb 8, 2021
@eldy
Merge pull request #16222 from WascarDev/13.0
9a9686e 
FIX #16143
@ajussak ajussak closed this as completed Feb 8, 2021
eldy pushed a commit that referenced this issue Mar 20, 2021
@bugness-chl
FIX #16143 Old PG requires "()" on DROP FUNCTION
6cf970d 
On PostgreSQL 9.6 and previous, the upgrade script fails with a syntax
error if the dropped function's name is not followed by parentheses.

Patch tested on 9.6 and 13.2.
eldy added a commit that referenced this issue Mar 20, 2021
@eldy
Merge pull request #16820 from bugness-chl/develop
7565937 
FIX #16143 Old PG requires "()" on DROP FUNCTION
eldy pushed a commit that referenced this issue Mar 20, 2021
@bugness-chl @eldy
FIX #16143 Old PG requires "()" on DROP FUNCTION
36baf9b 
On PostgreSQL 9.6 and previous, the upgrade script fails with a syntax
error if the dropped function's name is not followed by parentheses.

Patch tested on 9.6 and 13.2.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug This is a bug (something does not work as expected)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ajussak