Joomla! Forum Schweiz wird Teil der D-A-CH Community

Nach vielen Jahren als zentrale Anlaufstelle für Fragen rund um Joomla! in der Schweiz wird das Joomla! Forum Schweiz künftig als Archiv weitergeführt.

Die Joomla!-Communities aus Deutschland, Österreich und der Schweiz arbeiten heute enger denn je zusammen. Deshalb bündeln wir künftig auch den deutschsprachigen Support und Austausch an einem gemeinsamen Ort im Joomla! D-A-CH Forum.

Für neue Fragen, Diskussionen und den Austausch mit der Community nutzt bitte ab sofort:

forum.joomla.de

Das Joomla! Forum Schweiz bleibt weiterhin bestehen und wird als Archiv im Lesemodus erhalten. Die vielen Beiträge, Lösungen und Erfahrungen aus den vergangenen Jahren bleiben damit weiterhin zugänglich und über die Suche auffindbar.

Wir bedanken uns herzlich bei allen Mitgliedern, Moderatoren und Helfern, die das Schweizer Joomla! Forum über viele Jahre mit ihrem Wissen und ihrem Engagement geprägt haben.

Wir sehen uns im Joomla! D-A-CH Forum!

sehr merkwürdig: Got error 28 from storage engine

  • gibraltar
  • Autor
  • Neues Mitglied
  • Neues Mitglied
Mehr
05 Mai 2013 20:23 - 05 Mai 2013 20:24 #36789 von gibraltar
hallo und guten Abend


also auf meiner Joomlaseite hab ich heute sehr viel Ultra-Merkwürdiges entdeckt:;

das folgende nämlich:


BTW - mein SERVER ADMIN hat neulich mal von einem Einbruch erzählt.
Kann das denn sein!!?

Code:
a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM vjl1p_content AS a LEFT JOIN vjl1p_categories AS c ON c.id = a.catid LEFT JOIN vjl1p_users AS ua ON ua.id = a.created_by LEFT JOIN vjl1p_users AS uam ON uam.id = a.modified_by LEFT JOIN vjl1p_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN vjl1p_categories as parent ON parent.id = c.parent_id LEFT JOIN vjl1p_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM vjl1p_categories AS cat JOIN vjl1p_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN vjl1p_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-05 18:06:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-05 18:06:47') GROUP BY a.id ORDER BY c.lft, fp.ordering, a.created DESC LIMIT 0, 3 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM vjl1p_content AS a LEFT JOIN vjl1p_categories AS c ON c.id = a.catid LEFT JOIN vjl1p_users AS ua ON ua.id = a.created_by LEFT JOIN vjl1p_users AS uam ON uam.id = a.modified_by LEFT JOIN vjl1p_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN vjl1p_categories as parent ON parent.id = c.parent_id LEFT JOIN vjl1p_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM vjl1p_categories AS cat JOIN vjl1p_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN vjl1p_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-05 18:06:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-05 18:06:47') GROUP BY a.id ORDER BY c.lft, fp.ordering, a.created DESC
Mehr
05 Mai 2013 22:42 #36791 von Tribal6

.....fp.ordering, a.created DESC LIMIT 0, 3 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias.....


lmgtfy.com/?q=Got+error+28+from+storage+engine

:woohoo:

Tue das, was du kannst, mit dem was du hast, da wo du bist.
  • gibraltar
  • Autor
  • Neues Mitglied
  • Neues Mitglied
Mehr
06 Mai 2013 01:36 #36792 von gibraltar
Hi lieber Tribal


vielen Dank für deine Hilfe

Tribal6 schrieb:

.....fp.ordering, a.created DESC LIMIT 0, 3 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias.....


lmgtfy.com/?q=Got+error+28+from+storage+engine

:woohoo:


danke cool!!


also wie das hier aufgeloest wird

forum.joomla.org/viewtopic.php?p=2241972

scheint es sich da um einen reltativ typ. DB-Fehler zu handeln:

Database Error: Unable to connect to the database:Could not connect to MySQL


Error code 28: No space left on device

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



vgl

forum.joomla.org/viewtopic.php?f=470&t=8...8&p=3028623#p3028623


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.


werde mit meinem Server-Admin reden

er hat neulich schonmal gesagt, dass da noch etwas zu machen ist - dass die DB voll ist!


Wir müssten da mal ggf. neue SERVERHARDWARE investieren..


dir nochmals vielen Dank
vg gib
Moderatoren: Tribal6RePaoDragonlordChris Hoefligerpascaleadiheutschi.ch
Powered by Kunena Forum

Joomla! Verband Schweiz - Mitglied werden