search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.46k stars 2.79k forks source link

Bug: #25079

Closed Pyhot closed 4 months ago

Pyhot commented 1 year ago

Hello,

We are working with Dolibarr since v5.0.4. It’s a very good ERP and we like it. Congratulation to developers !

We have done all upgrades up to 17.0.2 but now, it is a big mess in our SQL (due to old External Modules with their specific tables and columns remaining everywhere).

So we would like to re-start from a clean install, and insert all our datas (customers, products, stock, GPAO, etc). Fresh install is ready.

The question is :

-> how to be sure to import all datas with all links, foreign keys, … to be sure nothing will break or be instable ? We tried several ways, but ...

Problems observed :

1- some tables structures are very different from 5.0.4. to 17.0.2 (number, names and place of several columns)

So when doing Backup from Dolibarr + import in all table in new SQL, this generate [error #1054 - Unknown column (…) in 'Field List'] !

2- when doing export from Dolibarr => import to Dolibarr, … it’s VERY difficult to map. Names / fields are too much different.

3- we also tried Export in TVS, but Import in TVS is not available… (Bug ?)

4- and if we go trough Restauration process, it will create the SAME tables as old version (corresponding to old uninstalled external modules, I guess )

So it will a great help if somebody could tell us : the safe procedure to Insert all our datas in newly installed Dolibarr.

Thanks in advance,

Instructions

This is a template to help you report good issues. You may use Github Markdown syntax to format your issue report. Please:

Bug

[Short description]

Environment

Expected and actual behavior

[Verbose description]

Steps to reproduce the behavior

[Verbose description]

Attached files (Screenshots, screencasts, dolibarr.log, debugging informations…)

[Files]

Report

ksar-ksar commented 1 year ago

Hello,

The only way is to try to remove as much as possible all the fields from the external module, then do the upgrade.

github-actions[bot] commented 5 months ago

This issue is stale because it has been open 1 year with no activity. If this is a bug, please comment to confirm it is still present on latest stable version. if this is a feature request, please comment to notify the request is still relevant and not yet covered by latest stable version. This issue may be closed automatically by stale bot in 10 days (you should still be able to re-open it if required).