Joomla.it Forum

Joomla! 1.0.x (versione con supporto terminato) => Le voci di Joomla.it (solo per versione Joomla 1.0.x) => : helpdesk 04 Sep 2007, 15:11:40

: Unable to save result set errore nei contenuti [risolto]
: helpdesk 04 Sep 2007, 15:11:40

Ciao mi aiutate a capire cosa č successo?

Warning: mysql_query(): Unable to save result set in /var/www/html/ns/includes/database.php on line 289
Non ci sono articoli da visualizzare

in admin ricevo invece + o- lo stesso errore

Warning: mysql_query(): Unable to save result set in /var/www/html/ns/includes/database.php on line 289

Warning: mysql_query(): Unable to save result set in /var/www/html/ns/includes/database.php on line 289
DB function failed with error number 1030
Got error 127 from storage engine SQL=SELECT c.*, g.name AS groupname, cc.name, s.name AS sect_name, u.name AS editor, f.ordering AS fpordering, v.name AS author FROM jos_content AS c INNER JOIN jos_categories AS cc ON cc.id = c.catid INNER JOIN jos_sections AS s ON s.id = cc.section AND s.scope='content' INNER JOIN jos_content_frontpage AS f ON f.content_id = c.id INNER 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 WHERE c.state >= 0 ORDER BY f.ordering LIMIT 30

grazie e ciao

: Re: errore nei contenuti in home e in admin
: bigham 04 Sep 2007, 16:57:03

Ciao.

127 = Record-file is crashed
Credo che si sia 'scassato' il DB.
Dovresti provare a ripararlo da phpMyAdmin.

: Re: errore nei contenuti in home e in admin
: helpdesk 05 Sep 2007, 08:57:29

Bravissimo! Era la tabella jos_categories.
Grazie

: Re: errore nei contenuti in home e in admin
: bigham 06 Sep 2007, 19:14:03

Benissimo!  ;D
Per favore, metti [RISOLTO] nell'oggetto del post cosė altri ne trarranno profitto.
Io aggiungerei nell'oggetto anche "Unable to save result set", per maggiore precisione.

Ciao e buon lavoro