System Information: Versions: Perl 5.008005, MySQL 5.0.45, ASP 4.0.2L, PHP 4.4.8, PHP5 5.2.5
Database Configuration STEP 4
THE PROBLEM: I am attempting to install JOOMLA 1.5.2 and I get the following message : -
.The MYSQL Database name must start with a letter and be followed by only letters, numbers or underscores
MySQL |This is probably MySQL
localhost |This is usually localhost or a host name provided by the hoster
web99-mydbname |This can be the default MySQL username root or a username provided by the hoster, or one that you have created whilst setting up your database server.
********* |For site security using a password for the MySQL account is mandatory. This is the same password used to access your database. This may again be preset by your hoster.
web99-mydbname |Some hosts allow only a certain DB name per account. If this is the case use the table prefix option in the following Advanced Parameters section to distinguish more than one Joomla! site.
I have Successfully installed a number of Joomla and mambo sites in the past and most recently installed 1.5.1 to the same host using the same Database name format.
What I have tried to solve the issue:
1)Thought about installing earlier release and upgrading.
2)Contacted Host - cannot change format of database name. Their Response is :
.Can I rename my database getting rid of the 'web-' part if the name?
Unfortunately this isn't possible as the convention is required for backing up the data on the web servers.
3)Tried to omit the "-" from the database name and its accepted although its not the correct name for the database. The issue seems to be the "-" in the database name not being accepted by the installation!
What searches I have done/information that may be related: Read simiar post on forum but not resolved. viewtopic.php?f=429&t=280580
Is there anything I have missed here?
UPDATE 3rd April 2008 17:29
I have used another domain that I have with the same Host and installed Joomla_1.5.1 quite sucessfully using the same database format has that detailed above. The site is fully installed at this time and with all intents and purposes, seems to be working just fine!
MY CONCLUSION - Seems there is an issue with the database name containing the character "-" in Joomla_1.5.2. preventing the software from installing and configuring the database.