Announcement

Collapse
No announcement yet.

web wiz import: Error

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

  • web wiz import: Error

    Hi,
    I try to import from web wiz system to vbulletin.
    I set all the seting in ImpExConfig.php but when i get in to import link in cpadmin i get the next error:

    Fatal error: Call to undefined function: mssql_connect() in D:\hshome\dachoweb\dacho.co.il\VBULLETIN\impex\db_mysql.php on line 54

    the vbulletin is not in the same server as the web wiz forum, but i set in ImpExConfig.php this:


    targetdatabasetype = mysql
    targetserver = mysql2.dacho.co.il
    targetuser = forum_user
    targetpassword = password
    targetdatabase = forum_db
    targettableprefix =

    [ Source Database ]
    ; If the system that is being imported from uses a database,
    ; enter the details for it here and set 'sourceexists' to TRUE.
    ; If the source data is NOT stored in a database, set 'sourceexists' to FALSE

    sourceexists = true

    ; mysql OR mssql
    sourcedatabasetype = mssql
    sourceserver = mssql.dacho.co.il
    sourceuser = dachowe_user
    sourcepassword = password
    sourcedatabase = dacho_db
    sourcetableprefix =


    anybody know why i get this problem?
    Thn'x yarden.

  • #2
    Well does your php instaltion have mssql support?

    Comment


    • #3
      I don't understand to what you mean... you can explain please?

      Comment


      • #4
        php must be compiled or have the module loaded to be able to access a mssql database.

        In phpinfo it will show if you have it or not, but seeing that error, you do not have it.

        Comment


        • #5
          What I can to do?

          Comment


          • #6
            You would need to ask your host to recompile php with mssql support, or wait untill jerry is able to help you with the import.

            Comment


            • #7
              Ok,
              When I can ask jerry?
              He have ICQ? MASSNGER?

              Comment


              • #8
                Jerry is generaly not around on the weekends, you can try PM'ing him however.

                Comment


                • #9
                  ok Thn'x you!

                  Comment


                  • #10
                    With out mssql support in php it won't be able to connect to the mssql database.

                    Best PM me or email [email protected] and ask for me.
                    I wrote ImpEx.

                    Blog | Me

                    Comment


                    • #11
                      If there is no MSSQL support in php, it will not be able to connect to the database. This can only be fixed by compiling mssql into php, this isn't something that impex or vbulletin can do.

                      Like so : http://uk.php.net/manual/en/ref.mssql.php
                      Last edited by Jerry; Sun 12 Dec '04, 2:58am.
                      I wrote ImpEx.

                      Blog | Me

                      Comment


                      • #12
                        Originally posted by yarden90
                        Ok,
                        When I can ask jerry?
                        He have ICQ? MASSNGER?
                        I do, though I never give support like that.
                        I wrote ImpEx.

                        Blog | Me

                        Comment


                        • #13
                          doesn't works either

                          Dear Jerry / Support.

                          We did more than that.
                          we've created on the windows where the SQL SERVER is located, an account with all the forum's files.
                          we've tried to convert the webwiz to remote mysql (that is being used by the real forum that sits on the linux server)
                          and still we've got the same error.
                          now the PHP that comes for windows (as binary only ofcourse) is with mssql support.

                          what i recommend is either you can provide us a convert tool that works.
                          or either we can supply you both connection strings for mssql and mysql and you can do the convert via your server that supports somehow in the mssql in the php.

                          Thanks
                          Ofir
                          פורום, פורומים, קהילות - דצ'ו

                          Comment


                          • #14
                            Originally posted by dacho
                            Dear Jerry / Support.

                            We did more than that.
                            we've created on the windows where the SQL SERVER is located, an account with all the forum's files.
                            we've tried to convert the webwiz to remote mysql (that is being used by the real forum that sits on the linux server)
                            and still we've got the same error.
                            now the PHP that comes for windows (as binary only ofcourse) is with mssql support.

                            what i recommend is either you can provide us a convert tool that works.
                            or either we can supply you both connection strings for mssql and mysql and you can do the convert via your server that supports somehow in the mssql in the php.

                            Thanks
                            Ofir
                            The importer works fine, I've used it many times.

                            You must have mssql support in php.

                            I would suggest compiling php with mssql support, that way it will be able to connect to a mssql database.
                            Attached Files
                            I wrote ImpEx.

                            Blog | Me

                            Comment


                            • #15
                              Originally posted by dacho
                              we've created on the windows where the SQL SERVER is located, an account with all the forum's files.
                              we've tried to convert the webwiz to remote mysql (that is being used by the real forum that sits on the linux server)
                              and still we've got the same error.
                              now the PHP that comes for windows (as binary only ofcourse) is with mssql support.
                              Install on the windows server that has the mssql support in the php binary, then move the site to the linux machine once it is installed.
                              I wrote ImpEx.

                              Blog | Me

                              Comment

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