TXP Tweet: arc_twitter and arc_twitter_intents

oliverker · 2010-07-04 20:20:14

Hey Andy,
Can’t seem to get arc_twitter to work on the domain sw.oliverker.com since the update, I’ve tried deleting and re-uploading, but doesn’t even ant to pull in tweets from the twitter account, do you have to connect via twitter to just get the tweets? I have tried connecting via the admin but getting errors.

I also got this error on install from deleting it.

Warning: Table 'stefanwolff_txp.arc_twitter' doesn't exist ALTER TABLE arc_twitter MODIFY COLUMN tweet_id BIGINT(20); in /home/oliverkerdev/sw.oliverker.com/textpattern/lib/txplib_db.php on line 85

cheers
Oli

monkeyninja · 2010-07-05 17:48:24

oliverker wrote:

Hey Andy,
Can’t seem to get arc_twitter to work on the domain sw.oliverker.com since the update, I’ve tried deleting and re-uploading, but doesn’t even ant to pull in tweets from the twitter account, do you have to connect via twitter to just get the tweets? I have tried connecting via the admin but getting errors.

To use the tags you shouldn’t have to connect to Twitter for authentication as long as you define the account user name in the tag attributes and that the account has public tweets. Is the plugin failing to connect? Is the site admin at [site-url]/textpattern? There are known issues with multi-site installs, but fixable.

I also got this error on install from deleting it.

Warning: Table 'stefanwolff_txp.arc_twitter' doesn't exist ALTER TABLE arc_twitter MODIFY COLUMN tweet_id BIGINT(20); in /home/oliverkerdev/sw.oliverker.com/textpattern/lib/txplib_db.php on line 85

cheers
Oli

Not sure why the SQL is failing, when does this happen? At a fresh install, update, or install after deleting the plugin?

eddiemw · 2010-07-07 16:52:33

Hi Andy, This is a fantastic plugin and worked really until I just tried to upgrade to your latest release, with no success – I deleted the previous install and uploaded latest beta only to keep getting the following warning:

Warning: Table ‘web45-so_uk548w.arc_twitter’ doesn’t exist ALTER TABLE arc_twitter MODIFY COLUMN tweet_id BIGINT; in /home/sites/eddiewade.co.uk/public_html/textpattern/lib/txplib_db.php on line 85

Any ideas? The prevoius install seemed to work fine…

Cheers,

Eddie

monkeyninja · 2010-07-08 17:18:38

eddiemw wrote:

Hi Andy, This is a fantastic plugin and worked really until I just tried to upgrade to your latest release, with no success – I deleted the previous install and uploaded latest beta only to keep getting the following warning:

Warning: Table ‘web45-so_uk548w.arc_twitter’ doesn’t exist ALTER TABLE arc_twitter MODIFY COLUMN tweet_id BIGINT; in /home/sites/eddiewade.co.uk/public_html/textpattern/lib/txplib_db.php on line 85

Any ideas? The prevoius install seemed to work fine…

Cheers,

Eddie

I’ve had a couple of people have an issue with that. I will investigate. I assume this is a fresh install and not an upgrade?

eddiemw · 2010-07-13 13:51:46

Hi Andy,

Thanks for getting back.. yes it was a clean install. I deleted the previous version and installed the new one.

However, I have been persevering and after the fourth attempt, despite the same database warning message on install, it worked fine and seems to function Ok as far as I can tell…weird huh?

Many thanks for all your hard work and effort in creating this fantastic plugin.

Cheers,

Eddie

thebombsite · 2010-07-15 15:46:22

Just a thought here because I have also had this database warning several times and what I find is that going straight to the “Options” and saving them seems to cure it. To me that suggests that maybe the required tables aren’t being created until the “Options” save??

monkeyninja · 2010-07-18 20:22:38

thebombsite wrote:

Just a thought here because I have also had this database warning several times and what I find is that going straight to the “Options” and saving them seems to cure it. To me that suggests that maybe the required tables aren’t being created until the “Options” save??

I managed to recreate this error earlier today, although it had no effect on me installing the plugin, it was just more of a warning as everything else worked fine. However, I am going to strip the guilty culprit out of the code as I suspect it is beginning to become redundant. It was intended for those upgrading from version 0.2.1 to fix the arc_twitter table. Saving the options has nothing to do with the issue as it all happens on the magical plugin install callback, but thanks for the comment.

