DB function failed with error number 1194

Discussion regarding Joomla! Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Security and Performance FAQs
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
nicolafw
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Tue Jul 03, 2007 9:09 am

Re: DB function failed with error number 1194

Post by nicolafw » Wed Apr 17, 2013 9:24 am

Jippie, and still in 2013 this worked. Tons of thanks!!!

Never solved such a live treatening problem in such short time!

:) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)

nexusfun
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Apr 19, 2013 5:12 pm

Re: DB function failed with error number 1194

Post by nexusfun » Fri Apr 19, 2013 5:20 pm

DB function failed with error number 1194
Table 'c' is marked as crashed and should be repaired 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

with the repair doesn't work....what can i do? please help me

User avatar
miloskorac
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Sun Sep 23, 2007 9:34 pm
Location: Punta Cana, Dominican Republic
Contact:

Re: DB function failed with error number 1194

Post by miloskorac » Sat Jun 28, 2014 1:38 am

I have removed the frontpage session handling for guests, and the guest session flooding stopped.

When the guest session handling is enabled, each bot that visit the page will create the entry in the table jos_session.


Locked

Return to “Performance - 1.0.x”