I just installed User Relationships on a Drupal 5.x install and when I went to the Admin page for UR, I got this error:

user warning: Table 'drupal_db.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /../includes/database.mysql.inc on line 172.

What does this mean?

Comments

Fayna’s picture

Fayna commented

Coincidentally, when I went to the UR Settings page the page went blank. I checked my logs and found this:

[12-May-2008 21:33:54] PHP Fatal error: Call to undefined function user_relationships_ui_default_messages() in /../modules/user_relationships/user_relationships_ui/user_relationships_ui.forms.inc on line 41

I'm not sure if this is error is related or not, but I figured I'd post it just in case.

telefunken’s picture

telefunken commented

got the same error

telefunken’s picture

telefunken commented

@fayna! i'm not sure if it works, but no errors for now....i tried to create databasetables with this:

--
-- Table structure for table `user_relationships`
--

CREATE TABLE IF NOT EXISTS `user_relationships` (
`rid` int(10) unsigned NOT NULL default '0',
`requester_id` int(11) NOT NULL default '0',
`requestee_id` int(11) NOT NULL default '0',
`rtid` int(11) NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '0',
`created_at` int(11) NOT NULL,
`updated_at` int(11) NOT NULL,
UNIQUE KEY `requester_id_2` (`requester_id`,`requestee_id`,`rtid`),
KEY `rid` (`rid`),
KEY `requester_id` (`requester_id`),
KEY `requestee_id` (`requestee_id`),
KEY `rtid` (`rtid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Table structure for table `user_relationship_types`
--
CREATE TABLE IF NOT EXISTS `user_relationship_types` (
`rtid` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`plural_name` varchar(255) NOT NULL default '',
`is_oneway` tinyint(1) NOT NULL default '0',
`requires_approval` tinyint(1) NOT NULL default '0',
`expires_val` int(10) unsigned NOT NULL default 0,
PRIMARY KEY (`rtid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

alex.k’s picture

alex.k commented
Status: Active » Closed (won't fix)

Not supported.