DB function failed with error number 1194

[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?

[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"

[buurdi]

Thank you so much !!

[ircmaxell]

No problem... Glad I could be of help...

[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.

[snowman03]

Thank You! Again, My life was saved with this information!

[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

[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

[mhshohag]

hello sir
thank you

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

[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' )

[danielransom]

life saving thread

[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!

[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.

[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

[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.

[protun]

oh ircmaxell you are my hero.
thankssss

[adi_2009]

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!

[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!

[TomT]

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

[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.

[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.

[dknoll]

Thanks all. I was optimistic until my repair using this method failed. Next step?

[tinflute]

3 years later, ircmaxell's advice worked like a charm.
props

[JesuSlaveX]

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!

[pergrammo]

Thank you verymuch Mannn.. this solv is great

[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

[yubi]

thanks soooo much ircmaxell...!!!

[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?

[poliboy7]

thank you so much ircmaxell i just had the same probleme and you give me the way to resolve it

[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