Anyone elsegetting alot of 505 errors on processing WP actions?

Seems like I am getting alot of 505 errors on a fresh install of BP. I've seen this happen on other installs too -- but figured it was because I was on a grid computing account. Now I see it on Private servers too.

Could the HTaccess mods be confusing the server?

  • JoseffB

    Here is the report from a 505 I just got.
    [Fri Dec 11 13:34:54 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_user_activity' doesn't exist for query SELECT COUNT(*) FROM wp_user_activity WHERE user_ID = '1' made by require, require_once, require_once, require_once, do_action, call_user_func_array, user_activity_init, user_activity_global_db_sync
    [Fri Dec 11 13:34:54 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_user_activity' doesn't exist for query UPDATE wp_user_activity SET last_active = '1260563694' WHERE user_ID = '1' made by require, require_once, require_once, require_once, do_action, call_user_func_array, user_activity_init, user_activity_global_db_sync
    [Fri Dec 11 13:34:54 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'housesoldiers.com/', '2009-12-11 20:34:54' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, reports_user_activity
    [Fri Dec 11 13:34:54 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_user_activity' doesn't exist for query SELECT COUNT(*) FROM wp_user_activity WHERE user_ID = '1' made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, user_activity_global_db_sync
    [Fri Dec 11 13:34:54 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_user_activity' doesn't exist for query UPDATE wp_user_activity SET last_active = '1260563694' WHERE user_ID = '1' made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, user_activity_global_db_sync
    [Fri Dec 11 13:34:56 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_user_activity' doesn't exist for query SELECT COUNT(*) FROM wp_user_activity WHERE user_ID = '1' made by require_once, require_once, do_action, call_user_func_array, user_activity_init, user_activity_global_db_sync
    [Fri Dec 11 13:34:56 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_user_activity' doesn't exist for query UPDATE wp_user_activity SET last_active = '1260563696' WHERE user_ID = '1' made by require_once, require_once, do_action, call_user_func_array, user_activity_init, user_activity_global_db_sync
    [Fri Dec 11 13:34:56 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_user_activity' doesn't exist for query SELECT COUNT(*) FROM wp_user_activity WHERE user_ID = '1' made by require_once, require_once, do_action, call_user_func_array, user_activity_init, user_activity_global_db_sync
    [Fri Dec 11 13:34:56 2009] [error] [client 65.217.231.6] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_user_activity' doesn't exist for query UPDATE wp_user_activity SET last_active = '1260563696' WHERE user_ID = '1' made by require_once, require_once, do_action, call_user_func_array, user_activity_init, user_activity_global_db_sync
    [Fri Dec 11 13:34:56 2009] [error] [client 65.217.231.6] mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.

  • JoseffB

    Now I have these error messages:
    [Sun Dec 13 12:18:12 2009] [error] [client 64.134.240.184] File does not exist: /var/chroot/home/content/j/o/s/joseffbhs/html/wp-content/themes/bp-fun/favicon.ico
    [Sun Dec 13 12:18:13 2009] [error] [client 64.134.240.184] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'housesoldiers.com/wp-content/themes/bp-fun/favicon.ico', '2009-12-13 19:18:13' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, reports_user_activity
    [Sun Dec 13 12:18:17 2009] [error] [client 64.134.240.184] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'housesoldiers.com/forums/', '2009-12-13 19:18:17' ) made by require, require_once, do_action, call_user_func_array, bp_core_do_catch_uri, load_template, require_once, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, reports_user_activity
    [Sun Dec 13 12:18:20 2009] [error] [client 64.134.240.184] File does not exist: /var/chroot/home/content/j/o/s/joseffbhs/html/wp-content/themes/bp-fun/_inc/images/item_list_back.gif
    [Sun Dec 13 12:18:20 2009] [error] [client 64.134.240.184] File does not exist: /var/chroot/home/content/j/o/s/joseffbhs/html/wp-content/themes/bp-fun/_inc/images/message_thread_back.gif
    [Sun Dec 13 12:18:20 2009] [error] [client 64.134.240.184] mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.
    [Sun Dec 13 12:18:22 2009] [error] [client 64.134.240.184] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'housesoldiers.com/wp-content/themes/bp-fun/_inc/images/item_list_back.gif', '2009-12-13 19:18:22' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, reports_user_activity
    [Sun Dec 13 12:18:22 2009] [error] [client 64.134.240.184] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'housesoldiers.com/wp-content/themes/bp-fun/_inc/images/message_thread_back.gif', '2009-12-13 19:18:22' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, reports_user_activity
    [Sun Dec 13 12:18:22 2009] [error] [client 64.134.240.184] mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.
    [Sun Dec 13 12:18:24 2009] [error] [client 64.134.240.184] File does not exist: /var/chroot/home/content/j/o/s/joseffbhs/html/wp-content/themes/bp-fun/_inc/images/item_list_back.gif
    [Sun Dec 13 12:18:24 2009] [error] [client 64.134.240.184] File does not exist: /var/chroot/home/content/j/o/s/joseffbhs/html/wp-content/themes/bp-fun/_inc/images/message_thread_back.gif
    [Sun Dec 13 12:18:25 2009] [error] [client 64.134.240.184] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'housesoldiers.com/wp-content/themes/bp-fun/_inc/images/item_list_back.gif', '2009-12-13 19:18:25' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, reports_user_activity
    [Sun Dec 13 12:18:25 2009] [error] [client 64.134.240.184] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'housesoldiers.com/wp-content/themes/bp-fun/_inc/images/message_thread_back.gif', '2009-12-13 19:18:25' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, reports_user_activity
    [Sun Dec 13 12:18:39 2009] [error] [client 64.134.240.184] FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'housesoldiers.com/', '2009-12-13 19:18:39' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, reports_user_activity
    [Sun Dec 13 12:18:42 2009] [error] [client 64.134.240.184] mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.
    [Sun Dec 13 12:18:43 2009] [error] [client 64.134.240.184] mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.

  • JoseffB

    I added the wp_reports table in MySQL but there was an error with:
    CREATE TABLE wp_reports_user_activity (
    active_ID bigint(20) unsigned NOT NULL auto_increment,
    user_ID bigint(35) NOT NULL default '0',
    location TEXT,
    date_time datetime NOT NULL default '0000-00-00 00:00:00,
    PRIMARY KEY (active_ID)
    ) ENGINE=InnoDB;

    CREATE TABLE wp_reports_blog_activity (
    active_ID bigint(20) unsigned NOT NULL auto_increment,
    blog_ID bigint(35) NOT NULL default '0',
    date_time datetime NOT NULL default '0000-00-00 00:00:00,
    PRIMARY KEY (active_ID)
    ) ENGINE=InnoDB;

    CREATE TABLE wp_reports_post_activity (
    active_ID bigint(20) unsigned NOT NULL auto_increment,
    blog_ID bigint(35) NOT NULL default '0',
    user_ID bigint(35) NOT NULL default '0',
    post_ID bigint(35) NOT NULL default '0',
    post_type VARCHAR(255),
    date_time datetime NOT NULL default '0000-00-00 00:00:00,
    PRIMARY KEY (active_ID)
    ) ENGINE=InnoDB;

    CREATE TABLE wp_reports_comment_activity (
    active_ID bigint(20) unsigned NOT NULL auto_increment,
    blog_ID bigint(35) NOT NULL default '0',
    user_ID bigint(35) default '0',
    user_email VARCHAR(255) default '0',
    comment_ID bigint(35) NOT NULL default '0',
    date_time datetime NOT NULL default '0000-00-00 00:00:00,
    PRIMARY KEY (active_ID)
    ) ENGINE=InnoDB;

    Look closely and you'll notice that the date_time default value needs a closing apostrophe to read:
    date_time datetime NOT NULL default '0000-00-00 00:00:00',

    added and it went through with no prob. I will review error logs in a bit and get back.

  • JoseffB

    OK getting this now:
    [Sun Dec 13 12:34:29 2009] [error] [client 64.134.240.184] mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.
    [Sun Dec 13 12:34:29 2009] [error] [client 64.134.240.184] mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.

    The above eror I read usually means a piece of software is looping. Any one seen this before?

    Also Logs seems to say that the bp_fun theme is missing two images.

    [Sun Dec 13 12:34:30 2009] [error] [client 64.134.240.184] File does not exist: /var/chroot/home/content/j/o/s/joseffbhs/html/wp-content/themes/bp-fun/_inc/images/message_thread_back.gif
    [Sun Dec 13 12:34:30 2009] [error] [client 64.134.240.184] File does not exist: /var/chroot/home/content/j/o/s/joseffbhs/html/wp-content/themes/bp-fun/_inc/images/item_list_back.gif

  • Andrew

    would have thought that was installed with the bp install.

    That's not a BP tables. It's a table for our User Activity plugin. The install.txt for that plugin states:

    "3) If the auto-install does not add the db table(s) for you then run the sql code in "sql.txt" on your wpmu db"

    I added the wp_reports table

    For some reason your setup isn't letting the plugins auto-create tables.

    Look closely and you'll notice that the date_time default value needs a closing apostrophe to read

    Thanks for pointing that out :slight_smile:

    The above eror I read usually means a piece of software is looping. Any one seen this before?

    What's the limit currently set to?

    Also Logs seems to say that the bp_fun theme is missing two images

    We'll look into that. For the time being just upload two 1px images as placeholders.

    Thanks,
    Andrew

  • JoseffB

    Newest error message is :
    FastCGI: server "/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: WordPress database error Table 'hssocial.wp_domain_mapping' doesn't exist for query SELECT domain FROM wp_domain_mapping WHERE blog_id = '1' ORDER BY id LIMIT 1 /* domain mapping */ made by require_once, require_once, do_action, call_user_func_array, domain_map->build_cookie

    Could the tables be getting deleted by something? THis wasnt there before was it?

  • JoseffB

    Seeing this eror in the logs:
    [Mon Dec 14 18:19:17 2009] [error] [client 74.72.126.233] FastCGI: server "/var/chroot/home/content/j/o/s/joseffbhs/html-x-httpd-php5" stderr: 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 '' at line 1 for query SELECT wp_1_posts.ID, post_title, post_name, post_date, COUNT(wp_1_comments.comment_post_ID) AS 'comment_total' FROM wp_1_posts LEFT JOIN wp_1_comments ON wp_1_posts.ID = wp_1_comments.comment_post_ID WHERE comment_approved = '1' AND post_date_gmt < '2009-12-15 01:19:17' AND post_status = 'publish' AND post_password = '' GROUP BY wp_1_comments.comment_post_ID ORDER BY comment_total DESC LIMIT made by require, require_once, do_action, call_user_func_array, bp_core_do_catch_uri, load_template, require_once, get_header, locate_template, load_template, require_once, load_template, require_once, dynamic_sidebar, call_user_func_array, custom_most_comment

    Also I've am checking if increasing the rewrite limit helps.

  • JoseffB

    this is weird. Indeed it looks like a comment related query -- but on every page view? Maybe it's a activity related thing.. hmm

    so I THINK i fixed the redirect max error by changeing my

    define('DOMAIN_CURRENT_SITE', 'housesoldiers.com' );

    to

    define('DOMAIN_CURRENT_SITE', $_SERVER['HTTP_HOST'] );

    This seems to work for other CMS having the same problem. I have to keep an eye out for what the side effects are though.