Tweet Wheel With WordPress-heroku

Hey, just bought this plugin today, and it’s quite broken for me. I am hosting my WordPress on Heroku, which uses Postgres as its database.

Two repositories for running WordPress on Heroku:
https://github.com/mhoofman/wordpress-heroku (we use this one… it showed up first in Google)
https://github.com/xyu/heroku-wp

I tried hacking the plugin, and got pieces of it to work.

I modified install.php to use pgsql supported operations instead.

$sql = “CREATE TABLE ” . $wpdb->prefix . “twp_queue (
ID bigint NOT NULL DEFAULT nextval((‘wp_twp_queue_seq’::text)::regclass),
post_ID bigint NOT NULL,
queue integer NOT NULL
)” . $charset_collate;

dbDelta( $sql );
pg_prepare(“create_sequence_1”, ‘CREATE SEQUENCE “wp_twp_queue_seq”‘);
pg_execute(“create_sequence_1”, array());

// …

$sql = “CREATE TABLE ” . $wpdb->prefix . “twp_log (
ID bigint NOT NULL DEFAULT nextval((‘wp_twp_log_seq’::text)::regclass),
post_ID bigint NOT NULL,
type text NOT NULL,
tweet text NOT NULL,
short_url text NOT NULL,
timestamp timestamp NOT NULL,
tweet_ID bigint NOT NULL
) ” . $charset_collate;

dbDelta( $sql );
pg_prepare(“create_sequence_2”, ‘CREATE SEQUENCE “wp_twp_log_seq”‘);
pg_execute(“create_sequence_2”, array());
// …

$sql = “CREATE TABLE ” . $wpdb->prefix . “twp_stats (
ID bigint NOT NULL DEFAULT nextval((‘wp_twp_stats_seq’::text)::regclass),
tweet_ID bigint NOT NULL,
stat_type text NOT NULL,
stat_value text NOT NULL,
timestamp timestamp NOT NULL
) ” . $charset_collate;

dbDelta( $sql );
pg_prepare(“create_sequence_3”, ‘CREATE SEQUENCE “wp_twp_stats_seq”‘);
pg_execute(“create_sequence_3”, array());

Don’t laugh, I am a total PHP noob.

I may have broken the plugin further, but I am now seeing these bugs:
1) Can’t click on schedule tab in admin settings because of the post_type parameter in the url.
2) Saving a post auto tweets even though the option isn’t checked.
3) While editing a post, touching the tw related settings often causes the browser tab to freeze at 100% cpu usage. Maybe javascript is hanging?
4) “Tweet Now” does not work when the ajax response says {response: ‘ok’}

Let me know if you have any desire to support this plugin for WordPress accounts hosted on Heroku. If not, then I’ll have to go use Buffer or something else.

https://wordpress.org/plugins/tweet-wheel/