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

More
5 years 1 month ago #85436 by brettf
brettf created the topic: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22)
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

Please Log in to join the conversation.

More
5 years 1 month ago #85453 by DenisChenu
DenisChenu replied the topic: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22)
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.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
5 years 1 month ago #85488 by Mazi
Mazi replied the topic: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22)
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'"

Please Log in to join the conversation.

More
5 years 1 month ago #85493 by brettf
brettf replied the topic: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22)
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.

Please Log in to join the conversation.

More
5 years 1 month ago #85511 by Mazi
Mazi replied the topic: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22)
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'"

Please Log in to join the conversation.

More
5 years 1 month ago #85542 by DenisChenu
DenisChenu replied the topic: Cant activate survey - Can't create table 'lime_survey_xxxxxx' (errno: 22)

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.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now