from forum to suite

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fabioo
    Member
    • Jun 2012
    • 58
    • 4.2.x

    from forum to suite

    Hi,

    I have a problem when importing attachments because i noticed that the "filedata" table structure of suite database is different from that of the forum.

    Code:
    mysql error: Invalid SQL:                 INSERT INTO filedata
                    (
                        importfiledataid,
                        userid,
                        dateline,
                        thumbnail_dateline,
                        filesize,
                        filehash,
                        extension,
                        height,
                        width,
                        refcount
                    )
                    VALUES
                    (
                        1,
                        2,
                        1358240402,
                        1358240402,
                        16429,
                        '1ab55208de870b7715c7a1e5fa444b40',
                        'jpg',
                        0,
                        0,
                        1
                    )
                
    
    
    
    
    mysql error: Unknown column 'importfiledataid' in 'field list'
    
    
    
    
    mysql error number: 1054
    how can I fix this?

    Thanks
    Fabio
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24359
    • 5.7.X

    #2
    Simple solution - don't use Impex!

    When moving from 4.x Forum to 4.x Publishing Suite, you just upgrade as normal and the CMS and Blog are installed as part of the upgrade process
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • Fabioo
      Member
      • Jun 2012
      • 58
      • 4.2.x

      #3
      how do I make the switch? i load the Suite files above those te forum files

      Comment

      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24359
        • 5.7.X

        #4
        Same way as a normal upgrade - upload all files (except install/install.php and includes/config.php.new) making sure you overwrite all files currently on your server then run the upgrade script.
        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

        Comment

        • Fabioo
          Member
          • Jun 2012
          • 58
          • 4.2.x

          #5
          thank you very much operation completed without errors

          Regards
          Fabio

          Comment

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