Tag Archives: WordPress

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

I saw this message again when I put this line in the IE’s address space:

http://localhost/aa/yy-1-1

it shows:

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

It shows that this line in the .htaccess file is related:

RewriteRule ^/aa/(.+)-(.+)-(.+)$ /aa/layer_detail.php?tid=$1&page_no=$2&page=$3 [NC,QSA,L]

I met such a problem on the space hosting server. I thought it’s the server’s mistake. More details in:
The WordPress issues are solved

I changed the line to:

RewriteRule ^/aa/([0-9]+)-([0-9]+)-([0-9]+)$ /aa/layer_detail.php?tid=$1&page_no=$2&page=$3  [NC,QSA,L]

Now, I type: http://localhost/aa/yy-1-1

It shows: 404.html. It should be that this RewriteRule in .htaccess works:

ErrorDocument 404$ 404.html

I changed the RewriteRule in the .htaccess in the hosting space server too and now, I can use the original WordPress now. 🙂