Announcement

Collapse
No announcement yet.

Impex Error Message

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

  • Impex Error Message

    I have vbulletin installed on a testing server and have impex installed. I'm getting the following error message when I click on 'import.'
    ImpEx Database errormysql error: 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,
    `product` varchar(25) default ''
    )


    mysql error: Table 'vbfields' already exists

    mysql error number: 1050

    Date: Tuesday 01st 2008f July 2008 12:28:43 PM
    Database: vbulletintemp
    MySQL error: Table 'vbfields' already exists

    Please advise.

    Thanks much

  • #2
    It would seem that 'vbfields' is an impex field. If I'm just now running the script for the first time, why is it already there? And why is it halting progress?

    Comment


    • #3
      Then ImpEx must of been run before, or the table wasn't created properly, or you don't have DROP permissions for your SQL account (which is unlikely).

      I would remove the table manually, delete the ImpEx session and restart the import.
      I wrote ImpEx.

      Blog | Me

      Comment


      • #4
        Thanks for the reply. How do I go about deleting the session?

        Comment


        • #5
          Okay, I figured out how to delete the impex session, and I deleted the vbfields table, I got a little further, but now it's complaining that I DON'T have a vbfields table.

          ImpEx Database errormysql error: Invalid SQL:
          SELECT fieldname, vbmandatory, defaultvalue, dictionary
          FROM vbfields
          WHERE tablename = 'usergroup'
          AND product='vbulletin'
          ORDER BY vbmandatory

          mysql error: Table 'vbulletintemp.vbfields' doesn't exist
          mysql error number: 1146
          Date: Thursday 03rd 2008f July 2008 09:59:00 AM
          Database: vbulletintemp
          MySQL error:

          Comment


          • #6
            Very strange.

            Can you double check you have the file vbfields.php uploaded to the impex directory.
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              Yes, it's there, but we just deleted the table it had created. How do I reinstate it? Run the install again? Will that mess things up if I don't uninstall it first?

              Or is there a way to run the contents of the vbfields as a query? I can't altogether distinguish between what's php and what's an sql query.

              Comment


              • #8
                I managed to input all the data in vbfields.php into the database. I'm proceeding to Step 1, check and update databases. It's not returning any valid fields, so I checked and found a table prefix of 'exp_'. I added that to the ImpExConfig.php. It didn't help. I tried it as just 'exp' and that didn't help either.

                Don't know what to try next.

                Comment


                • #9
                  Now that you have it working, without these details I can't really help ;

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

                  Blog | Me

                  Comment


                  • #10
                    Type of import (clean or merge). clean
                    Source board system and version. Expression Engine, installed two months ago.
                    Target version. Latest, just installed.
                    Module issue occurred on. ?
                    Any SQL error reported. None at present.

                    Comment


                    • #11
                      Originally posted by keress View Post
                      Any SQL error reported. None at present.
                      It didn't help. I tried it as just 'exp' and that didn't help either.
                      Then what is the current error or issue ? and what version of Expression Engine ?
                      I wrote ImpEx.

                      Blog | Me

                      Comment


                      • #12
                        The problem is that there are no valid tables found. Everything was in red:

                        moderator - importmoderatorid Completed
                        usergroup - importusergroupid Completed
                        ranks - importrankid Completed
                        poll - importpollid Completed
                        forum - importforumid Completed
                        forum - importcategoryid Completed
                        user - importuserid Completed
                        style - importstyleid Completed
                        thread - importthreadid Completed
                        post - importthreadid Completed
                        thread - importforumid Completed
                        smilie - importsmilieid Completed
                        pmtext - importpmid Completed
                        avatar - importavatarid Completed
                        customavatar - importcustomavatarid Completed
                        customprofilepic - importcustomprofilepicid Completed
                        post - importpostid Completed
                        attachment - importattachmentid Completed
                        pm - importpmid Completed
                        usernote - importusernoteid Completed
                        phrase - importphraseid Completed
                        subscription - importsubscriptionid Completed
                        subscriptionlog - importsubscriptionlogid Completed

                        Valid found tables :


                        Possibly custom tables or incorrect prefix :

                        forum_administrators NOT found.
                        forum_attachments NOT found.
                        forum_boards NOT found.
                        forum_moderators NOT found.
                        forum_polls NOT found.
                        forum_pollvotes NOT found.
                        forum_posts NOT found.
                        forum_ranks NOT found.
                        forum_read_topics NOT found.
                        forum_search NOT found.
                        forum_subscriptions NOT found.
                        forum_topics NOT found.
                        forums NOT found.
                        members NOT found.
                        member_groups NOT found.
                        Module 2 won't progess because Module 1 was not completed

                        I'm on Expression Engine v. 2.1.0

                        Thanks!
                        Last edited by keress; Sat 5 Jul '08, 1:16pm.

                        Comment


                        • #13
                          Ah, the current importer is for 1.6.2 not 2.1.0.

                          You'll have to contact me via a support ticket so I can check out the source database.
                          I wrote ImpEx.

                          Blog | Me

                          Comment


                          • #14
                            Have you had any luck with this? I need to delete the installation I have up to test whether this will work or not.

                            Comment

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