Relationship Graph
View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
05238 | Bug reports | Statistics | public | 2011-06-03 17:51 | 2011-06-08 14:14 |
Reporter | Assigned To | c_schmitz | |||
Priority | high | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.91+ | ||||
Fixed in Version | 1.91+ | ||||
Summary | 05238: Statistics Filters | ||||
Description | When attempting to filter survey by results with text fields, I always come up with no data found. When searching for other fields and data does come up, trying to browse it gives me an SQL syntax error. "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 'IN ('N') ORDER BY And "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 '( For example. I simply cannot "Browse" the results. And sometimes results won't come up at all. | ||||
Additional Information | I've attached my SQL data. | ||||
Tags | No tags attached. | ||||
Bug heat | 14 | ||||
Complete LimeSurvey version number (& build) | 10168 | ||||
I will donate to the project if issue is resolved | Yes | ||||
Browser | |||||
Database type & version | 5.0.92-community | ||||
Server OS (if known) | Unknown | ||||
Webserver software & version (if known) | cPanel 11.28.87-RELEASE_51188 | ||||
PHP Version | 5.2.13 | ||||
I have the same problem. |
|
I can reproduce the browse issue and it will be fixed in rev. 10209. I cannot reproduce the filter text issue. What exactly are you entering in which field/question in statistics? |
|
For example: I will be searching the name of the Audit agent, and will come up with 0 results. Anything that requires an input field (and not a selection of Yes/No or pre-defined answers) will come up with nothing. |
|
You will need to search with the full name or use the percent sign (%) as wildcard. See documentation: |
|
New version released. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2011-06-03 17:51 |
|
New Issue | |
2011-06-03 17:51 |
|
File Added: gotphq_lime1.sql | |
2011-06-03 17:51 |
|
Issue Monitored: user14338 | |
2011-06-03 17:52 |
|
File Added: limesurvey_survey_95846.lss | |
2011-06-05 15:38 | alicec | Issue Monitored: alicec | |
2011-06-05 17:43 | alicec | Note Added: 15298 | |
2011-06-05 22:35 | c_schmitz | Assigned To | => c_schmitz |
2011-06-05 22:35 | c_schmitz | Status | new => assigned |
2011-06-06 17:03 | c_schmitz | Note Added: 15330 | |
2011-06-06 17:03 | c_schmitz | Status | assigned => feedback |
2011-06-06 17:04 |
|
Note Added: 15331 | |
2011-06-06 17:04 |
|
Status | feedback => assigned |
2011-06-06 17:24 | c_schmitz | Note Added: 15333 | |
2011-06-06 17:25 | c_schmitz | File Deleted: gotphq_lime1.sql | |
2011-06-06 17:25 | c_schmitz | File Deleted: limesurvey_survey_95846.lss | |
2011-06-06 17:25 | c_schmitz | Status | assigned => resolved |
2011-06-06 17:25 | c_schmitz | Fixed in Version | => 1.91+ |
2011-06-06 17:25 | c_schmitz | Resolution | open => fixed |
2011-06-06 17:26 | c_schmitz | Relationship added | has duplicate 05237 |
2011-06-08 14:14 | c_schmitz | Note Added: 15380 | |
2011-06-08 14:14 | c_schmitz | Status | resolved => closed |
2021-08-03 10:01 | guest | Bug heat | 12 => 14 |