English

When trying to encode new hours in one's timesheet in OpenERP, the following error might appear:

ERROR:  null value in column "journal_id" violates not-null constraint insert into "account_analytic_line" (id,perm_id,"user_id","account_id","general_account_id","product_uom_id","journal_id","name","to_invoice","amount","unit_amount","date","product_id",create_uid,create_date) values (4,NULL,'4','6','634','4',NULL,'Analysis of AIM development project',NULL,-40.000000,2.000000,'2008-08-14','1',4,now())

The error code is not clear, but the problem in this case comes from t

I just finished debugging one client's portal. For some reason, he couldn't see his SCORM content although he could see them in other LMS (Moodle, Claroline, ...). After spending 2 minutes checking the files and directories names, I realised he had stuff like this:

Act_Positive%20and%20negative[1]/.

as root SCORM path.

I'm currently reviewing quickly the slow queries occuring in MySQL when querying the database of a Dokeos 1.8.5 campus with 200.000 users. Of course, the number of users influences largely the execution time of a query, MySQL being known (to me at least, from experience with Dokeos and Avanquest) to be behaving particularly badly from 1M records in a single table upwards. Of course also, as you might have guessed already, most of the queries that lag the most are those related directly to users, and particularly relations between the users table and a log table or a registration table. Here

I just integrated the first web service implementation for Dokeos.

Wow... this is great news for us. Mike Melanson, the developer of the Linux version of the Flash plugin, just announced on his blog that Flash plugin 10 beta 2 will start supporting V4L2! For Dokeos, this means that we will now be able to use the video recording of our little webcams directly from Linux. This is probably the great news of the day...

2008-10-11 update

I'm just finishing an hour of testing here.

When using OpenERP 4.2.2. with PostgreSQL 8.3, a few SQL errors appear when installing new modules, with SUBSTRING appearing with dates. A solution is suggested here (by cornflake on the OpenERP forum). Basically, it consists in replacing all occurences of "substring(date for 7)" by "to_char(date, 'YYYY-MM')" in /usr/share/tinyerp-server/addons/

Tonight I'm upgrading campus.dokeos.com to dokeos 1.8.5. One of the things that is difficult to put in a human mind is the number of users and courses on this portal and the implication it has on upgrade time. Over the last 5 days, 600 new users have registered on this portal, which made it pass the 200K users for the very first time. The portal still works nicely. It's now on a single cuad-core server, but it used to work on a Pentium 4 for 125K users. That's the beauty of Dokeos. However, upgrades to newer versions are always a difficult task.

There's a nice comparative study (if I get it right, it's based on analysis a few months back) between e-learning solutions here. The nice thing is it offers a cute chart of 4 axis of analysis, by an external company, so this is more likely to be a neutral result. No mention of Blackboard though...

I have updated the OpenERP wiki again to add documentation about the possible problems happening when trying to create new databases.

We've had reports about Dokeos creating problems when used with MySQL in strict mode. There's a large topic development on the forum about that. The idea is that MySQL can be set to be more strict about the SQL syntax used in queries.