I am trying to run the initial installation of e107. The initial database check works, it says its connected and verified, and the checklist has all green ticks. Once its done there's a "click here" to finish the installation, but it then hits the following error:
The installer could not select database: 'bfgel-v4h-u-097306'
MySQL Reported Error:
SQLSTATE: Syntax error or access violation: 1064 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 '-v4h-u-097306' at line 1
I am guessing theres some conflict between my hosting DB version/type/something and e107, but thats a wild guess really. I've deleted the DB and created fresh ones a couple of times, but that doesnt work. Same error.
I am hosting with 123-reg.co.uk, a large provider. Via their control panel I can view these settings:
- Server: mysql1.clusterdb.net via TCP/IP
- Server type: MariaDB
- Server version: 10.0.28-MariaDB - MariaDB Server
- Protocol version: 10
- User: firstname.lastname@example.org
- Server charset: UTF-8 Unicode (utf8)
- Apache/2.2.15 (CentOS)
- Database client version: libmysql - 5.1.73
- PHP extension: mysqli
- PHP version: 5.3.3
Any help would be greatly appreciated.