I installed the privatemsg module and it worked properly after installation.
Soon thereafter I installed the relationship module.

Upon installing the relationship module, neither one of them worked.
Both produced serious database errors that disabled my site.

I had to uninstall both the privatemsg and relationship modules.

Now when I try to install the privatemsg module again (without relationship module)

the following database errors are issued:

user error: Unknown column 'newmsg' in 'where clause'
query: SELECT COUNT(*) FROM privatemsg WHERE recipient = '2' AND newmsg = 1 AND recipient_del = 0 in /home/mysite/public_html/includes/database.mysql.inc on line 66.

warning: Cannot modify header information - headers already sent by (output started at /home/mysite/public_html/includes/common.inc:384) in /home/mysite/public_html/includes/common.inc on line 192.

++++++

To investigate this bug report you may want to examine the relationship module code.
I am submitted a similar bug report for the relationship module.

Together my database is now broken as well.
Can you suggest a fix that will enable me get privatemsg working again?

At a minimum what tables and other database modifications do I need to back out in order to completely remove the privatemsg module from my drupal database?

(I think I can do without the relationship module)

Comments

mindless’s picture

mindless commented

You can drop the tables starting with privatemsg and then reinstall the module (privatemsg, privatemsg_folder, privatemsg_archive). If you can retest on 4.7 and see if there is still a problem that would be helpful.

ericatkins’s picture

ericatkins commented

I can report the same error on 4.7.3. I've dropped the tables and now can't the .install to create the tables. Doing it manually helped. Would have been nice to keep old msgs, though.

mindless’s picture

mindless commented
Status: Active » Closed (fixed)

closing.. if anyone encounters this again please reopen and provide full details:
versions of drupal, privatemsg, relationship, php, database,
error message after both installed (before deactivating or dropping anything).