XHanch Studio Log in | Register | Cart

Forum

Notifications
Clear all

Only 1 tweet showing after a certain period of time

15 Posts
4 Users
0 Likes
10.4 K Views
(@alex997)
Posts: 10
Active Member
Topic starter
 

Hi there

I have been using My Twitter for quite a while now on our website's accountancy articles (example at bottom right of the linked webpage).

However with the recent updates to My Twitter WordPress plugin only 1 tweet shows up, despite 8 being selected.  I can sometimes get 8 to import plying with all the settings but then they disappear after a while back to 1.

Please could you look into this?

I tried exporting my profile from the settings page to attach it but in Firefox at least the export profile button just goes to a blank page.

Many thanks,

Alex

 
Posted : 01/08/2012 5:47 pm
XHanch
(@xhanch-alt)
Posts: 2105
Member Admin
 

Update: For those who had issue similar like this, you can try to reinstall/reset the plugin.
http://forum.xhanch.com/index.php/topic,3130.0.html
If the issue still appears, read provided information below.

First, check your database, see the wp_xmt_twt table.
How many records/tweets are stored there?

You can also try to delete the cache.

Here's a quick update to fix the export issue.
Extract the attached file below and upload profile-export.php to your plugins/xhanch-my-twitter/misc.
You should be able to export your profile after replacing this file.

You can mail the exported profile file to admin@xhanch.com

 
Posted : 01/08/2012 6:11 pm
(@alex997)
Posts: 10
Active Member
Topic starter
 

Many thanks for the fast reply!

First, check your database, see the wp_xmt_twt table.
How many records/tweets are stored there?

1612

You can also try to delete the cache.

Tried that, doesnt help.

Here's a quick update to fix the export issue.
Extract the attached file below and upload profile-export.php to your plugins/xhanch-my-twitter/misc.
You should be able to export your profile after replacing this file.

You can mail the exported profile file to admin@xhanch.com

Thanks I will give that a go and get back to you.

 
Posted : 01/08/2012 6:32 pm
(@alex997)
Posts: 10
Active Member
Topic starter
 

'delete all stored tweets' takes the database table down to 19 rows.  I did that yesterday though and obviously it got up to over 1000 on its own.

RESULT: all 8 tweets display.

As I say though, all 8 were showing yesterday too, and only 1 today without any settings changed.

 
Posted : 01/08/2012 6:38 pm
(@alex997)
Posts: 10
Active Member
Topic starter
 

Its now at 4 tweets - no settings changes or buttons pressed (other than emptying the WC3 Cache to see an updated page).  38 total rows in the database now also!

 
Posted : 01/08/2012 6:50 pm
(@alex997)
Posts: 10
Active Member
Topic starter
 

Emptying the W3C cache again made no difference to number of displayed tweets or rows in the db - so that cant be related.

Also the export still doesn't work with a new plugin file - still a blank page.

These are my settings:

Perhaps its the 10 minutes setting that double up the database rows each fetch?!

 
Posted : 01/08/2012 6:57 pm
XHanch
(@xhanch-alt)
Posts: 2105
Member Admin
 

I think I'm learning something.
Looks like your database is not successfully updated.

Check your wp_xmt_twt table again (see its structure).
Can you find acc_nme_twt_id index?
If not, you'll need to delete all tweets/empty that table.
Then, run/execute this SQL query:

alter table wp_xmt_twt add unique `acc_nme_twt_id` (`acc_nme`, `twt_id`)
 
Posted : 01/08/2012 7:18 pm
(@alex997)
Posts: 10
Active Member
Topic starter
 

The only indexes are:

Keyname                 Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY                 BTREE Yes No id 114 A
acc_nme_index BTREE No No acc_nme 0 A
twt_id_index         BTREE No No twt_id 2 A
twt_index                 BTREE No No twt 2 A
twt_dtp_index         BTREE No No twt_dtp 2 A
twt_typ_index         BTREE No No twt_typ 0 A

 
Posted : 01/08/2012 7:37 pm
(@alex997)
Posts: 10
Active Member
Topic starter
 

its because my table names have a 'ga' prefix to them over standard (security change).  So you need to make your install/upgrade scripts dynamic depending on the table name.

 
Posted : 01/08/2012 7:42 pm
XHanch
(@xhanch-alt)
Posts: 2105
Member Admin
 

No, you misunderstood.
The updater script is actually like this:

$sql = 'alter table '.$wpdb->prefix.'xmt_twt add unique `acc_nme_twt_id` (`acc_nme`, `twt_id`)';
$wpdb->query($sql);

So, the '.$wpdb->prefix.' will be replaced with your table prefix.
It'll be ridiculous if we didn't aware of table prefix.

I'm not sure why you can't run that query.

If your prefix is ga_, then empty the that table and run this query

alter table ga_xmt_twt add unique `acc_nme_twt_id` (`acc_nme`, `twt_id`)
 
Posted : 01/08/2012 7:53 pm
(@alex997)
Posts: 10
Active Member
Topic starter
 

Yes that's what I did - and we are back to 8 tweets again.

I have worked for Oracle for the last 6 years so that prefix change was pretty obvious 🙂

 
Posted : 01/08/2012 7:58 pm
(@dev kobayashi)
Posts: 1
New Member Guest
 

I have a similar problem.  I have it set to show only two tweets, but to not show "include replies from you". However if one of the last two tweets is a reply (a conversation) then only one tweet will show.  This sort of makes sense, but after this, it never grabs two tweets again even though there are two in a row which are not being filtered out.

Deleting stored tweets, and then grabbing new tweets solves the problem for about a minute (the time set for cache expiry).

Any ideas how to fix this?

 
Posted : 17/08/2012 11:31 pm
XHanch
(@xhanch-alt)
Posts: 2105
Member Admin
 

I have a similar problem.  I have it set to show only two tweets, but to not show "include replies from you". However if one of the last two tweets is a reply (a conversation) then only one tweet will show.  This sort of makes sense, but after this, it never grabs two tweets again even though there are two in a row which are not being filtered out.

Deleting stored tweets, and then grabbing new tweets solves the problem for about a minute (the time set for cache expiry).

Any ideas how to fix this?

Can you check your database (see the wp_xmt_twt table)?
Did you see something unusual there? (Ex: too many records, duplicated tweets)

 
Posted : 22/08/2012 2:20 pm
(@aaron)
Posts: 1
New Member
 

Hello. I've been using the My Twitter plugin for over a year and a half and have just recently been having a problem with it. Since one of the previous updates, it only shows one or two tweets maximum, even though I have it configured to display five. I've tried a bunch of things, including uninstalling it/deleting files, but the problem persists. I believe this started two updates ago, but it might be one. I'm sorry I forget the exact time it started.

Can you offer any advice? Other than getting a new plugin, of course.

Thank you.

 
Posted : 28/08/2012 8:15 pm
XHanch
(@xhanch-alt)
Posts: 2105
Member Admin
 

Hello. I've been using the My Twitter plugin for over a year and a half and have just recently been having a problem with it. Since one of the previous updates, it only shows one or two tweets maximum, even though I have it configured to display five. I've tried a bunch of things, including uninstalling it/deleting files, but the problem persists. I believe this started two updates ago, but it might be one. I'm sorry I forget the exact time it started.

Can you offer any advice? Other than getting a new plugin, of course.

Thank you.

Have you checked this topic?
http://forum.xhanch.com/index.php/topic,3069.0.html

 
Posted : 29/08/2012 8:35 pm
Share:

× Close Menu