Installing Office2007 with protected windows files error

If you run into error while installing Office2007 with description protected windows files problem, then here is the fix.

Copy fpault.dll file on the original xp cd,
hiding in I386\FP40EXT.CAB

to c:\program files\common files\microsoft shared\web server extensions\40\bin

ls command

Options:

-l list files one line at a time
-A lists all the contents of a directory except for current directory and parent directory
-B ignore backups
-c sort by change time
-d lists file and directory names without contents
-e lists all times in full
-f list without sorting
-k list file size in kilobytes
-l list files in long format
-L list files by symbolic link
-m list files horizontally separate by commas
-r sort files in reverse order
-R list files recursively
-S list files by size, biggest first
-u sort files by the last time they were accessed
-x print in columns, sorted horizontally
-X sort files alphabetically by file extension

Sort directory in linux

To sort directory based on size, here is the command

du -hs * | sort +0n

To view only the Gb,

du -hs * | sort +0n | grep Gb

Truncate all tables in SQL

Here is how to truncate all tables

EXEC [sp_MSforeachtable] @command1="TRUNCATE TABLE ?"

How to find files and move the files to folder in Linux

locate *.zip | grep backup | grep accountname | xargs -t -i mv {} /home/accountname/dump/

This will find all the zip files with the name consist of backup and accountname and then move them to a dump folder.

Moodle lose some of the administrative privilege

You are playing with roles specially admin privilege or user privilege and you end up locking your self because of the wrong configuration. To restore it back to normal, you need to go to the database and find mdl_role_capabilities table and do a search for permission |= -1 and you will see the value of -1000. Just change the value to 1 for all the -1000.

Questionnaire Export CSV Issue

You're trying to export questionnaire responses to csv format and there are missing response on one or more columns. Check the question name for that missing column and rename it with something else. It's probably a general name such as ID or Full name that interfere with the moodle general field name.