WAMP Discoveries #1

Problem: Have you ever encountered Internal Server Error at WAMP? The last statement really has something to say. The server error log can be found at wamp\logs folder with apache_error.log filename. At the end of the file content you can find the latest server error entry, similar to the following:


For this particular case, there was an invalid command 'RewriteEngine' found at .htaccess file.

Solution:

Locate the httpd.conf file. With WAMP it is located at wamp\bin\apache\Apache2.2.11\conf folder.

Using your favorite text editor, locate the line

• #LoadModule rewrite_module modules/mod_rewrite.so

Remove the # symbol in the beginning of this line and Save the file.

Restart the All Services of the WAMP server.


That's about it.

Internet Explorer Discoveries #1

Problem: When I'm accessing a website with a login box, the Internet Explorer (IE) browser is asking me:


We can turn it off right there and then by ticking the checkbox "Don't offer to remember any more passwords". However, how do you turn it on later?


Solution: Navigate Tools > Internet Options.


In the Internet Options Dialog, open the Content tab, and click on the Settings button in the AutoComplete section


In the AutoComplete Settings Dialog tick the checkbox "Prompt me to save passwords". Hit OK button to save the settings.

T-SQL Discoveries #1

Given: A database table with the following structure


Problem: How many of each subject were posted on a certain date?

Solution: Issue the following query

SELECT count(queueID) AS TotalCount, dateposted, subject FROM (SELECT queueID, CONVERT(DATETIME,postdate,111) AS dateposted, subject FROM tblQueue) AS tblQ GROUP BY dateposted, subject

NOTE: The above query disregards the posting time, i.e., it focuses on the date alone.