Dolibarr ERP & CRM » Bugs » bug #891
error add chargesociales to dictionaryLatest modifications
Answer now
Snapshot| Details |
| Submitted by: | David A. G. (braito) | | Submitted on: | 2013-05-08 15:29 |
| Last Modified On: | 2013-05-08 17:44 | |
| Summary: | error add chargesociales to dictionary |
| Description: | Tipo de gestor de base de datos: mysqli
Petición último acceso a la base de datos erróneo: SELECT a.id as rowid, a.code as code, a.libelle AS libelle, a.accountancy_code as accountancy_code, a.deductible, p.code as country_code, p.libelle as country, a.fk_pays as country_id, a.active FROM llx_c_chargesociales AS a, llx_c_pays as p WHERE a.fk_pays=p.rowid and p.active=1 ORDER BY country ASC, code ASC, a.libelle ASC LIMIT 1001
Código devuelto último acceso a la base de datos erróneo: DB_ERROR_NOSUCHFIELD
Información sobre el último acceso a la base de datos erróneo: Unknown column 'a.accountancy_code' in 'field list' |
| Step to reproduce bug: | |
| Version: | develop | | Category: | Module: Taxes |
| Severity: | 4 | | OS Type/Version: | |
| PHP version: | | | Database type and version: | |
| Status |
| Status: | Need more info | | Assigned to: | None |
| Resolution: | None | |
Comments- David A. G. 2013-05-08 17:57
- I know all the risks that's why I use the developer branch.
The point is, I don't know in what stage the database dropped the field, or even if It hadn't be created in any point; that's why i suggested to check the migration scripts, to avoid this issue. - Marcos García 2013-05-08 17:44
- Develop branch *should* not be used in a production environment as of its fast (and sometimes unestable) development. So... there's no need to create a script to check that. :/
- David A. G. 2013-05-08 17:41
- I have been updating dolibarr since 2 months ago to the developed branch... probably something got lost.
It would be interesting to add a script to check this things - Marcos García 2013-05-08 17:33
- Were you updating from a previous version or was it a fresh develop install?
(Try to speak in English so that the rest of the team/viewers understand you) - David A. G. 2013-05-08 17:30
- Spanish:
Hola Marcos. Estuve haciendo pruebas y resulta que me faltaba accountancy_code en llx_c_chargesociales.
No sé como pudo pasar. Mira si falta en algún script o si el sistema lo dropeó en alguna migración... sólo sé que lo añadí manualmente y ya funciona.
English (shorter version)
accountancy_code is missing in llx_c_chargesociales. I don't konw why. - Marcos García 2013-05-08 17:10
- It works fine for me. Can you try it with a fresh installation? Develop branch is frequently updated.
|
|
The point is, I don't know in what stage the database dropped the field, or even if It hadn't be created in any point; that's why i suggested to check the migration scripts, to avoid this issue.