Announcement

Collapse
No announcement yet.

Database Problem

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

  • Database Problem

    I have created a new website, however I want to use a forum I used in the past. I have a database backup and all site files. Here's what I did:

    1) Restored all data files using ftp.
    2) Created a new database using a different database name, username and password.
    3) Imported .sql file using phpMyAdmin
    4) Edited config.php to reflect the new database name, username and password

    I get the following results going to admincp:

    Database errorThe database has encountered a problem.Please try the following:
    • Load the page again by clicking the Refresh button in your web browser.
    • Open the 70.86.163.56 home page, then try to open another page.
    • Click the Back button to try another link.
    The 70.86.163.56 forum technical staff have been notified of the error, though you may contact them if the problem persists.
    We apologise for any inconvenience.

    Any ideas what I missed? Do I need to use the origional database name, username and password? If I do, how can I get around this?

    Thanks in advance!!
    ProvidentialSolutions.com
    V8buick.com

  • #2
    Please right click the page, select > View source > and find the FULL MySQL error and post it here. We require it in order to determine what might be wrong.

    Comment


    • #3
      <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
      <html>
      <head>
      <title> Database Error</title>
      <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
      <style type="text/css">
      <!--
      body { background-color: white; color: black; }
      #container { width: 400px; }
      #message { width: 400px; color: black; background-color: #FFFFCC; }
      #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
      .bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
      a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
      a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
      -->
      </style>
      </head>
      <body>
      <table cellpadding="3" cellspacing="5" id="container">
      <tr>
      <td><img src="../image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
      <td id="bodytitle" width="100%">Database error</td>
      </tr>
      <tr>
      <td class="bodytext" colspan="2">The database has encountered a problem.</td>
      </tr>
      <tr>
      <td colspan="2"><hr /></td>
      </tr>
      <tr>
      <td class="bodytext" colspan="2">
      Please try the following:
      <ul>
      <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
      <li>Open the <a href="/">70.86.163.56</a> home page, then try to open another page.</li>
      <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
      </ul>
      </td>
      </tr>
      <tr>
      <td class="bodytext" colspan="2">The 70.86.163.56 forum technical staff have been notified of the error, though you may <a href="mailto:[email protected]">contact them</a> if the problem persists.</td>
      </tr>
      <tr>
      <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
      </tr>
      </table>

      <!--
      Database error in vBulletin :
      Cannot use database appollo_tech
      MySQL Error : Access denied for user 'appollo'@'localhost' to database 'appollo_tech'
      Error Number : 1044
      Date : Saturday, February 23rd 2008 @ 02:08:43 AM
      Script : http://70.86.163.56/tech/forum/admincp/index.php
      Referrer :
      IP Address : 66.41.128.170
      Username :
      Classname : vb_database
      -->

      </body>
      </html>
      ProvidentialSolutions.com
      V8buick.com

      Comment


      • #4
        Access denied for user 'appollo'@'localhost' to database 'appollo_tech'


        Contact the hosting provider. Confirm the details:

        MySQL host
        MySQL port
        MySQL user
        MySQL pass
        MySQL database

        Make sure the user with the pass has permission to access that database.

        And confirm the database server is up and running.

        Comment


        • #5
          Got the database working. Thanks!!!

          One last item.

          My forum is located at http://70.86.163.56/tech/forum

          If I use that URL here's what the address bar switches to: http://appollosystems.com/tech/forum/

          I'm not using a domain name yet. Wanted to get the site running before switching ove to it.

          Here is another example: http://70.86.163.56/tech/forum/admincp
          If I use that URL here's what the address bar switches to: http://appollosystems.com/tech/forum/admincp/

          In all cases I get:
          <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
          <html dir=ltr>
          <head>
          <style>
          a:link {font:8pt/11pt verdana; color:FF0000}
          a:visited {font:8pt/11pt verdana; color:#4e4e4e}
          </style>
          <META NAME="ROBOTS" CONTENT="NOINDEX">
          <title>The page cannot be found</title>
          <META HTTP-EQUIV="Content-Type" Content="text-html; charset=Windows-1252">
          </head>
          <script>
          function Homepage(){
          <!--
          // in real bits, urls get returned to our script like this:
          // res://shdocvw.dll/http_404.htm#http://www.DocURL.com/bar.htm
          //For testing use DocURL = "res://shdocvw.dll/http_404.htm#https://www.microsoft.com/bar.htm"
          DocURL = document.URL;

          //this is where the http or https will be, as found by searching for :// but skipping the res://
          protocolIndex=DocURL.indexOf("://",4);

          //this finds the ending slash for the domain server
          serverIndex=DocURL.indexOf("/",protocolIndex + 3);
          //for the href, we need a valid URL to the domain. We search for the # symbol to find the begining
          //of the true URL, and add 1 to skip it - this is the BeginURL value. We use serverIndex as the end marker.
          //urlresult=DocURL.substring(protocolIndex - 4,serverIndex);
          BeginURL=DocURL.indexOf("#",1) + 1;

          urlresult=DocURL.substring(BeginURL,serverIndex);

          //for display, we need to skip after http://, and go to the next slash
          displayresult=DocURL.substring(protocolIndex + 3 ,serverIndex);
          InsertElementAnchor(urlresult, displayresult);
          }
          function HtmlEncode(text)
          {
          return text.replace(/&/g, '&amp').replace(/'/g, '&quot;').replace(/</g, '&lt;').replace(/>/g, '&gt;');
          }
          function TagAttrib(name, value)
          {
          return ' '+name+'="'+HtmlEncode(value)+'"';
          }
          function PrintTag(tagName, needCloseTag, attrib, inner){
          document.write( '<' + tagName + attrib + '>' + HtmlEncode(inner) );
          if (needCloseTag) document.write( '</' + tagName +'>' );
          }
          function URI(href)
          {
          IEVer = window.navigator.appVersion;
          IEVer = IEVer.substr( IEVer.indexOf('MSIE') + 5, 3 );
          return (IEVer.charAt(1)=='.' && IEVer >= '5.5') ?
          encodeURI(href) :
          escape(href).replace(/%3A/g, ':').replace(/%3B/g, ';');
          }
          function InsertElementAnchor(href, text)
          {
          PrintTag('A', true, TagAttrib('HREF', URI(href)), text);
          }
          //-->
          </script>
          <body bgcolor="FFFFFF">
          <table width="410" cellpadding="3" cellspacing="5">
          <tr>
          <td align="left" valign="middle" width="360">
          <h1 style="COLOR:000000; FONT: 13pt/15pt verdana"><!--Problem-->The page cannot be found</h1>
          </td>
          </tr>

          <tr>
          <td width="400" colspan="2">
          <font style="COLOR:000000; FONT: 8pt/11pt verdana">The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.</font></td>
          </tr>

          <tr>
          <td width="400" colspan="2">
          <font style="COLOR:000000; FONT: 8pt/11pt verdana">
          <hr color="#C0C0C0" noshade>

          <p>Please try the following:</p>
          <ul>
          <li>If you typed the page address in the Address bar, make sure that it is spelled correctly.<br>
          </li>

          <li>Open the

          <script>
          <!--
          if (!((window.navigator.userAgent.indexOf("MSIE") > 0) && (window.navigator.appVersion.charAt(0) == "2")))
          {
          Homepage();
          }
          //-->
          </script>
          home page, and then look for links to the information you want.</li>

          <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
          </ul>

          <h2 style="font:8pt/11pt verdana; color:000000">HTTP 404 - File not found<br>
          Internet Information Services<BR></h2>

          <hr color="#C0C0C0" noshade>

          Also, If I use the ip address/path/path/index.php on any of them, they work fine, just by adding index.php

          Thanks
          Last edited by mbucy; Sat 23 Feb '08, 12:33am.
          ProvidentialSolutions.com
          V8buick.com

          Comment


          • #6
            This is either due to a misconfigured htaccess file or the way that your server is configured. If you do not have a htaccess file on your server then you will need to contact your host about this.
            Kerry-Anne :)

            Twitter Blog

            www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

            Comment


            • #7
              Make sure the Admin Control Panel > vBulletin Options > vBulletin Options > Site URL is pointing to the IP and not the HOST.

              Comment


              • #8
                Originally posted by Floris View Post
                Make sure the Admin Control Panel > vBulletin Options > vBulletin Options > Site URL is pointing to the IP and not the HOST.
                Done that!
                ProvidentialSolutions.com
                V8buick.com

                Comment


                • #9
                  Originally posted by Kerry-Anne View Post
                  This is either due to a misconfigured htaccess file or the way that your server is configured. If you do not have a htaccess file on your server then you will need to contact your host about this.
                  I'll check with my hosting company and let you know what happens

                  Thanks
                  ProvidentialSolutions.com
                  V8buick.com

                  Comment


                  • #10
                    Hosting company says Vbulletin is the problem. Could I have a database problem? htaccess file looks good..
                    ProvidentialSolutions.com
                    V8buick.com

                    Comment


                    • #11
                      remove the htaccess and then try it. This is not a vBulletin problem and is either server or htaccess related.
                      Kerry-Anne :)

                      Twitter Blog

                      www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                      Comment


                      • #12
                        When you move a domain it will be working within minutes to up to 72 hours.
                        So this problem resolves itself once you move the domain over anyway.

                        But vBulletin works on JUST an IP, and/or a host address. I can't reproduce this with a 'new' account on a temp IP that has no host assigned to it. I've tried with hostgator and theplanet.

                        Comment

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