View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
06955Bug reportsSurvey participants (Tokens)public2012-11-26 13:292012-12-04 13:16
ReporterpfpDave Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06955: CDbException (Error 500) when viewing participant panel as a restricted user
Description

A user with access to the Participant Panel and Create surveys only gets the following error when clicking on 'Display Participants' in the central participant database:

<h1>CDbException</h1>

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'participants.firstname' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.. The SQL statement executed was: SELECT [participants].*, [participant_shares].[can_edit]
FROM [participants]
LEFT JOIN [participant_shares] ON participants.participant_id=participant_shares.participant_id
WHERE owner_uid = :userid1 OR share_uid = :userid2
GROUP BY [participants].[participant_id]. Bound with :userid1=4, :userid2=4 (C:\limesurvey_test\framework\db\CDbCommand.php:528)

#0 C:\limesurvey_test\framework\db\CDbCommand.php(390): CDbCommand->queryInternal('fetchAll', Array, Array)

#1 C:\limesurvey_test\application\models\Participants.php(178): CDbCommand->queryAll()

#2 C:\limesurvey_test\application\controllers\admin\participantsaction.php(1053): Participants->getParticipantsOwner(4)

#3 [internal function]: participantsaction->getParticipants_json()

#4 C:\limesurvey_test\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(Object(participantsaction), Array)

#5 C:\limesurvey_test\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(Object(participantsaction), Object(ReflectionMethod), Array)

#6 C:\limesurvey_test\framework\web\CController.php(309): Survey_Common_Action->runWithParams(Array)

#7 C:\limesurvey_test\framework\web\CController.php(287): CController->runAction(Object(participantsaction))

#8 C:\limesurvey_test\framework\web\CController.php(266): CController->runActionWithFilters(Object(participantsaction), Array)

#9 C:\limesurvey_test\application\controllers\AdminController.php(159): CController->run('participants')

#10 C:\limesurvey_test\framework\web\CWebApplication.php(276): AdminController->run('participants')

#11 C:\limesurvey_test\framework\web\CWebApplication.php(135): CWebApplication->runController('admin/participa...')

#12 C:\limesurvey_test\framework\base\CApplication.php(162): CWebApplication->processRequest()

#13 C:\limesurvey_test\index.php(178): CApplication->run()

#14 {main}

[12:25:28.597][trace][system.db.CDbCommand] Querying SQL: SELECT *
FROM [participant_attribute_values]

Additional Information

NB: I've recently implemented the recent fix that allows restricted users to see the participant panel

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)121121
I will donate to the project if issue is resolvedNo
BrowserIE8
Database type & versionSQL Express 2012
Server OS (if known)Server 2008
Webserver software & version (if known)IIS 7
PHP Version5.4.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2012-11-28 14:50

reporter   ~22623

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10521
mdekker

mdekker

2012-11-28 14:50

reporter   ~22624

Can you please verify the changed file fixes your problem?
mdekker

mdekker

2012-11-28 15:21

reporter   ~22626

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10523
pfpDave

pfpDave

2012-11-28 15:42

reporter   ~22629

Last edited: 2012-11-28 16:40

I'm afraid not ...

<edit: cut off the log>
pfpDave

pfpDave

2012-11-28 15:42

reporter   ~22631

This was tested on build 121127 by the way
mdekker

mdekker

2012-11-28 16:30

reporter   ~22638

Could you please check using http://github.com/LimeSurvey/LimeSurvey/tree/2c6040b859c09644f654c1b9d5e22d29efc3b868/application/models/Participants.php

(from the commit to master attached to this report)
pfpDave

pfpDave

2012-11-28 16:36

reporter   ~22640

Last edited: 2012-11-28 16:37

That was the file I used (replacing the participants file in the 121127 build) but have tested again using the link above as requested:

Application Log

[15:37:09.075][trace][system.db.CDbConnection] Opening DB connection

displa...cipants (line 345)

