Keyword

[SOLVED] Error: No articles to display

  • Brett H. Pojunis
  • Brett H. Pojunis's Avatar Topic Author
  • Offline
  • New Member
More
10 years 10 months ago #113288 by Brett H. Pojunis
[SOLVED] Error: No articles to display was created by Brett H. Pojunis
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.

Please Log in or Create an account to join the conversation.

  • Brett H. Pojunis
  • Brett H. Pojunis's Avatar Topic Author
  • Offline
  • New Member
More
10 years 10 months ago #113289 by Brett H. Pojunis
Replied by Brett H. Pojunis on topic Re: Error: No articles to display
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 is helpful.

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #113290 by Peter Grube
Replied by Peter Grube on topic Re: Error: No articles to display
Well done Brett & thx for sharing your solution sure it will help others'

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum