Upgrade destroyed something

[esforim]

Thank I will check it out.

[crmclients]

My update to this saga is here for FYI:

https://forum.espocrm.com/forum/developer-help/111420-can-t-login-500-error-espo-core-application-not-found?p=112405#post112405

[emillod]

Please check troubleshooting section Troubleshooting - EspoCRM Documentation

[crmclients]

esforim thanks so much for relaying your experience, I can't seem to get pass the login, I'm also trying locally on my WAMP instance but still struggling, of course I just sent my client a bill and 4 days now with their training instance is still Error 500

ThomasB sent me a link couple days ago so I can move from the original version to the same version which was 7.5.6, instead of trying to upgrade but no luck, still getting an error, Something somewhere is not letting go of something.

I seems to remember renaming, a long time ago, a folder to at least let the login work, like an Admin login folder, doesn't make sense maybe it was a fluke..also having trouble going the install page route, php version issue probably, but i can roll back via cpanel issue but still error 500...

out of ideas...

[esforim]

I'm like you! I'm scare to touch anything at the moment and just praying I stay logged.

I did try to copy/paste hash over but that doesn't seem to fix it (I think). I tried 1-2 times and it fail.

But interesting, were you on 8.4.3? Seem like this upgrade got some hidden bug that causing Permission error? Hence the failure.

[crmclients]

telecastg this is great, however now that there is a new file "config-internal.php" where it looks like the salt/hash/crypt were moved to, can you think of any additional steps affecting logging in?

I "stay logged in" but as soon as the db finishes updating, Espo logs me out and I cannot get back in(500)

i did replace salt/hash/crypt and wondering if there is something else now that there is a new file?

the db looks good, i had exported earlier in another test using drop tables (i got an error with truncate version above)

there are some failed job errors I can't seem to disable trying to run via renaming a file etc, or disable it looking for the adv pack which i wont have with this new version and scheduled report jobs also probably from the advanced pack

tried also replacing "user" and "group" in the internal file

so close....any ideas?

[telecastg]

You're welcome

[punkyard]

it worked perfectly for me
thanks a lot !

[emillod]

No problem, take care

[Fehu]

Thanks! I backup daily but now that I have a dev version that will help in the future.

[emillod]

Fehu,
next time consider:
1. running upgrade on dev version of your espo;
2. creating a backup before upgrade.

Many things can happen and if you don't have a backup you will be frustrated in case something go wrong.

You can create simple backup by yourself using simple commands on your linux server(if you have e.g. windows server, you commands will be different):
1. Prepare folder where you'll store backups, for example: mkdir /tmp/backups, mkdir /tmp/backups/files
2. Copy files of your EspoCR using command: cp -r ~/domains/devcrm.it/ /tmp/backups/files
3. Copy mysql: mysqldump -u devcrm_it -p devcrm_it > /tmp/backups/database.sql

You can also backup your whole backup using simple command:
tar -cvf /tmp/backup.tar /tmp/backups

Backups should be store on another server(if something go wrong with your production server there will be an issue), but backups on same server are better than nothing

[Fehu]

Hi telecastg,

Thanks for the effort! It mostly worked. I have the second site running on another server with the correct data and updated to the current version. I really appreciate your help on this. I am going to reset the CRM and customizations tomorrow.

Thanks!
Marcus

[telecastg]

I don't have any answers regarding the blue line issue, but this is how I have "restored" my installation when something goes seriously wrong and I need to "go nuclear" and discard completely the current instance:

1) Install a local server, if you don't have one (I use xampp)

2) Download and install the newest Espo version into the local server

3) Login as admin to test the local setup and make any adjustments if necessary, stay logged in

4) Use phpMyAdmin to export the remote (online) database to an sql script - choose the options "create table if not exists" and "truncate table before insert"

5) Download the "custom/Espo/Custom/" folder and copy into your local installation

6) Download the "client/custom/" folder and copy into your local installation

7) Download and copy to your local installation, if applicable, any extension folders:
"application/Espo/Modules/{your-extension}/"
"client/modules/{your-extension}/"
"custom/Espo/Modules/{your-extension}/"
"client/custom/modules/{your-extension}/"

8) Download and copy the folder "data/upload" (which contains your attachments) into the local server

9) Download the "data/config.php" file and save in your local machine, NOT on the local server (VERY important since you will need to copy the crypt key information to be able to retrieve passwords, and want to save your current preferences like navbar setup, logo, etc for your new installation)

10) Compare the local server "data/config.php" created by the fresh installation with the old "data/config.php" that you downloaded and update the new script as required with the data from the old script - MAKE SURE to copy at least the following items form the old script: "'passwordSalt", "cryptKey", "hashSecretKey" and copy other sections like "tabList" that will replicate your preferences.

11) Use phpMyAdmin to import the sql script created in step 4 into your local database

12) Run rebuild in your local Espo instance or use terminal (CLI) and run the command php rebuild.php

13) Your local installation should be now a mirror of you remote installation, so you can debug and run any tests until it works as intended.

Once you are satisfied with the local installation performance you can follow these steps to "restore" the online instance

a) Delete the existing espocrm (or whatever name you chosen to hold the espo instance) folder and the espocrm database in your online server

b) Download and install online a fresh Espo instance

c) Test the new remote installation, without any customization, as admin user and do not logout

d) Upload folders "custom/Espo/Custom/", "client/custom" and "data/upload" from your local server to your online server

e) Upload any extension folders (see step 7 above) from your local server to your online server

f) Edit the remote data/config.php script to make the same changes that you did to the file at your local installation in step 9 above

g) Use phpMyAdmin to import the sql script created in step 10 into your remote database

h) Rebuild the online instance from the Admin GUI or if you have SSH (terminal) (CLI) access type using php rebuild.php

Cross your fingers (it's a joke :-) ) and you should have the newest version loaded online with your data and customization.

[Fehu]

This CRM is junk. I cannot modify anything! I attempted to rearrange the menu items and boom! Blue line of death!

This used to be a super solid CRM but now, if I can't get this fixed I have to move on. I can't keep backing it up every time I think about changing anything on it.

Anybody!?!

If no answers does anybody know the best way to save all my data so I can import into a newer version. I tried backing up certain tables and keeping all of my custom html folders but that's not working either.

The updates are meant to make things better, not destroy 1-2 years of work.

[tothewine]

it's "git status"