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.
buurdi
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 25, 2007 7:35 am

DB function failed with error number 1194

Post by buurdi » Sat Oct 20, 2007 12:18 pm

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?

User avatar
ircmaxell
Joomla! Ace
Joomla! Ace
Posts: 1926
Joined: Thu Nov 10, 2005 3:10 am
Location: New Jersey, USA
Contact:

Re: DB function failed with error number 1194

Post by ircmaxell » Sat Oct 20, 2007 12:25 pm

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"
Anthony Ferrara - Core Team - Development Coordinator - Bug Squad - JSST

http://moovum.com/ - The Bird is in the air! Get Mollom Anti-Spam on your Joomla! website with Moovur...
http://www.joomlaperformance.com For All Your Joomla Performance Needs

buurdi
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 25, 2007 7:35 am

Re: DB function failed with error number 1194

Post by buurdi » Sat Oct 20, 2007 1:12 pm

Thank you so much !! :D

User avatar
ircmaxell
Joomla! Ace
Joomla! Ace
Posts: 1926
Joined: Thu Nov 10, 2005 3:10 am
Location: New Jersey, USA
Contact:

Re: DB function failed with error number 1194

Post by ircmaxell » Sat Oct 20, 2007 3:30 pm

No problem... Glad I could be of help...
Anthony Ferrara - Core Team - Development Coordinator - Bug Squad - JSST

http://moovum.com/ - The Bird is in the air! Get Mollom Anti-Spam on your Joomla! website with Moovur...
http://www.joomlaperformance.com For All Your Joomla Performance Needs

User avatar
kalalee
Joomla! Apprentice
Joomla! Apprentice
Posts: 23
Joined: Fri Oct 06, 2006 1:09 pm

Re: DB function failed with error number 1194

Post by kalalee » Mon Oct 22, 2007 10:19 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Jan 02, 2008 2:25 am

Re: DB function failed with error number 1194

Post by snowman03 » Sat Jun 14, 2008 5:13 pm

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

pwdsoft
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Mon Apr 28, 2008 6:16 pm
Contact:

Re: DB function failed with error number 1194

Post by pwdsoft » Sat Aug 16, 2008 6:06 pm

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
Thanks
pwdsoft
Website Design Development and Promotion
http://www.php-web-development.com

pedram
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Sun Feb 19, 2006 9:22 pm

Re: DB function failed with error number 1194

Post by pedram » Fri Sep 05, 2008 8:37 am

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Nov 04, 2008 3:31 am

Re: DB function failed with error number 1194

Post by mhshohag » Sun Nov 23, 2008 1:36 pm

hello sir
thank you

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

studio22
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Nov 28, 2008 2:42 am

Re: DB function failed with error number 1194

Post by studio22 » Wed Dec 03, 2008 12:59 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Thu Oct 02, 2008 10:55 pm

Re: DB function failed with error number 1194

Post by danielransom » Sun Jan 04, 2009 3:20 pm

life saving thread :)

LonePeach
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sat Feb 21, 2009 11:04 pm

Re: DB function failed with error number 1194

Post by LonePeach » Sat Feb 21, 2009 11:24 pm

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
Joomla! Intern
Joomla! Intern
Posts: 72
Joined: Thu Dec 11, 2008 3:00 pm
Location: Ontario, Canada
Contact:

Re: DB function failed with error number 1194

Post by Picasso Fish » Fri May 15, 2009 1:47 pm

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.
Picasso Fish Corporation - Experts in Joomla!, Web, Print, Design and Marketing.
picassofish.com - There's an Ocean of Opportunities... Swim to the Top with Picasso Fish.

User avatar
dibyadel
Joomla! Apprentice
Joomla! Apprentice
Posts: 23
Joined: Thu Jun 18, 2009 10:44 am
Location: new delhi
Contact:

Re: DB function failed with error number 1194

Post by dibyadel » Thu Jun 25, 2009 7:02 am

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
New Delhi, India

User avatar
dibyadel
Joomla! Apprentice
Joomla! Apprentice
Posts: 23
Joined: Thu Jun 18, 2009 10:44 am
Location: new delhi
Contact:

Re: DB function failed with error number 1194

Post by dibyadel » Thu Jun 25, 2009 7:07 am

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.
New Delhi, India

protun
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Wed Mar 11, 2009 10:40 am
Contact:

Re: DB function failed with error number 1194

Post by protun » Tue Sep 08, 2009 11:06 pm

oh ircmaxell you are my hero.
thankssss
Only exact URLs allowed in signature. Please read Forum Rules: http://forum.joomla.org/viewtopic.php?f=8&t=65

User avatar
adi_2009
Joomla! Intern
Joomla! Intern
Posts: 74
Joined: Sun Apr 12, 2009 8:46 pm

Re: DB function failed with error number 1194

Post by adi_2009 » Sat Jan 09, 2010 2:52 pm

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! :)

AROMAZLA
Joomla! Intern
Joomla! Intern
Posts: 95
Joined: Sun Apr 09, 2006 4:03 pm

Re: DB function failed with error number 1194

Post by AROMAZLA » Mon Feb 01, 2010 9:44 pm

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!

User avatar
TomT
Joomla! Ace
Joomla! Ace
Posts: 1270
Joined: Thu Aug 18, 2005 5:50 am
Location: Amsterdam
Contact:

Re: DB function failed with error number 1194

Post by TomT » Wed May 05, 2010 2:35 pm

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 :)

SpydrSS
Joomla! Apprentice
Joomla! Apprentice
Posts: 43
Joined: Tue Jul 10, 2007 8:20 am

Re: DB function failed with error number 1194

Post by SpydrSS » Tue May 11, 2010 1:43 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Tue Sep 20, 2005 7:23 pm

Re: DB function failed with error number 1194

Post by Letterhead » Sun May 16, 2010 11:02 am

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Jun 09, 2010 11:37 pm

Re: DB function failed with error number 1194

Post by dknoll » Wed Jun 09, 2010 11:41 pm

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

tinflute
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Feb 26, 2010 6:24 pm

Re: DB function failed with error number 1194

Post by tinflute » Tue Jun 22, 2010 12:16 am

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

JesuSlaveX
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Tue May 02, 2006 12:06 pm

Re: DB function failed with error number 1194

Post by JesuSlaveX » Tue Jul 06, 2010 2:02 pm

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

pergrammo
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Aug 18, 2010 7:50 am

Re: DB function failed with error number 1194

Post by pergrammo » Wed Aug 18, 2010 7:59 am

Thank you verymuch Mannn.. this solv is great :D

alysbeach
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Aug 11, 2010 7:14 pm

Re: DB function failed with error number 1194

Post by alysbeach » Tue Sep 07, 2010 3:02 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 18
Joined: Tue Jun 23, 2009 2:40 am

Re: DB function failed with error number 1194

Post by yubi » Wed Dec 22, 2010 3:52 pm

thanks soooo much ircmaxell...!!! :)

DonCorleo
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Sat Mar 25, 2006 10:21 pm

Re: DB function failed with error number 1194

Post by DonCorleo » Thu Jan 20, 2011 8:31 am

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Dec 23, 2008 2:55 pm

Re: DB function failed with error number 1194

Post by poliboy7 » Wed Feb 16, 2011 4:31 pm

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

User avatar
allen012087
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 103
Joined: Wed Feb 23, 2011 4:21 am
Location: Coimbatore, India
Contact:

Re: DB function failed with error number 1194

Post by allen012087 » Fri Jun 03, 2011 9:08 am

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


Locked

Return to “Performance - 1.0.x”