SQLSTATE[42S22]: Column not found:

i'm having the exact same problem, i am using the following modules;
advanced_help
amazon
auto_nodetitle
colorbox
computed_field
ctools
devel
email
entity
features
feeds
google_analytics
imagecache_profiles
job_scheduler
logintoboggan
nodereference_url
pathauto
privatemsg
references
rules
strongarm
token
viewfield
views

I am not sure what one is causing it, or even if one is causing it, but if we have one in common it might be a good place to start

Can you please try to update to the latest dev?

I was having the same problem with beta3, and updating to the dev version (from 2011-Jul-20) solved the problem for me.

I also updated from 7.x-3.0-rc1 to 7.x-3.x-dev but it didn't solve my problem. The following error remains:
'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'authname\' in \'field list\''

Did you clear cache?

Also before changing issues statuses you should make sure to read the guidelines (linked right below the field).

No, I forgot that. Thanks! Had to clear drupal's cache.

Update status

Same problem here, with Drupal 7.7 trying to add "User: Authentication name" field in table views, even after cache are cleared.

Here is my installed contributed modules :
advanced_help-7.x-1.0-beta1
ctools-7.x-1.0-rc1
calendar-7.x-2.0-alpha1
chart-7.x-1.0
date-7.x-2.0-alpha3
reference-7.x-2.0-beta3
nodereference-7.x-1.0
panels-7.x-3.0-alpha3
views-7.x-3.0-rc1
wysiwyg-7.x-2.1

@sandie
Please read http://drupal.org/node/1210312#comment-4703538

@hereine

Great, an error solved after upgrade to the current dev.
But I think I need to learn more with this new Views in Drupal 7 first, the node author still don't show up in the Views result.

Btw, thanks for the support.

You have

* Add the relationship node: author
* Add a user: name field.

Oh my, now I see those user:* in the field selection which doesn't show in previous stable rc1, this is what I was looking for. I think I'm getting used to, modify relationship node:author first then add the field, tip accepted.

Thanks @dereine, keep your nice work and have a nice days.

Hi Sandie, do you solve the problem? It seems to me that as long as I add the user field, I will get the error info like "Column not found: 1054 Unknown column 'authname' in 'field list'". Thank you.

Helo zackai, I just using latest dev (http://ftp.drupal.org/files/projects/views-7.x-3.x-dev.tar.gz) and it will show "User: Name" in field selection, and just use this field instead "User: Authentication name", but don't forget to enable relationship "node: author" first.

Look at solution #12.

Thank you Sandie. I did see dereine's note on #12, just didn't understand at first.
I add the author relationship and the problem solves. Thank you.

I can't seem to figure out dereine's directions from #12. I just don't know where I add those two, so even with the newest dev I only get User: Roles and no other options in my views. Sorry for acting like a newb.

I figured it out, and it is rather simple (as expected), but I'm going to post here in case anyone is lost like I was. In your Views Display (for whichever view you're trying to edit), there is an advanced column on the right. Open the advanced column and add a relationship in the Relationships tab there. Once you have added the "Content: Author" relationship (that part was different for me than above), the User:* field choices will auto-populate when you add a field again.