7.8.30 upgrade fails at system check

📦 Install & Upgrade Help
1

After going through my old thread some years ago, I’m still not a bit further. I’d like to start this topic anew therefore:

PHP Settings:

  • Version: 7.4
  • upload_max_filesize: 512M
  • post_max_size: 512M
  • memory_limit: 512M
  • max_execution_time: 1500

UpgradeWizard.log shows:

Mon, 12 Aug 2024 11:38:32 +0200 [UpgradeWizard] - setting session variables...
Mon, 12 Aug 2024 11:38:32 +0200 [UpgradeWizard] - -----------------------------------------------------------------------------
Mon, 12 Aug 2024 11:38:32 +0200 [UpgradeWizard] - Upgrade started. At start.php
Mon, 12 Aug 2024 11:38:32 +0200 [UpgradeWizard] - at unlinkUWTempFiles()
Mon, 12 Aug 2024 11:38:32 +0200 [UpgradeWizard] - finished!
Mon, 12 Aug 2024 11:38:32 +0200 [UpgradeWizard] - resetting $_SESSION
Mon, 12 Aug 2024 11:38:55 +0200 [UpgradeWizard] - setting session variables...
Mon, 12 Aug 2024 11:38:55 +0200 [UpgradeWizard] - [At systemCheck.php]
Mon, 12 Aug 2024 11:38:55 +0200 [UpgradeWizard] - Starting file permission check...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Finished file permission check.
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Starting database permissions check...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking CREATE TABLE permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking INSERT INTO permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking SELECT permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking DELETE FROM permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Checking DROP TABLE permissions...
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - No permissions errors found!
Mon, 12 Aug 2024 11:40:21 +0200 [UpgradeWizard] - Finished database permissions check.

all other log-files don’t show anything about it.

There used to be some patches that were included in the release notes which are not available anymore sadly.
Also this hotfix was available but I don’t know how to apply it since my installation has not include/Imap folder

anyone with an idea?

2

can you please replicate the CRM to your local install and then try to do the update ?? So by this we will found if the errors are related to the server.

3

Good idea,
What are the steps to do this on a local machine?

  1. Copy the CRM Files
  2. Install MySQL and host the database
  3. Connect the database in config.php
  4. … how to I run the CRM then on localhost?
4

Just do the steps till point 3, you have to install xampp for windows prior to setup these things
and then you can access the system by

http://localhost/your-crm-folder-name

5

With doing so, I was fighting with different errors, that made it not very productive to work on my server installation.
Another question:
Can I just install a fresh version of the latest version 7 on my server and plug my database to it? would that break the data?

6

Well I tried what I posted.
The installation and connection to my copied db went on without any problems or errors.
However when logging in, the page looks like this:

Screenshot from 2024-08-24 12-03-55
Screenshot from 2024-08-24 12-03-55598×890 48.1 KB

7

it seems like their are permission issue.
Thanks

9

you are right, after settings permissions right, The page is shown correctly.

However the files/users/contacts were not imported at all, even though I set the backup of my database (from version 7.8.30) when installing the new copy of version 7.14.5.
During installation, the install wizard did not complain when entering the old database’s credentials.