Announcement

Collapse
No announcement yet.

Snitz Forums import will not import private messages

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Snitz Forums import will not import private messages

    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?

  • #2
    When you run the import PM module what does it say.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      "imported 0 of 0"

      Comment


      • #4
        And what it is in the source prefix_PM table ?
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          "FORUM_" all thread, users, posts import fine though

          Comment


          • #6
            Originally posted by 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.
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              Its a standard snitz pm table, with about 4000 user private messages...
              Last edited by pipedreams; Wed 27 Apr '05, 2:00pm.

              Comment


              • #8
                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.
                I wrote ImpEx.

                Blog | Me

                Comment


                • #9
                  It worked!! - thanks so so much!

                  Comment


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

                    VB stored them in a different table?

                    Comment


                    • #11
                      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?

                      Comment


                      • #12
                        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.
                        I wrote ImpEx.

                        Blog | Me

                        Comment


                        • #13
                          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

                          Comment


                          • #14
                            My bad, typo !!

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

                            PHP Code:
                            $vB_pm_text->set_value('mandatory''message',$this->html_2_bb($pm['M_MESSAGE'])); 
                            Not $pm_text['M_MESSAGE'] .
                            I wrote ImpEx.

                            Blog | Me

                            Comment


                            • #15
                              It worked after I made that change!

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

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X