K2 Items disappear

: Category: Joomla; 27 August 2010; Hits: 64339

Basically you've woken up this morning, visited your website, and all your K2 articles are gone !!!!

If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error:

copy raw

Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 80

Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 80

If I went to K2 Comments, I'd get an additional error:

copy raw

Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 80

Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/comments/tmpl/default.php on line 145

Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 80
Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/comments/tmpl/default.php on line 145

So I checked these pages and the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error:

copy raw

#145 - Table './jos_k2_items' is marked as crashed and should be repaired

#145 - Table './jos_k2_items' is marked as crashed and should be repaired

The Quick Fix

I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab

Type the following query:

copy raw

REPAIR TABLE jos_k2_items

REPAIR TABLE jos_k2_items

Note that I say "jos_k2_items" because by default that's what it is... If you changed the table prefix when you installed Joomla! on your site (default is "jos_") then you'll need to change this repair table command to match the database table where your K2 articles are stored (eg. "zu1fq_k2_items").

Category: Joomla :: Article: 277

Comments

Not rated

newseason

10 years ago

Thank you. You saved my day

Reply | Reply with quote | Quote

Larry Coonrod

11 years ago

The fix works great, but the problem is occurring a couple of times a day.

Any idea how to fix permantely?

Hans12

12 years ago

I would hug you if i could! Thank you so much!

abdul paksc

Thanks you works perfect!

Mohamad Zahedi

13 years ago

It was a nightmare!
Thanks thanks many thanks!
Bests

Jorge Torres

Thank you very much, you saved me!

Bhavik Shah

awesome bussy....it was not able to figure it out how to solve this i restored it two times from my cpanel but all was waste thn i came across your blog from google and the problem solved with just one line query..

Jose Luis

You are a genius! u save my life! Thanks

bryan

hello, i have the same problem but it is still not fixed
the SQL says msg_text is OK
i can't figure out what wrong?
Please help me~

View replies

WebmasterLegacy

Hi Bryan,

If you can send me a link or screenshot I can check for you but msg_text does not necessarily indicate a problem with your K2 setup. From memory, this is a joomla variable but I'll wait to hear from you before suggesting anything.

Kind Regards,

Joe

Andrew Crossan

Masterful!!! One of the best fastest absolute fixes I've ever had to do.

Rachel Hart

You are my hero!!!!!!!

abdul

You saved many days of work. Many many Thanks a lot.

Kelly Langston

THANK YOU! You saved my day, and now I have time to work on my son's Science project...due tomorrow. Can you help with that too?

Seriously, I appreciate your time to post the resolution. Bless you!

tomoceus

14 years ago

You saved many days of work for me. Thanks a lot.

TazoChai

Thanks for this awesome info here.

Nuno

Over a 1000 K2 items disappeared after 5 hours installing virtuemart!

Thanks man, this post saved my site.
God bless you!

Emax

Thanks man, works perfect!

Joe Johnson

Hey, thanks buddy! This saved me a lot of time... Thanks again.

Viktor

15 years ago

Thanks. Your solution run 100% perfect, I probe the sql sentence and "voila" all structure table and items were restore.

Thaks again.

anon e guy

Thank you, sir! Regular "repair table" command wasn't available due to the table being crashed - your fix saved my day (week, month?)

george

Thanks man u saved me from hell it worked perfect like magic

Joey

you my friend are LIFE SAVER.. Question, I am an artist and dabble in developing so fixes like these are truly worth there weight in gold. But why did this occur? It happened just like you stated, I made some updates last night and this morning, POOF they were all gone! First time this has happened, just trying to understand the why. Again, thanks a bunch

Hi Joey,

I recreated this error by overloading a Joomla! CMS website with extensions that I've installed and uninstalled. Basically a lot of third party extensions (especially modules) do not have uninstall scripts, so my database had more tables that were no longer used than ones I was actually using.

I think basically, it's too much for your server to handle in terms of having to read a huge database file so housekeeping is key.

I thought I didn't have much installed when it happened to my site; but both my K2 and Remository (=download manager extension) had crashed. And that was only with about 100 downloads of a Joomla! module I had written. Everything that you install will each send several queries to your servers and the database, too many in fact.

Overloading the server was my issue. This isn't saying that this is what caused your error or that K2 are excess code. All I can do is say what happened to me and what fixed it. There are reports that it keeps happening to people but I'm lucky so far.

Glad this got your K2 articles back :c) Happy to help.

Refresh comments list

K2 Items disappear

The Quick Fix

Comments

Add comment

Credit where Credit is Due:

Latest Articles

Accreditation

Donate & Support

Joes Word Cloud