Announcement

Collapse
No announcement yet.

Impex Attachment Import

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

  • Impex Attachment Import

    I got WAMPS up and running on my local so I could more easily import by PHPBB board.

    (By the way Jerry I apprecite all your help to date on this. I figured it would be easiest if I could import myself)

    Anyway, I'm to the point where I need to import my attachments. I have downloaded them all off my site and placed them in a folder:

    C:\wamp\www\forums\attachments

    the forums exist at

    C:\wamp\www\forums\

    So for the full path to the attachments folder I enter:

    /www/forums/attachments

    or

    /forums/attachments

    Does not like either one. Tells me it cannot find the files. Am I missing something?

  • #2
    If its this :

    C:\wamp\www\forums\attachments

    Then enter that as its the full path and PHP should resolve it.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Worked like a charm, thanks Jerry

      Comment


      • #4
        Actually not quite...

        I get this error on one of the files.

        Code:
        ImpEx Database errormysql error: Invalid SQL: 
                                    UPDATE vb_attachment
                                    SET
                                    filedata = 'PK\0\0\0\0˜’.ÎýW¹zX2\0hß3\02\0\0\01GHybernate-Q330909-xp/Q330909_WXP_SP2_x86_ENU.exeì½
        XT×µ0|†à\0ƒgT0Ä`œD’šX’ÑD2š‚p 
        
        (snip a bunch of garbage)
        
                                    filesize = 3299770
                                    WHERE attachmentid = 44
                                
        
        mysql error: MySQL server has gone away
        
        mysql error number: 2006
        
        Date: Wednesday 30th 2006f August 2006 08:28:30 AM
        Database: test
        MySQL error:
        Any way of telling what file it bombed on or how to get past this error?

        Comment


        • #5
          It's your database that has bombed, not ImpEx.

          mysql error: MySQL server has gone away
          Check to see what your max_packet size is for MySQL, if its very small or your database is unreliable, I suggest storing the attachments in the file system.
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            The DB seems pretty reliable.

            Where is the max_packet setting contained?

            Comment


            • #7
              AdminCP > Maintenance > System Information > MySQL Variables

              In there will be max_allowed_packet.

              What is it's value ?
              I wrote ImpEx.

              Blog | Me

              Comment


              • #8
                1048576

                Some of the attachments MIGHT be larger than this. How would I change the mysql settings?

                Comment


                • #9
                  Would have to talk to your host about that and get their admin to sort it out.

                  I would suggest using the file system for storage and giving the import another go.
                  I wrote ImpEx.

                  Blog | Me

                  Comment


                  • #10
                    Actually this import is being done on my locl WAMPS setup so I would change it.

                    What are the pros/cons to file system storage?

                    Comment

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