August 3, 2007

Microsoft Access 2007 MS_WSSTemplateID bug

Strange error when trying to use a subform inside an Access form to the effect of:

SELECT*,sql_variant_property(value,'basetype') AS type FROM
::fn-listextendedproperty(N'MS_WSSTemplateID',N'user,N'dbo',N'table,N'tblCas
eInfo',NULL,NULL)


FIX:
Try to minimize the ribbon.
If the ribbon is minimized Access12 doesn't send the bugged query. Makes no sense, but works.

July 12, 2007

Awstats stopped updating

Install Geo::IP Perl Module and Install dos2unix on Debian linux

DOS text files traditionally have carriage return and line feed pairs as their newline characters, while Unix text files have the line feed as their newline character. We often find myself needing to ‘clean-up’ some files saved with Win/DOS characters, and this can be done very easy with dos2unix. While RedHat based Linux distributions will traditionally include these small utils by default, on Debian we have to install them if needed.

The file logresolvemerge.pl included in the awstats package from Debian, needs cleaning up as showed by the error:

/usr/share/doc/awstats/examples/logresolvemerge.pl -bash: /usr/share/doc/awstats/examples/logresolvemerge.pl:

/usr/bin/perl^M: bad interpreter: No such file or directory

The dos2unix and corresponding unix2dos, are found in the tofrodos Debian package, and to install the package just type:

#apt-get install tofrodos

Once we have dos2unix installed, I can use it to clean up very easy any file that needs that:

dos2unix logresolvemerge.pl

and the offending DOS characters are gone.

June 5, 2007

Gmail search tip (spam, deleted items)

You can search specific labels by using "label:" or for mails in trash with "in:trash". Actually, "is:", "in:" and "label:" all mean the same thing so "is:spam" "in:spam" and "label:spam" will return identical results. They work for labeled email, email statuses (read, starred) and for spam and trash. To search every single email use "in:anywhere". By default Gmail won't search deleted emails and emails marked spam.

April 25, 2007

http:BL

http:BL Project Honey Pot a service that allows you to use the data generated by Project Honey Pot in order to keep malicious web robots off your website.

Comment spamming bot blacklist (apache 2 mod).