# Upgrade suggestions wanted. Upgrading from version 3 to 16 **URL:** \ **Category:** Maintaining my Dolibarr\ **Created:** [January 11, 2023, 4:55pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237 "2023-01-11T16:55:12Z")\ **Posts on this page:** 15\ **Page:** 2
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 19, 2023, 3:13am UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/21 "2023-01-19T03:13:06Z")
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. ---
**Author:** ![TJ1](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/tj1/32/3565_2.png) [@TJ1](https://www.dolibarr.org/forum/u/TJ1)\ **Post date:** [January 22, 2023, 4:19pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/22 "2023-01-22T16:19:26Z")
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. ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 22, 2023, 4:55pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/23 "2023-01-22T16:55:55Z")
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. ---
**Author:** ![TJ1](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/tj1/32/3565_2.png) [@TJ1](https://www.dolibarr.org/forum/u/TJ1)\ **Post date:** [January 23, 2023, 8:24pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/24 "2023-01-23T20:24:18Z")
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/](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. ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 23, 2023, 9:54pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/25 "2023-01-23T21:54:05Z")
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. ---
**Author:** ![TJ1](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/tj1/32/3565_2.png) [@TJ1](https://www.dolibarr.org/forum/u/TJ1)\ **Post date:** [January 24, 2023, 9:39am UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/26 "2023-01-24T09:39:37Z")
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/](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. ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 24, 2023, 1:03pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/27 "2023-01-24T13:03:14Z")
I’m confused. How do i login Theo? LDAP does not work on your instance. There is no way for me log in. ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 24, 2023, 1:05pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/28 "2023-01-24T13:05:13Z")
Can you please send the phpmyadmin sql export for that llx\_const table manually? ---
**Author:** ![TJ1](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/tj1/32/3565_2.png) [@TJ1](https://www.dolibarr.org/forum/u/TJ1)\ **Post date:** [January 24, 2023, 4:36pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/29 "2023-01-24T16:36:39Z")
I expected you to have credentials to login. Dolibarr authentication is active so you should be fine. Just sent you an admin login. ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 24, 2023, 7:17pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/30 "2023-01-24T19:17:31Z")
Very kind of you. Thank you Theo. ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 24, 2023, 8:51pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/31 "2023-01-24T20:51:17Z")
Unfortunately your version is corrupted like mine. If you look carefully when you navigate to the user icon on the top right you can no longer have the options show up to logoff or see your users options. ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 24, 2023, 11:47pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/32 "2023-01-24T23:47:56Z")
So there was an error with these 2 modules: MAIN\_MODULE\_EXTERNALRSS MAIN\_OPTIMIZEFORTEXTBROWSER rss had to be turned removed from the migration and optimize had to be turned off has it was the reason the avatar was buggy. The Theme also had to be reset to eldy by default before the migration. Thank you guys for your help. ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 25, 2023, 7:00am UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/33 "2023-01-25T07:00:12Z")
And more importantly the salt and encryption variables which i can’t remember right now. But those were critical. ---
**Author:** ![TJ1](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/tj1/32/3565_2.png) [@TJ1](https://www.dolibarr.org/forum/u/TJ1)\ **Post date:** [January 25, 2023, 7:50am UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/34 "2023-01-25T07:50:08Z")
> [@nicolaszein](#): > > corrupted Corrupted is not the correct word because the SQL-file is congruent and (re)usable. The llx\_const table just held some theme-data (Business) which we changed to the “Eldy” theme. A simple diff of the content and the data of a fresh installation would have set you on the right track for completion as we mentioned before, I’m glad that your problem is solved, ---
**Author:** ![nicolaszein](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nicolaszein](https://www.dolibarr.org/forum/u/nicolaszein)\ **Post date:** [January 25, 2023, 12:40pm UTC](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237/35 "2023-01-25T12:40:55Z")
Ok gotcha Theo. Much appreciated. I am opening a new ticket as I now have an error related to tables that are present but that the Eldy theme does not seem to be able to find. [Previous page](https://www.dolibarr.org/forum/t/upgrade-suggestions-wanted-upgrading-from-version-3-to-16/23237.md?page=1)