Announcement

Collapse
No announcement yet.

Config.php issue

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

  • Config.php issue

    I am getting this message on the install:

    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /homepages/43/d175626259/htdocs/forums/includes/db_mysql.php on line 140

    I changed the values on the config.php file as originally requested.

    my host has reviewed the file and confirmed all of the settings.

    Yet still we receive the error message.

    May I send you the content of the page to review to see if you can determine the issue?

  • #2
    The most likely cause of this error is that the info in your config.php file is wrong or your db user does not have full permissions to this database. Please read this for all the known causes of this error:

    http://www.vbulletin.com/forum/showthread.php?t=194542
    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 think that part of the issue is that there is no "master server" on the file that is downloaded?

      I made my config.php page look almost exactly like the example, although they are not the same

      // ****** DATABASE SERVER NAME ******
      // This is the hostname or IP address of the database server.
      // It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
      // If you are unsure of what to put here, leave it at the default value.
      $config ['Database']['dbname'] = 'db516.ora.net';

      // ****** DATABASE USERNAME & PASSWORD ******
      // This is the username and password you use to access MySQL.
      // These must be obtained through your webhost.
      $config ['dbusername'] = 'dvvvvvv';
      $config ['dbpassword'] = 'sphhhhh';

      // ****** DATABASE NAME ******
      // This is the name of the database where your vBulletin will be located.
      // This must be created by your webhost.
      $config ['Database'] ['dbname'] = 'db1bbbbb6';

      // ****** TECHNICAL EMAIL ADDRESS ******
      // If any database errors occur, they will be emailed to the address specified here.
      // Leave this blank to not send any emails when there is a database error.
      $config ['Database']['technicalemail'] = '[email protected]';

      // ****** PERSISTENT CONNECTIONS ******
      // This option allows you to turn persistent connections to MySQL on or off.
      // The difference in performance is negligible for all but the largest boards.
      // If you are unsure what this should be, leave it off.
      // 0 = Off; 1 = On
      $config ['MasterServer']['usepconnect'] = 0;
      ====
      The only master server reference is on Persistent Connections. This appears different than the instructions you just directed me to???
      Last edited by Starfish82; Wed 6 Sep '06, 4:36am.

      Comment


      • #4
        Hello,

        First hoping the data showing up here are not the real one.

        Secondly, yes, you should reupload a new config.php.new, then rename it to config.php and re-edit it with the correct info.
        (you have two times the var $config ['Database']['dbname'] and that layout seems to be from an old vbulletin version)
        Be sure to use a config file from vb 3.6

        You are almost done,
        Last edited by Interdit; Wed 6 Sep '06, 2:11am.
        BPowers.com: Eu Web Hosting Solutions
        Shared hosting with Cpanel/Fantastico
        Live Help: http://www.bpowers.com

        Comment


        • #5
          All of the documentation references a config.php file that is from version 3.5, There is no file for version 3.6?

          That said - the documentation I am using has a Database Server Name and a Database Name category.

          Should both of these stay? If not, which one should be modified....and how?

          Comment


          • #6
            3.5 doc should be fine.

            All you have to do is to upload the files from your zip via ftp to your hosting account.
            From there, rename the file /includes/config.php.new to config.php
            Then edit that file and put the config settings that you put before. In that file you don't have to remove any lines. You just have to edit, most of the time and for a normal config, from line 1 to 59, if that can help.
            Then run the install.

            Good luck,
            Otherwise ask your host to assist you.
            BPowers.com: Eu Web Hosting Solutions
            Shared hosting with Cpanel/Fantastico
            Live Help: http://www.bpowers.com

            Comment


            • #7
              Tried all of that....same issues/message

              Server is running mySQL 4.0.27 so I didn't follow any of the other password instructions (version did not apply, right?)

              Host tried to assist, following documentation lockstep.

              I tried another time copying and pasting pieces from the documentation:

              // ****** MASTER DATABASE SERVER NAME ******
              // This is the hostname or IP address of the database server.
              // It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
              // If you are unsure of what to put here, leave it at the default value.
              $config['MasterServer']['servername'] = 'localhost';


              // ****** MASTER DATABASE USERNAME & PASSWORD ******
              // This is the username and password you use to access MySQL.
              // These must be obtained through your webhost.
              $config['MasterServer']['username'] = 'dbo17650...';
              $config['MasterServer']['password'] = 'lasdfvc';

              // ****** DATABASE NAME ******
              // This is the name of the database where your vBulletin will be located.
              // This must be created by your webhost.
              $config['Database']['dbname'] = 'db176sadfas';

              // ****** TECHNICAL EMAIL ADDRESS ******
              // If any database errors occur, they will be emailed to the address specified here.
              // Leave this blank to not send any emails when there is a database error.
              $config ['technicalemail'] = '[email protected]';

              // ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
              // This option allows you to turn persistent connections to MySQL on or off.
              // The difference in performance is negligible for all but the largest boards.
              // If you are unsure what this should be, leave it off. (0 = off; 1 = on)
              $config['MasterServer']['usepconnect'] = 0;


              What next???

              Comment


              • #8
                That's still not the default vBulletin config.php file.
                Please download vBulletin from the members area and use the config.php.new file from there, renaming it to config.php
                Best Regards
                Colin Frei

                Please don't contact me per PM.

                Comment


                • #9
                  Can we all agree that this is the most current file?

                  // ****** DATABASE SERVER NAME ******
                  // This is the hostname or IP address of the database server.
                  // It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
                  // If you are unsure of what to put here, leave it at the default value.
                  $servername = 'localhost';

                  // ****** DATABASE USERNAME & PASSWORD ******
                  // This is the username and password you use to access MySQL.
                  // These must be obtained through your webhost.
                  $dbusername = 'root';
                  $dbpassword = '';

                  // ****** DATABASE NAME ******
                  // This is the name of the database where your vBulletin will be located.
                  // This must be created by your webhost.
                  $dbname = 'forum';

                  // ****** TECHNICAL EMAIL ADDRESS ******
                  // If any database errors occur, they will be emailed to the address specified here.
                  // Leave this blank to not send any emails when there is a database error.
                  $technicalemail = '[email protected]';

                  Comment


                  • #10
                    No, that is not the config.php file for vB 3.6.0.
                    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