- Posts: 3
COMMUNITY FORUM
[SOLVED] Error: No articles to display
- Brett H. Pojunis
-
Topic Author
- Offline
- New Member
Less
More
11 years 11 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.
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
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 3
11 years 11 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.
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.
- Peter Grube
-
- Offline
- Elite Member
Less
More
- Posts: 241
11 years 11 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.