These are there errors i am getting from the error log for wordpress
[28-Jun-2013 11:18:38 UTC] PHP Warning: Parameter 1 to ec3_filter_posts_where() expected to be a reference, value given in /home/djroouk1/public_html/wp-includes/plugin.php on line 230
[28-Jun-2013 11:18:38 UTC] PHP Warning: Parameter 1 to ec3_filter_posts_join() expected to be a reference, value given in /home/djroouk1/public_html/wp-includes/plugin.php on line 230
[28-Jun-2013 11:18:38 UTC] PHP Warning: Parameter 1 to ec3_filter_posts_groupby() expected to be a reference, value given in /home/djroouk1/public_html/wp-includes/plugin.php on line 230
[28-Jun-2013 11:18:38 UTC] PHP Warning: Parameter 1 to ec3_filter_posts_orderby() expected to be a reference, value given in /home/djroouk1/public_html/wp-includes/plugin.php on line 230
[28-Jun-2013 11:18:38 UTC] PHP Warning: Parameter 1 to ec3_filter_posts_fields() expected to be a reference, value given in /home/djroouk1/public_html/wp-includes/plugin.php on line 230
[28-Jun-2013 11:18:38 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘FROM wp_posts WHERE 1=1’ at line 1 for query SELECT FROM wp_posts WHERE 1=1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
Can anyone tell me how i fix this this has been happening from June last year until now? If php or Mysql has been upgraded would this cause the issue?
Thanks
Rockyuk
Have you ever tried repairing your database tables?
Using Phpmyadmin or whatever database management tool your host provides.
Ok once in there is there a repair tool within PHPmyadmin?
Yes. Under the Operations tab – although the exact location is dependant upon what version of Phpmyadmin your hosts are running.
Ok tried the database repair but no joy i am afraid this is what i get when i try to post or locate posts!
http://s9.postimg.org/qkuzzjyrf/screendump_of_wordpress.jpg
That image is too small to see anything…
Do you have a recent database backup?
I’m afraid it’s possible that your database is trashed. 🙁
Have a look using phpMyAdim in the wp_posts table … are there entries in there? It’s getting that “All (5) Published (5)” from somewhere 🙂
Agreed but a WordPress database is filled with relational tables. All it takes is for one of these tables to be damaged and WordPress stops working effectively.