Converting from vb3.6.8 -- Successful convert, but PM inbox contents missing

Started by I Agree, August 18, 2008, 09:19:46 AM

Previous topic - Next topic

I Agree

Our conversion script reported full success, but we've noticed the contents of PM inboxes didn't transfer over (while the contents of the outboxes did)

Since this is our only hurdle so far, we'd like to continue evaluating SMF. However we'd really like to fix this if at all possible (with a mysql script) before publishing the new bbs.

SleePy

The converter appears to convert all pms that are not in the folder whos id is -1.
Is it just showing the pms in the members outbox in SMF?

Did you get any errors during the conversion?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

I Agree

There were no errors visible in the converter output. The inbox after conversion is empty. The outbox retains all from the original forum.

Can anyone hack together a script that might correct this? (overwrite the inboxes with the old inboxes -- or even merge, though I've instructed beta users of the new bbs to not use PMs)

If not I'll have to try my own hand at it. Another full convert isn't desirable at this point just for PM retention.

SleePy

Well you can remove all parts of the conversion other than the pm conversion part :P

Take your vbulletin36_to_smf.sql file and change the contents of it to this:


/* ATTENTION: You don't need to run or use this file!  The convert.php script does everything for you! */

/******************************************************************************/
---~ name: "vBulletin 3.6"
/******************************************************************************/
---~ version: "SMF 2.0"
---~ settings: "/admin/config.php", "/includes/config.php"
---~ from_prefix: "`" . $config['Database']['dbname'] . "`." . $config['Database']['tableprefix'] . ""
---~ table_test: "{$from_prefix}user"

/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
    pm.pmid AS id_pm, pm.touserid AS id_member, pm.readtime != 0 AS is_read,
    '' AS labels
FROM {$from_prefix}pmreceipt AS pm;
---*


Does that make it work now?
I removed everything other than the part of the conversion that is failing at this moment.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

I Agree

Ok, did this. The PMs were reset, but there is still nothing in the inbox, while the outboxes were kept. In other words, same as after the first conversion attempt.

If I can help diagnose why this is happening in any way, please let me know. I'll try to look into it myself when I get a chance, but naturally this seems to be your shtick, so please help me in any way you can if you can!

Thanks for the attention btw :)

I Agree

I noticed in the vbulletin database there is an extra table called just "pm." I think maybe these are the inbox PMs?? They lack the timestamps and send ids and instead have folder ids (sorting) and read booleans.

Seems like probably the converter isn't touching this table at all. Fields are:

pmid
pmtextid
userid
folderid
messageread

Apologies if my parlance isn't Mysql kosher!

offtopic: Any straight forward way to encrypt the message text btw. I noticed the PM message bodies are all stored in plain text, which isn't very private if someone has easy access to the database!

We might make our site opensource, so it would be a breach of privacy to share the pm database without at least some basic encryption to at least deter snooping.

I Agree

Also I've noticed the "To" fields are empty in the outbox/sent messages after conversion. And not all of the outbox was retained after conversion.

It seems in general the conversion script is weak in the PM dept. for vb3.6.8?

SleePy

In SMF, does messages show in the inbox?

I am interested if its doing the second part of the conversion correctly to make the messages show in the members inbox on SMF.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

I Agree

Quote from: SleePy on August 21, 2008, 12:51:00 PM
In SMF, does messages show in the inbox?

I am interested if its doing the second part of the conversion correctly to make the messages show in the members inbox on SMF.

There is nothing in the inbox. There are PMs in the outbox (from the sent folder of the old bbs) but some PMs are lost in the outbox (so only part of them made it over). The "To" tags in the outbox messages are lost (the To text is just missing)

I assume the entire pm text makes it over, but the indexing isn't handled right.

SleePy

Would you be able to send me a small dump of your pm and pmreceipt table?

If its only getting it in the outbox, then it has the pms converted. It is just not getting the recipient data so it knows who the pm went to.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

I Agree

Will this work?

These seem to be outstanding PMs.


-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 22, 2008 at 04:29 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `d3old`
--

-- --------------------------------------------------------

--
-- Table structure for table `d3bbspmreceipt`
--

