While I wanted to add an identi.ca stream to my drupalsite I got always trouble in file /usr/share/php/drupal/includes/database.pgsql.inc on line 139. I tried out several modules - the Twitter module and the activity stream module for identica. With both modules I got nearly equal errors.

While I was trying it with activitystream I tried to update the users activity stream information with the users identica account name. But instead of applying the changes I got these error from Drupal:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "activitystream_accounts" does not exist in /home/shnifti/public_html/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: DELETE FROM activitystream_accounts WHERE module = 'activitystream_feed' and uid = 3 in /home/shnifti/public_html/drupal/modules/activitystream/activitystream.module on line 39.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "activitystream_accounts" does not exist in /home/shnifti/public_html/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: DELETE FROM activitystream_accounts WHERE module = 'activitystream_identica' and uid = 3 in /home/shnifti/public_html/drupal/modules/activitystream/activitystream.module on line 39.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "activitystream_accounts" does not exist in /home/shnifti/public_html/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: INSERT INTO activitystream_accounts (module, uid, userid, password, feed) VALUES ('activitystream_identica', 3, 'shnifti', '', '') in /home/shnifti/public_html/drupal/modules/activitystream/activitystream.module on line 47.

When I try to add identi.ca user profile information while clicking to the twitter tab got also Error in the same file and line and nothing is showing up on the page.

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "twitter" does not exist in /home/shnifti/public_html/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(*) FROM (SELECT twitter.twitter_id AS twitter_id FROM twitter twitter LEFT JOIN twitter_account twitter_account ON twitter.screen_name = twitter_account.screen_name LEFT JOIN twitter_user twitter_user ON twitter_account.screen_name = twitter_user.screen_name LEFT JOIN users users ON twitter_user.uid = users.uid WHERE (twitter_account.protected = 0) AND (users.uid = 3) ) count_alias in /home/shnifti/public_html/drupal/modules/tagadelic/views/includes/view.inc on line 739.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "twitter" does not exist in /home/shnifti/public_html/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT twitter.twitter_id AS twitter_id, twitter_account.profile_image_url AS twitter_account_profile_image_url, twitter.text AS twitter_text, twitter.created_time AS twitter_created_time FROM twitter twitter LEFT JOIN twitter_account twitter_account ON twitter.screen_name = twitter_account.screen_name LEFT JOIN twitter_user twitter_user ON twitter_account.screen_name = twitter_user.screen_name LEFT JOIN users users ON twitter_user.uid = users.uid WHERE (twitter_account.protected = 0) AND (users.uid = 3) ORDER BY twitter_created_time DESC LIMIT 10 OFFSET 0 in /home/shnifti/public_html/drupal/modules/tagadelic/views/includes/view.inc on line 765.

I hope somebody can help me to solve this trouble. I also tried to apply the patch posted here: http://drupal.org/node/256001#comment-1864826
Unfortunately it didnt help me :-/
Ben

Comments

hdavis’s picture

I am having this exact same issue, have you been able to problem solve this yet?

damien tournoud’s picture

Assigned: Vollzeitaffe » Unassigned
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

This means that those tables have not been created, probably because of other errors when you installed the module. It could help if you could try to install those modules on a fresh Drupal installation and report back, but the best way would be to open an issue in those modules queues.

Converting this into a support request.

damien tournoud’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)