View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04201 | Bug reports | Authentication | public | 2010-03-15 12:19 | 2010-03-15 22:38 |
Reporter | Schelm | Assigned To | c_schmitz | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 1.87+ | ||||
Summary | 04201: SQL-Error after Login | ||||
Description | On my productive system (see specs below) I got an SQL-error after an attempt to login: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1:SELECT define_questions, edit_survey_property, delete_survey FROM lime_surveys_rights WHERE sid=1984839014933 AND uid = I don't know why the uid is empty and this thread: I figured that admin/database.php line 68 causes this problem, because the SQL-statement doesn't have good error-handling. If uid is a string, you have to encapsulate uid in apostrophes. Otherwise, you have to make sure that it is 0, when it is treated as an int (and not empty). Possible Solution: Fix: $actsurquery = "SELECT define_questions, edit_survey_property, delete_survey FROM {$dbprefix}surveys_rights WHERE sid=$surveyid AND uid = '".$_SESSION['loginID']."'"; //Getting rights for this survey Obviously, you should check if this is an appropriate solution, since I have no clue how uid is obtained, but it seems to work for me. | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 8472 | ||||
I will donate to the project if issue is resolved | |||||
Browser | |||||
Database type & version | MySQL | ||||
Server OS (if known) | Debian Lenny | ||||
Webserver software & version (if known) | Apache2 | ||||
PHP Version | 5+ | ||||
Can you attach a sample survey where we can reproduce the problem? |
|
Carsten, can you check if this really solves the problem?! I still guess there is also a server configuration component included because similar problems have been reported multiple times at the forum. |
|
This happened immediately after installation without a survey created yet upon the first attempt to login. Possibly, you might want to take into account the other bug reported by me: |
|
The fix is bogus. Most probably this is a follow-up to 04199. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2010-03-15 12:19 | Schelm | New Issue | |
2010-03-15 16:04 | Mazi | Note Added: 11349 | |
2010-03-15 16:04 | Mazi | Assigned To | => Mazi |
2010-03-15 16:04 | Mazi | Status | new => feedback |
2010-03-15 16:04 | Mazi | Status | feedback => assigned |
2010-03-15 16:04 | Mazi | Assigned To | Mazi => c_schmitz |
2010-03-15 16:05 | Mazi | Note Added: 11350 | |
2010-03-15 16:22 | Schelm | Note Added: 11352 | |
2010-03-15 17:38 | Mazi | Relationship added | related to 04199 |
2010-03-15 22:03 | c_schmitz | Relationship replaced | parent of 04199 |
2010-03-15 22:38 | c_schmitz | Note Added: 11373 | |
2010-03-15 22:38 | c_schmitz | Status | assigned => closed |
2010-03-15 22:38 | c_schmitz | Resolution | open => unable to reproduce |
2010-03-15 22:43 | c_schmitz | Note Edited: 11373 | |
2011-02-23 17:06 | Mazi | Relationship added | related to 04968 |