CREATE TABLE IF NOT EXISTS `d3bbspmreceipt` (
  `pmid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `touserid` int(10) unsigned NOT NULL default '0',
  `tousername` varchar(100) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `sendtime` int(10) unsigned NOT NULL default '0',
  `readtime` int(10) unsigned NOT NULL default '0',
  `denied` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pmid`),
  KEY `userid` (`userid`),
  KEY `touserid` (`touserid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `d3bbspmreceipt`
--

INSERT INTO `d3bbspmreceipt` (`pmid`, `userid`, `touserid`, `tousername`, `title`, `sendtime`, `readtime`, `denied`) VALUES
(261, 552, 443, 'john', 'xxxxxxx', 1187478300, 0, 1),
(1074, 9, 872, 'jane', 'Re: xxxxxxx', 1203373293, 0, 0),
(1160, 9, 872, 'jane', 'Re: xxxxxxx', 1204687477, 0, 0),
(1233, 9, 983, 'doe', 'xxxxxxx', 1209021916, 1209039335, 0);


The next dump is clipped to 16 rows.


-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 22, 2008 at 04:32 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `d3old`
--

-- --------------------------------------------------------

--
-- Table structure for table `d3bbspm`
--

CREATE TABLE IF NOT EXISTS `d3bbspm` (
  `pmid` int(10) unsigned NOT NULL auto_increment,
  `pmtextid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `folderid` smallint(6) NOT NULL default '0',
  `messageread` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pmid`),
  KEY `pmtextid` (`pmtextid`),
  KEY `userid` (`userid`,`folderid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1236 ;

--
-- Dumping data for table `d3bbspm`
--

INSERT INTO `d3bbspm` (`pmid`, `pmtextid`, `userid`, `folderid`, `messageread`) VALUES
(1, 1, 5, -1, 1),
(2, 1, 1, 0, 1),
(3, 2, 5, -1, 1),
(4, 2, 1, 0, 1),
(5, 3, 2, -1, 1),
(6, 3, 1, 0, 2),
(7, 4, 1, -1, 1),
(8, 4, 2, 0, 2),
(9, 5, 2, -1, 1),
(10, 5, 1, 0, 2),
(11, 6, 1, -1, 1),
(12, 6, 2, 0, 2),
(13, 7, 2, -1, 1),
(14, 7, 1, 0, 1),
(15, 8, 1, -1, 1),
(16, 8, 2, 0, 2);

SleePy

Is there no pm ids for 1-16 in the pmreceipt like the other sample data?

The odd thing is, that all the fields exist and look like they should be converting correctly.
What happens if you go to SMF -> Admin -> Forum Maintenance
Then click "Find and Repair Errors".

As well, if you go into the SMF database and go to the pm_recipients table. Is there any data in there?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

I Agree

I get this many errors:


The following errors are fouling up your forum:
Topic #503 has the wrong number of replies, 15.
Topic #523 has the wrong number of replies, 8.
Topic #526 has the wrong number of replies, 32.
Topic #536 has the wrong number of replies, 22.
Topic #554 has the wrong number of replies, 54.
Topic #555 has the wrong number of replies, 27.
Topic #564 has the wrong number of replies, 3.
Topic #580 has the wrong number of replies, 91.
Topic #586 has the wrong number of replies, 10.
Topic #594 has the wrong number of replies, 1.
Topic #604 has the wrong number of replies, 26.
Topic #605 has the wrong number of replies, 6.
Topic #606 has the wrong number of replies, 107.
Topic #664 has the wrong number of replies, 3.
Topic #705 has the wrong number of replies, 2.
Message #3325 was posted by member #445, who is now missing.
Message #3329 was posted by member #445, who is now missing.
Message #6326 was posted by member #445, who is now missing.
Message #6334 was posted by member #445, who is now missing.
Message #6342 was posted by member #445, who is now missing.
Message #6347 was posted by member #445, who is now missing.
Message #6349 was posted by member #445, who is now missing.
Message #6519 was posted by member #445, who is now missing.
Message #6521 was posted by member #445, who is now missing.
Message #6522 was posted by member #445, who is now missing.
Message #6534 was posted by member #445, who is now missing.
Message #6535 was posted by member #445, who is now missing.
Message #6542 was posted by member #445, who is now missing.
Message #6544 was posted by member #445, who is now missing.
Message #6547 was posted by member #445, who is now missing.
Message #6653 was posted by member #445, who is now missing.
Personal message #261 has been sent to one or more people, but does not exist.
Personal message #1233 has been sent to one or more people, but does not exist.
Personal message #526 was sent by member #445, who does not exist.
Personal message #530 was sent by member #445, who does not exist.
Personal message #545 was sent by member #445, who does not exist.
Personal message #549 was sent by member #445, who does not exist.
Personal message #553 was sent by member #445, who does not exist.
Personal message #555 was sent by member #445, who does not exist.
Personal message #557 was sent by member #445, who does not exist.
Personal message #594 was sent by member #445, who does not exist.
Personal message #592 was sent by member #445, who does not exist.
Personal message #606 was sent by member #445, who does not exist.
Personal message #608 was sent by member #445, who does not exist.
Personal message #616 was sent by member #445, who does not exist.
The subject of topic #3 is currently not stored in the subject cache.
The subject of topic #4 is currently not stored in the subject cache.
The subject of topic #5 is currently not stored in the subject cache.
The subject of topic #6 is currently not stored in the subject cache.
The subject of topic #8 is currently not stored in the subject cache.
The subject of topic #9 is currently not stored in the subject cache.
The subject of topic #10 is currently not stored in the subject cache.
The subject of topic #11 is currently not stored in the subject cache.
The subject of topic #12 is currently not stored in the subject cache.
The subject of topic #13 is currently not stored in the subject cache.
The subject of topic #14 is currently not stored in the subject cache.
The subject of topic #15 is currently not stored in the subject cache.
The subject of topic #16 is currently not stored in the subject cache.
The subject of topic #18 is currently not stored in the subject cache.
The subject of topic #19 is currently not stored in the subject cache.
The subject of topic #20 is currently not stored in the subject cache.
The subject of topic #21 is currently not stored in the subject cache.
The subject of topic #22 is currently not stored in the subject cache.
The subject of topic #23 is currently not stored in the subject cache.
The subject of topic #24 is currently not stored in the subject cache.
The subject of topic #25 is currently not stored in the subject cache.
The subject of topic #26 is currently not stored in the subject cache.
The subject of topic #27 is currently not stored in the subject cache.
The subject of topic #28 is currently not stored in the subject cache.
The subject of topic #29 is currently not stored in the subject cache.
The subject of topic #30 is currently not stored in the subject cache.
The subject of topic #31 is currently not stored in the subject cache.
The subject of topic #32 is currently not stored in the subject cache.
The subject of topic #33 is currently not stored in the subject cache.
The subject of topic #34 is currently not stored in the subject cache.
The subject of topic #35 is currently not stored in the subject cache.
The subject of topic #36 is currently not stored in the subject cache.
The subject of topic #37 is currently not stored in the subject cache.
The subject of topic #38 is currently not stored in the subject cache.
The subject of topic #40 is currently not stored in the subject cache.
The subject of topic #42 is currently not stored in the subject cache.
The subject of topic #43 is currently not stored in the subject cache.
The subject of topic #44 is currently not stored in the subject cache.
The subject of topic #45 is currently not stored in the subject cache.
The subject of topic #46 is currently not stored in the subject cache.
The subject of topic #47 is currently not stored in the subject cache.
The subject of topic #48 is currently not stored in the subject cache.
The subject of topic #49 is currently not stored in the subject cache.
The subject of topic #50 is currently not stored in the subject cache.
The subject of topic #52 is currently not stored in the subject cache.
The subject of topic #53 is currently not stored in the subject cache.
The subject of topic #54 is currently not stored in the subject cache.
The subject of topic #55 is currently not stored in the subject cache.
The subject of topic #56 is currently not stored in the subject cache.
The subject of topic #57 is currently not stored in the subject cache.
The subject of topic #58 is currently not stored in the subject cache.
The subject of topic #59 is currently not stored in the subject cache.
The subject of topic #60 is currently not stored in the subject cache.
The subject of topic #61 is currently not stored in the subject cache.
The subject of topic #64 is currently not stored in the subject cache.
The subject of topic #65 is currently not stored in the subject cache.
The subject of topic #66 is currently not stored in the subject cache.
The subject of topic #67 is currently not stored in the subject cache.
The subject of topic #68 is currently not stored in the subject cache.
The subject of topic #69 is currently not stored in the subject cache.
The subject of topic #70 is currently not stored in the subject cache.
The subject of topic #71 is currently not stored in the subject cache.
The subject of topic #72 is currently not stored in the subject cache.
The subject of topic #73 is currently not stored in the subject cache.
The subject of topic #74 is currently not stored in the subject cache.
The subject of topic #75 is currently not stored in the subject cache.
The subject of topic #76 is currently not stored in the subject cache.
The subject of topic #77 is currently not stored in the subject cache.
The subject of topic #78 is currently not stored in the subject cache.
The subject of topic #79 is currently not stored in the subject cache.
The subject of topic #80 is currently not stored in the subject cache.
The subject of topic #81 is currently not stored in the subject cache.
The subject of topic #82 is currently not stored in the subject cache.
The subject of topic #84 is currently not stored in the subject cache.
The subject of topic #85 is currently not stored in the subject cache.
The subject of topic #86 is currently not stored in the subject cache.
The subject of topic #87 is currently not stored in the subject cache.
The subject of topic #88 is currently not stored in the subject cache.
The subject of topic #89 is currently not stored in the subject cache.
The subject of topic #90 is currently not stored in the subject cache.
The subject of topic #91 is currently not stored in the subject cache.
The subject of topic #92 is currently not stored in the subject cache.
The subject of topic #93 is currently not stored in the subject cache.
The subject of topic #94 is currently not stored in the subject cache.
The subject of topic #95 is currently not stored in the subject cache.
The subject of topic #96 is currently not stored in the subject cache.
The subject of topic #100 is currently not stored in the subject cache.
The subject of topic #101 is currently not stored in the subject cache.
The subject of topic #102 is currently not stored in the subject cache.
The subject of topic #103 is currently not stored in the subject cache.
The subject of topic #104 is currently not stored in the subject cache.
The subject of topic #105 is currently not stored in the subject cache.
The subject of topic #107 is currently not stored in the subject cache.
The subject of topic #108 is currently not stored in the subject cache.
The subject of topic #109 is currently not stored in the subject cache.
The subject of topic #119 is currently not stored in the subject cache.
The subject of topic #121 is currently not stored in the subject cache.
The subject of topic #123 is currently not stored in the subject cache.
The subject of topic #128 is currently not stored in the subject cache.
The subject of topic #129 is currently not stored in the subject cache.
The subject of topic #130 is currently not stored in the subject cache.
The subject of topic #132 is currently not stored in the subject cache.
The subject of topic #133 is currently not stored in the subject cache.
The subject of topic #134 is currently not stored in the subject cache.
The subject of topic #135 is currently not stored in the subject cache.
The subject of topic #136 is currently not stored in the subject cache.
The subject of topic #137 is currently not stored in the subject cache.
The subject of topic #138 is currently not stored in the subject cache.
The subject of topic #139 is currently not stored in the subject cache.
The subject of topic #140 is currently not stored in the subject cache.
The subject of topic #142 is currently not stored in the subject cache.
The subject of topic #143 is currently not stored in the subject cache.
The subject of topic #144 is currently not stored in the subject cache.
The subject of topic #145 is currently not stored in the subject cache.
The subject of topic #146 is currently not stored in the subject cache.
The subject of topic #147 is currently not stored in the subject cache.
The subject of topic #148 is currently not stored in the subject cache.
The subject of topic #152 is currently not stored in the subject cache.
The subject of topic #156 is currently not stored in the subject cache.
The subject of topic #157 is currently not stored in the subject cache.
The subject of topic #162 is currently not stored in the subject cache.
The subject of topic #163 is currently not stored in the subject cache.
The subject of topic #166 is currently not stored in the subject cache.
The subject of topic #178 is currently not stored in the subject cache.
The subject of topic #183 is currently not stored in the subject cache.
The subject of topic #184 is currently not stored in the subject cache.
The subject of topic #187 is currently not stored in the subject cache.
The subject of topic #191 is currently not stored in the subject cache.
The subject of topic #192 is currently not stored in the subject cache.
The subject of topic #194 is currently not stored in the subject cache.
The subject of topic #200 is currently not stored in the subject cache.
The subject of topic #203 is currently not stored in the subject cache.
The subject of topic #207 is currently not stored in the subject cache.
The subject of topic #212 is currently not stored in the subject cache.
The subject of topic #214 is currently not stored in the subject cache.
The subject of topic #217 is currently not stored in the subject cache.
The subject of topic #220 is currently not stored in the subject cache.
The subject of topic #222 is currently not stored in the subject cache.
The subject of topic #227 is currently not stored in the subject cache.
The subject of topic #329 is currently not stored in the subject cache.
The subject of topic #330 is currently not stored in the subject cache.
The subject of topic #331 is currently not stored in the subject cache.
The subject of topic #332 is currently not stored in the subject cache.
The subject of topic #333 is currently not stored in the subject cache.
The subject of topic #336 is currently not stored in the subject cache.
The subject of topic #341 is currently not stored in the subject cache.
The subject of topic #342 is currently not stored in the subject cache.
The subject of topic #343 is currently not stored in the subject cache.
The subject of topic #344 is currently not stored in the subject cache.
The subject of topic #345 is currently not stored in the subject cache.
The subject of topic #346 is currently not stored in the subject cache.
The subject of topic #347 is currently not stored in the subject cache.
The subject of topic #349 is currently not stored in the subject cache.
The subject of topic #350 is currently not stored in the subject cache.
The subject of topic #351 is currently not stored in the subject cache.
The subject of topic #352 is currently not stored in the subject cache.
The subject of topic #353 is currently not stored in the subject cache.
The subject of topic #354 is currently not stored in the subject cache.
The subject of topic #355 is currently not stored in the subject cache.
The subject of topic #357 is currently not stored in the subject cache.
The subject of topic #358 is currently not stored in the subject cache.
The subject of topic #359 is currently not stored in the subject cache.
The subject of topic #360 is currently not stored in the subject cache.
The subject of topic #361 is currently not stored in the subject cache.
The subject of topic #362 is currently not stored in the subject cache.
The subject of topic #363 is currently not stored in the subject cache.
The subject of topic #364 is currently not stored in the subject cache.
The subject of topic #367 is currently not stored in the subject cache.
The subject of topic #368 is currently not stored in the subject cache.
The subject of topic #369 is currently not stored in the subject cache.
The subject of topic #370 is currently not stored in the subject cache.
The subject of topic #372 is currently not stored in the subject cache.
The subject of topic #373 is currently not stored in the subject cache.
The subject of topic #374 is currently not stored in the subject cache.
The subject of topic #375 is currently not stored in the subject cache.
The subject of topic #376 is currently not stored in the subject cache.
The subject of topic #377 is currently not stored in the subject cache.
The subject of topic #378 is currently not stored in the subject cache.
The subject of topic #379 is currently not stored in the subject cache.
The subject of topic #380 is currently not stored in the subject cache.
The subject of topic #381 is currently not stored in the subject cache.
The subject of topic #383 is currently not stored in the subject cache.
The subject of topic #384 is currently not stored in the subject cache.
The subject of topic #388 is currently not stored in the subject cache.
The subject of topic #389 is currently not stored in the subject cache.
The subject of topic #390 is currently not stored in the subject cache.
The subject of topic #393 is currently not stored in the subject cache.
The subject of topic #394 is currently not stored in the subject cache.
The subject of topic #399 is currently not stored in the subject cache.
The subject of topic #400 is currently not stored in the subject cache.
The subject of topic #401 is currently not stored in the subject cache.
The subject of topic #402 is currently not stored in the subject cache.
The subject of topic #403 is currently not stored in the subject cache.
The subject of topic #404 is currently not stored in the subject cache.
The subject of topic #406 is currently not stored in the subject cache.
The subject of topic #407 is currently not stored in the subject cache.
The subject of topic #410 is currently not stored in the subject cache.
The subject of topic #411 is currently not stored in the subject cache.
The subject of topic #412 is currently not stored in the subject cache.
The subject of topic #413 is currently not stored in the subject cache.
The subject of topic #414 is currently not stored in the subject cache.
The subject of topic #415 is currently not stored in the subject cache.
The subject of topic #416 is currently not stored in the subject cache.
The subject of topic #417 is currently not stored in the subject cache.
The subject of topic #418 is currently not stored in the subject cache.
The subject of topic #419 is currently not stored in the subject cache.
The subject of topic #422 is currently not stored in the subject cache.
The subject of topic #423 is currently not stored in the subject cache.
The subject of topic #424 is currently not stored in the subject cache.
The subject of topic #425 is currently not stored in the subject cache.
The subject of topic #426 is currently not stored in the subject cache.
The subject of topic #427 is currently not stored in the subject cache.
The subject of topic #428 is currently not stored in the subject cache.
The subject of topic #429 is currently not stored in the subject cache.
The subject of topic #430 is currently not stored in the subject cache.
The subject of topic #431 is currently not stored in the subject cache.
The subject of topic #432 is currently not stored in the subject cache.
The subject of topic #433 is currently not stored in the subject cache.
The subject of topic #434 is currently not stored in the subject cache.
The subject of topic #435 is currently not stored in the subject cache.
The subject of topic #436 is currently not stored in the subject cache.
The subject of topic #437 is currently not stored in the subject cache.
The subject of topic #438 is currently not stored in the subject cache.
The subject of topic #439 is currently not stored in the subject cache.
The subject of topic #440 is currently not stored in the subject cache.
The subject of topic #441 is currently not stored in the subject cache.
The subject of topic #442 is currently not stored in the subject cache.
The subject of topic #443 is currently not stored in the subject cache.
The subject of topic #444 is currently not stored in the subject cache.
The subject of topic #445 is currently not stored in the subject cache.
The subject of topic #446 is currently not stored in the subject cache.
The subject of topic #447 is currently not stored in the subject cache.
The subject of topic #448 is currently not stored in the subject cache.
The subject of topic #449 is currently not stored in the subject cache.
The subject of topic #450 is currently not stored in the subject cache.
The subject of topic #451 is currently not stored in the subject cache.
The subject of topic #452 is currently not stored in the subject cache.
The subject of topic #453 is currently not stored in the subject cache.
The subject of topic #455 is currently not stored in the subject cache.
The subject of topic #456 is currently not stored in the subject cache.
The subject of topic #457 is currently not stored in the subject cache.
The subject of topic #458 is currently not stored in the subject cache.
The subject of topic #459 is currently not stored in the subject cache.
The subject of topic #460 is currently not stored in the subject cache.
The subject of topic #461 is currently not stored in the subject cache.
The subject of topic #462 is currently not stored in the subject cache.
The subject of topic #463 is currently not stored in the subject cache.
The subject of topic #464 is currently not stored in the subject cache.
The subject of topic #465 is currently not stored in the subject cache.
The subject of topic #466 is currently not stored in the subject cache.
The subject of topic #467 is currently not stored in the subject cache.
The subject of topic #468 is currently not stored in the subject cache.
The subject of topic #469 is currently not stored in the subject cache.
The subject of topic #470 is currently not stored in the subject cache.
The subject of topic #471 is currently not stored in the subject cache.
The subject of topic #472 is currently not stored in the subject cache.
The subject of topic #473 is currently not stored in the subject cache.
The subject of topic #474 is currently not stored in the subject cache.
The subject of topic #475 is currently not stored in the subject cache.
The subject of topic #476 is currently not stored in the subject cache.
The subject of topic #477 is currently not stored in the subject cache.
The subject of topic #478 is currently not stored in the subject cache.
The subject of topic #479 is currently not stored in the subject cache.
The subject of topic #480 is currently not stored in the subject cache.
The subject of topic #481 is currently not stored in the subject cache.
The subject of topic #482 is currently not stored in the subject cache.
The subject of topic #483 is currently not stored in the subject cache.
The subject of topic #484 is currently not stored in the subject cache.
The subject of topic #485 is currently not stored in the subject cache.
The subject of topic #486 is currently not stored in the subject cache.
The subject of topic #487 is currently not stored in the subject cache.
The subject of topic #489 is currently not stored in the subject cache.
The subject of topic #490 is currently not stored in the subject cache.
The subject of topic #491 is currently not stored in the subject cache.
The subject of topic #493 is currently not stored in the subject cache.
The subject of topic #494 is currently not stored in the subject cache.
The subject of topic #495 is currently not stored in the subject cache.
The subject of topic #496 is currently not stored in the subject cache.
The subject of topic #498 is currently not stored in the subject cache.
The subject of topic #500 is currently not stored in the subject cache.
The subject of topic #501 is currently not stored in the subject cache.
The subject of topic #502 is currently not stored in the subject cache.
The subject of topic #503 is currently not stored in the subject cache.
The subject of topic #506 is currently not stored in the subject cache.
The subject of topic #507 is currently not stored in the subject cache.
The subject of topic #508 is currently not stored in the subject cache.
The subject of topic #509 is currently not stored in the subject cache.
The subject of topic #510 is currently not stored in the subject cache.
The subject of topic #511 is currently not stored in the subject cache.
The subject of topic #512 is currently not stored in the subject cache.
The subject of topic #513 is currently not stored in the subject cache.
The subject of topic #514 is currently not stored in the subject cache.
The subject of topic #515 is currently not stored in the subject cache.
The subject of topic #518 is currently not stored in the subject cache.
The subject of topic #519 is currently not stored in the subject cache.
The subject of topic #520 is currently not stored in the subject cache.
The subject of topic #521 is currently not stored in the subject cache.
The subject of topic #522 is currently not stored in the subject cache.
The subject of topic #523 is currently not stored in the subject cache.
The subject of topic #524 is currently not stored in the subject cache.
The subject of topic #525 is currently not stored in the subject cache.
The subject of topic #526 is currently not stored in the subject cache.
The subject of topic #527 is currently not stored in the subject cache.
The subject of topic #528 is currently not stored in the subject cache.
The subject of topic #529 is currently not stored in the subject cache.
The subject of topic #530 is currently not stored in the subject cache.
The subject of topic #531 is currently not stored in the subject cache.
The subject of topic #532 is currently not stored in the subject cache.
The subject of topic #533 is currently not stored in the subject cache.
The subject of topic #534 is currently not stored in the subject cache.
The subject of topic #535 is currently not stored in the subject cache.
The subject of topic #536 is currently not stored in the subject cache.
The subject of topic #539 is currently not stored in the subject cache.
The subject of topic #540 is currently not stored in the subject cache.
The subject of topic #542 is currently not stored in the subject cache.
The subject of topic #544 is currently not stored in the subject cache.
The subject of topic #545 is currently not stored in the subject cache.
The subject of topic #546 is currently not stored in the subject cache.
The subject of topic #547 is currently not stored in the subject cache.
The subject of topic #548 is currently not stored in the subject cache.
The subject of topic #549 is currently not stored in the subject cache.
The subject of topic #551 is currently not stored in the subject cache.
The subject of topic #552 is currently not stored in the subject cache.
The subject of topic #554 is currently not stored in the subject cache.
The subject of topic #555 is currently not stored in the subject cache.
The subject of topic #556 is currently not stored in the subject cache.
The subject of topic #557 is currently not stored in the subject cache.
The subject of topic #559 is currently not stored in the subject cache.
The subject of topic #560 is currently not stored in the subject cache.
The subject of topic #561 is currently not stored in the subject cache.
The subject of topic #563 is currently not stored in the subject cache.
The subject of topic #564 is currently not stored in the subject cache.
The subject of topic #565 is currently not stored in the subject cache.
The subject of topic #566 is currently not stored in the subject cache.
The subject of topic #567 is currently not stored in the subject cache.
The subject of topic #568 is currently not stored in the subject cache.
The subject of topic #569 is currently not stored in the subject cache.
The subject of topic #570 is currently not stored in the subject cache.
The subject of topic #573 is currently not stored in the subject cache.
The subject of topic #574 is currently not stored in the subject cache.
The subject of topic #575 is currently not stored in the subject cache.
The subject of topic #577 is currently not stored in the subject cache.
The subject of topic #578 is currently not stored in the subject cache.
The subject of topic #579 is currently not stored in the subject cache.
The subject of topic #580 is currently not stored in the subject cache.
The subject of topic #581 is currently not stored in the subject cache.
The subject of topic #583 is currently not stored in the subject cache.
The subject of topic #585 is currently not stored in the subject cache.
The subject of topic #586 is currently not stored in the subject cache.
The subject of topic #588 is currently not stored in the subject cache.
The subject of topic #589 is currently not stored in the subject cache.
The subject of topic #590 is currently not stored in the subject cache.
The subject of topic #592 is currently not stored in the subject cache.
The subject of topic #594 is currently not stored in the subject cache.
The subject of topic #595 is currently not stored in the subject cache.
The subject of topic #596 is currently not stored in the subject cache.
The subject of topic #597 is currently not stored in the subject cache.
The subject of topic #598 is currently not stored in the subject cache.
The subject of topic #599 is currently not stored in the subject cache.
The subject of topic #601 is currently not stored in the subject cache.
The subject of topic #603 is currently not stored in the subject cache.
The subject of topic #604 is currently not stored in the subject cache.
The subject of topic #605 is currently not stored in the subject cache.
The subject of topic #606 is currently not stored in the subject cache.
The subject of topic #607 is currently not stored in the subject cache.
The subject of topic #609 is currently not stored in the subject cache.
The subject of topic #610 is currently not stored in the subject cache.
The subject of topic #612 is currently not stored in the subject cache.
The subject of topic #613 is currently not stored in the subject cache.
The subject of topic #614 is currently not stored in the subject cache.
The subject of topic #615 is currently not stored in the subject cache.
The subject of topic #616 is currently not stored in the subject cache.
The subject of topic #617 is currently not stored in the subject cache.
The subject of topic #618 is currently not stored in the subject cache.
The subject of topic #619 is currently not stored in the subject cache.
The subject of topic #621 is currently not stored in the subject cache.
The subject of topic #623 is currently not stored in the subject cache.
The subject of topic #624 is currently not stored in the subject cache.
The subject of topic #627 is currently not stored in the subject cache.
The subject of topic #628 is currently not stored in the subject cache.
The subject of topic #629 is currently not stored in the subject cache.
The subject of topic #630 is currently not stored in the subject cache.
The subject of topic #634 is currently not stored in the subject cache.
The subject of topic #636 is currently not stored in the subject cache.
The subject of topic #637 is currently not stored in the subject cache.
The subject of topic #640 is currently not stored in the subject cache.
The subject of topic #642 is currently not stored in the subject cache.
The subject of topic #647 is currently not stored in the subject cache.
The subject of topic #650 is currently not stored in the subject cache.
The subject of topic #651 is currently not stored in the subject cache.
The subject of topic #652 is currently not stored in the subject cache.
The subject of topic #653 is currently not stored in the subject cache.
The subject of topic #657 is currently not stored in the subject cache.
The subject of topic #658 is currently not stored in the subject cache.
The subject of topic #659 is currently not stored in the subject cache.
The subject of topic #660 is currently not stored in the subject cache.
The subject of topic #661 is currently not stored in the subject cache.
The subject of topic #663 is currently not stored in the subject cache.
The subject of topic #664 is currently not stored in the subject cache.
The subject of topic #666 is currently not stored in the subject cache.
The subject of topic #668 is currently not stored in the subject cache.
The subject of topic #669 is currently not stored in the subject cache.
The subject of topic #670 is currently not stored in the subject cache.
The subject of topic #671 is currently not stored in the subject cache.
The subject of topic #674 is currently not stored in the subject cache.
The subject of topic #675 is currently not stored in the subject cache.
The subject of topic #676 is currently not stored in the subject cache.
The subject of topic #677 is currently not stored in the subject cache.
The subject of topic #678 is currently not stored in the subject cache.
The subject of topic #680 is currently not stored in the subject cache.
The subject of topic #681 is currently not stored in the subject cache.
The subject of topic #682 is currently not stored in the subject cache.
The subject of topic #683 is currently not stored in the subject cache.
The subject of topic #685 is currently not stored in the subject cache.
The subject of topic #686 is currently not stored in the subject cache.
The subject of topic #687 is currently not stored in the subject cache.
The subject of topic #688 is currently not stored in the subject cache.
The subject of topic #689 is currently not stored in the subject cache.
The subject of topic #691 is currently not stored in the subject cache.
The subject of topic #692 is currently not stored in the subject cache.
The subject of topic #693 is currently not stored in the subject cache.
The subject of topic #694 is currently not stored in the subject cache.
The subject of topic #695 is currently not stored in the subject cache.
The subject of topic #696 is currently not stored in the subject cache.
The subject of topic #697 is currently not stored in the subject cache.
The subject of topic #698 is currently not stored in the subject cache.
The subject of topic #699 is currently not stored in the subject cache.
The subject of topic #700 is currently not stored in the subject cache.
The subject of topic #703 is currently not stored in the subject cache.
The subject of topic #705 is currently not stored in the subject cache.
The subject of topic #710 is currently not stored in the subject cache.
The subject of topic #711 is currently not stored in the subject cache.
The subject of topic #712 is currently not stored in the subject cache.
The subject of topic #714 is currently not stored in the subject cache.
The subject of topic #715 is currently not stored in the subject cache.
The subject of topic #718 is currently not stored in the subject cache.
The subject of topic #719 is currently not stored in the subject cache.
Cached word 'SMF' is linked to a non-existent topic.
Cached word 'to' is linked to a non-existent topic.
Cached word 'Welcome' is linked to a non-existent topic.

I'm worried about fixing them... I fear losing content.

ThorstenE

no panic ;) you can make a backup from your database before "Find and Repair Errors" ..

