Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Was prompted by drupal to update my version of tweet feed. Everything was fine until i ran the update script within Drupal. It said the database update failed and here was the reason.
The following updates returned messages
tweet_feed module
Update #7113
Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT 0 COMMENT 'Is this tweet a reply to another?'' at line 1: ALTER TABLE {tweet_feed} ADD `is_reply` NOT NULL DEFAULT 0 COMMENT 'Is this tweet a reply to another?'; Array ( ) in db_add_field() (line 2844 of /mnt/stor12-wc1-ord1/881452/888493/.../includes/database/database.inc).
Please let me know if you need additional information. I am not well versed in SQL...sorry in advance.
Thanks.
Comments
Comment #2
lexmccurry4x3 commentedWe received the same error during twitter_feed update from 7.x-1.12 to 7.x-1.13. Reverting to 7.x-1.12 for now.
The following updates returned messages
tweet_feed module
Update #7113
• Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT 0 COMMENT 'Is this tweet a reply to another?'' at line 1: ALTER TABLE {tweet_feed} ADD `is_reply` NOT NULL DEFAULT 0 COMMENT 'Is this tweet a reply to another?'; Array ( ) in db_add_field() (line 2844 of /var/www/vhosts/... /httpdocs/includes/database/database.inc).
Comment #3
elusivemind commentedComment #4
elusivemind commentedComment #6
jubei_kibagami commented