Only 1 tweet showing after a certain period of time

Started by Alex997, August 01, 2012, 11:47:11 AM

previous topic - next topic
Go Down

Alex997

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

Xhanch Studio

August 01, 2012, 12:11:05 PM #1 Last Edit: August 31, 2012, 03:02:36 AM by Xhanch Studio
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
Best Regards,
Susanto B.Sc
----------------------------------------------------------------------------
Web development services, WordPress plugin and theme development, PSD to XHTML conversion - http://xhanch.com
Read free manga online - http://authrone.com

Alex997

Many thanks for the fast reply!
Quote from: Xhanch Studio on August 01, 2012, 12:11:05 PM
First, check your database, see the wp_xmt_twt table.
How many records/tweets are stored there?

1612
Quote
You can also try to delete the cache.

Tried that, doesnt help.
Quote
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.

Alex997

August 01, 2012, 12:38:34 PM #3 Last Edit: August 01, 2012, 12:40:30 PM by Alex997
'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.

Alex997

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!

Alex997

August 01, 2012, 12:57:34 PM #5 Last Edit: August 01, 2012, 01:11:14 PM by Xhanch Studio
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:
[spoiler=][/spoiler]

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

Xhanch Studio

August 01, 2012, 01:18:55 PM #6 Last Edit: August 01, 2012, 01:38:34 PM by Xhanch Studio
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:
Code Select
alter table wp_xmt_twt add unique `acc_nme_twt_id` (`acc_nme`, `twt_id`)

Best Regards,
Susanto B.Sc
----------------------------------------------------------------------------
Web development services, WordPress plugin and theme development, PSD to XHTML conversion - http://xhanch.com
Read free manga online - http://authrone.com

Alex997

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      

Alex997

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.

Xhanch Studio

No, you misunderstood.
The updater script is actually like this:
Code Select
$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
Code Select
alter table ga_xmt_twt add unique `acc_nme_twt_id` (`acc_nme`, `twt_id`)
Best Regards,
Susanto B.Sc
----------------------------------------------------------------------------
Web development services, WordPress plugin and theme development, PSD to XHTML conversion - http://xhanch.com
Read free manga online - http://authrone.com

Alex997

August 01, 2012, 01:58:32 PM #10 Last Edit: August 01, 2012, 01:59:17 PM by Xhanch Studio
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 :)

dev kobayashi

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?

Xhanch Studio

Quote from: dev kobayashi on August 17, 2012, 05:31:44 PM
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)
Best Regards,
Susanto B.Sc
----------------------------------------------------------------------------
Web development services, WordPress plugin and theme development, PSD to XHTML conversion - http://xhanch.com
Read free manga online - http://authrone.com

Aaron

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.

Xhanch Studio

August 29, 2012, 02:35:44 PM #14 Last Edit: August 31, 2012, 02:51:57 AM by Xhanch Studio
Quote from: Aaron on August 28, 2012, 02:15:23 PM
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
Best Regards,
Susanto B.Sc
----------------------------------------------------------------------------
Web development services, WordPress plugin and theme development, PSD to XHTML conversion - http://xhanch.com
Read free manga online - http://authrone.com

Go Up