Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Unable to Display Tokens After Upgrade

Unable to Display Tokens After Upgrade il y a 6 mois 3 semaines #100142

  • kripp88
  • Portrait de kripp88
  • Hors ligne
  • Junior Lime
  • Messages : 20
  • Karma: 0
I just recently completed an upgrade from 1.90 to 2.0. Everything seems to be working as intended, but I am unable to Display Tokens for some surveys. I can't quite seem to figure out the pattern, but some surveys work and others don't. When the issue happens I am sent to a HTTP 500 page after clicking Display Tokens. Can you tell me what the SQL that is used to run for the 'Display Tokens' page or what file I might find it in? I want to determine if it is a problem with the table/data itself or something like along the lines of a timeout. Any other ideas are greatly appreciated.

Thanks,
Kyle
Dernière édition: il y a 6 mois 3 semaines par c_schmitz.
L'administrateur a désactivé l'accès en écriture pour le public.

Unable to Display Tokens After Upgrade il y a 6 mois 3 semaines #100178

  • c_schmitz
  • Portrait de c_schmitz
  • Hors ligne
  • LimeSurvey Team
  • Messages : 719
  • Remerciements reçus 91
  • Karma: 83
First step would be to activate debug mode in /application/config/config.php - you should get a more detailed error then.
Support us, too. Donate to the LimeSurvey project and help keep us going!
L'administrateur a désactivé l'accès en écriture pour le public.
Cet utilisateur a été remercié pour son message par: kripp88

Unable to Display Tokens After Upgrade il y a 6 mois 3 semaines #100201

  • kripp88
  • Portrait de kripp88
  • Hors ligne
  • Junior Lime
  • Messages : 20
  • Karma: 0
Thank you, that was very helpful. After turning debugging to 2 and SQL Logging on I saw the following error, "Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 515 bytes) in C:\inetpub\wwwroot\limesurvey\framework\db\CDbCommand.php on line 506". I then increased the php memory allocation from 128M to 1024M which solved the problem for all but one of my surveys. The problem survey has more than 90,000 tokens. Since 1G seems like a lot to allocate to php is it safe to assume that there must be a memory leak somewhere or is allocating this much memory normal?

Thanks,
Kyle
L'administrateur a désactivé l'accès en écriture pour le public.

Unable to Display Tokens After Upgrade il y a 6 mois 3 semaines #100203

  • c_schmitz
  • Portrait de c_schmitz
  • Hors ligne
  • LimeSurvey Team
  • Messages : 719
  • Remerciements reçus 91
  • Karma: 83
What is the LimeSurvey version and build you are using?
Support us, too. Donate to the LimeSurvey project and help keep us going!
Dernière édition: il y a 6 mois 3 semaines par c_schmitz.
L'administrateur a désactivé l'accès en écriture pour le public.

Unable to Display Tokens After Upgrade il y a 6 mois 3 semaines #100204

  • kripp88
  • Portrait de kripp88
  • Hors ligne
  • Junior Lime
  • Messages : 20
  • Karma: 0
Version 2.00+ Build 130802
L'administrateur a désactivé l'accès en écriture pour le public.

Unable to Display Tokens After Upgrade il y a 6 mois 3 semaines #100210

  • c_schmitz
  • Portrait de c_schmitz
  • Hors ligne
  • LimeSurvey Team
  • Messages : 719
  • Remerciements reçus 91
  • Karma: 83
Can you try and update to the latest build of 2.0+ and see if the issue still exists?
I just created a survey with 10,000 tokens and had no problems at all (memory limit at 80MB).
What PHP version are you using? Maybe your PHP version has a bug leaking memory.
Support us, too. Donate to the LimeSurvey project and help keep us going!
L'administrateur a désactivé l'accès en écriture pour le public.

Unable to Display Tokens After Upgrade il y a 6 mois 2 semaines #100259

  • kripp88
  • Portrait de kripp88
  • Hors ligne
  • Junior Lime
  • Messages : 20
  • Karma: 0
I just updated to the most recent build (130929) and was unable to view tokens on a table with 50,000 without significantly increasing the php memory limit. I will continue to investigate, but it appears there must be a leak somewhere or a bug in php.
L'administrateur a désactivé l'accès en écriture pour le public.

Unable to Display Tokens After Upgrade il y a 6 mois 2 semaines #100260

  • c_schmitz
  • Portrait de c_schmitz
  • Hors ligne
  • LimeSurvey Team
  • Messages : 719
  • Remerciements reçus 91
  • Karma: 83
Sorry, I meant 100,000 tokens (which I created). What PHP version are you using?
Support us, too. Donate to the LimeSurvey project and help keep us going!
L'administrateur a désactivé l'accès en écriture pour le public.

Unable to Display Tokens After Upgrade il y a 6 mois 2 semaines #100261

  • kripp88
  • Portrait de kripp88
  • Hors ligne
  • Junior Lime
  • Messages : 20
  • Karma: 0
It is php v 5.4
L'administrateur a désactivé l'accès en écriture pour le public.

Unable to Display Tokens After Upgrade il y a 6 mois 2 semaines #100262

  • c_schmitz
  • Portrait de c_schmitz
  • Hors ligne
  • LimeSurvey Team
  • Messages : 719
  • Remerciements reçus 91
  • Karma: 83
Well, latest PHP version is 5.5.4 - I would try a PHP upgrade (or to countercheck any different version would do) first.
Support us, too. Donate to the LimeSurvey project and help keep us going!
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.147 secondes
Donation Image