View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update | 
|---|---|---|---|---|---|
| 19199 | Bug reports | Database design | public | 2023-10-27 10:22 | 2023-10-27 10:57 | 
| Reporter | mfavetti | Assigned To | ollehar | ||
| Priority | none | Severity | crash | ||
| Status | closed | Resolution | no change required | ||
| Product Version | 6.3.x | ||||
| Summary | 19199: 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: prefix is set to asdfsadfds instead of lime  | ||||
| Steps To Reproduce | Steps to reproduceclean install with prefix set to something besides lime_ Expected resultapplication works Actual resultcannot even login to admin side  | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 35d09e597d7ce689e953f8dd192960ed091edc5a | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | mariadb 11.1 | ||||
| Server OS (if known) | |||||
| Webserver software & version (if known) | |||||
| PHP Version | 8.2 | ||||
| 
	 Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here.  | 
|
| 
	 Seems in templatename on the forum It work on 5.X ?  | 
|
| 
	 seems to happen across 8.0/8.1/8.2 with debug=0 seen so far on paths: i think it has something to do with session if I delete my cookies, the error occurs everywhere  | 
|
| 
	 yes only on debug=0  | 
|
| 
	 Internal Server Error Thank you. 2023-10-27 01:34:46  | 
|
| 
	 'db' => array(  | 
|
| 
	 cannot reproduce on 5.x on any debug  | 
|
	
 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  | 
|
| 
	 sorry you're right!  | 
|
| 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 |