Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: old_survey old_tokens table clean-up

old_survey old_tokens table clean-up 5 years 9 months ago #57474

  • khoy01
  • khoy01's Avatar
  • Offline
  • Junior Lime
  • Posts: 20
  • Karma: 0
We have set up a Limesurvey environment with about 200 users and 300 surveys for the moment.
Our users activate and deactivate surveys constantly.
Limesurvey doesn't delete old_survey_XXXX and old_tokens_xxxx tables when a survey is deleted.
Is there a reason why the old tables are left?
Did someone already set up some processes to clean up these tables?
The administrator has disabled public write access.

old_survey old_tokens table clean-up 5 years 9 months ago #57478

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1373
  • Karma: 389
khoy wrote:
Is there a reason why the old tables are left?
Sometimes, you can want to acess to old survey.
And when you activate an unchanged survey, you can reimport the old answer.
Did someone already set up some processes to clean up these tables?
Check data integrety, on the first menu-bar

:)
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time (Need support ?).
A bug not reported is a bug not corrected. | 2.61lts version improved | Need plugins for LimeSurvey ?
The administrator has disabled public write access.

old_survey old_tokens table clean-up 5 years 9 months ago #57648

  • khoy01
  • khoy01's Avatar
  • Offline
  • Junior Lime
  • Posts: 20
  • Karma: 0
Ok. I found the button. But it didn't work for our set-up.
It only works if you use a prefix 'xxxx_' for the tables in the database.
Here $dbprefix is '' in config.php.
Maybe the code in integretycheck.php could be changed to work for no db-prefix or maybe even more (xxx_xxx_) because this seems to be the only place where it makes a difference what dbprefix you use.
The administrator has disabled public write access.

old_survey old_tokens table clean-up 5 years 9 months ago #57652

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1373
  • Karma: 389
khoy wrote:
Maybe the code in integretycheck.php could be changed to work for no db-prefix or maybe even more (xxx_xxx_) because this seems to be the only place where it makes a difference what dbprefix you use.
Can you see at our bug report system if this bug appear. And if not, put a complete bug report. Did you have some error in screen ?
Please test if the problem still exists at the latest release. If so please open a ticket at the bugtracker and...

1. Give as much information as possible

2. Attach your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.

3. Provide step-by-step instructions how to reproduce the problem.

4. If possible/helpful please provide screenshots

Afterwards please post the link to the bugtracker so we can follow the progress.

Thanks!

:)
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time (Need support ?).
A bug not reported is a bug not corrected. | 2.61lts version improved | Need plugins for LimeSurvey ?
The administrator has disabled public write access.

old_survey old_tokens table clean-up 5 years 9 months ago #57779

  • khoy01
  • khoy01's Avatar
  • Offline
  • Junior Lime
  • Posts: 20
  • Karma: 0
bug report entered #04995
The administrator has disabled public write access.

old_survey old_tokens table clean-up 5 years 9 months ago #57805

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1373
  • Karma: 389
khoy wrote:
bug report entered #04995
Fixed for svn version.

I think you can try with replace the file integritycheck.php in 1.90+ version

limesurvey.svn.sourceforge.net/viewvc/li...n/integritycheck.php

(do a backup before)
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time (Need support ?).
A bug not reported is a bug not corrected. | 2.61lts version improved | Need plugins for LimeSurvey ?
The administrator has disabled public write access.
Time to create page: 0.229 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form