Page 1 of 2

DB function failed with error number 1194

Posted: Sat Oct 20, 2007 12:18 pm
by buurdi
Hello.. I have a joomla site that have worked without problems. But yesterday it began crashing!

In administration site on content menu I get this message:

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.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 >= 0 AND c.catid = cc.id AND cc.section = s.id AND s.scope = 'content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 30

On the site, it just tell me that it don't have any content.

Somebody know what to do?

Re: DB function failed with error number 1194

Posted: Sat Oct 20, 2007 12:25 pm
by ircmaxell
Open up phpMyAdmin, select the database, click the checkbox on that table (jos_content).  Scroll down to the bottom of the page, and in the select box select "Repair"

Re: DB function failed with error number 1194

Posted: Sat Oct 20, 2007 1:12 pm
by buurdi
Thank you so much !! :D

Re: DB function failed with error number 1194

Posted: Sat Oct 20, 2007 3:30 pm
by ircmaxell
No problem... Glad I could be of help...

Re: DB function failed with error number 1194

Posted: Mon Oct 22, 2007 10:19 pm
by kalalee
To ALL...
A major thanks to 'ircmaxell' for posting this info. My Joomla jos_session crashed and his post allowed me to correct this issue and get on with my life! Thanks 'ircmaxell'...a candle will be glowing tonight at my church in your honor.

Re: DB function failed with error number 1194

Posted: Sat Jun 14, 2008 5:13 pm
by snowman03
Thank You! Again, My life was saved with this information!

Re: DB function failed with error number 1194

Posted: Sat Aug 16, 2008 6:06 pm
by pwdsoft
You have recieved this error because your database is not using jos_ as its prefix , if you let us know what your database prefix is we will change the code to suit your needs or if you are happy to edit code yourself .

To Change prefix Go to your database and check correct prefix (common starting charcters of tablename). Put that prefix in your configuration file of joomla.

you can check this post
http://www.php-web-development.com/late ... -1146.html

thanks

Re: DB function failed with error number 1194

Posted: Fri Sep 05, 2008 8:37 am
by pedram
hi, i have the same problem and i did click on jos_content but there is no repair box at the bottom of the page. i have phpMyAdmin 2.11.6

Re: DB function failed with error number 1194

Posted: Sun Nov 23, 2008 1:36 pm
by mhshohag
hello sir
thank you

I have the same problem on jos_module tabte. the problem has solver as you guided.

Re: DB function failed with error number 1194

Posted: Wed Dec 03, 2008 12:59 pm
by studio22
i had this problem how do i fix it thank you.

do i do the same as, the other problem?

jtablesession::Store Failed
DB function failed with error number 1194
Table 'jos151_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos151_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '7df061baa2944ca109ed70d20a9d25bc','1228309137','','0','1','0' )

Re: DB function failed with error number 1194

Posted: Sun Jan 04, 2009 3:20 pm
by danielransom
life saving thread :)

Re: DB function failed with error number 1194

Posted: Sat Feb 21, 2009 11:24 pm
by LonePeach
Help! I am receiving this error:
DB function failed with error number 1194
Table 'jos_session' is marked as crashed and should be repaired SQL=SELECT session_id FROM jos_session WHERE session_id = '8a003d641ae4801d866d39acc1ffb93b'
SQL =SELECT session_id
FROM jos_session
WHERE session_id = '8a003d641ae4801d866d39acc1ffb93b'
I think it is the same problem and I have read the entries assoicated with this error. Included with this problem I am locked out the adminstrator page-I enter my username and password and I see a blurp of an error (it appears to be the same as above) and it returns to the administrator log in page. Could both problems be connected? Any ideas on how to fix this problem? Thanks!

Re: DB function failed with error number 1194

Posted: Fri May 15, 2009 1:47 pm
by Picasso Fish
Every few weeks, I receive the same error on a high-traffic website:

jtablesession::Store Failed

DB function failed with error number 1194

Table 'jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '37406c995a013dca2438a90d7871e18c','1242316716','','0','1','0' )

I am using Joomla 1.5.7, MySQL 4.1.22 and PHP 4.4.8.

Would an upgrade of MySQL or PHP solve the problem?

The site is hosted at one of those cheap $10/mo hosting services, and it would probably be a good idea to switch anyway.

Re: DB function failed with error number 1194

Posted: Thu Jun 25, 2009 7:02 am
by dibyadel
I have faced the same problem.

tablesession::Store Failed
DB function failed with error number 1062
Duplicate entry 'sl60r0po3a8lbq9pqisp5j9pn2' for key 1 SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'sl60r0po3a8lbq9pqisp5j9pn2','1245912956','','0','1','0' )

when checked in the phpMyAdmin , the table jos_session -
MySQL said: Documentation
#1194 - Table 'jos_session' is marked as crashed and should be repaired

