View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
15676Bug reportsInstallationpublic2019-12-18 16:182020-01-13 15:42
ReporterConnectingMedia Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionno change required 
Product Version3.21.2 
Summary15676: Database name during installation does not accept names with dots.
Description

When installing the CE version on step 4 it asks for database credentials. When entering a database name that contains a dot it complains that the name is invalid.

Steps To Reproduce

Enter a database name with a dot during installation step 4.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)limesurvey3.21.2+191216
I will donate to the project if issue is resolvedNo
BrowserMozilla Firefox 71.0 (64-Bit)
Database type & versionMariaDB 10.3.18-MariaDB-0+deb10u1
Server OS (if known)Debian 10
Webserver software & version (if known)nginx 1.14.2
PHP Version7.3.11-1~deb10u1

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2020-01-10 15:58

administrator   ~55203

This is because dots are used to demark a databasename from a tablename.

A typical query would be like

select column1 from database1.tablenameA A left join column2 from database2.tablenameB B on A.columnameA=B.columnameb

This can be worked around with quotes but it is a world of hurt you don't want to enter voluntarily.
ConnectingMedia

ConnectingMedia

2020-01-13 08:47

reporter   ~55214

So you mean to tell me they currently are not quoted throughout?!?

And typically the database name should be irrelevant normal queries, as they are using only one database anyways. And that should be selected with the USE statement.
c_schmitz

c_schmitz

2020-01-13 08:52

administrator   ~55215

I am saying it is bad practice and I don't see a reason to support bad practice.
ConnectingMedia

ConnectingMedia

2020-01-13 15:42

reporter   ~55221

Because MySQL supports it.

Issue History

Date Modified Username Field Change
2019-12-18 16:18 ConnectingMedia New Issue
2020-01-10 15:58 c_schmitz Assigned To => c_schmitz
2020-01-10 15:58 c_schmitz Status new => closed
2020-01-10 15:58 c_schmitz Resolution open => no change required
2020-01-10 15:58 c_schmitz Note Added: 55203
2020-01-13 08:47 ConnectingMedia Note Added: 55214
2020-01-13 08:52 c_schmitz Note Added: 55215
2020-01-13 15:42 ConnectingMedia Note Added: 55221