Post Indexer Stopped Running / Mysql Errors

Hello. Post indexer previously worked but not any longer. Have dropped all wp_network related tables and related per previous threads. Site 9 is indexable, most others are not ...

Here is Post Indexer cron and error log is attached:

Post Indexer First Pass (30611)
Finished processing 2015-05-01 17:17:47
Post Indexer First Pass (30611)
Processing 0 queued items. 2015-05-01 17:17:47
Post Indexer First Pass (30611)
Initializing... 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Finished processing 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Blog: 18, is NOT indexable - removing from queue. 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Blog: 16, is NOT indexable - removing from queue. 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Blog: 15, is NOT indexable - removing from queue. 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Blog: 14, is NOT indexable - removing from queue. 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Blog: 9, Highest Post ID is 1016 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Blog: 9, is indexable. 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Blog: 4, is NOT indexable - removing from queue. 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Blog: 1, is NOT indexable - removing from queue. 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Processing 7 queued items. 2015-05-01 17:17:47
Post Indexer First Pass (30606)
Initializing... 2015-05-01 17:17:47
Post Indexer Second Pass (30145)
Finished processing 2015-05-01 17:16:16
Post Indexer Second Pass (30145)
Processing 0 queued items. 2015-05-01 17:16:16
Post Indexer Second Pass (30145)
Initializing...

    Trace

    Attachment didn't work, here's error log.... any way to add this without it being so long??? Ticks didn't work ....

    '[02-May-2015 00:14:08 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('680','0','0','1','2013-10-20 14:49:53','2013-10-20 19:49:53','\"Men, sometimes, become horse lovers, and ruin themselves thereby. Others give their lives up to their love of Automobiles. Still others sacrifice all for airplanes, or whisky or fine food, or old books, or art. Tracy Richardson, a real live young American, from Lamar, Missouri, is a victim of his love for the machine gun. You can play
    [02-May-2015 00:14:08 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('703','0','0','77','2013-10-21 15:37:13','2013-10-21 20:37:13','\"Wherever the cannon booms and the rifles bark, this American boy, who embodies in real life the type of moving picture hero one reads about but never sees, is pretty sure to turn up sooner or later -- and it is generally sooner. Along the Rio Grande he is known by thousands of the adventurous souls who populate that picturesque and v
    [02-May-2015 00:14:08 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('737','0','0','77','2013-12-11 23:53:35','2013-12-12 04:53:35','[gallery theme=\"photomosaic\"]\r\n\r\n<div style=\"text-align:center\">\r\nhttp://www.youtube.com/watch?v=znNmN6iQKJA\r\n\r\nhttp://www.youtube.com/watch?v=tNHHAJfyJYI\r\n\r\nhttp://www.youtube.com/watch?v=4U-9grX8eI8\r\n\r\nhttp://www.youtube.com/watch?v=ivSV97_glZU\r\n\r\nhttp://www.youtube.com/watch?v=6QijxRC9FZk\r\n\r\nhttp://www.
    [02-May-2015 00:14:08 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('956','0','0','77','2015-02-23 21:13:03','2015-02-23 21:13:03','[gallery theme=\"photomosaic\" ids=\"961,958,969,968,967,966,965,964,957,963,962,960,959\"]','Joshua Tree: February 2015','','publish','open','open','','joshua-tree-february-2015','','','2015-02-23 21:17:36','2015-02-23 21:17:36','','0','http://trace.alpinescience.com/?p=956','0','post','','0','9') ON DUPLICATE KEY UPDATE ID = VALUES
    [02-May-2015 00:14:08 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('976','0','0','77','2015-01-15 21:31:48','2015-01-15 21:31:48','[gallery theme=\"photomosaic\" ids=\"978,993,1002,991,986,987,992,1001,1008,997,980,982,981,1003,1012,1004,999,1006,1010,1000,983,985,1007,1009,995,1011,998,988,989,990,979,994,996,984,977,1005\"]','Drinking Ayahuasca in Peru: December 2014','','publish','open','open','','drinking-ayahuasca-in-peru-december-2014','','','2015-02-25 16:0
    [02-May-2015 00:06:37 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('680','0','0','1','2013-10-20 14:49:53','2013-10-20 19:49:53','\"Men, sometimes, become horse lovers, and ruin themselves thereby. Others give their lives up to their love of Automobiles. Still others sacrifice all for airplanes, or whisky or fine food, or old books, or art. Tracy Richardson, a real live young American, from Lamar, Missouri, is a victim of his love for the machine gun. You can play
    [02-May-2015 00:06:37 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('703','0','0','77','2013-10-21 15:37:13','2013-10-21 20:37:13','\"Wherever the cannon booms and the rifles bark, this American boy, who embodies in real life the type of moving picture hero one reads about but never sees, is pretty sure to turn up sooner or later -- and it is generally sooner. Along the Rio Grande he is known by thousands of the adventurous souls who populate that picturesque and v
    [02-May-2015 00:06:37 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('737','0','0','77','2013-12-11 23:53:35','2013-12-12 04:53:35','[gallery theme=\"photomosaic\"]\r\n\r\n<div style=\"text-align:center\">\r\nhttp://www.youtube.com/watch?v=znNmN6iQKJA\r\n\r\nhttp://www.youtube.com/watch?v=tNHHAJfyJYI\r\n\r\nhttp://www.youtube.com/watch?v=4U-9grX8eI8\r\n\r\nhttp://www.youtube.com/watch?v=ivSV97_glZU\r\n\r\nhttp://www.youtube.com/watch?v=6QijxRC9FZk\r\n\r\nhttp://www.
    [02-May-2015 00:06:37 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('956','0','0','77','2015-02-23 21:13:03','2015-02-23 21:13:03','[gallery theme=\"photomosaic\" ids=\"961,958,969,968,967,966,965,964,957,963,962,960,959\"]','Joshua Tree: February 2015','','publish','open','open','','joshua-tree-february-2015','','','2015-02-23 21:17:36','2015-02-23 21:17:36','','0','http://trace.alpinescience.com/?p=956','0','post','','0','9') ON DUPLICATE KEY UPDATE ID = VALUES
    [02-May-2015 00:06:37 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('976','0','0','77','2015-01-15 21:31:48','2015-01-15 21:31:48','[gallery theme=\"photomosaic\" ids=\"978,993,1002,991,986,987,992,1001,1008,997,980,982,981,1003,1012,1004,999,1006,1010,1000,983,985,1007,1009,995,1011,998,988,989,990,979,994,996,984,977,1005\"]','Drinking Ayahuasca in Peru: December 2014','','publish','open','open','','drinking-ayahuasca-in-peru-december-2014','','','2015-02-25 16:0
    [02-May-2015 00:01:01 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('680','0','0','1','2013-10-20 14:49:53','2013-10-20 19:49:53','\"Men, sometimes, become horse lovers, and ruin themselves thereby. Others give their lives up to their love of Automobiles. Still others sacrifice all for airplanes, or whisky or fine food, or old books, or art. Tracy Richardson, a real live young American, from Lamar, Missouri, is a victim of his love for the machine gun. You can play
    [02-May-2015 00:01:01 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('703','0','0','77','2013-10-21 15:37:13','2013-10-21 20:37:13','\"Wherever the cannon booms and the rifles bark, this American boy, who embodies in real life the type of moving picture hero one reads about but never sees, is pretty sure to turn up sooner or later -- and it is generally sooner. Along the Rio Grande he is known by thousands of the adventurous souls who populate that picturesque and v
    [02-May-2015 00:01:01 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('737','0','0','77','2013-12-11 23:53:35','2013-12-12 04:53:35','[gallery theme=\"photomosaic\"]\r\n\r\n<div style=\"text-align:center\">\r\nhttp://www.youtube.com/watch?v=znNmN6iQKJA\r\n\r\nhttp://www.youtube.com/watch?v=tNHHAJfyJYI\r\n\r\nhttp://www.youtube.com/watch?v=4U-9grX8eI8\r\n\r\nhttp://www.youtube.com/watch?v=ivSV97_glZU\r\n\r\nhttp://www.youtube.com/watch?v=6QijxRC9FZk\r\n\r\nhttp://www.
    [02-May-2015 00:01:01 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('956','0','0','77','2015-02-23 21:13:03','2015-02-23 21:13:03','[gallery theme=\"photomosaic\" ids=\"961,958,969,968,967,966,965,964,957,963,962,960,959\"]','Joshua Tree: February 2015','','publish','open','open','','joshua-tree-february-2015','','','2015-02-23 21:17:36','2015-02-23 21:17:36','','0','http://trace.alpinescience.com/?p=956','0','post','','0','9') ON DUPLICATE KEY UPDATE ID = VALUES
    [02-May-2015 00:01:01 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('976','0','0','77','2015-01-15 21:31:48','2015-01-15 21:31:48','[gallery theme=\"photomosaic\" ids=\"978,993,1002,991,986,987,992,1001,1008,997,980,982,981,1003,1012,1004,999,1006,1010,1000,983,985,1007,1009,995,1011,998,988,989,990,979,994,996,984,977,1005\"]','Drinking Ayahuasca in Peru: December 2014','','publish','open','open','','drinking-ayahuasca-in-peru-december-2014','','','2015-02-25 16:0
    [01-May-2015 23:44:38 UTC] WordPress database error Table 'alpinesc_slopes.wp_terms' doesn't exist for query SELECT t.*, tt.* 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 ('featured_item_tag') AND tr.object_id IN (697) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/page-blank.php'), get_header, locate_template, load_template, require_once('/themes/flatsome/header.php'), body_class, get_body_class, apply_filters('body_class'), call_user_func_array, Featured_Item_Post_Type->add_body_classes, get_the_terms, wp_get_object_terms
    [01-May-2015 23:44:38 UTC] WordPress database error Table 'alpinesc_slopes.wp_term_taxonomy' doesn't exist for query SELECT t.*, tt.* 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 ('post_tag') AND tr.object_id IN (697) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/page-blank.php'), get_header, do_action('get_header'), call_user_func_array, Woo_Conditions->get_conditions, Woo_Conditions->determine_conditions, Woo_Conditions->is_hierarchy, get_the_tags, get_the_terms, wp_get_object_terms
    made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/page-blank.php'), the_content, apply_filters('the_content'), call_user_func_array, blcPostTypeOverlord->hook_the_content
    AND parser_type = 'link'
    AND links.broken = 1
    AND instances.container_id = 697
    instances.container_type = 'page'
    WHERE
    ON instances.link_id = links.link_id
    FROM wp_blc_instances AS instances JOIN wp_blc_links AS links
    SELECT instances.raw_url
    [01-May-2015 23:44:27 UTC] WordPress database error Table 'alpinesc_slopes.wp_blc_links' doesn't exist for query
    [01-May-2015 23:36:55 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('80','0','0','1','2009-07-16 14:36:47','2009-07-16 20:36:47','I\'m finally getting some desperately needed downtime! Come meet a pup named Hollywood!\n\nhttp://www.youtube.com/watch?feature=player_embedded&v=vhIgOSjcmHw','Summer Vacation in Crested Butte, CO','','publish','closed','open','','summer-vacation-in-crested-butte-co','','','2009-07-16 14:36:47','2009-07-16 20:36:47','','0','http://tr
    [01-May-2015 23:36:55 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTO wp_network_posts (ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('86','0','0','1','2009-08-03 16:07:19','2009-08-03 22:07:19','[gallery theme=\"photomosaic\"]\n\n','Damn, I Miss These Guys','','publish','closed','open','','damn-i-miss-these-guys','','','2009-08-03 16:07:19','2009-08-03 22:07:19','','0','http://tracedef.com/?p=86','0','post','','0','9') ON DUPLICATE KEY UPDATE ID = VALUES(ID),forum_id = VALUES(forum_id),thread_id = VALUES(thread_id),`'

    Tyler Postle

    Hey Trace,

    Hope you're doing well today!

    You dropped the wp_network tables from your database? I'm a little confused on that part. If you could link to where you saw that then I should get a better idea of what is happening

    I've tested this on my install and it's still working correctly for me.

    Would you be able to grant support access? Then I can take a closer look at your settings.

    You can grant support access via admin dashboard - WPMU DEV > Support > Support Access > Grant Access.

    Look forward to hearing back!

    PS. You should be able to attach the log as a .txt file too, that would probably work best.

    Tyler Postle

    Hey Trace,

    Network tables have a lot more data than just posts, which is why I'm a little shocked that would be suggested. Do you have a backup of your database before deleting those tables? I would restore back to that, then we can start from there - that way we know whether the issue was to do with tables or not. The issue you're getting above I'm thinking is because of removing the tables. I can get one of our developers in on this too if needed.

    Talk to you soon! Hope you had a great weekend

    All the best,
    Tyler

    Tyler Postle

    Hey Trace,

    Thanks for the quick reply. Yes I'll flag one of our devs on this to take a look. See if they can make any sense of it. Would you be able to send in your cPanel so we have access to your current db? Just in-case they need access to that it will speed things up up to you though, if needed then you could always just export the db and send us that instead.

    If you don't mind sending in cPanel then you can send that privately to me through our contact form: https://premium.wpmudev.org/contact/

    Select "I have a different question" for your topic - this and the subject line ensure that it gets assigned to me

    Send in:

    Subject: "Attn: Tyler Postle"
    -cpanel(login url/username/password)
    -link back to this thread for reference
    -any other relevant urls

    If you could extend the support access that would be helpful too, then we won't have to ask for an extension later on. Either myself or the developer will respond back here after they have taken a look.

    Sorry for the earlier delay.

    Talk to you soon!

    Cheers,
    Tyler

    Tyler Postle

    Hey Trace,

    I spoke to the developer and as for your errors above, it looks like you were trying to index the bbpress, as the error occurred with the forum_id column. I can see now that you only have "posts" in the field for indexing though so that error shouldn't happen again.

    The reason your other sites aren't being indexed is because via:

    Network admin > Sites. Only one of your sites in selected to index, I've also just enabled another one too illustrate - as seen in my screenshot. If you enable them all then they should all index again.

    Something else I noticed is that most of your sites the posts are quite old, it won't index the same post again - are those posts already in your wp_network_posts table? If so then that should be all fine and working as expected

    If the posts aren't there, even after re-enabling the sites again and letting them process then let us know and we can take another look.

    All the best,
    Tyler

    Trace

    Hi. We've never had BBPress installed and have never made any changes to what is indexed, Post has always been the only type to be indexed as that is the default. I've enabled a second site but the other sites are demos or test sites with duplicate content ..... so we don't want to index those. Previously indexer worked on this site with only one site being turned on for indexing, fwiw ....

    I've attached error log and you can view a page that should have the posts in them from post indexer in them ... they are missing from the bottom of the page, sidebar and footer ... http://bit.ly/1JkJoYV

    Tyler Postle

    Hey Trace,

    Thanks for your reply. Sorry for enabling it for one of your test sites there, I should have asked first.

    Been discussing this further with the developer and it's tough to say without more background info on the issue, but based on the error it could be that the plugin didn't update correctly. Any chance you remember which version did you update from? Was it a really old one?

    If it wasn't an old version, then have you done a full plugin conflict check already too? I know WP Optimize makes changes to the DB. Deactivating it won't reverse those changes in most cases but it's still worth trying just so we can narrow down the possible causes for this issue.

    Soon as we find the cause of the issue then we can get it all fixed up for ya

    Cheers,
    Tyler

    Tyler Postle

    Hey Trace,

    Thanks for the reply, okay so it's likely not the update that caused the issue. Thanks for doing that plugin test. I'm still leaning towards it being wp optimize as the db changes it can make wouldn't be reversed when it's deactivated, but let us know how the full plugin conflict test went too.

    Do you remember at all if the issue started happening when wp optimize was installed?

    I have wp optimize installed and will try to reproduce the issue on my install, first just want to make sure I am using the same settings as you are before I process it.

    Sorry to ask, but can you re-grant support access? It's expired from earlier.

    You can grant support access via admin dashboard - WPMU DEV > Support > Support Access > Grant Access.

    Look forward to hearing back.

    Cheers,
    Tyler

    Trace

    What specific changes are you referring to wp optimize making, I'm not aware of any changes that it makes that should affect anything negatively ... fwiw.... all it does is remove transients, post revisions, etc. nothing significant that I'm aware of.

    I actually don't believe we've even ever ran wp optimize, to be honest ...

    Access granted ...

    It looks like the dev's interpretation of the error log is the only thing that is going to provide any clues ... I suspect we will need to change or drop some tables, can you check again please? I don't think there's much that can be done from WP dashboard at this point as I've exhausted every dashboard level option I can think of unless you have something else to offer.

    Jack Kitterhing

    Hiya @Trace,

    Hope you're well today, I'm the dev of Post indexer, I've been taking a look at this and your error log and it's definitely related to this:

    [04-May-2015 13:00:52 UTC] WordPress database error Unknown column 'forum_id' in 'field list' for query INSERT INTOwp_network_posts(ID,forum_id,thread_id,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count,BLOG_ID) VALUES ('570','0','0','1','2013-10-19 22:32:30','2013-10-20 03:32:30','[gallery theme=\"photomosaic\"]','Kauai: October 2013','','publish','open','open','','kauai-october-2013','','','2013-10-19 22:32:30','2013-10-20 03:32:30','','0','http://tracedef.com/?p=570','0','post','','0','9') ON DUPLICATE KEY UPDATEID= VALUES(ID),forum_id= VALUES(forum_id),thread_id= VALUES(thread_id),post_author`
    `

    wp_network_posts is a post indexer table, it's basically locking up the process when it fails because the columns don't exist for thread_id and forum_id, do you by any chance have BuddyPress installed?

    Would it be possible for you to send me database, wp-admin and FTP, so I can get a closer look here and fix this for you?

    If that's okay, please send it through our contact form:

    Can you please send in:

    - In the subject field add "Attn: Jack Kitterhing"
    - Link back to this thread
    - Include admin/network access
    - Include FTP
    - Include any relevant URLS for your site

    On the contact form, select "I have a different question", this ensures it comes through and gets assigned to me.

    https://premium.wpmudev.org/contact/

    Look forward to hearing from you.

    Thanks!

    Kind Regards
    Jack.