Welcome, Guest
Username: Password: Remember me

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) 1 year 7 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.

Re: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 1 year 7 months ago #85453

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5854
  • Thank you received: 716
  • Karma: 222
Hello,

Did you have acces to the mysql parameters ?

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

Denis
The administrator has disabled public write access.

Re: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 1 year 7 months ago #85488

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5279
  • Thank you received: 289
  • Karma: 246
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)limesurvey.org'"
The administrator has disabled public write access.

Re: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 1 year 7 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.

Re: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 1 year 7 months ago #85511

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5279
  • Thank you received: 289
  • Karma: 246
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)limesurvey.org'"
The administrator has disabled public write access.

Re: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22) 1 year 7 months ago #85542

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5854
  • Thank you received: 716
  • Karma: 222
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
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.223 seconds
Donation Image