CiviCRM could not create trigger
Overview
Please describe your problem or bug in detail. Installation of version 5.69.0 on a fresh Ubuntu install with WordPress.
-
I used this link to setup Wordpress on Ubuntu:
https://ubuntu.com/tutorials/install-and-configure-wordpress#1-overview
-
I followed this set of instructions to install CiviCRM:
-
When I go to the installation/setup wizard I add the credentials for the database I created (separate from WP database and the user has grant all and specifically grant trigger on civicrm.*). I did destroy the VM and build a second time with same steps and results.
If you have already posted on https://civicrm.stackexchange.com or https://chat.civicrm.org, please include the link to that conversation.
I have not posted there, but I see older posts regarding this on previous versions. None of those offer a valid solution for this present issue,
Reproduction steps
- Click on Contacts -> New Individual.
- Entered First Name and Last Name and clicked Save.
- Got an error "Fatal error: DB error".
Current behaviour
The setup stops after DB connect and reports unable to create triggers.
What happens currently. Please provide error messages, screenshots or gifs (LICEcap, SilentCast) where appropriate.
TIP: The best way to convey an error message is to copy it in here and use
three backtick ` symbols. You may edit the message to remove private
information (like passwords). The backticks will help to preserve any
special characters or spaces.
Expected behaviour
What should happen.
I should pass through the setup screen and have a functioning CiviCRM install.
Environment information
Ubuntu 20.04 MySqlD 8.0.35 Php 8.2.4 Apache2 2.4.41 CiviCRM 5.69.0
- Browser: Firefox 59.0.1/Chrome 78.0.3904/Safari 13
- CiviCRM: Master/5.20.0/5.19.1/5.18.2/...
- PHP: 7.0/7.1/7.2/7.3/..._
- CMS: Backdrop 1.5/Drupal 7.30/Joomla 3.3/WordPress 4.5/...
- Database: MySQL 5.7.7/MariaDB 10.4/...
- Web Server: Apache 2.4/Nginx 1.16/...
Comments
Anything else you would like the reviewer to note.
Thank you,
Karl Tatgenhorst