No articles to display error in K2 in News Template

Rate this topic: Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.1.00 out of 6 based on 1 vote(s)
GK User
Mon May 20, 2013 3:31 am
Reply with quote
Report this post
I am getting some errors in K2. I would greatly appreciate some help

FRONT END ERRORS:
Error: No articles to display

DB function failed with error number 145
Table '/forum/libpost_joomla/tn5zh_k2_items' is marked as crashed and should be repaired SQL=SELECT COUNT(*) FROM tn5zh_k2_items WHERE YEAR(created)=2013 AND MONTH(created)=5 AND DAY(created)=1 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-20 02:23:42' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-20 02:23:42' ) AND trash=0 AND access IN(1,1) AND EXISTS(SELECT * FROM tn5zh_k2_categories WHERE id= tn5zh_k2_items.catid AND published=1 AND trash=0 AND access IN(1,1) )

Blogs + Columns:
Warning: Invalid argument supplied for foreach() in templates/gk_news/html/com_k2/templates/default/latest.php on line 102


ADMIN PANEL ERRORS:

Control Panel:
Warning: Invalid argument supplied for foreach() in administrator/modules/mod_k2_stats/tmpl/default.php on line 52

K2:
Warning: Invalid argument supplied for foreach() in administrator/components/com_k2/views/items/view.html.php on line 52

Warning: Invalid argument supplied for foreach() in libraries/joomla/database/database/mysql.php on line 383

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

Here is the current configuration:

Joomla! setup:
Joomla! 2.5.11
K2 Version 2.6.5
Gavick Pro Template NEWS
RSS Feed Aggregators - We need to select one:
Feedgator 2.3.6 (most recent version)
Ob Grabber - Alternative rss reader & more

System Information:
Web Server Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP version 5.3.19
MySQL version 5.1.68-cll

Please contact me should you have any ideas.
User avatar
Senior Boarder

GK User
Mon May 20, 2013 3:36 am
Reply with quote
Report this post
Can you please do following.

1. Go to Extensions > Extension Manager > Database.
If there are any errors, on top right click on fix.
2. Reinstall K2 Component. Download from http://getk2.org/

Let us know how you get on.

See you around...
User avatar
Platinum Boarder

GK User
Mon May 20, 2013 7:40 am
Reply with quote
Report this post
Hi NormanUK,

Actually, I got it to work! I logged into cpanel and then under MySQL Databases / modify Databases, I selected the database I am using for this instance of Joomla and clicked on "Repair DB" and it appears to be working fine!

I am backing everything up now and hopefully I can figure out what caused this.

I hope this was helpful.
User avatar
Senior Boarder

GK User
Mon May 20, 2013 7:57 am
Reply with quote
Report this post
Seems to be broken tables during a process or a task. Nevermind glad to hear you ve fixed it. Let us know if you need further help

See you around...
User avatar
Platinum Boarder


cron