From time to time during normal work on the website I receive PDO exeption messeages:

Either:
Column already exists: 1060 Duplicate column name 'ls_remindercount': ALTER TABLE {limesurvey_sync_token_816642_revision} ADD `ls_remindercount` INT unsigned DEFAULT 0 COMMENT 'Reminder count.'; Array ( ) in db_add_field() (Zeile 2900 von /mnt/web/box35_2/docroot/includes/database/database.inc).
Or:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'ls_816642X17X127': ALTER TABLE {limesurvey_sync_answer_816642} ADD `ls_816642X17X127` VARCHAR(5) NULL DEFAULT NULL COMMENT 'How often do you contact us?'; Array ( ) in db_add_field() (line 2900 of /mnt/web/box35_2/docroot/includes/database/database.inc).

After a few minutes site is operating normal.

Why does this happen and what is the trigger for this code to execute?

CommentFileSizeAuthor
#4 ls_error.jpg67.82 KBslowflyer
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

slowflyer created an issue. See original summary.

jalpesh’s picture

jalpesh CreditAttribution: jalpesh as a volunteer and at Cybage Software Pvt Ltd. commented

Try to run update.php, see if you find any DB update over there from this module.

I am not sure about it just try to help out. thanks.

slowflyer’s picture

slowflyer CreditAttribution: slowflyer commented

No, there are no updates to run.

slowflyer’s picture

slowflyer CreditAttribution: slowflyer commented
FileSize
ls_error.jpg67.82 KB

I've been trying to modify image styles ...

nothing related to Limesurvey at all and this happens:

Additional uncaught exception thrown while handling exception.
Original

PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'ls_816642X17X127': ALTER TABLE {limesurvey_sync_answer_816642} ADD `ls_816642X17X127` VARCHAR(5) NULL DEFAULT NULL COMMENT 'How often do you contact us?'; Array ( ) in db_add_field() (line 2900 of .../docroot/includes/database/database.inc).
Additional

PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'ls_816642X18X129': ALTER TABLE {limesurvey_sync_answer_816642} ADD `ls_816642X18X129` VARCHAR(5) NULL DEFAULT NULL COMMENT 'How would you rate the technicians expertise of the problem?'; Array ( ) in db_add_field() (line 2900 of .../docroot/includes/database/database.inc).