View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
19199Bug reportsDatabase designpublic2023-10-27 10:57
Reportermfavetti Assigned Toollehar  
PrioritynoneSeveritycrash 
Status closedResolutionno change required 
Product Version6.3.x 
Summary19199: Using a table prefix besides lime_ is not respected across application causing numerous sql errors
Description

first saw here: https://forums.limesurvey.org/forum/installation-a-update-issues/142783-resolved-cdbexception-error-with-latest-version-of-limesurvey

error on login:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'limesurvey6.lime_settings_global' doesn't exist

prefix is set to asdfsadfds instead of lime
tables are created successfully

Steps To Reproduce

Steps to reproduce

clean install with prefix set to something besides lime_

Expected result

application works

Actual result

cannot even login to admin side

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)35d09e597d7ce689e953f8dd192960ed091edc5a
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmariadb 11.1
Server OS (if known)
Webserver software & version (if known)
PHP Version8.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2023-10-27 10:30

administrator   ~78076

Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here.

DenisChenu

DenisChenu

2023-10-27 10:31

developer   ~78077

Seems in templatename on the forum
good idea to check with another lime

It work on 5.X ?

mfavetti

mfavetti

2023-10-27 10:33

developer   ~78078

Last edited: 2023-10-27 10:49

seems to happen across 8.0/8.1/8.2 with debug=0
seems not to happen debug>0

seen so far on paths:
/
admin/index
admin/authentication/sa/login
admin/logout

i think it has something to do with session if I delete my cookies, the error occurs everywhere
maybe the prefix is stored there somehow?

mfavetti

mfavetti

2023-10-27 10:34

developer   ~78079

yes only on debug=0

mfavetti

mfavetti

2023-10-27 10:35

developer   ~78080

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'limesurvey6.lime_settings_global' doesn't exist
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

2023-10-27 01:34:46

mfavetti

mfavetti

2023-10-27 10:35

developer   ~78081

'db' => array(
'connectionString' => 'mysql:host=mysql;port=3306;dbname=limesurvey6;',
'emulatePrepare' => true,
'username' => 'root',
'password' => 'l!meSurv3y',
'charset' => 'utf8mb4',
'tablePrefix' => 'asdfsadfds_',
),

mfavetti

mfavetti

2023-10-27 10:41

developer   ~78082

Last edited: 2023-10-27 10:48

cannot reproduce on 5.x on any debug

DenisChenu

DenisChenu

2023-10-27 10:52

developer   ~78083

maybe the prefix is stored there somehow?

in runtime/cache : you need to delete all files inside this directory when update DB prefix.

Best is to clean runtime/* , jutc keep index.html

mfavetti

mfavetti

2023-10-27 10:57

developer   ~78084

sorry you're right!

Issue History

Date Modified Username Field Change
2023-10-27 10:22 mfavetti New Issue
2023-10-27 10:30 ollehar Assigned To => ollehar
2023-10-27 10:30 ollehar Status new => feedback
2023-10-27 10:30 ollehar Note Added: 78076
2023-10-27 10:30 ollehar Bug heat 0 => 2
2023-10-27 10:31 DenisChenu Note Added: 78077
2023-10-27 10:31 DenisChenu Bug heat 2 => 4
2023-10-27 10:33 mfavetti Note Added: 78078
2023-10-27 10:33 mfavetti Bug heat 4 => 6
2023-10-27 10:33 mfavetti Status feedback => assigned
2023-10-27 10:34 mfavetti Note Added: 78079
2023-10-27 10:35 mfavetti Note Added: 78080
2023-10-27 10:35 mfavetti Note Added: 78081
2023-10-27 10:41 mfavetti Note Added: 78082
2023-10-27 10:47 mfavetti Note Edited: 78082
2023-10-27 10:48 mfavetti Note Edited: 78082
2023-10-27 10:49 mfavetti Note Edited: 78078
2023-10-27 10:52 DenisChenu Note Added: 78083
2023-10-27 10:57 mfavetti Note Added: 78084
2023-10-27 10:57 mfavetti Status assigned => closed
2023-10-27 10:57 mfavetti Resolution open => no change required