Announcement

Collapse
No announcement yet.

Possiablly custom tables or incorrect prefix

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

  • Possiablly custom tables or incorrect prefix

    is it possible to import from ASP Web Wiz Forum to vBulletin ?

    for more detailed info for ASP Web Wiz Forum : http://www.webwizguide.info/

  • #2
    I'm not sure about the ASP. Which db format is the info stored in?

    http://www.vbulletin.com/docs/html/impex_tier_2

    webwiz 7.9 (MSSQL and MySQL, access databases need converting to MySQL, contact Jerry)
    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
      Hi zode,
      to do a good migration procedure you must (for first thing) convert your access db into a mysql database, i used Navicat Software to do this correctly and not the mysql Migration Tool !!!! Then you must set the configuration file for the Import/Export System of vBulletin and that's all !!!

      Soon,
      Giuseppe Leone

      Comment


      • #4
        Originally posted by Master85 View Post
        Hi zode,
        to do a good migration procedure you must (for first thing) convert your access db into a mysql database, i used Navicat Software to do this correctly and not the mysql Migration Tool !!!! Then you must set the configuration file for the Import/Export System of vBulletin and that's all !!!

        Soon,
        Giuseppe Leone
        u try ?

        Comment


        • #5
          I've just executed the migration from WWF to VB the last year, and everything gone fine. My personal council is to test all these passages in a local computer and then in the real server.

          Bye,
          Giuseppe Leone

          Comment


          • #6
            Originally posted by Master85 View Post
            I've just executed the migration from WWF to VB the last year, and everything gone fine. My personal council is to test all these passages in a local computer and then in the real server.

            Bye,
            Giuseppe Leone
            i will try mysql-migration-toolkit-1.0.25-win32 for migration

            Comment


            • #7
              Web Wiz Forum => vBulletin

              i download Web Wiz Forum DB . its db name is wwf.mdb . its path is "c:\"

              for impex config .php what will i write here

              PHP Code:
              # mysql / mssql
              $impexconfig['source']['databasetype']    = 'mysql';
              $impexconfig['source']['server']        = 'localhost';
              $impexconfig['source']['user']            = 'username';
              $impexconfig['source']['password']        = 'password';
              $impexconfig['source']['database']        = 'source';
              $impexconfig['source']['tableprefix']   = ''
              [when i click wwf.mdb following error occured ]

              HTML Code:
               "AOindex" is not index in this table
              - will it be migrate first ?

              or how

              Comment


              • #8
                Are you sure that the Web Wiz Forum DB is a MySQL database with that name?

                Usually .MDB is a MS Access database.
                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


                • #9
                  isn't mdb from ms access (try changing mysql to mssql)

                  Comment


                  • #10
                    Possiablly custom tables or incorrect prefix

                    when " Check and update database" followin error occured
                    HTML Code:
                    Possiablly custom tables or incorrect prefix :
                      	
                    ActiveUser NOT found. 	
                    Author NOT found. 	
                    BanList NOT found. 	
                    BookMark NOT found. 	
                    BuddyList NOT found. 	
                    Category NOT found. 	
                    Configuration NOT found. 	
                    DateTimeFormat NOT found. 	
                    EmailNotify NOT found. 	
                    Forum NOT found. 	
                    Group NOT found. 	
                    GuestName NOT found. 	
                    PMMessage NOT found. 	
                    Permissions NOT found. 	
                    Poll NOT found. 	
                    PollChoice NOT found. 	
                    Smut NOT found. 	
                    Thread NOT found. 	
                    Topic NOT found. 	Failed Check database permissions and connection, or table prefix to ensure its correct.
                    - already tables have no prefix

                    i suppose case sensitive problme but we can not change table names like impex want because

                    http://dev.mysql.com/doc/refman/5.1/...ind-table.html


                    what will i do ?????????

                    Comment


                    • #11
                      ImpEx Database errormysql error: Invalid SQL

                      PHP Code:
                      ImpEx Database errormysql errorInvalid SQL
                                  
                      SELECT FROM group
                                  ORDER BY group_id
                                  LIMIT 0
                      ,50

                      mysql error
                      You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'group
                                  ORDER BY group_id
                                  LIMIT 0,50' 
                      at line 1

                      mysql error number
                      1064

                      Date
                      Tuesday 19th 2006f December 2006 08:25:08 PM
                      Database
                      db
                      MySQL error
                      You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'group
                                  ORDER BY group_id
                                  LIMIT 0,50' 
                      at line 1 

                      Comment


                      • #12
                        I'd suggest this : http://www.convert-in.com/acc2sql.htm
                        I wrote ImpEx.

                        Blog | Me

                        Comment


                        • #13
                          What system are you converting from?
                          What ImpEx version are you using?
                          What is the MySQL version on your server?
                          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


                          • #14
                            Originally posted by Floris View Post
                            isn't mdb from ms access (try changing mysql to mssql)
                            Yes. That database will have to be converted to MySQL and they restored to the database.
                            I wrote ImpEx.

                            Blog | Me

                            Comment


                            • #15
                              Need more info.

                              Source system and table prefix etc.

                              http://www.vbulletin.com/forum/showthread.php?t=161907
                              I wrote ImpEx.

                              Blog | Me

                              Comment

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