- most parts in the above post are missing search table entries (this is normal after convertig to SMF)
- some of them come from a member with ID 445 and the member account is (possible) not existing (in your old vBulletin)?
- a few topics have a wrong number of replies in the topics-table..

I Agree

I'm just curious what the fixes would actually do. Whether they would mean any less content might be accessible. I imagine the missing IDs were deleted or something. I know of one deleted account (not sure why it was deleted) that I've seen posts from. They're fine in the board view, but if you try to access the profile it throws up a user does not exist page. For instance, if that be the case, and "fixed", then what would happen to those posts?

I'm more worried about losing information and not realizing it, than the bbs breaking. I will back it up though and get back to this thread.

I'm puzzled what could be going on if there is so much confidence in the converter.

After fixing I get:

Quote
All errors fixed! Please check on any categories, boards, or topics created to decide what to do with them.

Back to Forum Maintenance

Is there somewhere I can see the repaired sections and "decide what to do with them"?


PS: Nothing new on the PM front.

I Agree

Quote
As well, if you go into the SMF database and go to the pm_recipients table. Is there any data in there?


-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 23, 2008 at 09:39 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `d3old`
--

-- --------------------------------------------------------

--
-- Table structure for table `smf_pm_recipients`
--

CREATE TABLE IF NOT EXISTS `smf_pm_recipients` (
  `ID_PM` int(10) unsigned NOT NULL default '0',
  `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
  `labels` varchar(60) NOT NULL default '-1',
  `bcc` tinyint(3) unsigned NOT NULL default '0',
  `is_read` tinyint(3) unsigned NOT NULL default '0',
  `deleted` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID_PM`,`ID_MEMBER`),
  UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`deleted`,`ID_PM`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `smf_pm_recipients`
--

INSERT INTO `smf_pm_recipients` (`ID_PM`, `ID_MEMBER`, `labels`, `bcc`, `is_read`, `deleted`) VALUES
(1074, 872, '', 0, 0, 0),
(1160, 872, '', 0, 0, 0);

SleePy

Is there more than that in the table or was that just a sample?
That sample shows me they do exist in SMF's database. Just something is not right to have them show.
The labels might be off though, which could be the issue.
Try this query in phpMyAdmin:
UPDATE smf_pm_recipients
SET labels = '-1'


This will force all pms to default to the inbox.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

I Agree

That is the entire table.


UPDATE smf_pm_recipients
SET labels = '-1'


changed nothing.

edited: Seems the problem is more that there is no real smf_pm_recipients table after the conversion. My guess is this is because the pm_recipients in VB are only the outstanding PMs. That is PMs waiting for the recipient user to login so they can be sent (in vb you can edit your PMs in your outbox until the recipient logs in)

I think there is a more fundamental misunderstanding going on here. And maybe people who've used the converter in the past simply didn't value old PMs enough to report it.

What we're missing after conversion is all the PMs users had accumulated in their inbox. Also I'm pretty sure all of the outbox messages didn't make it over either. That is the outbox seems to be cutoff after so many messages.

I think all the pm_text made the crossover but the indexing is definitely not right.

