Announcement

Collapse
No announcement yet.

mysql error: 0 (VB_AREA)

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

  • Steve Machol
    replied
    There have been problems noted before with Lycos hosting. We do not make official recommendations regarding hosting companies. I suggest you view the vBulletin Hosting Options forum for advice from our customers:

    http://www.vbulletin.com/forum/forum...?s=&forumid=11

    Leave a comment:


  • GamersBible
    replied
    Originally posted by Steve Machol
    You can't use this?

    $dbname = 'gamersbible_forum';

    I don't know what else to suggest then. I haven't run across a server that insists on 2 underscores in the db name before. Whatever is going on, this is still either an issue with config.php or the server itself.

    Do you have a web site control panel? Do you know what it is? (Cpanel, Plesk, etc.)
    Its a cp created by the hosts themself (Lycos).

    Can you suggest a cheap, but good MB webspace and BW (like £5 -> £7 p/m and 600MB / 6-7GB BW or around that)?

    Leave a comment:


  • Steve Machol
    replied
    You can't use this?

    $dbname = 'gamersbible_forum';

    I don't know what else to suggest then. I haven't run across a server that insists on 2 underscores in the db name before. Whatever is going on, this is still either an issue with config.php or the server itself.

    Do you have a web site control panel? Do you know what it is? (Cpanel, Plesk, etc.)

    Leave a comment:


  • GamersBible
    replied
    Originally posted by Steve Machol
    Try using a database name that doesn't include two underscores. Of course, make sure you have created the database first and have assigned the db user to that db.
    I cannot, im on shared hosting.

    Leave a comment:


  • Steve Machol
    replied
    Try using a database name that doesn't include two underscores. Of course, make sure you have created the database first and have assigned the db user to that db.

    Leave a comment:


  • GamersBible
    replied
    Originally posted by Zachery
    Are you using the same database as you did for the 2.3.5 install?
    1) Yes.

    2) I cant seem to find how it can be wrong, MySQL server is up and running and config is fine in my eyes:

    Originally posted by config.php
    <?php
    /*======================================================================*\
    || #################################################################### ||
    || # vBulletin 3.0.1 - Licence Number ********
    || # ---------------------------------------------------------------- # ||
    || # All PHP code in this file is ©2000-2004 Jelsoft Enterprises Ltd. # ||
    || # This file may not be redistributed in whole or significant part. # ||
    || # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
    || # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
    || #################################################################### ||
    \*======================================================================*/
    /*-------------------------------------------------------*\
    | ****** NOTE REGARDING THE VARIABLES IN THIS FILE ****** |
    +---------------------------------------------------------+
    | If you get any errors while attempting to connect to |
    | MySQL, you will need to email your webhost because we |
    | cannot tell you the correct values for the variables |
    | in this 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 = 'gamersbible_com';
    $dbpassword = '******';
    // ****** DATABASE NAME ******
    // This is the name of the database where your vBulletin will be located.
    // This must be created by your webhost.
    $dbname = 'gamersbible_com_1';
    // ****** 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]';
    // ****** 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
    $usepconnect = 1;
    // ****** PATH TO ADMIN & MODERATOR CONTROL PANELS ******
    // This setting allows you to change the name of the folders that the admin and
    // moderator control panels reside in. You may wish to do this for security purposes.
    // Please note that if you change the name of the directory here, you will still need
    // to manually change the name of the directory on the server.
    $admincpdir = 'admincp';
    $modcpdir = 'modcp';
    // ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
    // The users specified here will be allowed to view the admin log in the control panel.
    // Users must be specified by *ID number* here. To obtain a user's ID number,
    // view their profile via the control panel. If this is a new installation, leave
    // the first user created will have a user ID of 1. Seperate each userid with a comma.
    $canviewadminlog = '1';
    // ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
    // The users specified here will be allowed to remove ("prune") entries from the admin
    // log. See the above entry for more information on the format.
    $canpruneadminlog = '1';
    // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    // The users specified here will be allowed to run queries from the control panel.
    // See the above entries for more information on the format.
    // Please note that the ability to run queries is quite powerful. You may wish
    // to remove all user IDs from this list for security reasons.
    $canrunqueries = '';
    // ****** UNDELETABLE / UNALTERABLE USERS ******
    // The users specified here will not be deletable or alterable from the control panel by any users.
    // To specify more than one user, separate userids with commas.
    $undeletableusers = '';
    // ****** SUPER ADMINISTRATORS ******
    // The users specified below will have permission to access the administrator permissions
    // page, which controls the permissions of other administrators
    $superadministrators = '';
    // Prefix that your vBulletin tables have in the database.
    // For example: $tableprefix = 'vb3_';
    $tableprefix = 'vb3_';
    // Prefix that all vBulletin cookies will have
    // For example
    $cookieprefix = 'bb';
    /*======================================================================*\
    || ####################################################################
    || # Downloaded: 09:39, Thu Jul 1st 2004
    || # CVS: $RCSfile: config.php.new,v $ - $Revision: 1.19 $
    || ####################################################################
    \*======================================================================*/
    ?>
    File saved as config.php. Can you see anything which is wrong ?

    Leave a comment:


  • Steve Machol
    replied
    Link-ID == false, connect failed

    This error means tht either the database info in config.php is wrong, or there is a problem with the MySQL server.

    Leave a comment:


  • Zachery
    replied
    Are you using the same database as you did for the 2.3.5 install?

    Leave a comment:


  • GamersBible
    replied
    Originally posted by Zachery
    Your config.php does not have the correct Data or MySQL is down
    But i have though. As i copied what the vB2.3.5 entered into the config file on the install (db_name, db_pass, db_servername, db_etc...) (Of course, i only copied the values, i didnt copy the varibales from the 2.3.5 or the whole config.)

    And MySQL isnt down cause i jsut installed 2.3.5 perfectaly.

    Leave a comment:


  • Zachery
    replied
    Your config.php does not have the correct Data or MySQL is down

    Leave a comment:


  • GamersBible
    replied
    Dont know which page you wanted but here is the "Step 2":

    Originally posted by Step 2
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <title>vBulletin 3.0 Install Script Step 2) Connect to the database</title>
    <link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />
    <style type="text/css">
    #all {
    margin: 10px;
    }
    #all p, #all td, #all li, #all div {
    font-size: 11px;
    font-family: verdana, arial, helvetica, sans-serif;
    }
    </style>
    </head>
    <body style="margin:0px">
    <table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody" style="borderutset 2px">
    <tr>
    <td width="160"><img src="../cpstyles/vBulletin_3_Default/cp_logo.gif" alt="" title="vBulletin 3 &copy;2000 - 2004 Jelsoft Enterprises Ltd." /></td>
    <td style="padding-left:100px">
    <b>vBulletin 3.0 Install Script</b><br />
    (Please be patient as some parts may take some time)<br />
    <br />
    <b style="font-size:10pt;">Step 2) Connect to the database</b> (Step 2 of 13)</td>
    </tr>
    </table>
    <div id="all">
    <p style="font-size:10pt;"><b><u>Step 2) Connect to the database</u></b></p>
    <p>Attempting to attach to database</p><p>Connection succeeded! The database already exists.</p><p>Do you wish to <b><a href="install.php?step=3&emptydb=true">empty</a></b> your database?</p> </div>
    <form action="install.php" method="get" name="nextStep">
    <input type="hidden" name="step" value="3" />
    <table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody" style="padding:4px; borderutset 2px;">
    <tr align="center">
    <td><b>Click the button on the right to proceed.</b><br />vBulletin &copy;2000 - 2004 Jelsoft Enterprises Ltd.</td>
    <td><input type="submit" class="button" value="Next Step (3/13)" title="Step 3) Creating Tables" /></td>
    </tr>
    </table>
    </form>
    </div>
    <!-- START CONTROL PANEL FOOTER -->
    <p align="center"><a href="http://www.vbulletin.com/" target="_blank" class="copyright">vBulletin v3.0.1, Copyright &copy;2000 - 2004, Jelsoft Enterprises Ltd.</a></p>
    </div>
    </body>
    </html>
    And the error page:

    Originally posted by Error Page
    <html><head><title> Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
    <body></table></td></tr></table></form>
    <blockquote><p class="error">&nbsp;</p><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</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="<A href="mailto:[email protected]">Technical">mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>
    <!--
    Database error in vBulletin :
    Link-ID == false, connect failed
    mysql error:
    mysql error number: 0
    Date: Thursday 01st of July 2004 06:56:57 PM
    Script: http://www.gamersbible.com/vB3_test/...all.php?step=3
    Referer: http://www.gamersbible.com/vB3_test/...all.php?step=2
    IP Address: 172.188.246.157
    -->
    </body></html>

    Leave a comment:


  • Zachery
    replied
    Right click and view the source and paste it here please.

    Leave a comment:


  • GamersBible
    started a topic mysql error: 0 (VB_AREA)

    mysql error: 0 (VB_AREA)

    Ok, i set up my config.php file to my db settings.

    I get upto step 2 and past that i get the error "Technical error, email dispacthed to webmaster, blah blah blah."

    I then tryed installing a vB2.3.5 and it worked fine. So my mysql database isnt offline/re-starting/etc..

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