Latest version local installation
I just downloaded the latest community version and trying to install it on my local machine to evaluate the application. I'm running on Mac and when I start the application I get error messages during database setup complaining about the migration script as follow:
SQL State : 42000
Error Code : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDEX `FK_m_tracker_bug_5` TO `FK_m_prj_bug_5`' at line 1
Location : db/migration/mysql/V20190325_1__Custom_Fields.sql (/Users/nxlabs/Downloads/MyCollab-7.0.2/file:/Users/nxlabs/Downloads/MyCollab-7.0.2/lib/mycollab-migration-7.0.2.jar!/db/migration/mysql/V20190325_1__Custom_Fields.sql)
Line : 34
Statement : ALTER TABLE `m_prj_bug` RENAME INDEX `FK_m_tracker_bug_5` TO `FK_m_prj_bug_5`
Considering this is an installation script and I don't have any initial database to be upgraded I'm not sure what I can do to resolve this. I've removed all tables and tried running the installation script a few times and each time it breaks on the same spot. I'm running XAMPP 7.3.0 with MySql info as follow:
- Server: Localhost via UNIX socket
- Server type: MariaDB
- Server connection: SSL is not being used
- Server version: 10.1.37-MariaDB - Source distribution
- Protocol version: 10
- User: root@localhost
- Server charset: UTF-8 Unicode (utf8)
Customer support service by UserEcho
Could you check with MySQL version? We tested it run well on MySQL and we don't support other databases at this moment.
what version of mysql you support?
MySQL version from 5.6 to 8
I'm using version mysql 8 and I posted the error message, it's totally up to you to take a look or ignore.