View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
03696 | Bug reports | Survey editing | public | 2009-09-17 17:06 | 2009-10-07 20:05 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | block | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 1.85+ | ||||
Summary | 03696: SQL error when adding label set to survey question | ||||
Description | error is Fatal error: Call to a member function FetchRow() on a non-object in /var/www/limesurvey/admin/labels.php on line 859 | ||||
Additional Information | We are running the websever on linux and the SQL server on Windows 2003. Also had to make the change listed in http://www.limesurvey.org/en/support/forums/1-installation-issues/30044-data-source-name-not-found-and-no-default-driver.html to get a MSSQL db server to work with linux. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | |||||
I will donate to the project if issue is resolved | |||||
Browser | IE and Firefox | ||||
Database type & version | MS SQL Server 2005 | ||||
Server OS (if known) | Ubuntu 8.04 and Centos 5.3 (web servers) - Windows 2003 server (MSSQL db server) | ||||
Webserver software & version (if known) | Apache 2.2 | ||||
PHP Version | 5.2.4 | ||||
Does that happens at every label set you try to add? Can you upload the survey you are using? |
|
Not sure, it happens when trying to add the labels to the "array - flexible labels" question type. Thanks |
|
Which build are you using? |
|
I can't reproduce. Can you describe the exact steps that lead to the error? Also update to the latest build first. |
|
Are you testing with a linux server running limesurvey connecting to a MSSQL server via ODBC? The problem only exists in this case. The problem does not occur when running limesurevey completely on a windows server. I'm using build 7593 i'll upgrade to the newest one to see if that helps. If not I'll post the exact steps to get to the error in my next post. Thanks |
|
I just upgraded to build 7670 and still get the same error. However I noticed this time around that I only get the error when clicking the "Save Changes" button while creating/editing a label set. The changes are saved even though it errors. The newly created/edited label set is usable on surveys as well. |
|
Can you quote the exact error message on the latest version , please? |
|
yes Fatal error: Call to a member function FetchRow() on a non-object in /var/www/limesurvey/admin/labels.php on line 862 |
|
Hm.. when using Linux and connecting to a Windows server the 'mssql_n' driver may be better suited than mssql_odbc |
|
bmmoritz ? |
|
Closing issue due to missing feedback. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2009-09-17 17:06 |
|
New Issue | |
2009-09-17 17:06 |
|
Status | new => assigned |
2009-09-17 17:06 |
|
Assigned To | => user372 |
2009-09-17 17:06 |
|
Browser | => IE and Firefox |
2009-09-17 17:06 |
|
Database & DB-Version | => MS SQL Server 2005 |
2009-09-17 17:06 |
|
Operating System (Server) | => Ubuntu 8.04 and Centos 5.3 (web servers) - Windows 2003 server (MSSQL db server) |
2009-09-17 17:06 |
|
Webserver | => Apache 2.2 |
2009-09-17 17:06 |
|
PHP Version | => 5.2.4 |
2009-09-17 18:57 | c_schmitz | Assigned To | user372 => c_schmitz |
2009-09-17 19:21 | Mazi | Note Added: 09590 | |
2009-09-17 19:21 | Mazi | Status | assigned => feedback |
2009-09-17 20:44 |
|
File Added: limesurvey_survey_26315.csv | |
2009-09-17 20:46 |
|
Note Added: 09591 | |
2009-09-17 21:00 | Mazi | Status | feedback => assigned |
2009-09-21 12:44 | c_schmitz | Note Added: 09619 | |
2009-09-21 12:54 | c_schmitz | Note Added: 09620 | |
2009-09-21 12:54 | c_schmitz | Status | assigned => feedback |
2009-09-21 12:56 | c_schmitz | Note Edited: 09620 | |
2009-09-23 16:44 |
|
Note Added: 09644 | |
2009-09-23 17:28 |
|
Note Added: 09645 | |
2009-09-25 13:09 | c_schmitz | Note Added: 09653 | |
2009-09-25 16:58 |
|
Note Added: 09659 | |
2009-09-27 22:17 | c_schmitz | Note Added: 09662 | |
2009-10-04 14:15 | c_schmitz | Note Added: 09715 | |
2009-10-07 20:05 | c_schmitz | Note Added: 09733 | |
2009-10-07 20:05 | c_schmitz | Status | feedback => closed |
2009-10-07 20:05 | c_schmitz | Resolution | open => unable to reproduce |
2010-10-25 00:17 | c_schmitz | Category | Survey Design => Survey design |
2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |