Hello, i got a problem with my database.

I deleted the bb_bbpm table in my database and re-installed the plugin againg.

Now i get the following error when i try to send a message to anyone:

“Either your outbox or the recipient’s inbox is full.”

The PM will send it but when i try to open it there is no text in it.

Can someone tell me how to add the db table back and which fields i need to use?

It is no problem if all my pm’s will deleted btw.

Thanks in advance!

[@paulhawke Member 14 years, 10 months ago]

I installed the plugin, deleted the table … then walked through rebuilding the database from what I saw in the code. The following SQL is an export of my bb_bbpm table direct from mySQL. If you run it, you should get PMs back up and running.

CREATE TABLE IF NOT EXISTS bb_bbpm (

ID bigint(20) unsigned NOT NULL auto_increment,

pm_title varchar(100) collate utf8_unicode_ci NOT NULL,

pm_read tinyint(1) NOT NULL default 0,

pm_from bigint(20) unsigned NOT NULL,

pm_to bigint(20) unsigned NOT NULL,

pm_text text collate utf8_unicode_ci NOT NULL,

sent_on int(10) NOT NULL,

del_sender tinyint(1) NOT NULL default 0,

del_reciever tinyint(1) NOT NULL default 0,

reply_to bigint(20) unsigned default NULL,

thread_depth int(10) unsigned NOT NULL default 0,

pm_thread bigint(20) unsigned NOT NULL,

PRIMARY KEY (ID),

KEY pm_to (pm_to,pm_from,reply_to),

KEY pm_thread (pm_thread)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

[@56alifar Blocked 14 years, 10 months ago]

Thanks! It worked!

[@chandersbs Member 14 years, 10 months ago]

Amazing Paul

[@chrishajer Participant 14 years, 10 months ago]

Jongeren Forum, I deleted your off-topic reply. Please start a new topic for your translation problem. Thanks.