MYSQL Error during instalation

[KenA]

I'm just testing out v2 on a fresh install and I'm getting an error on install.
: Query Error [#1064]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-mainst1 CHARACTER SET utf8' at line 1 Query: CREATE DATABASE web1-mainst1 CHARACTER SET utf8

From a quick serach of the forums I'm guessing that it is because of the "-" in the database name but unfortunately the hosts I use put the first part in automatically when creating a database.

A reply from the host regarding this issue:
"I think this is to do with the fact that their install system throws an error at a database name with a - in it (eg web1-mainst1). It may require them to provide a way round this, as we cannot change the format of a database name, however if they can provide the sql file to import to the database, we can possibly import it manually and then it should be able to continue with the install."

[CaMer0n]

I believe the error thrown is from MySQL, not e107 specifically. What happens if you try that command in phpMyAdmin?

[KenA]

Hi CaMer0n,
Thanks for the reply,
Unfortunately Lock Tables it set to on in PHPMyadmin so I cannot create databases directly in there. I access the databases through an admin panel to create them, then I can manage them, run SQL queries etc. in PHPMyadmin.

[e107steved]

If the database is already created, e107 shouldn't be trying to do so (there's a check box on the install which determines whether e107 creates the database).

[KenA]

OK guys - firstly thanks very much for all your help - much better than the hosts :(

I have managed to solve the problem from this end and, whether it is still a problem with e107 or the hosts database I'm not clear on that.

I downloaded and installed a new copy of 1.03 then downloaded the upgrade from 1.x to 2.0 alpha1, upgraded everything from admin/e107_update.php and everything works as it should now.

As mentioned I am not sure how the error occurs when installing a new 2.0 site but it hopefully will give some help to others and the developers.
I would post this info to my host but they would probably close the ticket saying obviously it is an e107 issue :(

[jetkappu]

please fix this issue , i have same problem too

[CaMer0n]

I just did a fresh install of the Github v2.x today on a linux machine without any errors. Are you upgrading or doing a fresh install?

[jetkappu]

im doing fresh install and checkout from this github.

[CaMer0n]

What is your server control panel? (cPanel, Plesk..etc) and how did you create the database?

[jetkappu]

im using xampp at windows my xampp version : 1.8.1 php : 5.4.7 mysql 5.0.10

creating database manually and already try to tick databse from installer same result

http://s19.postimg.org/n63vph1mr/Capture.png

[Grimston]

Looks like its trying to create the database.

Uncheck the create database check box.

-------- Original message --------
From: jetkappu notifications@github.com
Date: 24/11/2013 10:33 AM (GMT+08:00)
To: e107inc/e107 e107@noreply.github.com
Subject: Re: [e107] MYSQL Error during instalation (#252)

im using xampp at windows my xampp version : 1.8.1 php : 5.4.7 mysql 5.0.10

creating database manually and already try to tick databse from installer same result

http://s19.postimg.org/n63vph1mr/Capture.png

—
Reply to this email directly or view it on GitHub.

[CaMer0n]

Please enable install logging - by editing the following line in install.php

define('MAKE_INSTALL_LOG', false); and setting to true.

then upload the file e107InstallLog.log and provide a link, thanks

[jetkappu]

this is i got from my log after make it to true:

1385262828, 13-11-24 03:13:48 Stage 3 started

[CaMer0n]

hmm, not much help is it. Can you provide a screenshot of the MySQL data you entered during the install process?

[jetkappu]

here :
http://s19.postimg.org/r3r5evog3/Capture.png

[CaMer0n]

Thanks. Have you tried using a database name that starts with a letter? (instead of a number)

[jetkappu]

finally, so the databse must be a letter instead of number ... thank you so much it really help me :)

[CaMer0n]

Corrected and should now also allow for dashes in the database name.