Xhanch Forum
FacebookTwitterDiggDelicious

Author Topic: Only 1 tweet showing after a certain period of time  (Read 8381 times)

Offline Alex997

  • Newbie
  • *
  • Posts: 10
  • Reputation Power: 1
  • Alex997 is nobody yet.
    • View Profile
Only 1 tweet showing after a certain period of time
« on: August 01, 2012, 11:47:11 AM »
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 Forum

Only 1 tweet showing after a certain period of time
« on: August 01, 2012, 11:47:11 AM »

Offline Xhanch Studio

  • Xhanch Founder
  • Administrator
  • Hero Member
  • *****
  • Posts: 2109
  • Reputation Power: 1045
  • Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!
    • View Profile
    • Xhanch Studio
Re: Only 1 tweet showing after a certain period of time
« Reply #1 on: August 01, 2012, 12:11:05 PM »
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
« Last Edit: August 31, 2012, 03:02:36 AM by Xhanch Studio »
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

Offline Alex997

  • Newbie
  • *
  • Posts: 10
  • Reputation Power: 1
  • Alex997 is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #2 on: August 01, 2012, 12:32:11 PM »
Many thanks for the fast reply!
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.

Offline Alex997

  • Newbie
  • *
  • Posts: 10
  • Reputation Power: 1
  • Alex997 is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #3 on: August 01, 2012, 12:38:34 PM »
'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.
« Last Edit: August 01, 2012, 12:40:30 PM by Alex997 »

Offline Alex997

  • Newbie
  • *
  • Posts: 10
  • Reputation Power: 1
  • Alex997 is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #4 on: August 01, 2012, 12:50:55 PM »
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!

Offline Alex997

  • Newbie
  • *
  • Posts: 10
  • Reputation Power: 1
  • Alex997 is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #5 on: August 01, 2012, 12:57:34 PM »
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?!
« Last Edit: August 01, 2012, 01:11:14 PM by Xhanch Studio »

Offline Xhanch Studio

  • Xhanch Founder
  • Administrator
  • Hero Member
  • *****
  • Posts: 2109
  • Reputation Power: 1045
  • Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!
    • View Profile
    • Xhanch Studio
Re: Only 1 tweet showing after a certain period of time
« Reply #6 on: August 01, 2012, 01:18:55 PM »
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`)
« Last Edit: August 01, 2012, 01:38:34 PM by Xhanch Studio »
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

Offline Alex997

  • Newbie
  • *
  • Posts: 10
  • Reputation Power: 1
  • Alex997 is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #7 on: August 01, 2012, 01:37:33 PM »
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      

Offline Alex997

  • Newbie
  • *
  • Posts: 10
  • Reputation Power: 1
  • Alex997 is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #8 on: August 01, 2012, 01:42:12 PM »
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.

Offline Xhanch Studio

  • Xhanch Founder
  • Administrator
  • Hero Member
  • *****
  • Posts: 2109
  • Reputation Power: 1045
  • Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!
    • View Profile
    • Xhanch Studio
Re: Only 1 tweet showing after a certain period of time
« Reply #9 on: August 01, 2012, 01:53:21 PM »
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

Offline Alex997

  • Newbie
  • *
  • Posts: 10
  • Reputation Power: 1
  • Alex997 is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #10 on: August 01, 2012, 01:58:32 PM »
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 :)
« Last Edit: August 01, 2012, 01:59:17 PM by Xhanch Studio »

Offline dev kobayashi

  • Newbie
  • *
  • Posts: 1
  • Reputation Power: 1
  • dev kobayashi is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #11 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?

Offline Xhanch Studio

  • Xhanch Founder
  • Administrator
  • Hero Member
  • *****
  • Posts: 2109
  • Reputation Power: 1045
  • Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!
    • View Profile
    • Xhanch Studio
Re: Only 1 tweet showing after a certain period of time
« Reply #12 on: August 22, 2012, 08:20:13 AM »
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

Offline Aaron

  • Newbie
  • *
  • Posts: 1
  • Reputation Power: 1
  • Aaron is nobody yet.
    • View Profile
Re: Only 1 tweet showing after a certain period of time
« Reply #13 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.

Offline Xhanch Studio

  • Xhanch Founder
  • Administrator
  • Hero Member
  • *****
  • Posts: 2109
  • Reputation Power: 1045
  • Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!Xhanch Studio is awe-inspiring!
    • View Profile
    • Xhanch Studio
Re: Only 1 tweet showing after a certain period of time
« Reply #14 on: August 29, 2012, 02:35:44 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
« Last Edit: August 31, 2012, 02:51:57 AM by Xhanch Studio »
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

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
2998 Views
Last post March 01, 2011, 06:04:37 PM
by Xhanch Studio
3 Replies
14760 Views
Last post September 29, 2011, 11:53:59 AM
by alarch
0 Replies
4088 Views
Last post March 22, 2011, 10:20:29 PM
by Xhanch Studio
8 Replies
11326 Views
Last post April 01, 2012, 07:27:46 PM
by GrumpyTrucker
0 Replies
3393 Views
Last post August 07, 2011, 09:58:11 AM
by Xhanch Studio
4 Replies
9017 Views
Last post September 21, 2011, 03:22:59 AM
by cicibar
0 Replies
3628 Views
Last post October 11, 2011, 05:55:31 AM
by Xhanch Studio
1 Replies
7422 Views
Last post December 20, 2011, 10:58:08 PM
by Xhanch Studio
1 Replies
7070 Views
Last post July 31, 2012, 03:01:22 PM
by Xhanch Studio
0 Replies
4976 Views
Last post August 02, 2013, 10:34:52 PM
by mrt

Powered by SMF 2.0 RC5 | SMF © 2006–2011, Simple Machines LLC
SMFAds for Free Forums