Need Help Modules Backend Not Working - Joomla! Forum - community, help and support

hi,

i dont know did, suddently error message appears when go module manager :

code: select all

db function failed error number 1
can't create/write file '/tmp/#sql_44db_0.myi' (errcode: 30) sql=select m.*, u.name editor, g.name groupname, min(mm.menuid) pages jos_modules m left join jos_users u on u.id = m.checked_out left join jos_groups g on g.id = m.access left join jos_modules_menu mm on mm.moduleid = m.id m.client_id = 0 group m.id order m.position , m.ordering asc limit 0, 20

and cant see module.

when go install/unistall -> module, appears:

code: select all

warning: array_slice() expects parameter 1 array, null given in /home/sergio/public_html/administrator/components/com_installer/models/modules.php on line 113

warning: array_slice() expects parameter 1 array, null given in /home/sergio/public_html/administrator/components/com_installer/models/modules.php on line 113

when activate debug mode shows off :

code: select all

jdatabasemysql::query: 1 - can't create/write file '/tmp/#sql_44db_0.myi' (errcode: 30) sql=select distinct a.*, u.name, u.username, p.avatar jos_hwdvidsvideos left join jos_hwdvidslogs_views l on l.videoid = a.id left join jos_users u on u.id = a.user_id left join jos_comprofiler p on p.id = a.user_id a.published = 1 , a.approved = "yes" , l.date > now() - interval 60 minute order l.date desc limit 0, 10

call stack
#   function   location
1   jsite->render()   /home/sergio/public_html/index.php:79
2   jdocumenthtml->render()   /home/sergio/public_html/includes/application.php:168
3   jdocumenthtml->_parsetemplate()   /home/sergio/public_html/libraries/joomla/document/html/html.php:249
4   jdocumenthtml->getbuffer()   /home/sergio/public_html/libraries/joomla/document/html/html.php:386
5   jdocumentrenderermodules->render()   /home/sergio/public_html/libraries/joomla/document/html/html.php:190
6   jdocumentrenderermodule->render()   /home/sergio/public_html/libraries/joomla/document/html/renderer/modules.php:41
7   jmodulehelper->rendermodule()   /home/sergio/public_html/libraries/joomla/document/html/renderer/module.php:84
8   require()   /home/sergio/public_html/libraries/joomla/application/module/helper.php:173
9   jdatabasemysql->loadobjectlist()   /home/sergio/public_html/modules/mod_hwd_vs_sql_datalists/mod_hwd_vs_sql_datalists.php:211
10   jdatabasemysql->query()   /home/sergio/public_html/libraries/joomla/database/database/mysql.php:458
11   jerror->raiseerror()   /home/sergio/public_html/libraries/joomla/database/database/mysql.php:231
12   jerror->raise()   /home/sergio/public_html/libraries/joomla/error/error.php:171
13   jexception->__construct()   /home/sergio/public_html/libraries/joomla/error/error.php:136

dont know why happened ok , suddently...

sounds bad! remind me never let near computer!! :-)

seriously, sounds may have crashed database. try repairing via front end phpmyadmin or direct php scripts if you're php coder. otherwise, time restore database backup. (you have backup, right?)

reminder - isn't question of if database crash, question when , answer "when haven't backed in long while"!

sorry, wish had better news. on bright side, hosting people may have backup you.