Joomla! Forum - community, help and support

hi this is S Sekhar D
Today I faced one problem with joomla Version 1.5.10

when i went for creating the modules after installing joomla Version 1.5.10 then I had this error.
It is showing the error which i am displaying - below and also a screen short file attached .

"DB function failed with error number 1
Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8a8_0.MYD' (Errcode: 17) 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"

please help me out

Have you tried clearing the folder windows\temp and restarting the MySQL server? Which version of MySQL are you using?

toivo wrote:Have you tried clearing the folder windows\temp and restarting the MySQL server? Which version of MySQL are you using?

Oh, thank u very much.

Tomorrow is my project delivery date and Iwasso scary when I recieved the error "DB function failed with error number 1".

I clean up my /temp directory and erase the joomla caché and, wallah!

Thanks toivo, just helped me with the same error

hello
I need some help with this error: 500 - An error occured!

DB function failed with error number 1
Can't create/write to file '/localservices/tmpfs/#sql_aa6_0.MYI' (Errcode: 2) 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

I deleted the temp folder from windows folder but in my error is not stated windows/temp ,i have localservice/tmps. I also cleared cache and deleted it from joomla platform.
Actually this error appeared after looking at my site's first page and noticing that i don't have anymore the articles on the main page i went in the back page of joomla and it appeared at articles manager.
Please if you have any idea/ ideas help me.
I also asked where my site is hosted if they have some issues but they said they have no problem.

Thank you!