Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

CDbException - Limesurvey and Azure SQL Database

  • dario.veledo
  • dario.veledo's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months ago - 1 year 9 months ago #228763 by dario.veledo
Hi there,

I've installed Limesurvey in Azure in an Azure VM with this configuration:
  • Centos 7.9.2009
  • PHP 7.4.29 (php-cli php-fpm php-common php-mbstring php-xml php-mysql php-gd php-zip php-ldap php-imap php-sqlsrv)
  • Apache 2.4.6
  • Limesurvey version 5.3.14+220516
  • Microsoft ODBC Driver for SQL Server (Linux): msodbcsql17
  • DB: Azure SQL Server
The installation process was successful, including the DB configuration and the initial table creation (with lime_* prefix) but everytime I confirm changes (for example: after creating a survey or a question) I get this error:

Code:
CDbCommand falló al ejecutar la sentencia SQL: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.. The SQL statement executed was: SELECT [answers].[aid] AS [t1_c0], [answers].[qid] AS [t1_c1], [answers].[sortorder] AS [t1_c3], [answers].[assessment_value] AS [t1_c4], [answers].[scale_id] AS [t1_c5] FROM [dbo].[lime_answers] [answers] WHERE ([answers].[qid]=:ypl0) ORDER BY sortorder, code, [answers].[sortorder] ASC. Bound with :ypl0='7' 

/var/www/html/limesurvey/application/views/questionAdministration/questionSummary.php(28)
Code:
            <?php eT('Question summary'); ?> 
                 <small>
                     <em><?= $question->title; ?></em> 
                     (ID: <?php echo (int) $question->qid;?>;)
                 </small>
             </div>
             <div class="row">
                 <?php $this->renderPartial(
                     "summary",
                     [
                         'question'         => $question,
                         'questionTheme'    => $questionTheme,
                         'answersCount'      => count($question->answers),
                         'subquestionsCount' => count($question->subquestions),
                         'advancedSettings'  => $advancedSettings
                     ]
                 ); ?>
             </div>
             <?php if (Permission::model()->hasSurveyPermission($survey->sid, 'surveycontent', 'update')): ?>
                 <div id="survey-action-title" class="pagetitle h3"><?php eT('Question quick actions'); ?></div>
                 <div class="row welcome survey-action">
                     <div class="col-lg-12 content-right">
 
                         <!-- create question in this group -->
                         <div class="col-lg-3">



As far as I can see, the actions are executed successfuly (if I list the surveys and the questions I can see the element created even i got that error), but I always get that error. I don't know what is wrong. I suppose this is related to the type of DB used, but, is there any solution?

Thanks in advance,
Regards,
Last edit: 1 year 9 months ago by dario.veledo. Reason: Format errors

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose