actually, it's the xoops_charset that I'd like to modify...

The XOOPS test database was created using UTF-8 but now my production server, we use latin-1. I'd like to change the value of the variable "xoops_langcode" used in templates so that special characters are displayed correctly.
Tks

We found the solution. It had to do with the auto-increment value not being replicated during the import of the db.

I tried the debug mode and I get the following errors :
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = 'e9047b71cb9f134edcdc76d4af2f8e4a'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'system'
SELECT * FROM xoops_groups WHERE groupid=3
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '4') ORDER BY conf_order ASC
UPDATE xoops_groups SET name = 'Utilisateurs_anonymes', description = 'Groupe des utilisateurs anonymes', group_type = 'Anonymous' WHERE groupid = 3
DELETE FROM xoops_group_permission WHERE (gperm_groupid = '3' AND gperm_modid = '1' AND (gperm_name = 'system_admin' OR gperm_name = 'module_admin' OR gperm_name = 'module_read' OR gperm_name = 'block_read'))
INSERT INTO xoops_group_permission (gperm_id, gperm_groupid, gperm_itemid, gperm_modid, gperm_name) VALUES (0, 3, 10, 1, 'system_admin')
INSERT INTO xoops_group_permission (gperm_id, gperm_groupid, gperm_itemid, gperm_modid, gperm_name) VALUES (0, 3, 1, 1, 'module_admin')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO xoops_group_permission (gperm_id, gperm_groupid, gperm_itemid, gperm_modid, gperm_name) VALUES (0, 3, 1, 1, 'module_read')
Error number: 1062
Error message: Duplicate entry '0' for key 1
INSERT INTO xoops_group_permission (gperm_id, gperm_groupid, gperm_itemid, gperm_modid, gperm_name) VALUES (0, 3, 2, 1, 'block_read')
Error number: 1062
Error message: Duplicate entry '0' for key 1

I've installed XOOPS 2.0.13.2 on my desktop computer using Xampp (last versions of PHP/MySQL et Apache server). I've now trnasfered this setup on a production server using MySQL 3.23.58. To do so, I've exported my db using 3.23.x compatibility and imported it on the new server. I've also made the correct changes in the mainfile.php.

Everything seems to work fine, I can post items etc...

The problem is that each time I change one of the module or block access right in the group administration for any permananent user group, all the rights are removed (boxes are unchecked).

I get no error message and the database seems to work fine with the rest of the modules...

Any idea ?
Tks a lot,
Yann