Announcement

Collapse
No announcement yet.

Database error! Please help

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

  • beishe8
    replied
    Originally posted by GHC Webmaster View Post
    Although you are correct on that, when upgrading you have keep the old config.php. When you rename config.php.new to config.php and then upload it you would overwrite your old config.php including all your server info.
    You may keep it.
    No harm could be done by editing(file name AND content) and uploading the newer version.(which is most of the cases the same as the older version)

    Leave a comment:


  • GHC Webmaster
    replied
    Originally posted by beishe8 View Post
    The server knows what is .php,does not know what is .new
    That file is useless on the server as config.php.new.
    Although you are correct on that, when upgrading you have keep the old config.php. When you rename config.php.new to config.php and then upload it you would overwrite your old config.php including all your server info.

    The file is called config.php.new exactly to prevent that from happening accidently and should only be renamed to config.php on new installations. In which case you will have to edit it to include your server info.

    Therefore Wiets is right and this line should not be in the Upgrading instructions. And I can confirm that the line is there in the included vb3_readme (botht .html and .txt) files in the 3.8.1 download. This is a (serious) mistake on the part of the vB developers which causes problems for anyone following the readme file exactly.

    Leave a comment:


  • beishe8
    replied
    Originally posted by Wiets View Post
    "Then open the 'upload/includes/' folder. In this you will find config.php.new. You should rename this to config.php and then open it in a text editor.

    This is totally incorrect! The config.php.new file name must not be changed to config.php. It must be uploaded to the server as is.
    The server knows what is .php,does not know what is .new
    That file is useless on the server as config.php.new.

    Leave a comment:


  • Wiets
    replied
    No, it is not from the install instructions! It is from the upgrade instructions in the "vb3_readme.html" file included in the download!
    It's there once again to install the latest patch: vbulletin_3-8-1_Patch_Level_1_VBF1C712E6

    Here is an extract of the instructions:

    Upgrading from a previous version of vBulletin 3

    Close your board via the Admin Control Panel.
    Upload all files from the 'upload/' folder in the zip, with the exception of 'install/install.php'.
    Then open the 'upload/includes/' folder. In this you will find config.php.new.
    You should rename this to config.php and then open it in a text editor.

    Open your browser and point the URL to http://www.example.com/forum/install/upgrade.php (where www.example.com/forums/ is
    the URL of your vBulletin). You should now be automatically forwarded to the appropriate upgrade script and step.
    Follow the instructions on the screen. Make sure you click next step or proceed until you are redirected to your
    Admin Control Panel. Here, you can reopen your board.

    For a complete description of how to upgrade from a previous version of vBulletin 3 to the latest version, see the
    upgrade section of the vBulletin 3 Manual.

    Please note that the format for config.php in vBulletin 3.5.x is different from previous versions of vBulletin, and
    you will need to manually update your config file to the new format. Instructions are here.
    Last edited by Wiets; Fri 6 Mar '09, 3:13pm.

    Leave a comment:


  • Steve Machol
    replied
    Where do you see that? That looks like it's from the install instructions. I can't find that in the actual upgrade instructions:

    http://www.vbulletin.com/docs/html/upgrade/

    Leave a comment:


  • Wiets
    replied
    I found the problem!!!
    vBulletin's Upgrade instructions are incorrect!

    "Then open the 'upload/includes/' folder. In this you will find config.php.new. You should rename this to config.php and then open it in a text editor.

    This is totally incorrect! The config.php.new file name must not be changed to config.php. It must be uploaded to the server as is.

    More than one week wasted!!!!

    Leave a comment:


  • Steve Machol
    replied
    Note: You have not edited the config.php file with the info for your db and db user.

    Please start your own thread with all the relevant details. Thank you.

    Leave a comment:


  • TJMagoo
    replied
    I am getting the same error. I checked my old config file and the new one, and I am seeing everything is the same. Where could my problem be?

    Database error in vBulletin :
    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'root'@'localhost' (using password: NO)
    /home/kyoung/public_html/includes/class_core.php on line 311
    MySQL Error :
    Error Number :
    Request Date : Thursday, February 5th 2009 @ 02:03:07 PM
    Error Date : Thursday, February 5th 2009 @ 02:03:07 PM
    Script : http://jeep-forums.4wd.com/install/upgrade.php
    Referrer :
    IP Address : 65.42.106.146
    Username :
    Classname : vB_Database
    MySQL Version :

    If the config file is the same as the one on the site, why rename it and add it then?

    Leave a comment:


  • 1QuickSI
    replied
    The erorr message is saying that VB can not talk to the MySQL database. So you need to check your config.php file in the sections relating to the database and conenctions (ID, PW, localhost, etc.).

    When upgrading there should be no need to edit your config.php file and when you copy the new files up the included config.php file is named differently so you cant/forget not to over write the file.

    You need to upload the /install folder when upgrading and you should ALWAYS close your board while preforming the upgrade.

    When installing you need to run:
    http://www.YourDomain.com/LocationOf...ll/upgrade.php

    Once done you will receive an eror message that the install folder still exists. Just delete the entire folder, relogin to your ACP and open your forums.

    Leave a comment:


  • Wiets
    replied
    We are still encountering the same problems!
    I contacted my hosting company and this is what they say;

    "I just checked and the server is operating normally. As the script author they will need to provide specific information on why they feel the server is the issue."


    I have also read the link provided above and I am completely out of my depth searching and fixing possible errors or mistakes.

    Question:
    Will it work if I install 3.8.1 with a new database in another directory and then import certain tables of the old 3.7.4 SQL database into the new 3.8.1 SQL database?

    Leave a comment:


  • Steve Machol
    replied
    No changes were needed and as you said you made none. Therefore that error is a server issue.

    Leave a comment:


  • Wiets
    replied
    Originally posted by Steve Machol View Post
    Then this is a server issue and you need to contact your host.
    Was I suppose to make any changes to the config.php file before uploading it? Is so, what?

    Leave a comment:


  • Steve Machol
    replied
    Then this is a server issue and you need to contact your host.

    Leave a comment:


  • Wiets
    replied
    Originally posted by Steve Machol View Post
    Assuming the db info in your config.php file is correct, this is a server issue. Please see this page for the causes of this error:

    http://www.vbulletin.com/docs/html/cantconnect
    I did not make any alterations to the config.php file as the upgrade directions mentions nothing of this. I suggest that you add this escpecilaly for newbies like me;

    Close your board via the Admin Control Panel.
    Upload all files from the 'upload/' folder in the zip, with the exception of 'install/install.php'. Then open the 'upload/includes/' folder. In this you will find config.php.new. You should rename this to config.php and then open it in a text editor. ???????????

    Open your browser and point the URL to http://www.example.com/forum/install/upgrade.php (where www.example.com/forums/ is the URL of your vBulletin). You should now be automatically forwarded to the appropriate upgrade script and step.
    I did open the config.php in Notepad and thought that there will be further instuctions.
    Must I type in all the server and database info, save the config.php file, upload and then run the upgrade.php again?

    Leave a comment:


  • Steve Machol
    replied
    Assuming the db info in your config.php file is correct, this is a server issue. Please see this page for the causes of this error:

    http://www.vbulletin.com/docs/html/cantconnect

    Leave a comment:

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