WordPress database error for ”INSERT INTO ( blog_id, meta_key, meta_value ) VALUES”

[adrian7]

I checked the php error_log file on my website and stubled across a lot or lines like this:

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 '( blog_id, meta_key, meta_value ) VALUES ( 2420, 'last_activity', '2012-03-29 22' at line 1 for query INSERT INTO  ( blog_id, meta_key, meta_value ) VALUES ( 2420, 'last_activity', '2012-03-29 22:02:16' ) made by require, require_once, require_once, require_once, do_action, call_user_func_array, maybe_add_existing_user_to_blog, add_existing_user_to_blog, add_user_to_blog, do_action, call_user_func_array, bp_blogs_add_user_to_blog, bp_blogs_record_blog, bp_blogs_update_blogmeta

I remebed I just added an existing user from the network to an existing blog.

I am still on 1.5.4, but it might affect the latest 1.5.5 version.

I guess the function responsible for this is bp_blogs_update_blogmeta where there's the queries.

$wpdb->prepare( "INSERT INTO {$bp->blogs->table_name_blogmeta} ( blog_id, meta_key, meta_value ) VALUES ( %d, %s, %s )", $blog_id, $meta_key, $meta_value ) 

And update respectively.

So it seems the var $bp->blogs->table_name_blogmeta is empty at that point.

[DJPaul]

Do you have the Blogs component (site tracking) enabled on this site?

[adrian7]

Yes. Activated.

Well the user was added to the blog, with the role asssigned. But errors shows something got the wrong way...

[DJPaul]

We don't have this problem any more. I assume it was fixed in the last few years somewhere.