database not installed [#164606]

hi.

i'm before use privatemsg module, and after not working...

i'm delete privatemedg module for all db record and table, and delete modules/privatemsg folder.

and new version upload modules/privatemsg

but not work

i work update.php, print this code

* user warning: Table 'cehennem_chorg.privatemsg' doesn't exist query: ALTER TABLE privatemsg ADD thread int NOT NULL in /home/cehennem/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'cehennem_chorg.privatemsg_archive' doesn't exist query: ALTER TABLE privatemsg_archive ADD thread int NOT NULL in /home/cehennem/public_html/includes/database.mysql.inc on line 172.

how to re-install this modules.

thanks.

Comments

Comment #1

Santa Claus commented 6 August 2007 at 11:38

there are error in:
privatemsg.install line 46:
db_query("CREATE TABLE {privatemsg_mails} )

you need to change this line:
db_query("CREATE TABLE {privatemsg_mails} (
http://drupal.org/node/163705

or you have to run SQL (for making table "privatemsg_mails"):
CREATE TABLE privatemsg_mails (
description varchar(255),
type varchar(255),
subject varchar(255),
body varchar(255),
notification_subject varchar(255),
notification_text_body varchar(255),
notification_html_body varchar(255),
notification_group_text_body varchar(255),
notification_group_html_body varchar(255),
mailkey varchar(255) NOT NULL,
PRIMARY KEY (mailkey)
);