Announcement

Collapse
No announcement yet.

vB Install Issue

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

  • vB Install Issue

    Hello everyone. I just purchased vBulletin, and I'm trying to convert from my phpBB database using the converter.

    I have vBulletin 2.3.3 installed, because I know the converters dont work with the gamma.

    When I get to step 2 in the phpBB convert, "Associate Users", I click the button to Associate Users and I get this SQL error:

    Database error in vBulletin Control Panel 2.3.3:

    Invalid SQL: SELECT COUNT(*) AS count FROM mixx941_forum.phpbb_users
    mysql error: select command denied to user: '[email protected]' for table 'phpbb_users'

    mysql error number: 1142

    Date: Friday 12th of December 2003 08:07:50 PM
    Script: http://www.*******.com/forum/forum/i...ort_phpbb2.php
    Referer: http://www.*******.com/forum/importe...ort_phpbb2.php
    What can I do? I've tried it many times now. The database user has full permissions to the db.

    -Mark

    P.S. What's a good GZIP level to set it at? Un GZIPPED, my phpBB board takes 200-300MB of bandwidth per day
    Last edited by mixx941; Sat 13 Dec '03, 6:30am.
    Party107 Forums (powered by vBulletin): http://www.party107.com/forum/

    MIXXnet IRC Network: http://www.mixxnet.net
    irc.mixxnet.net

  • #2
    I responded to your support ticket about this.
    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've reinstalled vBulletin MANY times from a fresh database. I keep trying to import from phpBB 2.0.6. Here is what I am entering in all the input fields for the import script, and the error I get.

      When I go to bb import, here is what I enter:

      1) Choose bulletin board system: phpBB 2
      2) phpBB Database name: mixx941_forum
      3) phpBB Table Prefix: phpbb_
      4) In "User Association" I associate vBulletin username "administrator" with phpBB username "administrator" because they are the same
      5) Users To Import Per Cycle: 25 (default)
      6) Would you like to pause the import after each page so you can edit individual users? : No
      7) Would you like to empty your existing vBulletin members database?: No

      I click Import Users, and I get:

      =======
      Database error in vBulletin Control Panel 2.3.3:

      Invalid SQL: SELECT * FROM .users LIMIT 25,25
      mysql error: Table 'mixx941_vb.users' doesn't exist

      mysql error number: 1146

      Date: Saturday 13th of December 2003 12:28:30 AM
      Script: http://www.*******.com/forum
      Referer: http://www.*******.com/forum
      /importers/bbimport_phpbb2.php
      ==========

      Someone told me that the "users" table should not exist in vBulletin...so what can I do?

      Thank you in advance
      Last edited by mixx941; Sat 13 Dec '03, 5:14am.
      Party107 Forums (powered by vBulletin): http://www.party107.com/forum/

      MIXXnet IRC Network: http://www.mixxnet.net
      irc.mixxnet.net

      Comment


      • #4
        Martin is working with you on this in the support system. Please note that the import script has not been thoroughly tested with your versuion of phpBB.
        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
          Thanks for the reply.....

          I was just thinking someone in the community might have some input since I'm not getting a response from my ticket, and it's been 12+ hours.

          Originally posted by Steve Machol
          Please note that the import script has not been thoroughly tested with your versuion of phpBB.
          It hasnt? It's the latest stable, non beta version that everyone is or should be running....2.0.6, I was under the impression it was.
          Last edited by mixx941; Sat 13 Dec '03, 10:26am.
          Party107 Forums (powered by vBulletin): http://www.party107.com/forum/

          MIXXnet IRC Network: http://www.mixxnet.net
          irc.mixxnet.net

          Comment


          • #6
            Just to note....

            I tried a fairly complicated process to rule out anything else in the mixx941_forum database being the problem.....

            1) I created a new database
            2) I dumped all the tables and data from mixx941_forum (which phpBB is installed in along with a few other scripts)
            3) Created a new database
            4) Imported all of the tables from mixx941_forum
            5) Removed any tables not associated with phpBB
            6) Tried the vBulletin import set to take it from that new database

            Same errors......

            Anyone have any ideas? I really need this online quickly.....

            Thanks in advance
            Last edited by mixx941; Sat 13 Dec '03, 10:52am.
            Party107 Forums (powered by vBulletin): http://www.party107.com/forum/

            MIXXnet IRC Network: http://www.mixxnet.net
            irc.mixxnet.net

            Comment


            • #7
              I looked at your ticket. According to one of your latest messages you are still using two seprate db users for the two databases. You need to make sure both db have the same db user.

              Also you should update your ticket with the URL and login for CPanel or equivalent site manager.
              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


              • #8
                Steve:

                By same user, I am interpreting it that the user "mixx941_vb" be the user for both vBulletin and phpBB.

                Again, what I have done last night was added user mixx941_vb (which is the vb user) full permissions to both the vBulletin and phpBB databases, which you said in the ticket would fix this:

                Originally posted by Support Ticket
                Also as I said before, the db users need to be the same for both databases. You can add mixx941_vb to the mixx941_forum database to do this.
                And my cPanel information, no rudeness intended, but that's taking it way too far. My databases are setup the way that I said before, and with the latest error, even with me being a vBulletin novice user I know that doesnt have anything to do with permissions or my database problems.

                I would appreciate any help I can get on this as soon as possible. Again, not trying to be rude but I dont see other members giving out root information to their sites to get problems fixed...

                Regards.....
                Last edited by mixx941; Sat 13 Dec '03, 3:04pm.
                Party107 Forums (powered by vBulletin): http://www.party107.com/forum/

                MIXXnet IRC Network: http://www.mixxnet.net
                irc.mixxnet.net

                Comment


                • #9
                  Actually we ask for and get this information on a regular basis when trying to help customers with problems. I wouldn't ask for it if I didn't think it would help us troubleshoot and solve the problem. If you don't want this help then that's your choice. Not trying to be rude - I'm just trying to help.
                  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


                  • #10
                    Well, I dont want to give that information out until I know its 100% necesary. Martin hasnt even tried yet without it, and he didnt request it, so I'd like for him to try ASAP, because it's been all day today I've been trying, and no progress has been made.

                    Again, I say this with the most respect. I appreciate you trying to help, but I was under the impression that a paid forum solution at so much money was supposed to work 100%....and importing is part of it working.

                    Regards....
                    Last edited by mixx941; Sat 13 Dec '03, 4:02pm.
                    Party107 Forums (powered by vBulletin): http://www.party107.com/forum/

                    MIXXnet IRC Network: http://www.mixxnet.net
                    irc.mixxnet.net

                    Comment


                    • #11
                      Okay then. I was just trying to help since Martin hasn't been available to work on this today.
                      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


                      • #12
                        When will he be available to work on this?

                        I appreciate you trying to help, and if there is anything you can think of to addon, please share.

                        Thanks in advance.
                        Party107 Forums (powered by vBulletin): http://www.party107.com/forum/

                        MIXXnet IRC Network: http://www.mixxnet.net
                        irc.mixxnet.net

                        Comment


                        • #13
                          I have already done the best I can with the info available to me. Sorry but I don't know when Martin will be back to work on this. He hasn't been online all day.
                          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


                          • #14
                            I can understand that, and I think you for your efforts. I understand things can always go wrong with computers, I'm in the same business....

                            But isnt there someone else besides Martin? Jelsoft has alot of customers, and is a pretty big company, so I would think there would be.

                            Regards, and thanks in advance.
                            Party107 Forums (powered by vBulletin): http://www.party107.com/forum/

                            MIXXnet IRC Network: http://www.mixxnet.net
                            irc.mixxnet.net

                            Comment


                            • #15
                              Today I am the only one working on official support issues. That's normally the case on weekends (I work 7 days a week.)
                              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

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