Upgrade suggestions wanted. Upgrading from version 3 to 16

Hello,

Don’t need to install version one by one, just install V16.
The installation script will then ask you to perform all the updates 4,5,6,…16

First do a backup!

Instructions can be found on the wiki.

Good luck

OH ok brilliant. Thanks man.

Ksar knows more than me super i have just read the other explanation

Ok wonderful, much appreciated.

Thank you for all your help guys, it was a success. The upgrade manager told me to go through all the 16 upgrades from 3.6 to 16 and it went well.

Small issue though, the new version has a few errors i was not able to fix, namely:

I get an error on the front page about access to a file that is restricted.
The profile user picture/avatar is huge and does not go away or stay in the top right corner.
The members list is broken.

Any ideas what might cause this?

I have attached images of all 3 problems in this window.


this is the error on the main page.

Hello,

The fatal error is due to the configuration of the Log module.
Try to deactivate it :

For the “big” picture, I think it’s a browser cache issue, try to reload page with Ctl+F5 or clear the browser cache

My version looks nothing like yours. I’m so confused.

ksar, turning off the module helps with some errors but isn’t it a permission issue we can fix differently in windows?

And how about the huge profile icon on the right side?

From my research it seems that the table:

llx_adherent_type

as changed.

Column “cotisation” was removed and “subscription”, “amount”, “morphy”, and “duration” were added.

But why is the query asking for “cotisation” in the image i uploaded in the new version of Dolibarr?

Hello,

This error seems indicate that you have old PHP files with new PHP files.
Try to remove all the PHP files and put back fresh V16 from archive

I tried 5 times, there is a bug with the update process. I tried it with a blank installation and still nothing.

Hello,

Unfortunately, it will be difficult to guide you through a forum.
Maybe you can contact a dolibarr partner to help you on that?

After 2 days of not sleeping i found the table causing the issue llx_const

I am not sure i can tell what is causing that issue but that is for sure the culprit.

When i load that table it crashes the entire application. I can send it to you if you are curious.

Upgrading from such an ancient Dolibarr version has some challenges but they are manageble if you have the patience to upgrade using all the older versions for migration and NOT to upgrade with only the latest PHP-code. In the historic chain of upgrades some some erros exist.
We have done various migrations (v3.4.2 & up) several times succesfully and might be able to help you.
Just send a SQL-script of the original database and we will give it a try to help you out.

What is your email? Please shoot me one here: nicolas.zein at zeintek dot com

thank you so much.

The database backups seem to have been corrupted due to encoding issues so i am not sure what we can do. Let’s discuss this.

Hello Nicolas,

I think the problems are theme related. As you know the “Eldy” theme is the only official supported skin for the application. And after changing some data in the table “llx_const” (without truncating all the data), the application seems to work. But since I only got a SQL backup file, the external modules like the Patas tools and LDAP obviously don’t work.
When you have a look at https://union.dolibar.nl/ this represents the current state of the UI.
As an administrator you should be able to backup the database and restore it in your environment.
Hopefully you can continue working with this Dolibarr instance.

Brilliant it looks better than my version. I don’t see the table data to compare it to mine. Much appreciated. I have a list of upgrades we need to do, this would segway into a paying contract since you were so helpful. Thanks so much Theo.

No problem Nicolas. What you can do is take the table structure from a fresh v16.0.3 installation and generate a SQL backup on https://union.dolibar.nl/ [Admin Tools → Backup] and compare those two files. This should give you the correct information about differences in the data.
Btw: The SQL-backup can be restored on your Dolibarr V16.0.3 and will work correctly.

I’m confused. How do i login Theo? LDAP does not work on your instance. There is no way for me log in.