I'm getting the same problem. I just installed the new version (Download version), and when I create a user in the admin area it returns this error:

Warning:  [mysql error 1048] Column 'language' cannot be null

INSERT INTO piwigo_user_infos
  (nb_image_line,nb_line_page,adviser,language,maxwidth,maxheight,expand,show_nb_comments,show_nb_hits,recent_period,theme,enabled_high,level,user_id,status,registration_date)
  VALUES('5','3','false',NULL,'800','600','true','true','true','7',NULL,'true','0','3','normal','2010-05-22 23:19:19') in /home/espaco/public_html/meu/include/dblayer/functions_mysql.inc.php on line 642


Warning: Cannot modify header information - headers already sent by (output started at /home/espaco/public_html/meu/include/dblayer/functions_mysql.inc.php:641) in /home/espaco/public_html/meu/include/page_header.php on line 98

The abilities to have users is very important. Would someone be kind to let me know why this is happening?

Again, this is a fresh new instalation of the new version 2.1.0

Thanks.

Leo

Alright. Here I am again. This time I have something tangile to say... :)

Yes, a fresh instalation was breaking for no reason after playing with the setttings. So after a lot of trouble shooting I found what causes the problem. Here are the steps:

1) Install a new fresh install of Piwigo. Try to create a new regular user. It should work ok.

2)  Edit the GUEST SETTINGS, and change something there. (Or all settings).

3) Now try to create any user in the admin area, and you can this:

Warning:  [mysql error 1048] Column 'language' cannot be null

INSERT INTO piwigo_user_infos
  (nb_image_line,nb_line_page,adviser,language,maxwidth,maxheight,expand,show_nb_comments,show_nb_hits,recent_period,theme,enabled_high,level,user_id,status,registration_date)
  VALUES('5','4','false',NULL,'800','600','true','true','true','7',NULL,'true','0','10','normal','2010-05-23 02:25:42') in /home/espaco/public_html/meu10/include/dblayer/functions_mysql.inc.php on line 642

After this only a new db or a new fresh install altogether. There is something with the Guest Settings that's causing this. I guess for now I will install Piwigo again, and will just stay away from Guest Settings, so it doesn't crash my site.

It would be great if the admin could post a fix for this issue.

Thanks.

Leo

Please create it for me if you can;. I'm new to your forum and don't know my way around that well yet.

Yes, I was going crazy also with the issue. I literaly spent the whole night yesterday going step by step and documenting until I got the error. And it was right after I had changed the Guest Settings. Something kept telling me that the issue was started by some setting changed in the admin; because a fresh install was always ok at first.

This issue really ruins the site if someone changes the Guest Settings (would have to be reinstalled from backup.) It's like a time bomb. :)

I'm also curious when you might be able to release a fix for this?

Thanks bro.

Leo Caju

How do I patch my existing site instalation with this new fix? Also, I'm, curious to know exactly what files are updated/replaced with this fix/patch (for my records). I keep careful backups, so I want to patch the site knowing what was patched, just in case something else happens. :)

Thanks.

Leo

looked at the subversion - but am not clear exactly either where to replace what to fix this. Is it possible to give precise instructions?
Really appreciate it.
Thanks

That worked great! The issue is fixed! Awesome. :)

You guys are the best!

Leo

Last edited by leo (2010-05-24 20:39:11)

Piwigo 2.1.1 avoids to break user registration