Welcome to the LimeSurvey Community Forum

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

warning-database crashed-user read it

  • tpartner
  • tpartner's Avatar Topic Author
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 10 months ago #120470 by tpartner
warning-database crashed-user read it was created by tpartner
I think that rather than just making loud, sometimes irrelevant statements, you should focus on your survey designs, not the perceived limitations of the platform.

If you think you can improve LS, you are welcome to submit pull requests.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: DenisChenu, holch, Ben_V, Bigred01
The topic has been locked.
More
8 years 10 months ago #120491 by robertk01
Replied by robertk01 on topic warning-database crashed-user read it
If this is perceived, should take care of innocent user, remind first and fix the bug ASAP.

Just in my eyes, this guy(girl?) help to find a bug, your brashness say no to those developer help.

vest of a loyal user from 1.9
The topic has been locked.
More
8 years 10 months ago - 8 years 10 months ago #120494 by Ben_V
Replied by Ben_V on topic warning-database crashed-user read it
Welcome Robert(k),

I assume you've around 5 years experience with LimeSurvey without any major encountered issue, if you are a "loyal user from 1.9" and if this is your 1st participation in this active forum where problems are usually discussed and solved… This sounds very good and it will be particularly valuable for all the LimeSurvey community (developers & users) if you can (in a few words) describe how you are using the software (context/purpose) & your personal overall opinion (pro & cons) ?

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 8 years 10 months ago by Ben_V.
The following user(s) said Thank You: holch
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 10 months ago #120504 by holch
Replied by holch on topic warning-database crashed-user read it
I am also asking myself how someone wants to create a database design that DOESN'T use one column per question. I am not a database expert, but I would love to hear how this could be improved. Would be very interesting. Maybe one of those database experts could explain this in detail.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
More
8 years 10 months ago #120508 by jelo
Replied by jelo on topic warning-database crashed-user read it
Since iscar has posted in this thread that he has changed from Limesurvey to another tool, you might no longer get an answer from iscar.

1.) A warning is not that simple, since different database servers are coming up with different limits. No simple rule of thumb or easy checking.

It isn't a big issue if you backup your surveys. I wonder what kind of surveys are designed.
Before they reach the limit they will get slow. The main purpose of LimeSurvey is asking questions in form of a survey. Sometimes it look that they want to design a data input tool with very big array questions and other things which would raise the dropout rate in a typical survey situation up to 100%.

There is always room to improve the database model.

2.) If there is room for a database design discussion take a look at
stackoverflow.com/questions/1764435/data...-design-for-a-survey

manual.limesurvey.org/Database_Storage_E...t_M1_Database_Design

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
More
8 years 10 months ago #120546 by misys
Replied by misys on topic warning-database crashed-user read it
I Closed your post in SO, had been entertained.
1.read it first, How number of columns affects performance?

2.When tables get too many columns,technically speaking, it's a design flaw.
Even limit is 4096,it's seldom to see a table columns>60.no engineer would like to design wide table.
It absolutely cause performance problem, and many unpredictable issues even crash. Cases I experienced such as backup database but it contain inconsistent data.

3.
when create those wide facts table, always "vertical split" wide table to several thin tables with the same primary key-id.
Normally revise 3 places:
Code:
// table_1 include column1-100, table_2 include column101-200
for($i=0; $i<=100; $i++) {
   CREATE table_n(column1,column2,…column100
 
//switch tables or get _n from another individual table
switch ($column_n)  
        {  
            case $column_n > 100 &amp;&amp; $column_n <= 200:  
                $table_n = 'table_1';  
                break;  
            case $column_n > 200 &amp;&amp; $column_n <= 300 :  
                                    $table_n = 'table_2';
               ...
 
//join query If you select *
select * from table_1 inner join table_2
Try it, 30mins code work.

Btw, users reminder is always been appreciated.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 10 months ago #120595 by DenisChenu
Replied by DenisChenu on topic warning-database crashed-user read it

misys wrote: ....
Try it, 30mins code work.

Btw, users reminder is always been appreciated.

Hi,

You can patch the next Major LimeSurvey release, Sam is worjing on it, and we need help to get quick. github.com/SamMousa/LimeSurvey

Remind :
- need to work on more SQL the mySQL only
- need to be easily updatable (when we all our old user's update 1.90 version for example)
- need to be maintainable

We have a project to do big optimisation on SQL table, need some times. Maybe if we sell LimeSurvey a lot of money ....

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 10 months ago #120597 by holch
Replied by holch on topic warning-database crashed-user read it
@misys: How much is your hourly rate? If this really is just 30min code work, I guess I could sponsor this feature. Not that I need it much, but I ran in the database column limit once, with a survey that had loads of multiple answer questions, with long answer lists. So it would be interesting.

I am sure that the limesurvey developers wouldn't mind implementing this in 2.06 if we could get this running in the next 2 weeks (any feedback on that?).

Could you let me know when you would be able work on this and what the total cost would be for this?

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
More
8 years 10 months ago #120599 by jelo
Replied by jelo on topic warning-database crashed-user read it
Since iscar, robertk and misys are one person I wouldn't expect too much interaction.

But let me quote DenisChenu who once told me about problematic Wordpress plugins: "use a plugin make by a good dev".
Transfer that remark to survey systems and you have nothing to fear.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
More
8 years 9 months ago #120819 by misys2
Replied by misys2 on topic warning-database crashed-user read it

DenisChenu wrote:

misys wrote: ....
Try it, 30mins code work.

Btw, users reminder is always been appreciated.

Hi,

You can patch the next Major LimeSurvey release, Sam is worjing on it, and we need help to get quick. github.com/SamMousa/LimeSurvey

Remind :
- need to work on more SQL the mySQL only
- need to be easily updatable (when we all our old user's update 1.90 version for example)
- need to be maintainable

We have a project to do big optimisation on SQL table, need some times. Maybe if we sell LimeSurvey a lot of money ....

Hi,

I am willing to help you.
It's quick to paste the vertical split paradigm.Since I never engaged in this project, most of time spend on reading the original code.
I skimmed through the 2.05 version last weekend, have no experience on the 1.90 version.

It's bold idea that maintain multi subversions at the same time. I guess 1.90 version has something special thus still been maintained. I suggest to pack the files need to be revised of each subversion.

Btw, based on my understanding, update script always based on the latest version. It's easy to find the update problem and minimize the update script.
The topic has been locked.
More
8 years 9 months ago #120820 by misys2
Replied by misys2 on topic warning-database crashed-user read it
@holch, I am misys, cannot login that account.

Pls pack the files need to be revised with your requirement, my mail:misys B) linuxmail.org

I think you are the leader of this project, but your speaking smell weird and it seemed you know little about database. I am not sure your authenticity.
Btw, freelancer.com is open for you.
The topic has been locked.
More
8 years 9 months ago #120821 by misys2
Replied by misys2 on topic warning-database crashed-user read it
Uhhh, dunnt understand what you said.
If any further question, please mail me.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose