openid column in wp_comments table not created

[sairuh]

I installed rev24325 (trunk svn) of Will Norris' wp-openid plugin on my test site ( http://sairuh.org/) running WordPress 2.3.1, and found that errors display on my single post pages.

1. Deactivated previous version of wp-openid.
2. Installed rev24325, then activated it.
3. Go view site, clicked on a post heading to view single post page.

Results: Right above the posted comments I see the following error:

WordPress database error: [Unknown column 'openid' in 'where clause'] SELECT * FROM wp_comments WHERE comment_post_ID = '9' AND openid = 1 AND comment_author_url = ' http://sairuh.org' AND comment_author != 'sairuh' AND comment_approved = '0' ORDER BY comment_date

4. Fired up phpMyAdmin to browse the WordPress tables, and sure enough, there's no openid column in the wp_comments table.

This bug persists even if I deactivate and reactivate wp-openid several times.

[sairuh]

Couldn't figure out the precise cause of this, but somehow things resolved themselves after the following:

1. Change db table prefix in wp-config.php (eg, from wp_ to test_), reinstalled clean db tables, turned on only the openid plugin to test. Result: No more db error displayed; also, the openid column in wp_comments is created. (Note that this step may not have been necessary.)

2. Change back to using previous wp_ prefix (error comes back). Turn on debugging in openid plugin by changing 'warning' to 'debug' and reactivate plugin:

define ( 'WPOPENID_LOG_LEVEL', 'warning');

3. As expected, wp-content/uploads/php.log is created --although I didn't recognize info regarding the error while tailing the file. For some reason at this point, though, the errors stop appearing on the single post page. Mystery!

4. Change logging level back to 'warning' and reactivate plugin. Results: Still looks good, no more error as originally reported. Moreover, the openid column in wp_comments now exists.

[sairuh]

Addendum: Tested using trunk rev 24416 build.