Announcement

Collapse
No announcement yet.

ImpEx "slight problem with database"

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

  • ImpEx "slight problem with database"

    we got our license just a few weeks ago and now 3.5.0 is out before we had a chance to import the old forum, perfect timing but the new(?) impex i downloaded along with 3.5.0 says "Database Error: There seems to have been a slight problem with the database.", i got the old one to work but there was some text in the member area about impex being only for 3.5 so i got this new one and it doesn't work at all, how can i see a more exact error? i've renamed both config files, for vb and impex, and filled in all the correct info into them, double checked it more than once before posting here

    edit: i just inserted a mysql_error() in the halt() function and saw this
    "You have an error in your SQL syntax near 'ENGINE=MyISAM; ' at line 7"

    edit: i just removed the ; behind ENGINE=MyISAM in vbfields.php and now it works, i'm a postgresql man and don't remember much about mysql syntax so i have to ask if it's safe to continue like this, after all i didn't get any errors
    Last edited by swehack; Thu 29 Sep '05, 5:48am.

  • #2
    Can you post the before and after SQL in vBfields that you changed, thanks.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      I have the same problem : "Database Error: There seems to have been a slight problem with the database."
      With the old ImpEx version I have had never problems, my import is vb 3.0.9 to vb 3.5.0. I have filled in everything such as I have always done.

      Comment


      • #4
        With out seeing the SQL error from the source of the page I can't debug the issue.
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          Originally posted by Jerry
          With out seeing the SQL error from the source of the page I can't debug the issue.
          Sorry Jerry, here is the source of the error page.

          PHP Code:
          <html><head><titleDatabase Error</title><style type="text/css"><!--.error font11px tahomaverdanaarialsans-serif; }--></style></head>
          <
          body></table></td></tr></table></form>
          <
          blockquote><class="error">&nbsp;</p><class="error"><b>There seems to have been a slight problem with the  database.</b><br />
          Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</abutton in your browser.</p><class="error">An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, who you can also contact if the problem persists.</p><class="error">We apologise for any inconvenience.</p></blockquote>

          <!--
          Database error in vBulletin:ImpEx Target :

          Invalid SQLCREATE TABLE `vbfields` (
                `
          fieldnamevarchar(50NOT NULL default '',
                `
          tablenamevarchar(20NOT NULL default '',
                `
          vbmandatoryenum('Y','N','A'NOT NULL default 'N',
                `
          defaultvaluevarchar(200) default 'NULL',
                `
          dictionarymediumtext NOT NULL
              
          ENGINE=MyISAM;
              
          mysql errorYou have an error in your SQL syntax near 'ENGINE=MyISAM;
              ' 
          at line 7

          mysql error number
          1064

          Date
          Thursday 29th of September 2005 11:13:54 PM
          Script
          http://test.mysite.nl/forum/impex/index.php
          Refererhttp://test.mysite.nl/forum/admincp/index.php?do=nav
          IP Addressxx.xxx.xx.xxx
           
          -->

          </
          body></html

          Comment


          • #6
            I have updated vbfields.php and removed "ENGINE=MyISAM" you can either edit the file directly or download impex again and upload and overwrite, vbfields.php.
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              I fixed it!!!

              darn it...there was a " missing in the vbfields.php file. After they removed the ENGINE=**** part, they accidently removed the " between the ) and the ;

              Partial code below:
              `dictionary` mediumtext NOT NULL
              )";

              Comment


              • #8
                Originally posted by Jerry
                I have updated vbfields.php and removed "ENGINE=MyISAM" you can either edit the file directly or download impex again and upload and overwrite, vbfields.php.
                I have still the error, but now I delete the ; after the ) and it works now, but is it the correct manner.

                PHP Code:
                Database error in vBulletin:ImpEx Target :

                Invalid SQLCREATE TABLE `vbfields` (
                      `
                fieldnamevarchar(50NOT NULL default '',
                      `
                tablenamevarchar(20NOT NULL default '',
                      `
                vbmandatoryenum('Y','N','A'NOT NULL default 'N',
                      `
                defaultvaluevarchar(200) default 'NULL',
                      `
                dictionarymediumtext NOT NULL
                      
                );
                    
                mysql errorYou have an error in your SQL syntax near '; 
                    ' 
                at line 7

                mysql error number
                1064 
                Last edited by Rhoads; Thu 29 Sep '05, 9:26pm.

                Comment


                • #9
                  me too...just got another awful error long as heck...

                  dang it

                  Comment


                  • #10
                    there is still a problem when i submit the first impex form where i select which forum to import from, i get a completly blank page, no source code sent to client

                    i select phpbb2 and hit submit, i've done this with the latest impex package and i get a blank page so i don't see how you could have missed this

                    also i don't know if this has anything with the problem to do but it might help in debugging, the old impex had some style, it had colors but this new one has none, only standard html, no styling of anything, i like that better but i thought maybe some paths are wrong or something and the css is not being included, i honestly have no idea

                    Comment


                    • #11
                      I seem to be having a similar problem, and I admittedly don't really know what I'm doing when it comes to playing with the database. Would someone be willing to give me a few simple step-by-step instructions to fix this?

                      Thanks!

                      Database error in vBulletin:ImpEx Target :

                      Invalid SQL: CREATE TABLE `vbfields` (
                      `fieldname` varchar(50) NOT NULL default '',
                      `tablename` varchar(20) NOT NULL default '',
                      `vbmandatory` enum('Y','N','A') NOT NULL default 'N',
                      `defaultvalue` varchar(200) default 'NULL',
                      `dictionary` mediumtext NOT NULL
                      );

                      mysql error: You have an error in your SQL syntax near ';
                      ' at line 7

                      mysql error number: 1064
                      This is with vb 3.5 Gold and the latest ImpEx download. Attempting to import from a phpBB 2.0.17 board.

                      - Justin
                      Last edited by Tru2Chevy; Fri 30 Sep '05, 5:33pm.

                      Comment


                      • #12
                        Damnit! Took forever to associate a ton of users from a vB 3 site I'm merging, and I'm now stuck at this point, too.

                        Damnit. Now Firefox crashed, and I don't know what imported data was saved or not. What a waste of two hours.

                        OH WHAT THE FARK! MY BOARD IS NOW RIGHT TO LEFT!!!!! IT'S AN ENGLISH BOARD, NOT HEBREW DAMNIT! Damnit. At least I backed up a couple of hours ago, but posts had to be lost. F***!

                        Call me when it's fixed. I mean really fixed, not just user "oh I got it working now" solutions. I mean Jelsoft fixed. I don't want to waste more bours associating users and pissing off users with some freaky RTL board and lost posts. Impex needs a LOT of work.
                        Last edited by cyburbia; Fri 30 Sep '05, 6:42pm.
                        Cyburbia Forums - a third place for urban planners
                        http://www.cyburbia.org/forums

                        Comment


                        • #13
                          Backup won't restore. Well, it will, but it reverts immediately to RTL. Can't log in, either.

                          Just lovely. Anyone in Israel want an urban planning Web site?
                          Last edited by cyburbia; Fri 30 Sep '05, 7:16pm.
                          Cyburbia Forums - a third place for urban planners
                          http://www.cyburbia.org/forums

                          Comment


                          • #14
                            I have the same EXACT error.

                            ugh!

                            Comment


                            • #15
                              Anyone? Hello?
                              Cyburbia Forums - a third place for urban planners
                              http://www.cyburbia.org/forums

                              Comment

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