I have a local site running Drupal 7.32, Twitter module/Twitter Post module 7.x-5.8 and OAuth 7.x-3.2.
I set up the twitter module according to the instructions and ran a test tweet. Everything seemed to work ok, the test
showed up in my client's twitter feed as expected. I ran cron to pull the tweets into Drupal and got the following error (some values masked to protect privacy):
PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'in_reply_to_user_id' at row 1:
INSERT INTO {twitter} (twitter_id, screen_name, created_time, text, source, in_reply_to_status_id, in_reply_to_user_id,
in_reply_to_screen_name, truncated) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2,
:db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6,
:db_insert_placeholder_7, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => *******************
[:db_insert_placeholder_1] => *************** [:db_insert_placeholder_2] => **************
[:db_insert_placeholder_3] => @************* Some text...[:db_insert_placeholder_4] =>
Twitter Web Client [:db_insert_placeholder_5] => *****************
[:db_insert_placeholder_6] => -150********** [:db_insert_placeholder_7] => ************** [:db_insert_placeholder_8] => 0 )
in twitter_status_save() (line 163 of C:\WAMP\apache2\htdocs\www\sites\all\modules\twitter\twitter.inc).
The error is repeatable 100% of the time, but does not affect the actual posting of the tweet, either on Twitter or the Drupal site. I did research and found that others have received the same sort of SQL error, but the solutions were not relevant.
So I have 2 questions/issues:
1. This is a completely stock site, configured out of the box with default settings. How/why is the twitter module generating this exception?
2. More importantly, my biggest concern is the insertion of a completely unrelated twitter account into my twitter_user table. How did that get there and how can I ensure this doesn't happen again?
This site has never been live. It has been behind a firewall the entire time it has been worked on. The twitter account info is secure and never been compromised, yet I have unrelated users in my table.
Thanks
Comments
Comment #1
damienmckennaThis should have been fixed by #2040901: PDOException in import when importing mentions (no default value for {twitter.uid}). Feel free to reopen the issue if the problem persists.