Announcement

Collapse
No announcement yet.

Lotsza Errors..

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

  • Lotsza Errors..

    Okay I have gotten a SERIES of errors within this day:

    Database error in vBulletin: Invalid SQL:
    SELECT DISTINCT
    user.*, userfield.*, session.userid AS sessionuserid, session.lastactivity
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
    FROM user
    LEFT JOIN usergroup ON (usergroup.usergroupid = user.usergroupid)
    LEFT JOIN userfield ON (userfield.userid = user.userid)
    LEFT JOIN session ON (session.userid = user.userid
    AND session.userid <> 0 AND user.invisible = 0 AND session.lastactivity>0)
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=user.userid
    WHERE user.usergroupid IN(6,5)
    GROUP BY user.username
    ORDER BY user.userid

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Tuesday 22nd of May 2001 11:46:00 AM
    Script: /showmods.php?
    Referer:
    Database error in vBulletin: Link-ID == false, connect failed
    mysql error:
    mysql error number:
    Date: Tuesday 22nd of May 2001 10:15:51 AM
    Script: /forums/index.php
    Referer:
    Database error in vBulletin: Invalid SQL: SELECT privatemessage.*,touser.username AS tousername,fromuser.username AS fromusername,icon.title AS icontitle,icon.iconpath FROM privatemessage,user AS touser,user AS fromuser LEFT JOIN icon ON icon.iconid=privatemessage.iconid WHERE privatemessage.userid='13' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 ORDER BY dateline DESC
    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Tuesday 22nd of May 2001 03:19:34 PM
    Script: /usercp.php?s=
    Referer:
    Gotten lots of the same errors. What is happening?

  • #2
    Error code 28 means there's no space left on the device. You'll have to free some up before you can continue.

    Comment


    • #3
      I am also getting this error in the adminlog mySQL entry

      adminlog Browse Select Insert Properties Drop Empty
      Warning: Supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/lib.inc.php on line 507
      That warning is under records.

      I also don't think I am out of room because people can still post and do PMs.

      Comment


      • #4
        Code:
        [[email protected] root]# perror 28
        Error code  28:  No space left on device
        You are out of disk space on the drive where your MySQL databases are stored.

        Comment


        • #5
          I also cannot access my admin screen... this is getting bad......

          Comment


          • #6
            It won't get any better until you have your host free up disk space. I recommend shutting down your forums now before some more serious corruption occurs.

            Comment


            • #7
              How do I shut it down w/o admin access? I could reload a recent backup.. should I backup my current stuff? For some reason I am getting an error message from my mySQL database [shown above] can you explain?

              Comment


              • #8
                Run this query:
                Code:
                UPDATE setting SET value='0' WHERE varname='bbactive';

                Comment


                • #9
                  Open phpMyAdmin, run this query:

                  SELECT template FROM template WHERE title = 'options'

                  then set the $bbactive variable to 0 and save the template again.

                  Comment


                  • #10
                    This is really *&^$ed, I can't even do that, won't let me click edit... ugh! I don't know what to do! My host has not responded and I am still getting an error 28.

                    Comment


                    • #11
                      In PHPMyAdmin, empty your searchindex and word tables.

                      These contain no critical data that can't be restored. They are two of the largest tables. And will free up enough space so that you can recover until your host responds.
                      Translations provided by Google.

                      Wayne Luke
                      The Rabid Badger - a vBulletin Cloud demonstration site.
                      vBulletin 5 API - Full / Mobile
                      Vote for your favorite feature requests and the bugs you want to see fixed.

                      Comment


                      • #12
                        That worked!

                        Although I still need to figure out if my database is being limited, but that is between me and my host. Thanks for all the help everyone.

                        Comment

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