Articles 
Web Development Joomla! CMS 3rd-party Joomla! K2 Items disappear
Web Development Joomla! CMS 3rd-party Joomla! K2 Items disappear
Friday, 27 August 2010 06:49
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:
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:
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:
#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. I have phpMyAdmin installed so I click on "jos_k2_items" table and then click on the SQL tab
Type the following query:
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 my repair table command to match the database table where your K2 articles are stored.
| < Prev |
|---|
