View Issue Details

IDProjectCategoryView StatusLast Update
15931Bug reports[All Projects] Installationpublic2020-02-28 11:05
Reportersurveyunihi Assigned To 
Status newResolutionopen 
Product Version4.1.7 
Target VersionFixed in Version 
Summary15931: Custom table-prefix ignored

I want to use several versions of LimeSurvey in one database by setting custom tableprefixes - this worked so far. The first (oldest) version was installed using the default table-prefix "lime".

While trying to install Version 4.1.7:
A custom table-prefix stated in installation step 4 "Configuration" is ignored in installation step 5 "Database settings". Instead, the default table-prefix "lime_" is used, causing a conflict with the oldest version.

Steps To Reproduce

You need a database with an existing LimeSurvey-Installation using the default table-prefix "lime_".

Start a new installation using this database.

During installation step 4 "Configuration", set a custom table-prefix, e.g. "lime4_" (see LimeSurvey_error1.png).

In installation step 5 "Configuration", the message "Database already exists, do you want to create necessary tables?" is confirmed (see LimeSurvey_error2.png).

=> Errormessage "Table 'lime_answers' already exists" (see LimeSurvey_error3.png)

TagsNo tags attached.
Complete LimeSurvey version number (& build)limesurvey4.1.7+200224
I will donate to the project if issue is resolvedNo
BrowserFirefox 73.0.1
Database & DB-VersionMySQL 5.7.29-0ubuntu0.18.04.1 - (Ubuntu)
Server OS (if known)
Webserver software & version (if known) Apache/2.4.29 (Ubuntu) Datenbase-Client Version: libmysql - mysqlnd 5.0.12-dev - 20150407
PHP Version7.2.24-0ubuntu0.18.04.3




2020-02-28 11:05


LimeSurvey_error2.PNG (32,279 bytes)
LimeSurvey_error2.PNG (32,279 bytes)
LimeSurvey_error1.PNG (49,592 bytes)
LimeSurvey_error1.PNG (49,592 bytes)
LimeSurvey_error3.PNG (23,229 bytes)
LimeSurvey_error3.PNG (23,229 bytes)

Issue History

Date Modified Username Field Change
2020-02-28 11:05 surveyunihi New Issue
2020-02-28 11:05 surveyunihi File Added: LimeSurvey_error2.PNG
2020-02-28 11:05 surveyunihi File Added: LimeSurvey_error1.PNG
2020-02-28 11:05 surveyunihi File Added: LimeSurvey_error3.PNG