please help : DB function failed with error number 1030

General questions relating to Joomla! 1.5 There are other boards for more specific help on Joomla! features and extensions.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Locked
sidalisi
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Mar 25, 2009 7:40 pm

please help : DB function failed with error number 1030

Post by sidalisi » Fri Jul 17, 2009 12:42 pm

i have a probleme on my site
when i want to go tothe article manager it tell me this:

DB function failed with error number 1030
Got error 28 from storage engine SQL=SELECT c.*, g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c LEFT JOIN jos_categories AS cc ON cc.id = c.catid LEFT JOIN jos_sections AS s ON s.id = c.sectionid LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state != -2 ORDER BY section_name , section_name, cc.title, c.ordering LIMIT 0, 20

help me please

 
User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27510
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: please help : DB function failed with error number 1030

Post by imanickam » Fri Jul 17, 2009 12:53 pm

This is MySQL error. The analysis of the error reveals that there is storage issue. If you could provide another error code (e.g., 12, 28, 134) it will provide more clue to why this error has occurred.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Translations Coordination Team | Tamil (தமிழ்) Translation Team

Eegan - Support the poor and underprivileged

sidalisi
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Mar 25, 2009 7:40 pm

error 28

Post by sidalisi » Fri Jul 17, 2009 1:01 pm

DB function failed with error number 1030
Got error 28 from storage engine SQL=SELECT m.*, u.name AS editor, g.name AS groupname, MIN(mm.menuid) AS pages FROM jos_modules AS m LEFT JOIN jos_users AS u ON u.id = m.checked_out LEFT JOIN jos_groups AS g ON g.id = m.access LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.client_id = 0 GROUP BY m.id ORDER BY m.position , m.ordering ASC LIMIT 0, 20

sidalisi
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Mar 25, 2009 7:40 pm

Re: please help : DB function failed with error number 1030

Post by sidalisi » Fri Jul 17, 2009 1:04 pm

imanickam wrote:This is MySQL error. The analysis of the error reveals that there is storage issue. If you could provide another error code (e.g., 12, 28, 134) it will provide more clue to why this error has occurred.

i think it s error code 28
help please

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27510
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: please help : DB function failed with error number 1030

Post by imanickam » Fri Jul 17, 2009 1:19 pm

Review the following links for more information.

http://www.vbulletin.com/forum/showthread.php?t=149174
http://k3lvinmitnick.[URL banned].com/2007/ ... -1030.html

As the discussions suggest this is a storage related issue. If the issue persists then you may have to talk to your service provider. You can also seek help from the MySQL forum.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Translations Coordination Team | Tamil (தமிழ்) Translation Team

Eegan - Support the poor and underprivileged

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20118
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: please help : DB function failed with error number 1030

Post by leolam » Fri Jul 17, 2009 2:51 pm

This is normally caused because your /tmp folder is filled with sessions etc. You might want/need to contact your ghost to clean that folder for you since you have no access. They can btw if they want install on host/server level a cronjob to take care of that issue permanently

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20118
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: please help : DB function failed with error number 1030

Post by leolam » Mon Aug 24, 2009 3:22 am

Please refrain from sending me email messages for help. If you want my 1:1 support follow my signature and purchase a support ticket.

Error code 28: No space left on device

If you get his error, you need to check all filesystems where MySQL operates. MySQL often creates temporary tables for some queries - most of them are placed in tmpdir, but some into database directory. You must ensure, that there is enough free disk space available for MySQL.

First try to repair and successively optimize your database tables through phpMyAdmin. If that does not work you need to contact your host so they can assist you finding out why the (server) partition is filling up

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

User avatar
prolipes
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Sun Jun 06, 2010 12:19 am
Location: Portugal
Contact:

Re: please help : DB function failed with error number 1030

Post by prolipes » Thu Aug 26, 2010 6:20 pm

Too bad! I have some problem right now...
Yesterday Joomla! was working very fine... and now suddently it crashes in the admin backend.. And I dont do anything on DB :S
Why??

I can't create, modify or edit articles:

it says:

Code: Select all

DB function failed with error number 1
Can't create/write to file '/tmp/#sql_ece_0.MYI' (Errcode: 28) SQL=SELECT c.*, g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c LEFT JOIN jos_categories AS cc ON cc.id = c.catid LEFT JOIN jos_sections AS s ON s.id = c.sectionid LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state != -2 ORDER BY section_name , section_name, cc.title, c.ordering LIMIT 0, 20


view install or unninstall modules etc... says:

Code: Select all

Warning: array_slice() expects parameter 1 to be array, null given in /home/public_html/local.com/administrator/components/com_installer/models/modules.php on line 113


PHP: 5.2.11
Joomla!: Joomla! 1.5.20 Stable [ senu takaa ] 18-July-2010 18:00 GMT

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16584
Joined: Thu Aug 18, 2005 7:13 am

Re: please help : DB function failed with error number 1030

Post by Tonie » Thu Aug 26, 2010 6:25 pm

Did you read this thread and looked at your used space?

User avatar
prolipes
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Sun Jun 06, 2010 12:19 am
Location: Portugal
Contact:

Re: please help : DB function failed with error number 1030

Post by prolipes » Fri Aug 27, 2010 5:48 pm

Hi! Yes a looked to 'space left ondevice' but my hosting is unlimited space and it wasn't real DB error...
Maybe they are making a backup or something else... I really dont know..
It was very weird because I was already seeing that I had to start all work over again.. from the beginning. :'| Argh!
Few minutes waiting the backend administration was working fine again! :) uff!

tks

Gleber
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Sep 05, 2010 7:49 pm

Re: please help : DB function failed with error number 1030

Post by Gleber » Sun Oct 31, 2010 8:11 pm

I had this same issue, was getting odd SQL errors, and eventually got to
the Joomla error "DB function failed with error number 1030."
When you see the mySQL error "Got error 28 from storage engine SQL..."
Error Code 28 is definitely "No Space Left on Device"

I busted into the server room and we had 5.2 KB left on disk. Heh.
Time to delete useless files!
So, lotsa useless logs and other non-essential progs got deleted that day.

Restarted and... problem solved.

 

Locked

Return to “General Questions/New to Joomla! 1.5”