Snitz Forums import will not import private messages

[pipedreams]

The Snitz importer works fine for me except for private messages.
(I've imported from ms access to mysql, and everyting else imports ok)

My snitz pm structure is standard and has messages in it.

It seems the query to select them for import is empty, from what I can debug.
(I have not modified the import code)

Any ideas what could be wrong?

[Jerry]

When you run the import PM module what does it say.

[pipedreams]

"imported 0 of 0"

[Jerry]

And what it is in the source prefix_PM table ?

[pipedreams]

"FORUM_" all thread, users, posts import fine though

[Jerry]

And what it is in the source prefix_PM table ?

The question is, what is in the source database for the prefix_PM table.

Just because some things import dosn't mean they all will or that 100% of the source data is perfect.

[pipedreams]

Its a standard snitz pm table, with about 4000 user private messages...

[Jerry]

All I can think is that its failing on the tablecheck, delete lines 391,392 and 409 from impex/systems/snitz/000.php i.e. the if($this->check_table()) and braces for the if.

[pipedreams]

:D It worked!! - thanks so so much! ;)

[pipedreams]

I was too eager - pm message headers worked - but not the message body text.

VB stored them in a different table?

[pipedreams]

I looked into this more and it seems that the "message" field in the vb table is empty, where as the private messagse text (m_message) exists in the snitz pm table.

It there another check thats failing, or maybe the field casting is not working?

[Jerry]

What version of snitz are you running as in 3.4.04 all the PM data is in one table, there isn't a seprate table.

[pipedreams]

I meant that vbulletin has 2 tables.

My snitz has it all in forum_pm and ver 3.4.04.

It just seems that the messages bodies are not been imported, but the vbulletin tables (after import) have data in both of them but not message (body data) in pmtext

[Jerry]

My bad, typo !!

Line 139 of impex/systems/snitz/008.php should be :



$vB_pm_text->set_value('mandatory', 'message',$this->html_2_bb($pm['M_MESSAGE']));


Not $pm_text['M_MESSAGE'] .

[pipedreams]

It worked after I made that change!

Much much thanks, as its a relief for me to get the pm's imported!