Database Errors, how can I fix these?

  • Ryder

    (@hyflex)


    10 years, 6 months ago

    My wordpress get’s errors like this all the time, these are the errors from the last two days.

    [01-Oct-2013 19:17:37 UTC] WordPress database error Got error -1 from storage engine for query SELECT t.*, tt.* FROM wpl_terms AS t INNER JOIN wpl_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wpl_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (3110) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/rtr/single.php'), include('/themes/rtr/blog-sidebar.php'), wpp_get_mostpopular, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, WordPressPopularPosts->wpp_shortcode, WordPressPopularPosts->get_popular_posts, get_permalink, get_the_category, get_the_terms, wp_get_object_terms
[01-Oct-2013 19:17:38 UTC] WordPress database error Got error -1 from storage engine for query SELECT t.*, tt.* FROM wpl_terms AS t INNER JOIN wpl_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wpl_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (3016) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/rtr/single.php'), include('/themes/rtr/blog-sidebar.php'), wpp_get_mostpopular, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, WordPressPopularPosts->wpp_shortcode, WordPressPopularPosts->get_popular_posts, get_permalink, get_the_category, get_the_terms, wp_get_object_terms
[01-Oct-2013 19:17:38 UTC] WordPress database error Got error -1 from storage engine for query SELECT t.*, tt.* FROM wpl_terms AS t INNER JOIN wpl_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wpl_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (2867) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/rtr/single.php'), include('/themes/rtr/blog-sidebar.php'), wpp_get_mostpopular, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, WordPressPopularPosts->wpp_shortcode, WordPressPopularPosts->get_popular_posts, get_permalink, get_the_category, get_the_terms, wp_get_object_terms
[01-Oct-2013 19:17:38 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wpl_terms AS t INNER JOIN wpl_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wpl_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (2905) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/rtr/single.php'), include('/themes/rtr/blog-sidebar.php'), wpp_get_mostpopular, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, WordPressPopularPosts->wpp_shortcode, WordPressPopularPosts->get_popular_posts, get_permalink, get_the_category, get_the_terms, wp_get_object_terms
[01-Oct-2013 21:45:29 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.*, tr.object_id FROM wpl_terms AS t INNER JOIN wpl_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wpl_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (3328) ORDER BY t.name ASC made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, _prime_post_caches, update_post_caches, update_object_term_cache, wp_get_object_terms
[01-Oct-2013 22:17:54 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wpl_terms AS t INNER JOIN wpl_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wpl_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (110) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/rtr/page.php'), thematic_post_class, get_the_category, get_the_terms, wp_get_object_terms
[02-Oct-2013 00:12:35 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wpl_terms AS t INNER JOIN wpl_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wpl_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (5356) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/rtr/page.php'), thematic_post_class, get_the_category, get_the_terms, wp_get_object_terms
[02-Oct-2013 08:00:13 Europe/London] WordPress database error Got error -1 from storage engine for query SELECT  wpl_sftopics.forum_id, forum_name, forum_slug, forum_disabled, wpl_sftopics.topic_id, topic_name, topic_slug, topic_icon, topic_icon_new, wpl_sftopics.post_count,
								wpl_sftopics.post_id, post_status, post_index, post_date,
								guest_name, wpl_sfposts.user_id, post_content, display_name FROM wpl_sftopics JOIN wpl_sfforums ON wpl_sfforums.forum_id = wpl_sftopics.forum_id JOIN wpl_sfgroups ON wpl_sfgroups.group_id = wpl_sfforums.group_id JOIN wpl_sfposts ON wpl_sfposts.post_id = wpl_sftopics.post_id LEFT JOIN wpl_sfmembers ON wpl_sfmembers.user_id = wpl_sfposts.user_id WHERE wpl_sftopics.topic_id IN (378,374,372,371,367,335,334,333,332,323,326,330,329,22,328,327,325,324,322,321) ORDER BY group_seq, forum_seq, wpl_sftopics.post_id DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/rtr/page.php'), the_content, apply_filters('the_content'), call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include('/sp-resources/forum-themes/rtr/templates/spTopicView.php'), sp_load_template, include('/sp-resources/forum-themes/rtr/templates/spHead.php'), sp_QuickLinksTopic, spTopicList->__construct, spTopicList->sp_listview_query, spdbComplex->select, spdb_select

    Does anyone know how to fix these?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator t-p

    (@t-p)

    10 years, 6 months ago

    Try manually re-uploading all files and folders EXCEPT the wp-config.php file and the /wp-content/ directory from a fresh download of WordPress. Make sure that you delete the old copies of files & folder before uploading the new ones. Read the Manual Update directions first!

    Thread Starter Ryder

    (@hyflex)

    10 years, 6 months ago

    @tara

    The problem with that is the wordpress is 2~ years old and has A LOT of uploaded content…

    leejosepho

    (@leejosepho)

    10 years, 6 months ago

    all files and folders EXCEPT the wp-config.php file and the /wp-content/ directory

    You do not have to re-upload all the content you have mentioned, just everything other than that and wp-config.php (and after first deleting the things you *will* be uploading).
    note: Do *not* delete and re-upload wp-config.php or the wp-content folder (directory).

    Moderator t-p

    (@t-p)

    10 years, 6 months ago

    If possible, it’s always safe to update to the current version.

    But if that’s not possible at this time for some reason, you can find archives of your version here: http://wordpress.org/download/release-archive/

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database Errors, how can I fix these?’ is closed to new replies.