Announcement

Collapse
No announcement yet.

PM Database problem

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

  • PM Database problem

    Hello
    Few hours ago, I could access the PM page fine.

    All of a sudden, when I go to private.php, the following error comes up with the email being dispatched and all that message.

    Code:
    SELECT pm.*, pmtext.* 
    , icon.title AS icontitle, icon.iconpath 
    FROM pm AS pm 
    LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid) 
    LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid) 
    WHERE pm.userid=1 AND pm.folderid=0 
    ORDER BY pmtext.dateline DESC 
    LIMIT 0, 50
    Could anyone give me some advice?

    Thank you

  • #2
    we need the whole error, this includes the scirpt name and the error number.

    Comment


    • #3
      Ok.

      Code:
      Database error in vBulletin 3.0.1:
      Invalid SQL: 
         SELECT pm.*, pmtext.*
      	, icon.title AS icontitle, icon.iconpath
         FROM pm AS pm
         LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
         LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
         WHERE pm.userid=1 AND pm.folderid=0
         ORDER BY pmtext.dateline DESC
         LIMIT 0, 50
        
      mysql error: Got error 28 from table handler
      mysql error number: 1030
      Date: Tuesday 26th of October 2004 06:48:32 AM
      Script: http://forums.sishangout.com/private.php?
      Referer: http://forums.sishangout.com/
      Username: MiN*[2017.waiting]
      IP Address: ***.***.***.***

      Comment


      • #4
        It would be great if I could get this problem solved ASAP since this is urgent.

        Thank you

        Comment


        • #5
          MySQL Error 1030: Got error 28

          "While this error is rare, it can be difficult to track down the actual culprit. Typically, the error is caused by the server not having enough disk space for MySQL to perform the action. Contact your Host or server admin and ask that they make sure there is sufficient space on the server."

          Google fix everything...

          Comment


          • #6
            Imported all the attachments on the mysql to the file format or something and everything's fixed.

            Thanks!

            Comment


            • #7
              FYI:

              Error code 28: No space left on device

              One or more partitions on your server was out of space or didn't have enough space to complete this operation.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment

              Loading...
              Working...
              X