View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
19654Bug reportsDatabase designpublic2024-08-28 11:54
Reporterpirnr81 Assigned To 
PrioritynoneSeverityblock 
Status newResolutionopen 
Product Version6.5.x 
Summary19654: Limesurvey broken after 6.5.15 -> 6.5.16 upgrade: similar to Bug 19351
Description

Hi,
after an attempt to upgrade to the most recent version of Limesurvey, I get the following error when trying to access previous (imported) surveys:

500: Internal Server Error - CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text <> integer
LINE 1: ...AND parent_qid=0 AND((attribute='hidden' AND value!=1 )OR at...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Steps To Reproduce

Steps to reproduce

Upgrade manually from LS 6.5.15 to 6.5.16 (or 17)

Expected result

Upgrade

Actual result

Upgrade but existing surveys can no longer be accessed

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)6.5.15
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgres
Server OS (if known)
Webserver software & version (if known)
PHP Version8.3

Relationships

related to 19351 closedmohabmes Limesurvey broken after 5.6.50 -> 6.4.2 upgrade 

Users monitoring this issue

There are no users monitoring this issue.

Activities

pirnr81

pirnr81

2024-07-16 14:43

reporter   ~80631

NASTY HACK (very limited knowledge of php) - change lines 2021-2024 in application/models/Survey.php to:

          ->count(
              &quot;sid=:sid AND parent_qid=:parent_qid AND((attribute='hidden' AND value!='1' )OR attribute IS NULL)&quot;,
              ['sid' => $this->sid, 'parent_qid' => 0]
          );
pirnr81

pirnr81

2024-07-17 10:49

reporter   ~80642

So, in the end I just replaced the current version of the getCountTotalQuestions()- fuction with the pre 6.5.16 variant:

public function getCountTotalQuestions()
{
    $condn = array('sid' => $this->sid, 'parent_qid' => 0);
    $sumresult = Question::model()->countByAttributes($condn);
    return (int) $sumresult;
}
pirnr81

pirnr81

2024-07-23 13:37

reporter   ~80696

fixed in 6.5.18

Mazi

Mazi

2024-08-28 11:54

updater   ~80844

@pinr81, can you add the commit which fixed it in 6.5.18?

@tibor.pacalat, I think we can then close this one?

Issue History

Date Modified Username Field Change
2024-07-15 13:47 pirnr81 New Issue
2024-07-15 15:09 DenisChenu Relationship added related to 19351
2024-07-16 14:43 pirnr81 Note Added: 80631
2024-07-16 14:43 pirnr81 Bug heat 0 => 2
2024-07-17 10:49 pirnr81 Note Added: 80642
2024-07-23 13:37 pirnr81 Note Added: 80696
2024-08-28 11:54 Mazi Note Added: 80844
2024-08-28 11:54 Mazi Bug heat 2 => 4