[15:37:09.079][trace][system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name
FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k
LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c
ON k.table_name = c.table_name
AND k.constraint_name = c.constraint_name
WHERE c.constraint_type ='PRIMARY KEY'
AND k.table_name = :table
AND k.table_schema = :schema. Bound with :table='settings_global', :schema='dbo'

displa...cipants (line 346)

[15:37:09.083][trace][system.db.CDbCommand] Querying SQL: SELECT
KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'
, KCU1.TABLE_NAME AS 'FK_TABLE_NAME'
, KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME'
, KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION'
, KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME'
, KCU2.TABLE_NAME AS 'UQ_TABLE_NAME'
, KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME'
, KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION'
FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1
ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG
AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2
ON KCU2.CONSTRAINT_CATALOG =
RC.UNIQUE_CONSTRAINT_CATALOG
AND KCU2.CONSTRAINT_SCHEMA =
RC.UNIQUE_CONSTRAINT_SCHEMA
AND KCU2.CONSTRAINT_NAME =
RC.UNIQUE_CONSTRAINT_NAME
AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION
WHERE KCU1.TABLE_NAME = :table. Bound with :table='settings_global'

displa...cipants (line 347)

[15:37:09.085][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+'.'+table_name), column_name, 'IsIdentity') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME='settings_global' AND TABLE_SCHEMA='dbo'

displa...cipants (line 348)

[15:37:09.086][trace][system.db.ar.CActiveRecord] Settings_global.findAll()

displa...cipants (line 349)

