Database

Once you are logged in your hosting provider panel, you should look for section named Databases in order to create a new database.

Please take note of the following information while creating the database:

  • The host name

  • The database name

  • The database username

  • The database password

Make sure that the sql_mode system variable does not contain ONLY_FULL_GROUP_BY as this is not compatible with Eventic

You can either remove the ONLY_FULL_GROUP_BY manually by:

  • Open up PhpMyAdmin

  • Click on the Variables menu

  • Scroll down to sql mode

  • Click on the edit button and change the value by removing ONLY_FULL_GROUP_BY

  • Click on save

Or by executing the following sql query:

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Your database password should not contain the @ character , otherwise the connection won't work successfully

Last updated