But how to repair the table . kindly let me know

Re: DB function failed with error number 1194

Posted: Thu Jun 25, 2009 7:07 am
by dibyadel
Ok I could get the 'repair table' option under 'operation'. now I could repair the table and my portal is restored and no working. Thanks again.

Re: DB function failed with error number 1194

Posted: Tue Sep 08, 2009 11:06 pm
by protun
oh ircmaxell you are my hero.
thankssss

Re: DB function failed with error number 1194

Posted: Sat Jan 09, 2010 2:52 pm
by adi_2009
ircmaxell wrote:Open up phpMyAdmin, select the database, click the checkbox on that table (jos_content).  Scroll down to the bottom of the page, and in the select box select "Repair"
I also saved same problem thanks to this post ;) thnx ircmaxell, you rock! :)

Re: DB function failed with error number 1194

Posted: Mon Feb 01, 2010 9:44 pm
by AROMAZLA
Where is located "Repair" I dont see it. mine shows this

jtablesession::Store Failed
DB function failed with error number 1194
Table 'jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'fb48a628d69bfd60eb0614af1989e312','1265060605','','0','1','0' )

help!

Re: DB function failed with error number 1194

Posted: Wed May 05, 2010 2:35 pm
by TomT
ircmaxell wrote:Open up phpMyAdmin, select the database, click the checkbox on that table (jos_content).  Scroll down to the bottom of the page, and in the select box select "Repair"
A post from 20 Oct 2007 makes me very happy today :)

Re: DB function failed with error number 1194

Posted: Tue May 11, 2010 1:43 pm
by SpydrSS
I had the same problem on my site, and on one of my clients sites, (all in one day), This post certainly helped me solve it, but what I need to know is how to prevent it as I cannot go through 400 sites every day to see if the database hasn't crashed?

If anyone knows what causes this, and how to prevent it... stand up and be counted.

Re: DB function failed with error number 1194

Posted: Sun May 16, 2010 11:02 am
by Letterhead
sunday morning, i looked, i freaked, thought my day was taken from me, and then bingo, found this thread fast, up and running before any calls, a seriously big thank you.

Re: DB function failed with error number 1194

Posted: Wed Jun 09, 2010 11:41 pm
by dknoll
Thanks all. I was optimistic until my repair using this method failed. Next step?

Re: DB function failed with error number 1194

Posted: Tue Jun 22, 2010 12:16 am
by tinflute
3 years later, ircmaxell's advice worked like a charm.
props

Re: DB function failed with error number 1194

Posted: Tue Jul 06, 2010 2:02 pm
by JesuSlaveX
ircmaxell wrote:Open up phpMyAdmin, select the database, click the checkbox on that table (jos_content).  Scroll down to the bottom of the page, and in the select box select "Repair"

You sir a God among men. Though my issue was with the JOS_SESSION table, the same fix applied.

Thank ya kindly! :D

Re: DB function failed with error number 1194

Posted: Wed Aug 18, 2010 7:59 am
by pergrammo
Thank you verymuch Mannn.. this solv is great :D

Re: DB function failed with error number 1194

Posted: Tue Sep 07, 2010 3:02 pm
by alysbeach
to noobs like myself..If you cannot find the "repair" option.... at the bottom of the page, there is a dropdown that says "with selected" ...the repair table option is listed there

Re: DB function failed with error number 1194

Posted: Wed Dec 22, 2010 3:52 pm
by yubi
thanks soooo much ircmaxell...!!! :)

Re: DB function failed with error number 1194

Posted: Thu Jan 20, 2011 8:31 am
by DonCorleo
Yesterday i had the same error. Repairing works like a charm, but i want to know what the cause is.
Does anyone have an idea?

Re: DB function failed with error number 1194

Posted: Wed Feb 16, 2011 4:31 pm
by poliboy7
thank you so much ircmaxell i just had the same probleme and you give me the way to resolve it

Re: DB function failed with error number 1194

Posted: Fri Jun 03, 2011 9:08 am
by allen012087
i too have this error!! can someone fix this? the error message i get is

Code: Select all

DB function failed with error number 1054
Unknown column 'on_court' in 'field list' SQL=INSERT INTO `jos_ad_fields` ( `adfield_id`,`adfield_ad_id`,`field_gender`,`field_aboutme`,`field_mobile_low`,`field_mobile_high`,`field_landphone_low`,`field_landphone_high`,`field_address`,`field_state`,`field_city`,`tennis_level`,`i_am_a_low`,`i_am_a_high`,`my_game`,`on_court`,`my_style`,`post_code`,`field_country` ) VALUES ( '','11','Male','','','','','','','','','None','','','Beginner','Lobber','Right Handed','','Australia' )
thanks much in advance