View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
03696Bug reportsSurvey editingpublic2009-10-07 20:05
Reporteruser4937Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionunable to reproduce 
Product Version1.85+ 
Summary03696: 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.

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
BrowserIE and Firefox
Database type & versionMS 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 Version5.2.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2009-09-17 19:21

updater   ~09590

Does that happens at every label set you try to add?

Can you upload the survey you are using?

user4937

2009-09-17 20:46

  ~09591

Not sure, it happens when trying to add the labels to the "array - flexible labels" question type.

Thanks

c_schmitz

c_schmitz

2009-09-21 12:44

administrator   ~09619

Which build are you using?

c_schmitz

c_schmitz

2009-09-21 12:54

administrator   ~09620

Last edited: 2009-09-21 12:56

I can't reproduce. Can you describe the exact steps that lead to the error? Also update to the latest build first.

user4937

2009-09-23 16:44

  ~09644

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

user4937

2009-09-23 17:28

  ~09645

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.

c_schmitz

c_schmitz

2009-09-25 13:09

administrator   ~09653

Can you quote the exact error message on the latest version , please?

user4937

2009-09-25 16:58

  ~09659

yes

Fatal error: Call to a member function FetchRow() on a non-object in /var/www/limesurvey/admin/labels.php on line 862

c_schmitz

c_schmitz

2009-09-27 22:17

administrator   ~09662

Hm.. when using Linux and connecting to a Windows server the 'mssql_n' driver may be better suited than mssql_odbc
Can you try and see if it fixes the problem?

c_schmitz

c_schmitz

2009-10-04 14:15

administrator   ~09715

bmmoritz ?

c_schmitz

c_schmitz

2009-10-07 20:05

administrator   ~09733

Closing issue due to missing feedback.

Issue History

Date Modified Username Field Change
2009-09-17 17:06 user4937 New Issue
2009-09-17 17:06 user4937 Status new => assigned
2009-09-17 17:06 user4937 Assigned To => user372
2009-09-17 17:06 user4937 Browser => IE and Firefox
2009-09-17 17:06 user4937 Database & DB-Version => MS SQL Server 2005
2009-09-17 17:06 user4937 Operating System (Server) => Ubuntu 8.04 and Centos 5.3 (web servers) - Windows 2003 server (MSSQL db server)
2009-09-17 17:06 user4937 Webserver => Apache 2.2
2009-09-17 17:06 user4937 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 user4937 File Added: limesurvey_survey_26315.csv
2009-09-17 20:46 user4937 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 user4937 Note Added: 09644
2009-09-23 17:28 user4937 Note Added: 09645
2009-09-25 13:09 c_schmitz Note Added: 09653
2009-09-25 16:58 user4937 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