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

Members export fails #2712

Closed
matlopes opened this issue Apr 25, 2015 · 4 comments
Closed

Members export fails #2712

matlopes opened this issue Apr 25, 2015 · 4 comments
Assignees
@rdoursenaud
Labels
Priority - Medium Bug or Expected functionality. If bug, a feature may be blocked but a workaround is found easily.

Comments

@matlopes
Copy link

Adherent export gets an error at step 3:
Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic:
Date: 20150425142146
Dolibarr: 3.7.0
Niveau de fonctionnalités: 0
PHP: 5.5.9-1ubuntu4.9
Serveur: Apache/2.4.7 (Ubuntu)
OS: Linux dell 3.13.0-49-generic #83-Ubuntu SMP Fri Apr 10 20:11:33 UTC 2015 x86_64
UserAgent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:37.0) Gecko/20100101 Firefox/37.0

Url sollicitée: /extranet/www/exports/export.php?step=3&datatoexport=adherent_1
Referer: http://localhost/extranet/www/exports/export.php?step=2&datatoexport=adherent_1&action=selectfield&field=all
Gestionnaire de menu: eldy_menu.php

Type gestionnaire de base de données: mysqli
Requête dernier accès en base en erreur: SELECT rowid as rowid, libelle as label FROM llx_fk_adherent_type
Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHTABLE
Information sur le dernier accès en base en erreur: Table 'extranet.llx_fk_adherent_type' doesn't exist

Final error is:
Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic:
Date: 20150425141732
Dolibarr: 3.7.0
Niveau de fonctionnalités: 0
PHP: 5.5.9-1ubuntu4.9
Server: Apache/2.4.7 (Ubuntu)
OS: Linux dell 3.13.0-49-generic #83-Ubuntu SMP Fri Apr 10 20:11:33 UTC 2015 x86_64
UserAgent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:37.0) Gecko/20100101 Firefox/37.0

Url sollicitée: /extranet/www/exports/export.php?step=5&datatoexport=adherent_1
Referer: http://localhost/extranet/www/exports/export.php?step=5&datatoexport=adherent_1
Gestionnaire de menu: eldy_menu.php

Message: Bad value for field with code=a.civilite. Try to redefine export.
@eldy
Copy link
Member

eldy commented Apr 25, 2015

Did you used an old predefined export with a previous versious version ?
You probably have to redefine it.

@matlopes
Copy link
Author

Maybe i did. I don't know.

This time, i just checked "all fields", at step 2, not using any predefined export.

Here's what i get at step 3, at the "Type d'adhérent Id type adhérent" [fr] line:

Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic:
Date: 20150426170739
Dolibarr: 3.7.0
Niveau de fonctionnalités: 0
PHP: 5.5.9-1ubuntu4.9
Serveur: Apache/2.4.7 (Ubuntu)
OS: Linux dell 3.13.0-49-generic #83-Ubuntu SMP Fri Apr 10 20:11:33 UTC 2015 x86_64
UserAgent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:37.0) Gecko/20100101 Firefox/37.0

Url sollicitée: /extranet/www/exports/export.php?step=3&datatoexport=adherent_1
Referer: http://localhost/extranet/www/exports/export.php?step=2&datatoexport=adherent_1&action=selectfield&field=all
Gestionnaire de menu: eldy_menu.php

Type gestionnaire de base de données: mysqli
Requête dernier accès en base en erreur: SELECT rowid as rowid, libelle as label FROM llx_fk_adherent_type
Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHTABLE
Information sur le dernier accès en base en erreur: Table 'extranet.llx_fk_adherent_type' doesn't exist

If I ignore this message and continue further, export file generation (Excel 95, but same goes with other filetypes) fails without any error message (blank page).

@matlopes matlopes changed the title Adherent exports buggy Bug: Adherent exports fails Apr 26, 2015
@rdoursenaud
Copy link
Contributor

fk_adherent_type is a field from llx_adherent not a table. Strange error…

@rdoursenaud rdoursenaud added the Priority - Medium Bug or Expected functionality. If bug, a feature may be blocked but a workaround is found easily. label Apr 30, 2015
@rdoursenaud rdoursenaud changed the title Bug: Adherent exports fails Members export fails Apr 30, 2015
@rdoursenaud rdoursenaud self-assigned this Apr 30, 2015
rdoursenaud added a commit to GPCsolutions/dolibarr that referenced this issue Apr 30, 2015
@rdoursenaud
Fixed SQL table reference for members types in export
afc582a 
FIX Dolibarr#2712
@rdoursenaud rdoursenaud mentioned this issue Apr 30, 2015
Merged
@matlopes
Copy link
Author

matlopes commented May 1, 2015

The fix works perfectly. Thanks

@simnandez simnandez added this to the 3.7.1 milestone May 1, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rdoursenaud rdoursenaud

Labels
Priority - Medium Bug or Expected functionality. If bug, a feature may be blocked but a workaround is found easily.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@simnandez @eldy @matlopes @rdoursenaud