Announcement

Collapse
No announcement yet.

database issues

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

  • #16
    Does this server have any sort of contorl panel software installed?

    Comment


    • #17
      how would i set it up to connect remotely to the database on the other server?

      $impexconfig['sourceexists'] = ???;

      # mysql / mssql
      $impexconfig['source']['databasetype'] = 'mysql';
      $impexconfig['source']['server'] = 'www.otherwebsite.com;
      $impexconfig['source']['user'] = 'pokerfor_smf2';
      $impexconfig['source']['password'] = '*******';
      $impexconfig['source']['database'] = 'pokerfor_smf2';
      $impexconfig['source']['tableprefix'] = 'smf_';

      would that be correct?

      Comment


      • #18
        it's got cpanel and whm...but i don't have the whm password apparently...and I can't get ahold of the owner to get it. I can't create the pokerfor_smf2 database on the new server because the cpanel account is pokertr...so i could only make a pokertr_smf2 database and user

        Comment


        • #19
          You can only connect to a remote host if the MySQL server on that host allows remote connections from the server your running ImpEx on.
          I wrote ImpEx.

          Blog | Me

          Comment


          • #20
            it's a vps that the smf is on...so i'm sure i could set it to recieve remote connections if i knew how.

            also...i got root access to the new server now...i created a user and database (pokerfor_smf2) on it...and when i tried the ssh command again..it went through but it didn't work because it said the database already existed.

            Comment


            • #21
              Check the SQL file.

              http://www.vbulletin.com/forum/showp...8&postcount=12
              I wrote ImpEx.

              Blog | Me

              Comment


              • #22
                oh yeah, let me do that...this should be fun...wonder how long it'll take to open a 120mb file...lol

                Comment


                • #23
                  You can vi it on the server, though if your doing it locally I would advise www.textpad.com.

                  I can open a 1054 meg file over a network in about 60 seconds and locally in 8 seconds, so you should be fine.

                  The lines you'll be looking for will be at the top.

                  It's nice and easy to open and look for them.
                  I wrote ImpEx.

                  Blog | Me

                  Comment


                  • #24
                    strange...keeps locking my computer up trying to open it.

                    it's good now though...i got the server provider to upload it as a different name and so far they seem to be having no problems...i'll let you know if anything else comes up (which my luck it will...)

                    Comment


                    • #25
                      i was right.

                      the database is there and in good condition...i was hoping that would fix the issue i was having at the customer number input screen but it isn't...

                      everytime i hit enter...it just refreshes the customer input screen

                      Comment


                      • #26
                        are any images called after that button is pressed?

                        this is from the error log...these are around the time i was trying it this morning...

                        Code:
                        [Thu Oct  5 10:37:38 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:38 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/menu_open.gif
                        [Thu Oct  5 10:37:38 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:38 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/navbits_start.gif
                        [Thu Oct  5 10:37:26 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:26 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/menu_open.gif
                        [Thu Oct  5 10:37:26 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:26 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/navbits_start.gif
                        [Thu Oct  5 10:37:25 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:25 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/menu_open.gif
                        [Thu Oct  5 10:37:25 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:25 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/navbits_start.gif
                        [Thu Oct  5 10:37:21 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:21 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/menu_open.gif
                        [Thu Oct  5 10:37:21 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:21 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/navbits_start.gif
                        [Thu Oct  5 10:37:13 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:13 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/menu_open.gif
                        [Thu Oct  5 10:37:13 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/404.shtml
                        [Thu Oct  5 10:37:13 2006] [error] [client ***.*.***.***] File does not exist: /home/pokertr/public_html/gallery/images/RedLeaf/misc/navbits_start.gif

                        Comment


                        • #27
                          Originally posted by creedmaniac View Post
                          ...i was hoping that would fix the issue i was having at the customer number input screen but it isn't...

                          everytime i hit enter...it just refreshes the customer input screen
                          The screen where you put in your customer number as you select import from the menu ?
                          I wrote ImpEx.

                          Blog | Me

                          Comment


                          • #28
                            Originally posted by Jerry View Post
                            The screen where you put in your customer number as you select import from the menu ?
                            yes

                            Comment


                            • #29
                              Originally posted by creedmaniac View Post
                              yes
                              Remove all the system files that you don't need in impex/system, i.e. just leave the one you need (smf I'm guessing).

                              Clear all your cookies to that domain, so you'll have to login again.

                              If doing both of those steps don't work, run ImpEx standalone, that means move it out of vBulletin all together and browse to it directly.
                              I wrote ImpEx.

                              Blog | Me

                              Comment


                              • #30
                                Originally posted by Jerry View Post
                                move it out of vBulletin all together and browse to it directly.
                                they are both installed in the root folder (the impex directory is in there along with admincp, includes, etc...)

                                do i need to move the impex to somewhere else? That didn't work either....

                                Comment

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