Open EMR 7.0.4 Fresh installation SQL issue

Situation
Describe your problem here

OpenEMR Version
I’m using OpenEMR version: 7.04

Browser:
I’m using:Google Chrome

Thank you all for your dedicated time to upgrade the new realse. please note that I tried to make fresh install and get stuck in this page. anyone have a solution. thanks in advance.

How did you install openemr?
Any logs?

I have the same problem on Rocky Linux 9.7 whit nginx, tell me if you have a similar distro so I can look for the error. This is my nginx log:

2025/12/30 13:26:00 [error] 755#755: *105649 FastCGI sent in stderr: “PHP message: PHP Warning: Undefined array key “collate” in openemr/setup.php on line 1129; PHP message: PHP Fatal error: Uncaught TypeError: Installer::collateNameIsValid(): Argument #1 ($name) must be of type string, null given, called in openemr/setup.php on line 1129 and defined in openemr/library/classes/Installer.class.php:177
Stack trace:
#0 openemr/setup.php(1129): Installer->collateNameIsValid()
#1 {main}
thrown in openemr/library/classes/Installer.class.php on line 177” while reading response header from upstream, client: 104.23.237.86, server: uriarte.ar, request: “POST /openemr/setup.php?site=default HTTP/2.0”, upstream: “fastcgi://unix:/run/php-fpm/www.sock:”, host: “xxxxx.xx”, referrer: “https://xxxxxx.xx/openemr/setup.php?site=default”

@moussa cpanel I am not sure about the linux OS but i have bean installing old version on the same hosting company. i am trying to find any error log but i was not able to find it all i can see from the dev tool via browser is nothing is the css file.

this is my first time facing this issue all the old issue over the old version i was able to fix thim

What are you selecting for collate? I don’t see how a non-string is passed in to the collate verifier.

Hi jerry so during installation when i set the SQL infomration it states conctcted then it shows a blank page

I’m not passing any values. I’m doing it with a pre-existing database. I’ve always created them with charset utf-8mb4, collation utf8mb4_general_ci

yep but if I remember right step 4 or 5 asks for collation however maybe not if database exists.

@luisuriarte This holds a potential fix if you want to test. Just use the installer class. Title is deceiving.

@sjpadgett I’ll try it, either by creating a database in the new installation or by choosing one. I’ll let you know.

I made the changes in Installer.class.php, and I’ve tried it both ways: creating a new database and using an existing one. I’m getting a timeout error. The tables are created. My server is behind Cloudflare

I don’t know how to approach helping here beyond what I’ve provided. I think though I’ll turn on my user debugger if I can for the setup for future.

Any new or the same errors on fail?

Did past versions work or is this new to 7.0.4. I’m running out of time to get a fix out in v8.0.0 if we have one.

I can’t find the error. I tried versions 7.0.3 and 7.0.4, and they both time out. In version 7.0.3, all the tables are created, and then it times out. In version 7.0.4, it doesn’t manage to create all the tables and times out. The server is Ubuntu 34.04.3 tls, PHP 8.3.6, MariaDB version 15.1, distribution 10.11.13-MariaDB, for debian-linux-gnu, and Nginx version 1.24.0 (Ubuntu). Don’t worry, it might be the configuration of some servers. I’ll keep investigating. Updates work perfectly.

Thanks, please update us here if you see the issue and maybe something we can look out for.