Results 1 to 5 of 5
  1. #1

    Joomla error, mysql problem?

    Hello, my site is showing this error, what could be happening? I have a VPS..

    Error loading Modules:Got error 28 from storage engine SQL=SELECT m.*, am.params as adv_params FROM jos_modules as m LEFT JOIN jos_advancedmodules as am ON am.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 ORDER BY m.ordering, m.id
    This just happened a few moments ago, what I did, was just perform a I/O test..

    dd if=/dev/zero of=tmp bs=64k count=16k conv=fdatasync
    (it was a similar command)

    I see all services on, but tmp is almost full:
    99.29% (492299 of 495844)

    Maybe that's the problem? I can't find information about this in google
    Last edited by warlock-m; 04-01-2011 at 10:07 PM.

  2. #2
    Join Date
    Mar 2003
    Posts
    663
    Copy paste and run the query directly from your Phpmyadmin or SSH to mysql and see if there's error.

    SELECT m.*, am.params as adv_params FROM jos_modules as m LEFT JOIN jos_advancedmodules as am ON am.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 ORDER BY m.ordering, m.id

  3. #3
    It was the temp folder, I completely removed it.. applied a backup I had of that folder and restarted mysql service.. and now it works.. Thank you Anlene!

  4. #4
    Join Date
    Mar 2003
    Posts
    663
    No prob, glad it all worked out for ya.
    Member Since 2003.

  5. #5
    Join Date
    Apr 2001
    Location
    Paradise
    Posts
    12,052
    The temporal folder was out of space.
    Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
    LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
    Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
    DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore

Similar Threads

  1. Parse error: syntax error,is this mysql problem,plz?
    By skyaus in forum Hosting Security and Technology
    Replies: 5
    Last Post: 10-25-2008, 09:31 PM
  2. Joomla installation - Username/Password Incorrect MySQL Database Error
    By Jon12345 in forum Hosting Security and Technology
    Replies: 10
    Last Post: 06-25-2007, 07:03 PM
  3. PHP - Mysql Error during query, help out with a simple problem? :)
    By optimumd in forum Programming Discussion
    Replies: 12
    Last Post: 06-30-2006, 02:00 PM
  4. MySQL syntax error.. I can't figure out the problem here
    By Josh1billion in forum Programming Discussion
    Replies: 3
    Last Post: 02-19-2006, 11:00 PM
  5. mysql error problem help $$$
    By David Tan in forum Employment / Job Offers
    Replies: 4
    Last Post: 07-15-2003, 10:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •