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) 2 years 1 month 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) 2 years 1 month ago #85453

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6472
  • Thank you received: 855
  • Karma: 254
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) 2 years 1 month ago #85488

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5351
  • Thank you received: 299
  • Karma: 250
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) 2 years 1 month 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) 2 years 1 month ago #85511

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5351
  • Thank you received: 299
  • Karma: 250
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) 2 years 1 month ago #85542

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6472
  • Thank you received: 855
  • Karma: 254
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.209 seconds
Donation Image