I just installed moodle on my server and got into a big mysql error complaining about binlog and other stuffs…
Cannot execute statement: impossible to write to binary log since
BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine
limited to row-based logging. InnoDB is limited to row-logging when
transaction isolation level is READ COMMITTED or READ UNCOMMITTED
After a bit of googling and understand what this was about I figured I should add the following in my my.cnf file and then restart mysql.
Here is a great python script very useful to download an HD video from Youtube using the command line in Linux.
It’s very simple, download and run. The result is an mp4 file that you can watch offline with VLC or Media Player Classsic under Windows or any other mp4 player under Linux.
I finally decided to create my company (Bonne Idée: bonneidee.biz) and do something with it. I am now involved in two projects.
– Yaentrainement.fr (french version of nimenhuuto.com)
Yaentrainement is an online sport team management platform which is having a huge success in Finland (170K+ users and 43M sign-ups as of may 2012).
With Ubuntu 10.04 came a new version of Grub. During an upgrade from a previous version to 10.04 or higher there will be a time when the system will ask you if you want to keep your own version of the configuration or get the package maintener version.
If I am not mistaken, you should say you want the maintener one.
But then something strange may happen depending on your upgrade path.
These days I am looking for a web developer in Lithuania. It is not very easy because it’s a small country… but on Linkedin you can find quite many profiles.
The problem is, sometimes you can’t connect to these people because they are too far out of your network.
Usually you would get the first name of the person and some skills in his profile.
When building a web application it can seem a bit tricky to get the value of the id (primary key) of the latest row inserted in a mysql table.
It is not that complicated.
The function LAST_INSERT_ID() can help you finding that. This function will return the latest auto-incremented value. No need to specify the table, it just takes the latest one.
SELECT LAST_INSERT_ID() ;
The next question is: what happens when I have many concurrent sessions on the same server? Will I get the latest inserted id from another user?
sudo apt-get install lamp-server^
Be careful not to delete the ^ character.
This will install:
Login and re-login and re-re-login in phpmyadmin is a huge pain.
Here is the way to extend sessions duration.
Open the file config.inc.php in /usr/share/phpmyadmin or in /etc/phpmyadmin
Add the following line:
And in php.ini, modify the following line:
session.gc_maxlifetime = 86400
You now have 24h sessions.