[15:37:09.089][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[settings_global] [t]

displa...cipants (line 350)

[15:37:09.130][trace][system.db.ar.CActiveRecord] Settings_global.findByPk()

displa...cipants (line 351)

[15:37:09.130][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[settings_global] [t] WHERE [t].[stg_name]='updatelastcheck'

displa...cipants (line 352)

[15:37:09.133][trace][system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name
FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k
LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c
ON k.table_name = c.table_name
AND k.constraint_name = c.constraint_name
WHERE c.constraint_type ='PRIMARY KEY'
AND k.table_name = :table
AND k.table_schema = :schema. Bound with :table='surveys', :schema='dbo'

displa...cipants (line 353)

[15:37:09.137][trace][system.db.CDbCommand] Querying SQL: SELECT
KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'
, KCU1.TABLE_NAME AS 'FK_TABLE_NAME'
, KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME'
, KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION'
, KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME'
, KCU2.TABLE_NAME AS 'UQ_TABLE_NAME'
, KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME'
, KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION'
FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1
ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG
AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2
ON KCU2.CONSTRAINT_CATALOG =
RC.UNIQUE_CONSTRAINT_CATALOG
AND KCU2.CONSTRAINT_SCHEMA =
RC.UNIQUE_CONSTRAINT_SCHEMA
AND KCU2.CONSTRAINT_NAME =
RC.UNIQUE_CONSTRAINT_NAME
AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION
WHERE KCU1.TABLE_NAME = :table. Bound with :table='surveys'

displa...cipants (line 354)

[15:37:09.139][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+'.'+table_name), column_name, 'IsIdentity') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME='surveys' AND TABLE_SCHEMA='dbo'

displa...cipants (line 355)

[15:37:09.146][trace][system.db.ar.CActiveRecord] Settings_global.findByPk()

displa...cipants (line 356)

[15:37:09.146][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[settings_global] [t] WHERE [t].[stg_name]='DBVersion'

displa...cipants (line 357)

[15:37:09.154][trace][system.db.ar.CActiveRecord] Survey.findAll()

displa...cipants (line 358)

[15:37:09.158][trace][system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name
FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k
LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c
ON k.table_name = c.table_name
AND k.constraint_name = c.constraint_name
WHERE c.constraint_type ='PRIMARY KEY'
AND k.table_name = :table
AND k.table_schema = :schema. Bound with :table='surveys_languagesettings', :schema='dbo'

displa...cipants (line 359)

[15:37:09.163][trace][system.db.CDbCommand] Querying SQL: SELECT
KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'
, KCU1.TABLE_NAME AS 'FK_TABLE_NAME'
, KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME'
, KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION'
, KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME'
, KCU2.TABLE_NAME AS 'UQ_TABLE_NAME'
, KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME'
, KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION'
FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1
ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG
AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2
ON KCU2.CONSTRAINT_CATALOG =
RC.UNIQUE_CONSTRAINT_CATALOG
AND KCU2.CONSTRAINT_SCHEMA =
RC.UNIQUE_CONSTRAINT_SCHEMA
AND KCU2.CONSTRAINT_NAME =
RC.UNIQUE_CONSTRAINT_NAME
AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION
WHERE KCU1.TABLE_NAME = :table. Bound with :table='surveys_languagesettings'

displa...cipants (line 360)

[15:37:09.164][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+'.'+table_name), column_name, 'IsIdentity') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME='surveys_languagesettings' AND TABLE_SCHEMA='dbo'

displa...cipants (line 361)

[15:37:09.168][trace][system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name
FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k
LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c
ON k.table_name = c.table_name
AND k.constraint_name = c.constraint_name
WHERE c.constraint_type ='PRIMARY KEY'
AND k.table_name = :table
AND k.table_schema = :schema. Bound with :table='users', :schema='dbo'

displa...cipants (line 362)

[15:37:09.171][trace][system.db.CDbCommand] Querying SQL: SELECT
KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'
, KCU1.TABLE_NAME AS 'FK_TABLE_NAME'
, KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME'
, KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION'
, KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME'
, KCU2.TABLE_NAME AS 'UQ_TABLE_NAME'
, KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME'
, KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION'
FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1
ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG
AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2
ON KCU2.CONSTRAINT_CATALOG =
RC.UNIQUE_CONSTRAINT_CATALOG
AND KCU2.CONSTRAINT_SCHEMA =
RC.UNIQUE_CONSTRAINT_SCHEMA
AND KCU2.CONSTRAINT_NAME =
RC.UNIQUE_CONSTRAINT_NAME
AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION
WHERE KCU1.TABLE_NAME = :table. Bound with :table='users'

displa...cipants (line 363)

[15:37:09.173][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+'.'+table_name), column_name, 'IsIdentity') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME='users' AND TABLE_SCHEMA='dbo'

displa...cipants (line 364)

[15:37:09.177][trace][system.db.CDbCommand] Querying SQL: SELECT [t].[sid] AS [t0_c0], [t].[owner_id] AS [t0_c1], [t].[admin] AS [t0_c2], [t].[active] AS [t0_c3], [t].[expires] AS [t0_c4], [t].[startdate] AS [t0_c5], [t].[adminemail] AS [t0_c6], [t].[anonymized] AS [t0_c7], [t].[faxto] AS [t0_c8], [t].[format] AS [t0_c9], [t].[savetimings] AS [t0_c10], [t].[template] AS [t0_c11], [t].[language] AS [t0_c12], [t].[additional_languages] AS [t0_c13], [t].[datestamp] AS [t0_c14], [t].[usecookie] AS [t0_c15], [t].[allowregister] AS [t0_c16], [t].[allowsave] AS [t0_c17], [t].[autonumber_start] AS [t0_c18], [t].[autoredirect] AS [t0_c19], [t].[allowprev] AS [t0_c20], [t].[printanswers] AS [t0_c21], [t].[ipaddr] AS [t0_c22], [t].[refurl] AS [t0_c23], [t].[datecreated] AS [t0_c24], [t].[publicstatistics] AS [t0_c25], [t].[publicgraphs] AS [t0_c26], [t].[listpublic] AS [t0_c27], [t].[htmlemail] AS [t0_c28], [t].[sendconfirmation] AS [t0_c29], [t].[tokenanswerspersistence] AS [t0_c30], [t].[assessments] AS [t0_c31], [t].[usecaptcha] AS [t0_c32], [t].[usetokens] AS [t0_c33], [t].[bounce_email] AS [t0_c34], [t].[attributedescriptions] AS [t0_c35], [t].[emailresponseto] AS [t0_c36], [t].[emailnotificationto] AS [t0_c37], [t].[tokenlength] AS [t0_c38], [t].[showxquestions] AS [t0_c39], [t].[showgroupinfo] AS [t0_c40], [t].[shownoanswer] AS [t0_c41], [t].[showqnumcode] AS [t0_c42], [t].[bouncetime] AS [t0_c43], [t].[bounceprocessing] AS [t0_c44], [t].[bounceaccounttype] AS [t0_c45], [t].[bounceaccounthost] AS [t0_c46], [t].[bounceaccountpass] AS [t0_c47], [t].[bounceaccountencryption] AS [t0_c48], [t].[bounceaccountuser] AS [t0_c49], [t].[showwelcome] AS [t0_c50], [t].[showprogress] AS [t0_c51], [t].[allowjumps] AS [t0_c52], [t].[navigationdelay] AS [t0_c53], [t].[nokeyboard] AS [t0_c54], [t].[alloweditaftercompletion] AS [t0_c55], [t].[googleanalyticsstyle] AS [t0_c56], [t].[googleanalyticsapikey] AS [t0_c57], [languagesettings].[surveyls_survey_id] AS [t1_c0], [languagesettings].[surveyls_language] AS [t1_c1], [languagesettings].[surveyls_title] AS [t1_c2], [languagesettings].[surveyls_description] AS [t1_c3], [languagesettings].[surveyls_welcometext] AS [t1_c4], [languagesettings].[surveyls_endtext] AS [t1_c5], [languagesettings].[surveyls_url] AS [t1_c6], [languagesettings].[surveyls_urldescription] AS [t1_c7], [languagesettings].[surveyls_email_invite_subj] AS [t1_c8], [languagesettings].[surveyls_email_invite] AS [t1_c9], [languagesettings].[surveyls_email_remind_subj] AS [t1_c10], [languagesettings].[surveyls_email_remind] AS [t1_c11], [languagesettings].[surveyls_email_register_subj] AS [t1_c12], [languagesettings].[surveyls_email_register] AS [t1_c13], [languagesettings].[surveyls_email_confirm_subj] AS [t1_c14], [languagesettings].[surveyls_email_confirm] AS [t1_c15], [languagesettings].[surveyls_dateformat] AS [t1_c16], [languagesettings].[surveyls_attributecaptions] AS [t1_c17], [languagesettings].[email_admin_notification_subj] AS [t1_c18], [languagesettings].[email_admin_notification] AS [t1_c19], [languagesettings].[email_admin_responses_subj] AS [t1_c20], [languagesettings].[email_admin_responses] AS [t1_c21], [languagesettings].[surveyls_numberformat] AS [t1_c22], [owner].[uid] AS [t2_c0], [owner].[users_name] AS [t2_c1], [owner].[password] AS [t2_c2], [owner].[full_name] AS [t2_c3], [owner].[parent_id] AS [t2_c4], [owner].[lang] AS [t2_c5], [owner].[email] AS [t2_c6], [owner].[create_survey] AS [t2_c7], [owner].[create_user] AS [t2_c8], [owner].[participant_panel] AS [t2_c9], [owner].[delete_user] AS [t2_c10], [owner].[superadmin] AS [t2_c11], [owner].[configurator] AS [t2_c12], [owner].[manage_template] AS [t2_c13], [owner].[manage_label] AS [t2_c14], [owner].[htmleditormode] AS [t2_c15], [owner].[templateeditormode] AS [t2_c16], [owner].[questionselectormode] AS [t2_c17], [owner].[one_time_pw] AS [t2_c18], [owner].[dateformat] AS [t2_c19] FROM [dbo].[surveys] [t] LEFT OUTER JOIN [dbo].[surveys_languagesettings] [languagesettings] ON ([languagesettings].[surveyls_survey_id]=[t].[sid]) LEFT OUTER JOIN [dbo].[users] [owner] ON (t.owner_id = owner.uid) WHERE (sid IN (SELECT sid FROM survey_permissions WHERE uid = :uid AND permission = :permission AND read_p = 1)) AND (surveyls_language=language). Bound with :uid=4, :permission='survey'

displa...cipants (line 365)

[15:37:09.205][trace][system.db.CDbCommand] Querying SQL: SELECT TABLE_NAME, TABLE_SCHEMA FROM [INFORMATION_SCHEMA].[TABLES]
WHERE TABLE_SCHEMA=:schema AND TABLE_TYPE in ('BASE TABLE','VIEW'). Bound with :schema='dbo'

displa...cipants (line 366)

[15:37:09.258][trace][system.db.ar.CActiveRecord] User.findAll()

displa...cipants (line 367)

[15:37:09.258][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[users] [t]

displa...cipants (line 368)

[15:37:09.261][trace][system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name
FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k
LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c
ON k.table_name = c.table_name
AND k.constraint_name = c.constraint_name
WHERE c.constraint_type ='PRIMARY KEY'
AND k.table_name = :table
AND k.table_schema = :schema. Bound with :table='participant_attribute_names', :schema='dbo'

displa...cipants (line 369)

[15:37:09.265][trace][system.db.CDbCommand] Querying SQL: SELECT
KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'
, KCU1.TABLE_NAME AS 'FK_TABLE_NAME'
, KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME'
, KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION'
, KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME'
, KCU2.TABLE_NAME AS 'UQ_TABLE_NAME'
, KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME'
, KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION'
FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1
ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG
AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2
ON KCU2.CONSTRAINT_CATALOG =
RC.UNIQUE_CONSTRAINT_CATALOG
AND KCU2.CONSTRAINT_SCHEMA =
RC.UNIQUE_CONSTRAINT_SCHEMA
AND KCU2.CONSTRAINT_NAME =
RC.UNIQUE_CONSTRAINT_NAME
AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION
WHERE KCU1.TABLE_NAME = :table. Bound with :table='participant_attribute_names'

displa...cipants (line 370)

[15:37:09.266][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+'.'+table_name), column_name, 'IsIdentity') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME='participant_attribute_names' AND TABLE_SCHEMA='dbo'

displa...cipants (line 371)

[15:37:09.267][trace][system.db.ar.CActiveRecord] ParticipantAttributeNames.findAll()

displa...cipants (line 372)

[15:37:09.267][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[participant_attribute_names] [t] WHERE visible = 'TRUE'

displa...cipants (line 373)

[15:37:09.269][trace][system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name
FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k
LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c
ON k.table_name = c.table_name
AND k.constraint_name = c.constraint_name
WHERE c.constraint_type ='PRIMARY KEY'
AND k.table_name = :table
AND k.table_schema = :schema. Bound with :table='participant_attribute_names_lang', :schema='dbo'

displa...cipants (line 374)
POST http://pfpconsulttest/index.php/admin/participants/getParticipants_json

500 CDbException
171ms
jquery.js (line 16)

[15:37:09.351][trace][system.db.CDbCommand] Querying SQL: SELECT
KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'
, KCU1.TABLE_NAME AS 'FK_TABLE_NAME'
, KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME'
, KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION'
, KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME'
, KCU2.TABLE_NAME AS 'UQ_TABLE_NAME'
, KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME'
, KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION'
FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1
ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG
AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2
ON KCU2.CONSTRAINT_CATALOG =
RC.UNIQUE_CONSTRAINT_CATALOG
AND KCU2.CONSTRAINT_SCHEMA =
RC.UNIQUE_CONSTRAINT_SCHEMA
AND KCU2.CONSTRAINT_NAME =
RC.UNIQUE_CONSTRAINT_NAME
AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION
WHERE KCU1.TABLE_NAME = :table. Bound with :table='participant_attribute_names_lang'

displa...cipants (line 375)

[15:37:09.511][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+'.'+table_name), column_name, 'IsIdentity') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME='participant_attribute_names_lang' AND TABLE_SCHEMA='dbo'

displa...cipants (line 376)

[15:37:09.527][trace][system.db.ar.CActiveRecord] ParticipantAttributeNamesLang.findAll()

displa...cipants (line 377)

[15:37:09.527][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[participant_attribute_names_lang] [t] WHERE attribute_id = :attribute_id. Bound with :attribute_id='1'

displa...cipants (line 378)

[15:37:09.529][trace][system.db.ar.CActiveRecord] ParticipantAttributeNamesLang.findAll()

displa...cipants (line 379)

[15:37:09.529][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[participant_attribute_names_lang] [t] WHERE attribute_id = :attribute_id. Bound with :attribute_id='2'

displa...cipants (line 380)

[15:37:09.530][trace][system.db.CDbCommand] Querying SQL: SELECT [participant_attribute_names]., [participant_attribute_names_lang].
FROM [participant_attribute_names]
JOIN [participant_attribute_names_lang] ON participant_attribute_names_lang.attribute_id = participant_attribute_names.attribute_id
WHERE participant_attribute_names_lang.lang = 'en'
ORDER BY [participant_attribute_names].[attribute_id]

displa...cipants (line 381)

[15:37:09.532][trace][system.db.CDbCommand] Querying SQL: SELECT *
FROM [participant_attribute_values]

displa...cipants (line 382)
displa...cipants (line 344)
mdekker

mdekker

2012-11-28 16:41

reporter   ~22641

Could you instead of this log add the error trace or could you (maybe by private message to menno - at - dutchguys . com send me a login to your installation so i can see the error myself? I only need restricted access to dummy data.
pfpDave

pfpDave

2012-11-28 16:48

reporter   ~22645

There's no public access available to this box I'm afraid, I could try and set up an environment on my own external web host and give you access to that but would take me a little while to do and would be on a *nix platform with a MySQL backend so may not work the same?

I would be happy to sent you an error trace if you can tell me where I get this from? There's nothing in Firebug --> Errors and of course because of the pop-up on the page it doesn't return the debug text on screen ... below is just the error extract from the above Firebug log if that at all helps?

[15:44:48.745][trace][system.db.CDbCommand] Querying SQL: SELECT
KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'
, KCU1.TABLE_NAME AS 'FK_TABLE_NAME'
, KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME'
, KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION'
, KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME'
, KCU2.TABLE_NAME AS 'UQ_TABLE_NAME'
, KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME'
, KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION'
FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1
ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG
AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2
ON KCU2.CONSTRAINT_CATALOG =
RC.UNIQUE_CONSTRAINT_CATALOG
AND KCU2.CONSTRAINT_SCHEMA =
RC.UNIQUE_CONSTRAINT_SCHEMA
AND KCU2.CONSTRAINT_NAME =
RC.UNIQUE_CONSTRAINT_NAME
AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION
WHERE KCU1.TABLE_NAME = :table. Bound with :table='participant_attribute_names_lang'

displa...cipants (line 375)

[15:44:48.747][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+'.'+table_name), column_name, 'IsIdentity') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME='participant_attribute_names_lang' AND TABLE_SCHEMA='dbo'

displa...cipants (line 376)

[15:44:48.747][trace][system.db.ar.CActiveRecord] ParticipantAttributeNamesLang.findAll()

displa...cipants (line 377)

[15:44:48.747][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[participant_attribute_names_lang] [t] WHERE attribute_id = :attribute_id. Bound with :attribute_id='1'

displa...cipants (line 378)

[15:44:48.748][trace][system.db.ar.CActiveRecord] ParticipantAttributeNamesLang.findAll()

displa...cipants (line 379)

[15:44:48.748][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[participant_attribute_names_lang] [t] WHERE attribute_id = :attribute_id. Bound with :attribute_id='2'

displa...cipants (line 380)

[15:44:48.749][trace][system.db.CDbCommand] Querying SQL: SELECT [participant_attribute_names]., [participant_attribute_names_lang].
FROM [participant_attribute_names]
JOIN [participant_attribute_names_lang] ON participant_attribute_names_lang.attribute_id = participant_attribute_names.attribute_id
WHERE participant_attribute_names_lang.lang = 'en'
ORDER BY [participant_attribute_names].[attribute_id]

displa...cipants (line 381)

[15:44:48.749][trace][system.db.CDbCommand] Querying SQL: SELECT *
FROM [participant_attribute_values]
mdekker

mdekker

2012-11-28 16:49

reporter   ~22646

I have linux / mysql and it works for me so that probably won't help. Will see if i can get my hands on a mssql install.
mdekker

mdekker

2012-11-29 22:37

reporter   ~22719

tested latest checkout of git on mssql (finally working) and for me it is ok now. there could be errors on some places still (csv export) but i will adress them one by one. the next release (probably next tuesday) will be a lot more stable and performant
mdekker

mdekker

2012-11-29 22:38

reporter   ~22720

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10584
mdekker

mdekker

2012-11-29 22:38

reporter   ~22721

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10585
c_schmitz

c_schmitz

2012-12-04 13:16

administrator   ~22861

LimeSurvey 2.0+ build 121204 released.

Related Changesets

LimeSurvey: master 2c6040b8

2012-11-28 14:49

mdekker


Details Diff		 Fixed 06955: CDbException (Error 500) when viewing participant panel as a restricted user Affected Issues
06955
mod - application/models/Participants.php Diff File

LimeSurvey: 2.1 450976ef

2012-11-28 15:19

mdekker


Details Diff		 Fixed 06955: CDbException (Error 500) when viewing participant panel as a restricted user Affected Issues
06955
mod - application/models/Participants.php Diff File
mod - application/models/User.php Diff File

LimeSurvey: master 7d97e52e

2012-11-29 22:37

mdekker


Details Diff		 Fixed 06955: CDbException (Error 500) when viewing participant panel as a restricted user Affected Issues
06955
mod - application/models/Participants.php Diff File

LimeSurvey: 2.1 1999a5b6

2012-11-29 22:37

mdekker


Details Diff		 Fixed 06955: CDbException (Error 500) when viewing participant panel as a restricted user Affected Issues
06955
mod - application/models/Participants.php Diff File

Issue History

Date Modified Username Field Change
2012-11-26 13:29 pfpDave New Issue
2012-11-28 14:37 mdekker Assigned To => mdekker
2012-11-28 14:37 mdekker Status new => assigned
2012-11-28 14:50 mdekker Changeset attached => LimeSurvey master 2c6040b8
2012-11-28 14:50 mdekker Note Added: 22623
2012-11-28 14:50 mdekker Resolution open => fixed
2012-11-28 14:50 mdekker Note Added: 22624
2012-11-28 15:21 mdekker Changeset attached => LimeSurvey 2.1 450976ef
2012-11-28 15:21 mdekker Note Added: 22626
2012-11-28 15:42 pfpDave Note Added: 22629
2012-11-28 15:42 pfpDave Note Added: 22631
2012-11-28 16:30 mdekker Note Added: 22638
2012-11-28 16:36 pfpDave Note Added: 22640
2012-11-28 16:37 pfpDave Note Edited: 22640
2012-11-28 16:40 mdekker Note Edited: 22629
2012-11-28 16:41 mdekker Note Added: 22641
2012-11-28 16:48 pfpDave Note Added: 22645
2012-11-28 16:49 mdekker Note Added: 22646
2012-11-29 22:37 mdekker Note Added: 22719
2012-11-29 22:38 mdekker Changeset attached => LimeSurvey master 7d97e52e
2012-11-29 22:38 mdekker Note Added: 22720
2012-11-29 22:38 mdekker Changeset attached => LimeSurvey 2.1 1999a5b6
2012-11-29 22:38 mdekker Note Added: 22721
2012-11-30 14:51 mdekker Status assigned => resolved
2012-11-30 14:51 mdekker Fixed in Version => 2.00+
2012-12-04 13:16 c_schmitz Note Added: 22861
2012-12-04 13:16 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)