Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

"Database name is invalid" error in installer if name starts with numbers

  • maccer
  • maccer's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 5 months ago #142365 by maccer
I'm trying to install Limesurvey 2.52+160920 running the installation script in my web browser (Safari 10.0 on MacOS 10.10.5).

In step 4 "configuration" I want to insert the name and login info for an already existing MySQL database at my webhost. The database has a name like "12345-limesurvey" where the numbers and dash in the beginning is set by the webhost and cannot be changed by me. The installer gives an error message
"Database name is invalid."
Why would my database name be invalid, as I have been able to use names like that in every other occasion? How can I continue with the installation?

If I enter a database name that starts with letters instead of numbers, I can get to a next step for creating the database, but that is not an option for the two web hosts I'm currently using as both have the same numbers-dash-letters db naming scheme.
The topic has been locked.
More
8 years 5 months ago #142367 by Ben_V
same concerns here ...

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
The topic has been locked.
More
8 years 5 months ago - 8 years 5 months ago #142374 by jelo

maccer wrote: If I enter a database name that starts with letters instead of numbers, I can get to a next step for creating the database, but that is not an option for the two web hosts I'm currently using as both have the same numbers-dash-letters db naming scheme.


The check routine for these "invalid" names is in this file:
Application->Models->InstallerConfigForm.php

The line can be modified or commented out.
Code:
array('dbname','match', 'pattern' => '/^[a-zA-Z_][a-zA-Z0-9_]*$/'), // Check that database name is a single word with options underscores not starting with a number

I don't know why this validation rule was introduced.
Feel free to comment on this "bug" here (look in the notes, not in the bug description):
bugs.limesurvey.org/view.php?id=11621

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Last edit: 8 years 5 months ago by jelo.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • New Member
  • New Member
More
8 years 5 months ago #142386 by LouisGac

jelo wrote: The line can be modified or commented out.

I guess we should add a param in config for that.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • New Member
  • New Member
More
8 years 5 months ago #142392 by LouisGac
After some discussion with Carsten, it seems we're going to allow dash and number again.
The topic has been locked.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose