[Plugin: Facebook AWD All in one] Inconsistent publishing on OpenGraph Publishing

I’ve been toying around with it and I think I’ve ‘better diagnosed’ the problem.
It will publish on facebook, but only if I delete all the recent activity via the ‘my activity’ window. It will only publish one thing.

Even after leaving it for 12 hours and reading a new fresh article it wouldn’t publish on facebook until I’d deleted the previous action from My Activity. Why might this be?

All actions triggered on page load (11 sec after) can be published on facebook timeline only one time.

If the activity already exists on facebook, the plugin will not publish it again because facebook API return an error.

If the plugin cannot find this activity in the database, he will create it in the WP database, and will not publish it any more until you delete it by your self.

TO clear the table of activity, simply deactivate and reactivate the plugin Facebook AWD Opengraph Actions

Thanks, but perhaps I didn’t explain the issue properly.

If I publish a completely new article on my site and read it for more than 11 seconds, nothing will be published on facebook. The only way to make it publish is to delete any previous publishing action (of which there is only one) and then it will publish the article I’m reading.

It seems to only allow one publish action entirely, not per post.

Cheers,
Ash

Can you please look with firebug the response of the ajax call ?

Not sure what I’m looking for sorry. I’ve got firebug running on an article that should publish. How do I check the response?

You must look in the console when the page loading.
You will see a call to admin_ajax.php
You can check the response with fire bug.

Cheers. Below is the ajax response. Nothing was published for the article being read, and the ‘May 27, 2012 1:37am’ article was the last one published (which published after deleting the previous action).

{"id":"10151014034876579","success":true,"htmlResponse":"","callbackJs":"","debug":true,"activity_list":"<table class=\"awd_fcbk_opengraph_actions_activity_list simple\">\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th colspan=\"2\">Post<\/th>\n\t\t\t\t\t<th>Action<\/th>\n\t\t\t\t\t<th>Object<\/th>\n\t\t\t\t\t<th>Date<\/th>\n\t\t\t\t\t<th colspan=\"3\">Controls<\/th>\n\t\t\t\t<\/tr>\n\t\t\t<\/thead><tbody><tr><td><\/td><td><\/td><td>News.reads<\/td><td>Article<\/td><td>May 27, 2012 1:37 am<\/td><td><a href="" title="View Post">View<\/a><\/td><td></a><a href="http:\/\/www.facebook.com\/AshDav\/activity\/10151014034876579" title="View activity on Facebook">Feed<\/a><\/td><td></a><a href="#" title="Delete activity"><\/a><\/td><\/tr><\/tbody><\/table>"}</a>

Ok so I suppose there is a problem with the databse.

Can you check is the table is correctly created in your databse ?
If not try to deactivate the plugin and re activate it to create the database. are you using the 1.1 of the pluhin ?

Because with this response i saw the article read action is pushed on facebook, Or already exists on facebook.

Note: An actions news read can be publied only one time on facebook.
This activity cannot be duplicate between a post and an action until you delete it from your site or from facebook.

There is a db table wp_awd_fcbk_opengraph_actions_activity with only three fields in it, three articles that could have been published (although I would have expected more publishes – we’ve had at least 20 facebook registrations today)

That appears to be the only facebook AWD table on the database. There is also wp_fb_friends and wp_fb_lastlogin. We did have a different fb connect app installed before switching to AWD.

Tried deactivating both AWD and opengraph but no change.

Can you give me an url to test it ?

You said only 3 fields ?

The plugin should create a table like that:

CREATE TABLE $table_name (
	id mediumint(9) NOT NULL AUTO_INCREMENT,
	post_id INT(11) NOT NULL,
	user_id INT(11) NOT NULL,
	fb_id BIGINT(30) NOT NULL,
	action tinytext NOT NULL,
	object text NOT NULL,
	url VARCHAR(255) NOT NULL,
	time datetime NOT NULL,
	UNIQUE KEY id (id)
);

Yep the db table matches that.

Jump over to this article https://www.photoguides.net/14-standout-entries-from-the-2012-sony-photography-awards
Facebook login button is on the right sidebar under ‘join us’. Can you try it for yourself and see how it reacts when you read different articles?
Also the ‘view all’ page doesn’t show accurate activity. Confusing.

Thanks,
Ash

*By 3 fields I meant three rows. As though only three items had been published.

So i just try it, can said me if all fields are not empty in rows in the table ?

Because it seems the plugin do not find the post id…
Can you post just a screen shot of some rows ?

You’re right, none of them have a post id! All other fields are there though.

Here’s a screenshot https://www.photoguides.net/photoguides-db-postid.png

*That does make sense actually. If they all have the same id it would assume the user is reading the same article and not publish again?