Joomla-cms: [4.0] Blank Pages at Frontend and Backend after Fresh installation of Joomla on MySQL 8

[bosunski]

Steps to reproduce the issue

• Cloned fresh 4.0-dev branch
• Ran composer install and then npm install
• Ran Joomla Web installation as usual
• Tried to open either the Administrator or the Site

Expected result

I expect to see content both on the Frontend and backend like this:

Actual result

I saw a blank Page both on the Frontend and the Backend(Administrator) sides.

System information (as much as possible)

• MAC OSX Mojave 10.14.3
• PHP 7.2.15 and 7.3
• MySQL 8
• Node v10.15.2
• NPM v6.4.1

Additional comments

I noticed this when I turned on debugging for the one I installed on my Ubuntu Server and the One I have locally on my Mac OSX, here is the result:

[ghazal]

Everything worked fine for me today.
Using a mac too.
Try this:
git clone --depth=1 -b 4.0-dev https://github.com/joomla/joomla-cms/
composer install
npm ci
instead of
npm install

[joomla-cms-bot]

Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/24151

[ghost]

closed as unconfirmed Report. Please reopen if Issue persist.

@ghazal thanks for Investigation.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24151.}

[bosunski]

@ghazal Thanks.

The issues still persist after trying out @ghazal 's suggestion. Tried on 2 Macbooks, still same issue.

@ghazal What is your environment details?

[bosunski]

Do you have a similar environment like mine?
System information

• MAC OSX Mojave 10.14.3
• PHP 7.2.15 and 7.3
• MySQL 8
• Node v10.15.2
• NPM v6.4.1

[joomla-cms-bot]

Set to "open" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/24151

[ghost]

reopened as Issue persist.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24151.}

[ghazal]

My environment:
mac 10.12

node 11.10.0
npm 6.8.0
Composer version 1.8.4
All packagers installed and updated via Homebrew

iTerm instead of Mac Terminal

php 7.2.5
MySQL 5.7.22
Actually, I am using Bitnami MAMP stack, so I don't have to care about these versions.

[bosunski]

Based on what you just posted above, the only notable difference in our configuration is the MySQL versions, mine is v8 while yours is v5.7. Noticing that, I downgraded to v5.7 and everything works fine now.

It appears Joomla v4.0 might be having compatibility issues with MySQL v8.

Thanks, @ghazal and @franz-wohlkoenig 😅 for the time, I'm finally done with this battle after days!

[brianteeman]

Can this be re-opened please and change the title from (mac osx) to (mysql 8) as it definitely needs investigating

[bosunski]

Alright ... I'll do that.

[alikon]

@bosunski can you report back what it is present in your mysql 8 error.log please

[bosunski]

I didn't think of the error logs earlier as I already removed MySQL 8 and installed 5.7. I will install v8 again and get the error logs across.

[Quy]

Duplicate #22974?

[roland-d]

Does this need updating? https://docs.joomla.org/Joomla_and_MySQL_8

[Quy]

Close this as a known issue as there is a doc page for it?

[ghost]

closed as stated above; Issue can always be reopened.

[mbabker]

Actually, there should be one issue open somewhere tracking the progress of MySQL 8 compatibility in the CMS. Without that, items will be continually closed pointing to that docs page which gives the impression that Joomla is not making efforts to support MySQL 8 (hell it still doesn't fully support 5.7).

Closing items and pointing to a doc page generally comes across as "this is how Joomla works, here is the documentation reference explaining it".

[ghost]

Reopen Issue as comment by @mbabker stated above.

[Quy]

Closing in favor of #25452 as it has additional details.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24151.}