I was trying to compile FFMPEG rev 24953 (27-08-2010) on CentOS 4.8 and following error occured:

[root@server ffmpeg]# make
CC libavdevice/alldevices.o
CC libavdevice/avdevice.o
CC libavdevice/dv1394.o
CC libavdevice/oss_audio.o
CC libavdevice/v4l.o
In file included from libavdevice/v4l.c:34:
/usr/include/linux/videodev.h:56: error: expected specifier-qualifier-list before ‘ulong’
libavdevice/v4l.c: In function ‘grab_read_header’:
libavdevice/v4l.c:136: error: ‘struct video_tuner’ has no member named ‘mode’
libavdevice/v4l.c:138: error: ‘struct video_tuner’ has no member named ‘mode’
libavdevice/v4l.c:140: error: ‘struct video_tuner’ has no member named ‘mode’
make: *** [libavdevice/v4l.o] Error ...

When ran as Apache module, PHP will get $_SERVER variables in the form that they come in the request:
Content-Type, Content-Length, X-File-Size, X-File-Name and so on.


When ran as PHP-FPM with NGINX, php will see the $_SERVER variables in a totally different way (this is because of the default passing of server parameters to fcgi scripts in nginx).

Here's how $_SERVER variables will be seen by php when ran as php-fpm:
Array ( [USER] => ...

To rename a mysql table, just use the rename mysql command

The column order in mysql is not very important in most of the cases, since the SELECT statement can create another column order, one specifically for the application being developed (but not the "SELECT *" statement).

But in cases where order is important, this command will change the position of "column_two" after "column_one".

Remember that column type must be a char, varchar, enum or some other column type that supports default value. TEXT/BLOB columns do NOT support default values.

If an attempt to set a text column's default value a mysql error will be produced:

Controlls the limit of each SMTP message submitted to a postfix smtp server.

The above example sets the limit of a mail message to 20MB.

somebody@excy.nl will be a spam testing pool

The following command will remove an existing table's specified column and the data contained:


As with any database/file delete/edit actions, it's recommended to have a backup. You never know when you meight need it.

The syntax for adding a unique index to a mysql table is the following

Some binaries or some command output (unexpected) can contain control sequence which can cause a terminal to interpret it as changing character set. That's why the prompt becomes unreadable and keystrokes abnormal (lines).

To fix this, there are few possible solutions:

or
(NOT REBOOT)
or