I put this up on FogBugz as an error report, but being the for-free user I am, I am not holidng my breath on receiving a response for it... So, I figured I would see if the few active users here on this forum would have an idea how to fix it!
I recently upgraded from Movable Type 4.3x to 5.01, following the appropriate instructions of deleting all relevant files and folders, and uploading the new folders onto a clean slate. The upgrade process went relatively seamlessly, and my blog is functioning about as it did before... with one notable exception.
On any of my posts, when writing a comment, the delay between pressing the "Submit" button and having the comment archive page refresh itself with the new comment has been exceeding four minutes on a regular basis (with a maximum of about six before my browser times out). If I click any other link on the webpage, and go back to the entry archive, the comment shows up as being posted. Likewise, almost immediately after pressing the "Submit" button, the comment shows up on my weblog's control panel. However, if I remain on the same page, the "Waiting for http://www.wallsofthecity.net/.../mtcomment.cgi" line remains at the bottom of my browser, and the progress bar just creeps along, for far longer than it ever did in the past (typically 0-5 seconds).
I am using Windows Vista 32-bit, IE8, Movable Type 5.01, and the following plugins: Autoban 1.2.3, Auto Smileys 0.9, TypePad AntiSpam 1.0, SmartyPants 1.5.1, and all three functions of SpamLookup. My base templates remain more-or-less unchanged, and the overall webpage is hosted at DreamHost. Feel free to try it yourself at www.wallsofthecity.net.
I have tried disabling all plugins, and that reduces the load time to about two minutes, but that still seems far longer than is appropriate, and significantly longer than 4.xx ever managed.
If you need further information or other specifics, please feel free to let me know. Below are some of the lines from the userstats log Movable Type can generate:
[Fri Feb 5 23:26:40 2010] thunder pt-times: pid=11095, uri=[/mt-comments.cgi?post=Submit&static=1&__lang=en&author=&bakecookie=1&entry_id=3388&email=&text=Time%20it%20now.%20%20&url=http%3A%2F%2Fwww.wallsofthecity.net], mem_start=, mem_end=91352, Total=77.98985
[Fri Feb 5 23:34:05 2010] thunder pt-times: pid=13510, uri=[/mt.cgi?magic_token=ukE191OSiTyAmS2qNml7ixHfx0pomx3s7yEu6xAO&itemset_action_input=&plugin_action_selector=0&_type=comment&return_args=__mode%3Dlist_comment%26blog_id%3D1&__mode=delete&action_name=&id=16380&blog_id=1], mem_start=, mem_end=94248, Total=84.03161
[Fri Feb 5 23:47:07 2010] thunder pt-times: pid=17246, uri=[/mt-comments.cgi?post=Submit&static=1&__lang=en&author=&bakecookie=1&entry_id=3388&email=&text=Testing.&url=http%3A%2F%2Fwww.wallsofthecity.net], mem_start=, mem_end=92152, Total=73.54368
Thank you for your time.
Reported on Movable Type 5
A couple of things to check.
Are you ping'ing externals sites to notify them of updates? MT has to wait for a response from each site it notifies, one bad site can slow stuff down.
Are you building things that don't need to be rebuilt?
Have you tried enabling debug mode? http://www.movabletype.org/documentation/appendices/config-directives/debugmode.html that should report any templates taking longer that 1/4 second to build.
Rob,
Thanks for the feedback! Up until now, MT was set up to ping the normal set of webpages (google.com, weblogs.com, and technorati.com), but turning that off does not appear to have affected the post-"Submit" refresh time. Likewise, I have turned of all plugins in the past, and reactivated them, and none of that seems to affect the refresh time.
Regarding rebuilding, so far as I know, I have not changed any templates or setups that would affect that kind of thing... not even sure where they would be found.
As for "debug mode", I activated it on setting 5, and the following Warning and Log Message showed up repeatedly at the Feedback Setting page, with times ranging from 0.5 seconds to over 1 second:
• Request completed in 1.103 seconds.
• QUERY: SELECT blog_id FROM mt_blog WHERE (blog_id = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_id, blog_allow_anon_comments, blog_allow_comment_html, blog_allow_commenter_regist, blog_allow_comments_default, blog_allow_pings, blog_allow_pings_default, blog_allow_reg_comments, blog_allow_unreg_comments, blog_archive_path, blog_archive_tmpl_category, blog_archive_tmpl_daily, blog_archive_tmpl_individual, blog_archive_tmpl_monthly, blog_archive_tmpl_weekly, blog_archive_type, blog_archive_type_preferred, blog_archive_url, blog_autodiscover_links, blog_autolink_urls, blog_basename_limit, blog_cc_license, blog_children_modified_on, blog_class, blog_convert_paras, blog_convert_paras_comments, blog_created_by, blog_created_on, blog_custom_dynamic_templates, blog_days_on_index, blog_description, blog_email_new_comments, blog_email_new_pings, blog_entries_on_index, blog_file_extension, blog_google_api_key, blog_internal_autodiscovery, blog_is_dynamic, blog_junk_folder_expiry, blog_junk_score_threshold, blog_language, blog_manual_approve_commenters, blog_moderate_pings, blog_moderate_unreg_comments, blog_modified_by, blog_modified_on, blog_mt_update_key, blog_name, blog_old_style_archive_links, blog_parent_id, blog_ping_blogs, blog_ping_google, blog_ping_others, blog_ping_technorati, blog_ping_weblogs, blog_remote_auth_token, blog_require_comment_emails, blog_sanitize_spec, blog_server_offset, blog_site_path, blog_site_url, blog_sort_order_comments, blog_sort_order_posts, blog_status_default, blog_theme_id, blog_use_comment_confirmation, blog_use_revision, blog_welcome_msg, blog_words_in_excerpt FROM mt_blog WHERE (blog_id IN (?)) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT author_id FROM mt_author WHERE (author_auth_type = ?) AND (author_name = ?) AND (author_type = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT author_id, author_api_password, author_auth_type, author_basename, author_can_create_blog, author_can_view_log, author_created_by, author_created_on, author_email, author_entry_prefs, author_external_id, author_hint, author_is_superuser, author_modified_by, author_modified_on, author_name, author_nickname, author_password, author_preferred_language, author_public_key, author_remote_auth_token, author_remote_auth_username, author_status, author_text_format, author_type, author_url, author_userpic_asset_id FROM mt_author WHERE (author_id IN (?)) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT session_id FROM mt_session WHERE (session_kind = ?) AND (session_id = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT session_id, session_data, session_duration, session_email, session_kind, session_name, session_start FROM mt_session WHERE (session_id IN (?)) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT permission_id FROM mt_permission WHERE (permission_author_id = ?) AND (permission_blog_id IN (?,?)) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT permission_id, permission_author_id, permission_blog_id, permission_blog_prefs, permission_created_by, permission_created_on, permission_entry_prefs, permission_modified_by, permission_modified_on, permission_page_prefs, permission_permissions, permission_restrictions, permission_role_mask, permission_template_prefs FROM mt_permission WHERE (permission_id IN (?,?)) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT permission_id FROM mt_permission WHERE (permission_author_id = ?) AND (permission_blog_id = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT author_id FROM mt_author WHERE (author_auth_type = ?) AND (author_name = ?) AND (author_type = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_id, blog_allow_anon_comments, blog_allow_comment_html, blog_allow_commenter_regist, blog_allow_comments_default, blog_allow_pings, blog_allow_pings_default, blog_allow_reg_comments, blog_allow_unreg_comments, blog_archive_path, blog_archive_tmpl_category, blog_archive_tmpl_daily, blog_archive_tmpl_individual, blog_archive_tmpl_monthly, blog_archive_tmpl_weekly, blog_archive_type, blog_archive_type_preferred, blog_archive_url, blog_autodiscover_links, blog_autolink_urls, blog_basename_limit, blog_cc_license, blog_children_modified_on, blog_class, blog_convert_paras, blog_convert_paras_comments, blog_created_by, blog_created_on, blog_custom_dynamic_templates, blog_days_on_index, blog_description, blog_email_new_comments, blog_email_new_pings, blog_entries_on_index, blog_file_extension, blog_google_api_key, blog_internal_autodiscovery, blog_is_dynamic, blog_junk_folder_expiry, blog_junk_score_threshold, blog_language, blog_manual_approve_commenters, blog_moderate_pings, blog_moderate_unreg_comments, blog_modified_by, blog_modified_on, blog_mt_update_key, blog_name, blog_old_style_archive_links, blog_parent_id, blog_ping_blogs, blog_ping_google, blog_ping_others, blog_ping_technorati, blog_ping_weblogs, blog_remote_auth_token, blog_require_comment_emails, blog_sanitize_spec, blog_server_offset, blog_site_path, blog_site_url, blog_sort_order_comments, blog_sort_order_posts, blog_status_default, blog_theme_id, blog_use_comment_confirmation, blog_use_revision, blog_welcome_msg, blog_words_in_excerpt FROM mt_blog WHERE (blog_id = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT author_id FROM mt_author WHERE (author_id = ?) AND (author_type = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT author_id FROM mt_author WHERE (author_id = ?) AND (author_type = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_meta_type FROM mt_blog_meta WHERE (blog_meta_blog_id = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_meta_blog_id, blog_meta_type FROM mt_blog_meta WHERE (blog_meta_blog_id = ?) AND (blog_meta_type = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_meta_blog_id, blog_meta_type, blog_meta_vchar, blog_meta_vchar_idx, blog_meta_vdatetime, blog_meta_vdatetime_idx, blog_meta_vinteger, blog_meta_vinteger_idx, blog_meta_vfloat, blog_meta_vfloat_idx, blog_meta_vblob, blog_meta_vclob FROM mt_blog_meta WHERE (blog_meta_blog_id = ?) AND (blog_meta_type = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_meta_blog_id, blog_meta_type FROM mt_blog_meta WHERE (blog_meta_type = ?) AND (blog_meta_blog_id = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_meta_blog_id, blog_meta_type, blog_meta_vchar, blog_meta_vchar_idx, blog_meta_vdatetime, blog_meta_vdatetime_idx, blog_meta_vinteger, blog_meta_vinteger_idx, blog_meta_vfloat, blog_meta_vfloat_idx, blog_meta_vblob, blog_meta_vclob FROM mt_blog_meta WHERE (blog_meta_blog_id = ?) AND (blog_meta_type = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT asset_id, asset_blog_id, asset_class, asset_created_by, asset_created_on, asset_description, asset_file_ext, asset_file_name, asset_file_path, asset_label, asset_mime_type, asset_modified_by, asset_modified_on, asset_parent, asset_url FROM mt_asset WHERE (asset_id = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT asset_meta_type FROM mt_asset_meta WHERE (asset_meta_asset_id = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT asset_meta_asset_id, asset_meta_type FROM mt_asset_meta WHERE (asset_meta_asset_id = ?) AND (asset_meta_type = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT asset_meta_asset_id, asset_meta_type, asset_meta_vchar, asset_meta_vchar_idx, asset_meta_vdatetime, asset_meta_vdatetime_idx, asset_meta_vinteger, asset_meta_vinteger_idx, asset_meta_vfloat, asset_meta_vfloat_idx, asset_meta_vblob, asset_meta_vclob FROM mt_asset_meta WHERE (asset_meta_asset_id = ?) AND (asset_meta_type = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT asset_meta_asset_id, asset_meta_type FROM mt_asset_meta WHERE (asset_meta_asset_id = ?) AND (asset_meta_type = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT asset_meta_asset_id, asset_meta_type, asset_meta_vchar, asset_meta_vchar_idx, asset_meta_vdatetime, asset_meta_vdatetime_idx, asset_meta_vinteger, asset_meta_vinteger_idx, asset_meta_vfloat, asset_meta_vfloat_idx, asset_meta_vblob, asset_meta_vclob FROM mt_asset_meta WHERE (asset_meta_asset_id = ?) AND (asset_meta_type = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_meta_blog_id, blog_meta_type FROM mt_blog_meta WHERE (blog_meta_type = ?) AND (blog_meta_blog_id = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_meta_blog_id, blog_meta_type, blog_meta_vchar, blog_meta_vchar_idx, blog_meta_vdatetime, blog_meta_vdatetime_idx, blog_meta_vinteger, blog_meta_vinteger_idx, blog_meta_vfloat, blog_meta_vfloat_idx, blog_meta_vblob, blog_meta_vclob FROM mt_blog_meta WHERE (blog_meta_blog_id = ?) AND (blog_meta_type = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT author_meta_type FROM mt_author_meta WHERE (author_meta_author_id = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT author_meta_author_id, author_meta_type FROM mt_author_meta WHERE (author_meta_author_id = ?) AND (author_meta_type = ?) at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT author_meta_author_id, author_meta_type, author_meta_vchar, author_meta_vchar_idx, author_meta_vdatetime, author_meta_vdatetime_idx, author_meta_vinteger, author_meta_vinteger_idx, author_meta_vfloat, author_meta_vfloat_idx, author_meta_vblob, author_meta_vclob FROM mt_author_meta WHERE (author_meta_author_id = ?) AND (author_meta_type = ?) LIMIT 1 at lib/MT/ObjectDriver/Driver/DBI.pm line 37.
• QUERY: SELECT blog_id, blog_allow_anon_comments, blog_allow_comment_html, blog_allow_commenter_regist, blog_allow_comments_default, blog_allow_pings, blog_allow_pings_default, blog_allow_reg_comments,
Now, personally, I cannot make heads or tails of that particular warning string, but maybe someone else can...
Hello Linoge... I'm experiencing similar problems, but only in entries with more than 200 comments. Had you solved this problem in any way?
Fortunately or unfortunately, I did find a solution, bjunior - I migrated my weblog to WordPress, and there has not been a single problem since. If MovableType doesnot want to work, there are other solutions out there, thankfully :), and the migration process was not *too* bad.