SleePy

What is the structure of the pm_text table in vb then?

If the receipients table doesn't hold the actual data of who received the pm. Then I would assume that the next best thing looking at how vb is handling it, is in the actual pm table conains the user it went to while the pm_text is holding who sent it.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

I Agree


-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 24, 2008 at 12:12 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `d3old`
--

-- --------------------------------------------------------

--
-- Table structure for table `d3bbspmtext`
--

CREATE TABLE IF NOT EXISTS `d3bbspmtext` (
  `pmtextid` int(10) unsigned NOT NULL auto_increment,
  `fromuserid` int(10) unsigned NOT NULL default '0',
  `fromusername` varchar(100) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `message` mediumtext NOT NULL,
  `touserarray` mediumtext NOT NULL,
  `iconid` smallint(5) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `showsignature` smallint(5) unsigned NOT NULL default '0',
  `allowsmilie` smallint(5) unsigned NOT NULL default '1',
  PRIMARY KEY  (`pmtextid`),
  KEY `fromuserid` (`fromuserid`,`dateline`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=861 ;


SleePy

Ok,
Give this one a shot. It will only convert the trouble area we are having right now.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

I Agree

Quote from: SleePy on August 25, 2008, 01:57:35 PM
Ok,
Give this one a shot. It will only convert the trouble area we are having right now.

Ok, this looks like a winner  :-*

Just for the record, the conversion could probably be made more perfect. However this should satisfy anyone converting over I'd think. I hope this has helped perfect the conversion script a little...

Thanks for your support!

Advertisement: