Announcement

Collapse
No announcement yet.

Problem Importing MS SQL WebWiz 8.05 to MySQL vB3.6.4

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

  • Problem Importing MS SQL WebWiz 8.05 to MySQL vB3.6.4

    I am having a problem either connecting to the database or using the tables found in the database. The MS SQL database and the MySQL database are on the same server.

    Config file is using the same information I used to setup web wiz in the first place.

    Here is what I get: http://www.cicenet.net/impexprob.htm

    Any help would me much appreciated.
    Thanks,
    Lee

  • #2
    It looks like your source data is wrong in ImpExConfig.php or you are missing a lot of the standard WebWiz tables.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      I added the extension "tbl" to the mix, and now it finds all tables except the last two tables: tblActiveUser and tblBookMark.

      I then went to MS SQL Server Studio, and came to realize that those two tables do not exist. In Web Wiz 8.05, the two tables were taken care of in other ways. Is there anyway to get a custom WebWiz 8.05 script so that I can import my forum?

      Comment


      • #4
        Did you try the import anyway?
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          I now receive this error when I attempt to import UserGroups ImpEx Database errormysql error: Invalid SQL:
          INSERT INTO usergroup
          (
          importusergroupid, title, description,
          usertitle, passwordexpires, passwordhistory,
          pmquota, pmsendmax,
          opentag, closetag, canoverride,
          ispublicgroup, forumpermissions, pmpermissions,
          calendarpermissions, wolpermissions, adminpermissions,
          genericpermissions, genericoptions, attachlimit,
          avatarmaxwidth, avatarmaxheight, avatarmaxsize,
          profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize,
          signaturepermissions, sigpicmaxwidth, sigpicmaxheight,
          sigpicmaxsize, sigmaximages, sigmaxsizebbcode, sigmaxchars,
          sigmaxrawchars, sigmaxlines
          )
          VALUES
          (
          '1',
          'Admin Group',
          'Admin Group',
          '',
          0,
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          ''
          )

          mysql error: Field 'ibpa_cats' doesn't have a default value
          mysql error number: 1364
          Date: Friday 23rd 2007f February 2007 05:58:47 PM
          Database: vb_forums
          MySQL error: Field 'ibpa_cats' doesn't have a default value


          Any Ideas?

          Comment


          • #6
            Unfortunately I have no idea how to fix this. I'm afraid it'll have to wait until Jerry is available which will not be until the 26th at the earliest. Sorry!
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Any word on this yet?

              Comment


              • #8
                It's still early on the 26th. There is not exact time when Jerry will be available. I said the '26th at the earliest' but I did not mean to imply an iron-clad guarantee. Sorry for the confusion.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  Still nothing?

                  Comment


                  • #10
                    mysql error: Field 'ibpa_cats' doesn't have a default value

                    There is no such column in the default vBulletin usergroup table. You seem to be importing into a vBulletin database that already have modifications installed and one of these modifications added a column to the database without providing a proper default value.

                    Either remove this modification or contact the author for an update.
                    Want to take your board beyond the standard vBulletin features?
                    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                    Comment

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