MySQL Error (Denies me access to amincp options, other member pages and sometimes posts.)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Greenpk
    Member
    • Nov 2012
    • 78

    MySQL Error (Denies me access to amincp options, other member pages and sometimes posts.)

    When visiting Options in AdminCP:
    Code:
    Database error in vBulletin 4.2.2:
    
    Invalid SQL:
    
            SELECT setting.*, settinggroup.grouptitle
            FROM settinggroup AS settinggroup
            LEFT JOIN setting AS setting USING(grouptitle)
            WHERE settinggroup.displayorder <> 0
            ORDER BY settinggroup.displayorder, setting.displayorder;
    
    MySQL Error   : Got error 28 from storage engine
    Error Number  : 1030
    Request Date  : Saturday, April 26th 2014 @ 08:37:51 AM
    Error Date    : Saturday, April 26th 2014 @ 08:37:51 AM
    Script        : http://domain.net/forum/admin-login/options.php?null=0
    Referrer      : http://domain.net/forum/admin-login/index.php?do=nav
    IP Address    : **.***.***.***
    Username      : Username
    Classname     : vB_Database
    MySQL Version : 5.1.73-cll
    When visiting a member's page:
    Code:
    Database error in vBulletin 4.2.2:
    
    Invalid SQL:
    
                    SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
                        
                    FROM userlist AS userlist
                    INNER JOIN user AS user ON (user.userid = userlist.relationid)
                    LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
                    LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) 
                    
                    WHERE userlist.userid = 8
                        AND userlist.type = 'buddy'
                        AND userlist.friend = 'yes'
                        
                    ORDER BY RAND()
                    LIMIT 0, 5;
    
    MySQL Error   : Got error 28 from storage engine
    Error Number  : 1030
    Request Date  : Saturday, April 26th 2014 @ 08:40:53 AM
    Error Date    : Saturday, April 26th 2014 @ 08:40:53 AM
    Script        : http://domain.net/forum/member.php?8-username
    Referrer      : http://domain.net/forum/forum.php
    IP Address    : **.***.***.***
    Username      : Username
    Classname     : vB_Database
    MySQL Version : 5.1.73-cll
    Mail recieved:
    Code:
     
     Return-path: <hostname@domain[U].com[/U]> Received: from hostname by domain.com with local (Exim 4.82) 	(envelope-from <hostname[U]@domain.com[/U]>) 	id 1WbC9b-003RWR-G5 	for [EMAIL="[email protected]"][email protected][/EMAIL]; Fri, 18 Apr 2014 13:00:43 -0400 To: [EMAIL="[email protected]"][email protected][/EMAIL] Subject: vBulletin Database Error! From: [EMAIL="[email protected]"][email protected][/EMAIL] Message-Id: <[EMAIL="[email protected]"]E1WbC9b-003RWR-G5[/EMAIL][U]@hostname.com[/U]> Sender:  <hostname[U]@hostname.com[/U]> Date: Fri, 18 Apr 2014 13:00:43 -0400  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/hostname/public_html/forumpath/includes/class_core.php on line 317  MySQL Error   :  Error Number  :  Request Date  : Friday, April 18th 2014 @ 01:00:43 PM Error Date    : Friday, April 18th 2014 @ 01:00:43 PM Script        : [URL="http://a-trix.net/forum/"]http://domainname.net/forumpath/[/URL] Referrer      :  IP Address    : **.***.***.*** Username      :  Classname     : vB_Database MySQL Version :
    This is how config.php looks:
    Code:
    [CODE]$config['MasterServer']['username'] = 'hostname_admin';
    $config['MasterServer']['password'] = 'passwordhere';
    [/CODE]

    This is how class_core.php (line 317) looks:
    Code:
    $link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);
            }
    Suddenly today it all happend. At first it happend like once every 10 minutes or so, and now it is just permanent on those two pages.
    I would really appriciate some help.

  • donald1234
    Senior Member
    • Oct 2011
    • 1953
    • 4.1.x

    #2
    Your config.php is a default or blank one, did you overwite it?. Anyway if you don't have a complete one in a back up you will need to fill in the fields for database name, username and password.

    Comment

    • Lynne
      Former vBulletin Support
      • Oct 2004
      • 26255

      #3
      MySQL Error : Got error 28 from storage engine

      One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools &lt;- awesome site for html/css help

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73981

        #4
        Most likely cause is the /tmp directory. It needs to be at least 3 times the size of largest database on the server.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

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