Note on Sept. 7, 2010:  

 it’s a problem on .htacess.  Don’t need so much trouble as below.  
More details: It Didn’t Work: Unknown column ‘**’ in ‘where clause’

The problem shows like this: broken Dashboard, can’t leave comments etc.  I installed one on my own computer or move the files from the web hosting space,  it works just perfect.

I found that there can’t be more than two “-” in the path and the filename. If so, the file won’t be found and show a strange hint “It Didn’t Work: Unknown column ‘**’ in ‘where clause'”. I think that the rewriting rules has some problems on the web hosting server. 

I tried the following test to prove it:
Those files and subfolders don’t exit, but it doesn’t always show the webpage cannot be found.

When I try to find this file: http://www.coolder.com/wp-try/load-styles.php

It shows: It Didn’t Work: Unknown column ‘wp’ in ‘where clause’

Other examples are as follows:

http://www.coolder.com/wd-try/load-styles.php

It Didn’t Work: Unknown column ‘wd’ in ‘where clause’

http://www.coolder.com/wd-try/loadstyles.php

The webpage cannot be found

http://www.coolder.com/wdtry/load-styles.php

The webpage cannot be found

http://coolder.com/try/wp-comments-post.php
It Didn’t Work: Unknown column ‘try’ in ‘where clause’

http://coolder.com/try/wp-comments.php

The webpage cannot be found

http://coolder.com/try/wp-co-o.php
It Didn’t Work: Unknown column ‘try’ in ‘where clause’  

I changed the subfolder prefix from “wp-” to “wp_”. I also changed the names of the files which include more than one “-“. I just keep one “-”  and change the rest “-” to “_”.  And I changed those filenames in the file too according to the new name. 

It works now. Some filenames still has more than one “-“, such as some image files, maybe because their connections are in the file so the rewriting rules aren’t used.

Maybe this change will bring other problems, but I don’t know now.

If u like to see more details, have a look at this link: http://www.coolder.com/727-1-1