View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
19776Bug reportsDatabase designpublic2024-10-04 16:13
ReporterPackages support Assigned Totibor.pacalat  
PrioritynoneSeverityblock 
Status assignedResolutionopen 
Product Version6.6.x 
Summary19776: Importe survey - Limit culumn table
Description

When importing a survey into our tool, we receive the attached error message.

After some research we detected that the sql server limit when creating a table was of 1024 column, but for our survey we need more columns, is it possible to change this?

Furthermore, we were wondering what type of database was used for Limesurvey in SaaS mode?

Steps To Reproduce

(Write here what happened instead)

TagsNo tags attached.
Attached Files
thumbnail_image006.png (9,840 bytes)   
thumbnail_image006.png (9,840 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)6.6.3
I will donate to the project if issue is resolvedNo
Browser
Database type & versionSQL Database on Azure
Server OS (if known)
Webserver software & version (if known)
PHP Version8.1.28

Users monitoring this issue

There are no users monitoring this issue.

Activities

tibor.pacalat

tibor.pacalat

2024-10-02 16:09

administrator   ~81138

@Packages support MySQL is used for Limesurvey in SaaS mode.

There is a restriction on number of columns using this DB. Postgres allows up to 1600.

Packages support

Packages support

2024-10-03 14:52

reporter   ~81155

Are there any plans to implement the sparse function?

https://learn.microsoft.com/en-us/sql/relational-databases/tables/use-sparse-columns?view=sql-server-ver16

tibor.pacalat

tibor.pacalat

2024-10-04 16:13

administrator   ~81164

Not as far as I know.

Issue History

Date Modified Username Field Change
2024-09-26 15:15 Packages support New Issue
2024-09-26 15:15 Packages support File Added: thumbnail_image006.png
2024-10-02 16:09 tibor.pacalat Note Added: 81138
2024-10-02 16:09 tibor.pacalat Bug heat 0 => 2
2024-10-02 16:10 tibor.pacalat Assigned To => tibor.pacalat
2024-10-02 16:10 tibor.pacalat Status new => feedback
2024-10-03 14:52 Packages support Note Added: 81155
2024-10-03 14:52 Packages support Bug heat 2 => 4
2024-10-03 14:52 Packages support Status feedback => assigned
2024-10-04 16:13 tibor.pacalat Note Added: 81164