If by removing it it will cause issues for those upgrading from very old versions of the plugin then I will look into providing some form of “mend tables” function under the options tab for making the required corrections.

visualpeople · 2010-07-24 07:06:51

I think I just figured out the hashtag problem —

The code has http://www.twitter.com/…

But Twitter automatically redirects a url with www to just the plain ol’ http://twitter.com. for some reason on the hashtag links, it adds an extra couple of characters in when it does that.

Changing the plugin code with a simple find and replace in (I think just) three places from http://www.twitter.com to http://twitter.com seems to fix the problem.

Hope that helps,
-Ryan

monkeyninja · 2010-07-24 11:03:17

visualpeople wrote:

I think I just figured out the hashtag problem —

The code has http://www.twitter.com/…

But Twitter automatically redirects a url with www to just the plain ol’ http://twitter.com. for some reason on the hashtag links, it adds an extra couple of characters in when it does that.

Changing the plugin code with a simple find and replace in (I think just) three places from http://www.twitter.com to http://twitter.com seems to fix the problem.

Hope that helps,
-Ryan

Thanks Ryan that’s fixed it! I went back and checked some earlier versions of the plugin and it seems that when v1.0beta was released the url got changed by mistake.

The ALTER TABLE bug has now also been removed as of v1.0.3beta; however, as a result I have decided to drop support for upgrades from v0.2.1 or older. Hopefully this won’t affect people, but it is really important people check the version they are upgrading from before installing the latest release. If you are using a very old version (and missing out on loads of new features since released) then upgrade using v1.0.2beta first otherwise your arc_twitter database table will not be correct and won’t store all the information needed for some features of TXP Tweet.

You can get the latest two releases from the plugins homepage.

reid · 2010-07-24 12:57:57

I’m getting an error on the article write page when I switch “Twitter update” from no to yes and then click save:

Notice: A non well formed numeric value encountered in /users/home/photodude/web/public/textpattern/publish/taghandlers.php on line 2815

The update posts to twitter as expected, so it seems this error doesn’t affect function (though it does screw the CSS rendering in the theme I’m using). Just thought you should know about it.

whocarez · 2010-07-27 23:09:18

Hello,

I use 1.0.3beta and I often get an 401 (not authorized) error if I try to republish an article on twitter, which wasn´t published there yet. Maybe it is associated with cyrillic signs in url or/and title, but I´m not sure. Tests with non cyrillic urls also failed, when the article was already published, but it seems that if the article is new and nonpublished, that it is possible to get it via arc_twitter submitted to twitter not important whether it uses cyrillic symbols in url or not.

monkeyninja · 2010-08-03 18:08:30

reid wrote:

I’m getting an error on the article write page when I switch “Twitter update” from no to yes and then click save:

Notice: A non well formed numeric value encountered in /users/home/photodude/web/public/textpattern/publish/taghandlers.php on line 2815

The update posts to twitter as expected, so it seems this error doesn’t affect function (though it does screw the CSS rendering in the theme I’m using). Just thought you should know about it.

I think this might be related to your article’s url rather than arc_twitter but I’m not 100% sure. What url format are you using (not that this should matter)? Are the tweets correctly linking to your articles?

whocarez wrote:

I use 1.0.3beta and I often get an 401 (not authorized) error if I try to republish an article on twitter, which wasn´t published there yet. Maybe it is associated with cyrillic signs in url or/and title, but I´m not sure. Tests with non cyrillic urls also failed, when the article was already published, but it seems that if the article is new and nonpublished, that it is possible to get it via arc_twitter submitted to twitter not important whether it uses cyrillic symbols in url or not.

Is this only the case when you try to update Twitter after publishing your article? Wondering if this is related in part to Reid’s issue.

How is your 401 error showing? Is it appearing within the edit screen within the Twitter Update block?

Textpattern CMS

Textpattern CMS support forum

#85 2010-07-04 20:20:14

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#86 2010-07-05 17:48:24

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#87 2010-07-07 16:52:33

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#88 2010-07-08 17:18:38

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#89 2010-07-13 13:51:46

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#90 2010-07-15 15:46:22

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#91 2010-07-18 20:22:38

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#92 2010-07-24 07:06:51

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#93 2010-07-24 11:03:17

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#94 2010-07-24 12:57:57

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#95 2010-07-27 23:09:18

Re: TXP Tweet: arc_twitter and arc_twitter_intents

#96 2010-08-03 18:08:30

Re: TXP Tweet: arc_twitter and arc_twitter_intents

Board footer