Info
- 5 posts
- 4 voices
- Started 2 years ago by PS Vita
- Latest reply from chrishajer
- This topic is resolved
BBPM Problem
-
- Posted 2 years ago #
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!
-
- Posted 2 years 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 ;
-
- Posted 2 years ago #
Thanks! It worked!
-
- Posted 2 years ago #
Amazing Paul
-
- Posted 2 years ago #
Jongeren Forum, I deleted your off-topic reply. Please start a new topic for your translation problem. Thanks.
-
You must log in to post.