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

TOPIC: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22)

Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 4 years 2 months ago #85436

  • brettf
  • brettf's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Hi,

I've recently upgraded to 1.92 and now when trying to activate a new survey, I get the error:

Survey could not be activated.
Database error: Can't create table 'lime_survey_66944' (errno: 22)

I've checked the DB user has create table permissions, which it does (from localhost).

config.php and config-default.php seem to both be correct.

Exact version is:

Version 1.92+ Build 120909

The problem persists for both new surveys I attempt to create, and old surveys that I de-activate and then try and re-activate (even though they've previously worked ok).

At this point I'm really stuck. Even a point in the right direction would be immensely appreciated.

Cheers, Brett
The administrator has disabled public write access.

Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 4 years 2 months ago #85453

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1373
  • Karma: 389
Hello,

Did you have acces to the mysql parameters ?

forums.mysql.com/read.php?22,200011,209283

Denis
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.

Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 4 years 2 months ago #85488

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6027
  • Thank you received: 373
  • Karma: 260
Sounds like a problem with your database. Also check available disk space on the DB-server.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
The administrator has disabled public write access.

Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 4 years 2 months ago #85493

  • brettf
  • brettf's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thanks for the tips.

The diskspace is ok, the permissions in the filesystem are ok.

However, I can write a file in /var/lib without issue, if I drop into /var/lib/mysql I get errors. Googling indicates there is most likely a filesystem issue. So presently doing a FSCK on the filesystem, which others with similar VPS issues note resolved the problem.

Fingers crossed.
The administrator has disabled public write access.

Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 4 years 2 months ago #85511

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6027
  • Thank you received: 373
  • Karma: 260
Good luck!

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
The administrator has disabled public write access.

Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 4 years 2 months ago #85542

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1373
  • Karma: 389
brettf wrote:
However, I can write a file in /var/lib without issue, if I drop into /var/lib/mysql I get errors.
Hello,

Maybe you have some particioning system. can you put the result of :
$ df
and
$ mount
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.296 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form