Buddylist funktioniert bei mir nicht
am 05.04.2007 - 13:54 Uhr in
Wollte das Modul Buddylist für Version 4.7 installieren, aber die Tabellen werden nicht automatisch hinzugefügt. Nach dem händischen Hinzufügen fehlen jedoch noch immer ein paar Tabellen.
* user warning: Table 'drupal47x.buddylist_pending_requests' doesn't exist query: SELECT COUNT(requester_uid) FROM buddylist_pending_requests WHERE requester_uid = 1 in C:\xampplite\htdocs\drupal47x\includes\database.mysql.inc on line 108.
* user warning: Table 'drupal47x.buddylist_pending_requests' doesn't exist query: SELECT COUNT(requestee_uid) FROM buddylist_pending_requests WHERE requestee_uid = 1 in C:\xampplite\htdocs\drupal47x\includes\database.mysql.inc on line 108.
Kann mir wer helfen?
- Anmelden oder Registrieren um Kommentare zu schreiben
4 Tabellen
am 16.04.2007 - 20:23 Uhr
Es müssen diese vier Tabellen angelegt werden:
CREATE TABLE {buddylist} (
uid int(10) unsigned NOT NULL default '0',
buddy int(10) unsigned NOT NULL default '0',
timestamp int(11) NOT NULL default '0',
received tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid,buddy)
) /*!40100 DEFAULT CHARACTER SET utf8 */;
CREATE TABLE {buddylist_buddy_group} (
uid int(11) NOT NULL default '0',
buddy int(11) NOT NULL default '0',
label_id int(11) NOT NULL default '0',
PRIMARY KEY (uid, buddy, label_id)
) /*!40100 DEFAULT CHARACTER SET utf8 */;
CREATE TABLE {buddylist_groups} (
uid int(11) NOT NULL default '0',
label_id int(11) NOT NULL default '0',
label varchar(255) NOT NULL default '',
visible tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid, label_id)
) /*!40100 DEFAULT CHARACTER SET utf8 */;
CREATE TABLE {buddylist_pending_requests} (
requester_uid int(11) NOT NULL default '0',
requestee_uid int(11) NOT NULL default '0',
received tinyint(1),
PRIMARY KEY (requester_uid, requestee_uid)
) /*!40100 DEFAULT CHARACTER SET utf8 */;
--
bv - drupalcenter.de