So, Update-Status Module told me to update my 5.x.2.x-dev release. Did that, visited */update.php and saw Private message wanted to update the MySql (update #3). Ran that.

Now when I visit /privatemsg/ I see my three pages via pager yet no private message are shown.

*EEK!*

Comments

czarphanguye’s picture

czarphanguye commented

Notes: Sent messages display. Inbox is the one that doesn't show the messages.

jsgammato’s picture

jsgammato commented

I'm in the samne boat - all PMs have vanished. I can see the Sent Messages when I Manage Folders, and my users can see that there are messages awaiting them but they cannot get to them. Filter Unread/All always returns no results, and I cannot select any other filter.
I have tinymce installed, and a few other contributed modules.

czarphanguye’s picture

czarphanguye commented

I also have TinyMCE installed (if it matters)...

Boy, I sure wish I didn't apply the update to my production site. :-(

scott falconer’s picture

scott falconer commented

Seems to be caused by a missing field in the table 'privatemsg' called 'type'. If you add that manually, it should start displaying the messages again.

czarphanguye’s picture

czarphanguye commented

Ah... Ahow about that. Ty and fixed.

type varchar(255) NOT NULL

So, what's type do? I imagine this is a new feature?

czarphanguye’s picture

czarphanguye commented

Another note: the *.install file seems to have other tables/fiels that did not get upgrade. "// $Id: privatemsg.install,v 1.5.2.4.2.2 2007/08/01 12:01:18 chx Exp $"

Is all of this is also needed?

      db_query("CREATE TABLE {privatemsg_mails} )
          description varchar(255) NOT NULL,
          type varchar(255) NOT NULL,
          subject varchar(255) NOT NULL,
          body varchar(255) NOT NULL,
          notification_subject varchar(255) NOT NULL,
          notification_text_body varchar(255) NOT NULL,
          notification_html_body varchar(255) NOT NULL,
          notification_group_text_body varchar(255) NOT NULL,
          notification_group_html_body varchar(255) NOT NULL,
          mailkey varchar(255) NOT NULL,
          PRIMARY KEY  (mailkey)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
czarphanguye’s picture

czarphanguye commented

WOW... ZzZzZzZz

rszrama’s picture

rszrama commented

Simple fix... your PMs should all be in the database still, but there was a bug in the upgrade from 1.5 to 1.7 or somewhere around there. I never had a chance to fix it in the .install file. You need to edit your sequences table and manually set the private message ID up to be 1 greater than your highest valued private message. If you don't know how to do this, post back and I can try and walk you through it.

Also, I'm not sure if the latest code is all correct or not. I have posted the package here:
http://www.ubercart.org/forum/announcements/163/private_messaging_and_si...

czarphanguye’s picture

czarphanguye commented

Thanks for the reply m8. I dunno about the "manually set the private message ID up to be 1" part, yet I did grab "privatemsg-5--2-0.tar" from your web-site and I can finally send AND get messages. Perfect.

All the 'type' stuff is gone (it kind of looks like what I was running before the breakage.). Anyways. TY! <3

Side note
Using the one here @ Drupal I even added privatemsg_mail_edit, yet nothing. Stick with privatemsg-5--2-0.tar!

CREATE TABLE `privatemsg_mail_edit` (
`type` VARCHAR( 255 ) NOT NULL ,
`mailkey` VARCHAR( 255 ) NOT NULL ,
`notification_subject` VARCHAR( 255 ) NOT NULL ,
`notification_text_body` VARCHAR( 255 ) NOT NULL ,
`notification_html_body` VARCHAR( 255 ) NOT NULL ,
`notification_group_text_body` VARCHAR( 255 ) NOT NULL ,
`notification_group_html_body` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `mailkey` ) 
) ENGINE = MYISAM ;
igorik’s picture

igorik commented

Hi!

I have the same problem, I can't see anby private messages after upgrading on my test site, just paging is visible.
I tried your hint about give +1 number for privatemsg_id in sequences table but no progress.

I manually entered table 

db_query("CREATE TABLE {privatemsg_mail_edit} (
          type varchar(255) NOT NULL,
          mailkey varchar(255) NOT NULL,
          PRIMARY KEY  (mailkey)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

because update didn't insert it

anyway, no progress.
I have using old version of private messages (about month ago)

Igor
somvprahe.sk

salvis’s picture

salvis
he/his
commented
Status: Active » Fixed

http://drupal.org/node/167756

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)