Error 500 Saving -> Proffesional ID in settings

Hi!

I get some internal 500 server errors when trying to save here and there.
I just updated to 8.0.2 and are happy too see many things now are working much better - e.g. search for products in purchase orders.

But back to the internal 500 error warning.

I am trying to save Company information -> Edit -> Professional ID 1
- Returns 500 server error.

The same goes for dictionary, when trying to click on that in the settings:
- Returns 500 server error.

I am not sure this is a bug, but maybe some 0644 / 0755 issues. Although I am not sure where to start looking.

Going through server error logs, it doesn’t show anything.

Anyone have any suggestions?

Hi Roger,
I don’t get these errors. Thus it should be specific to your installation.
Error 500 are in general reported in apache logs, if you use apache.
Perhaps you get them in /var/log/apache2/error_log according to the configuration of your webserver.

Hello

Thanks for posting.

Kindly post (here) your Dolibarr setup environment as suggested in the [url=www.dolibarr.org/t/post-guidelines/16873/1 Guidelines[/url]. This will greatly help the community in assisting you where possible.

To improve Dolibarr community engagement, you are also strongly advised to update your profile details to include your location and gender.

Thanks, I have updated the location and gender now.

DOLIBARR ENVIRONMENT
- Version: [8.0.2
- Operating System: CloudLinux 7
- Web Server: LiteSpeed
- PHP: [7.0]
- Database: 10.2.17-MariaDB-cll-lve - MariaDB Server
- URL(s):
/admin/company.php?action=edit (When pressing SAVE)
/admin/dict.php?mainmenu=home (when trying to visit)

Those are the two I found so far.

Thank you very much for trying to help me solve.

I have checked a lot of logs, searched for “dolibarr” in those logs, but none of them contains anything noticeable.

In my dolibarr root category there is an errorlog, but this is empty.
In my /var/ directory there is no logs.
In my /public_html/ I also find one, but this contains only error logs from my prestashop installation.
In my / absolutely root-category there is also one, this is empty.

Could it be that the installation is bad of some sort?

What happened is that I suddenly needed an ERP really fast a couple of years go. Did a quick google search, found Dolibarr (Thank God), and tested it the quickest way possible -> Using Softaculous from cPanel.

Dolibarr was fantastic, and since I was already 2-3 days behind, I just started using it
 as it was. Never bothered to uninstall it, and do the installation myself.

So it is still a Softaculous installation. And when I updated it yesterday, I had to update it using Softaculous.

Would this work:

  1. Backup my DB.
  2. Delete all
  3. Install it manually using cPanel filemanager + unzip files.
  4. Restore DB backup`

Or could this be dangerous for the future?

And again - thank you very much for helping me out - I know it takes a lot, sitting in a different country even, trying to help someone you don’t know if are able to (or motivated) to receive the help. In my case I am :wink: Just wanted to let you know I appreciate the help.

I am no programmer, but I should manage to make this work if I knew where to look.

1 Like

We’re all here to help Roger and whilst Dolibarr isn’t perfect, it still is the most flexible ERP for most professions in the business world I would say.

I would personally do that yes. Once you restore the db backup, you will be prompted for a database upgrade. Remember, there is no way to downgrade the database after though. Also, in terms of product pictures or logos for thir parties etc, remember to keep or copy over the ‘documents’ folder. I think thats where it all is.

I’m no programmer either, but in the open source world, I believe thoughts and time create solutions which help each other.

Best of luck :happy:

Thank you!

It took me a while to man up to trying a re-install. LUCKILY I did backup everything - and I needed it this time.

Problem seems to be, that after the upgrade, it added all the dolibarr-files to /dolibarr/htdocs/ as well as it kept the ones in /dolibarr/
This is of course a huge problem all together, because it now reports duplicates of all modules and all files. And especially since I don’t know which ones it actually uses. Thanks to previous experience with web and software, I took a backup of absolutely everything, and I am now able to log in and have a semi-working function, so I at least can keep business going.

But still I need to find a way to /delete all once again, and somehow be able to reinstall and copy the contents of the database over to the new installed one.
Maybe I can try some export of the one I have now, and the import it all to the new one?

Does anyone have any time leftover, and are willing to help me for some $$? You really need to know what you are doing though - I don’t hand out this job to whomever :wink:

Except that the export tool of course gives a 500 error


Hello

Glad you got ‘something’ working, but please clarify the current issues you’re facing. Are you saying you have two installations? under the same folder? or two databases?

There seems to be two installations / two sets og files.
Only one db.

Softacalous made it this way after the update to 8.0.2

Ok, this topic can now be marked as closed.

If you are interested in what happened, and what I did to fix the 500 Server errors, here it is:

In the update-process I did not understand that I should only copy from htdocs to my root category of dolibarr installation. So it kept all the original files under /dolibarr/ and then installed a new version on /htdocs/. (Maybe dolibarr should make this a little clearer)

I manually uploaded all new files in the .zip for the newest version and made them overwrite the current ones in /dolibarr/.
Then I deleted all files from /htdocs/ and checked the install -> it actually worked without 500 errors now.

New backup of DB / sql_dump.
then I opened my sql dump in notepad++ and ran a search&replace for the prefix llx_ to erp_ (just for the fun of it, never understood the llx anyway.))

Then a /Delete_All from webserver and mysql

New install, with new DB on the mariaDB database - set up in cpanel.
phpmyadmin -> delete ALL tables in the newly installed database
Then I ran my sql_dump with erp_ prefixes - and voila’

All good now!
Now I feel lucky, hope it will work tomorrow when we will ship some pallets from our warehouse.