Nombre total de pages vues

mardi 22 janvier 2013

Wordpress you are not allowed to edit this post


Recently, I've met this error when I went create a new article on my Wordpress blog.
I tried to disable all plugins and activate the wordpress default theme but not solved.
Then I checked the php error log and I saw this error:


WordPress database error Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause for the query

                        SELECT COUNT(*) FROM wp_em_events ...



I've searched few days to understand that problem was related with the ONLY_FULL_GROUP_BY sql mode.
I had used the Percona tools web interface to generate my mysql config file and in effect this config file contains parameters for sql modes such as:

sql_mode                       = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY


Solution for me was simply to disable the ONLY_FULL_GROUP_BY sql_mode by removing the parameter on the config line like this:

sql_mode                       = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE



Save the config file and restart the MySQL/MariaDB/Percona server to validate the new config.
Then, I've tried to write a new post on the wordpress blog but same issue again.
Now, this error can be checked into the php error log file:

WordPress database error Incorrect datetime value: '0000-00-00 00:00:00' for column 'post_date_gmt' at row 1 for query INSERT INTO wp_posts 

Here, a quick search helped me to find that the NO_ZERO_DATE sql mode was the cause of this error thus I removed this sql mode into the config file again like this:

sql_mode                       = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE

Saved and restart mysql server to validate.
After these both edits I can now write articles on the blog, very glad because lot of time was lost for this bullshit !

mercredi 12 décembre 2012

15 Greatest Open Source Terminal Applications Of 2012



Nice article on NixCraft:

Linux on the desktop is making great progress. However, the real beauty of Linux and Unix like operating system lies beneath the surface at the command prompt. nixCraft picks his best open source terminal applications of 2012.

Most of the following tools are packaged by all major Linux distributions and can be installed on *BSD or Apple OS X.

Link: http://www.cyberciti.biz/open-source/best-terminal-applications-for-linux-unix-macosx/

FlexGet


FlexGet is a multipurpose automation tool for content like torrents, nzbs, podcasts, comics, series, movies, etc. It can use different kinds of sources like RSS-feeds, html pages, csv files, search engines and there are even plugins for sites that do not provide any kind of useful feeds.
There are numerous plugins that allow utilizing FlexGet in interesting ways and more are being added continuously.
FlexGet is extremely useful in conjunction with applications which have watch directory support or provide interface for external utilities like FlexGet.



jeudi 17 mai 2012

Bandwidth monitor NG


Bandwidth Monitor NG is a small and simple console-based live network and disk io bandwidth monitor for Linux, BSD, Solaris, Mac OS X and others.
So it is very useful to display current ethernet interfaces stats with this top like.


RPM package is present into the EPEL repo or you can download sources from the source forge web page: http://sourceforge.net/projects/bwmng/


Here is the features list of bwm-ng:

  • supports /proc/net/dev, netstat, getifaddr, sysctl, kstat, /proc/diskstats /proc/partitions, IOKit, devstat and libstatgrab
  • unlimited number of interfaces/devices supported
  • interfaces/devices are added or removed dynamically from list
  • white-/blacklist of interfaces/devices
  • output of KB/s, Kb/s, packets, errors, average, max and total sum
  • output in curses, plain console, CSV or HTML
  • configfile

Short list of changes since 0.5 (for full list read changelog):

  • curses2 output, a nice bar chart
  • disk input for bsd/macosx/linux/solaris
  • win32 network bandwidth support
  • moved to autotools
  • alot fixes

Website: http://www.gropp.org/?id=projects&sub=bwm-ng




jeudi 5 avril 2012

Elastix 2.3 released


Elastix 2.3 was released yesterday, here is the release note:

Release Notes: This release updates Asterisk to 1.8.8, Centos to 5.7, Dadhi to 2.4.1.2-9, Wanpipe to 3.5.25-0, and jquery to 1.7.1, redesigns the Addons module, improves the Addons, Calendar, Call Center, Fax, PBX, Email Accounts, Security, Reporting, and System modules, supports adding multiple custom actions to the grid, checks filters in report tables, and completely rewrites the Fax Viewer module.

Elastix website: http://www.elastix.org/