Bebop is a plugin that allow users to sync their social media account with their BuddyPress account on the platform.
Recently, I noticed that the Twitter sync was not working anymore. I started to investigate by looking at the plugin dashboard where if found a whole list of errors in the error log
What I tried:
1.Flushing the database tables : no change
Removing existing sync account and creating new one: doing this I noticed that only the first tweet is imported and then the same problem comes back
Deleteting the tables of an other plugin that has the same feature but was very buggy: no change
Deactivating all plugins: no change
Finally, I started to Look at the message of error. The importation of each tweet generate a secondary item id based on the following structure:
11361294947
1 = user id
13 = year
61294947 = item number
This secondary item id is written in one of the plugin table called: wp_bp_bebop_oer_manager
Before the 2 February --> this secondary item id was created and passed to the activity stream (wp-bp-activity table). After this date , the proper secondary item id is no longer passed to the activity stream table. (it is easy to identify what component generated the activity in the activity table because it is labelled : bebop_oer_plugin). From this date, the secondary item id passed to the activity stream table is always 2147483647.
This might explain the error encountered, each time that the plugin try to import a new tweet, it checks whether the tweet is already in the activity stream and find that there is already an item associated with 2147483647.
Between the to dates I updated Wordpress from 3.4.2 to 3.5.1 and a bunch of plugins.
What is weird however is that I cannot replicate this error on the test server where I also upgraded WordPress and the plugin.
Bebop is a plugin that allow users to sync their social media account with their BuddyPress account on the platform.
Recently, I noticed that the Twitter sync was not working anymore. I started to investigate by looking at the plugin dashboard where if found a whole list of errors in the error log
135 2013-02-20 09:59:30 Import Error - twitter 11361311184 already exists 134 2013-02-20 09:59:30 Import Error - twitter 11361312874 already exists 133 2013-02-20 09:43:53 Import Error - twitter 11361294947 already exists 132 2013-02-20 09:43:53 Import Error - twitter 11361311184 already exists 131 2013-02-20 09:43:53 Import Error - twitter 11361312874 already exists
What I tried: 1.Flushing the database tables : no change
Finally, I started to Look at the message of error. The importation of each tweet generate a secondary item id based on the following structure:
11361294947 1 = user id 13 = year 61294947 = item number
This secondary item id is written in one of the plugin table called: wp_bp_bebop_oer_manager
Before the 2 February --> this secondary item id was created and passed to the activity stream (wp-bp-activity table). After this date , the proper secondary item id is no longer passed to the activity stream table. (it is easy to identify what component generated the activity in the activity table because it is labelled : bebop_oer_plugin). From this date, the secondary item id passed to the activity stream table is always 2147483647.
This might explain the error encountered, each time that the plugin try to import a new tweet, it checks whether the tweet is already in the activity stream and find that there is already an item associated with 2147483647.
Between the to dates I updated Wordpress from 3.4.2 to 3.5.1 and a bunch of plugins. What is weird however is that I cannot replicate this error on the test server where I also upgraded WordPress and the plugin.