You are not logged in. Please login or register.
PunBB Forums → PunBB 1.2 bug reports → Error: Unable to insert group forum permissions.
When changing the group permissions for a given user group for a given forum, I sometimes get the error "Error: Unable to insert group forum permissions."
The problem only occurs when setting "Read forum" or "Post replies" rights, and only on one specific forum. I've been trying to play around with the database (which is SQLite-powered) but with no result so far.
Any help on how to solve this would be greatly appreciated. Thanks!
turn on debug mode and post the full error
Full error:
File: /Users/alurio/Sites/forum/admin_forums.php
Line: 204PunBB reported: Unable to insert group forum permissions
Database reported: constraint failed (Errno: 19)
I should probably also mention that this is a rather fresh PunBB 1.2.5 install, thus without any modifications installed.
What have you done to the DB since you first got the error?
well its obviously some sqlite error, however i can't seem to find any good sqlite documentation, infact searching for sqlite Errno: 19 found a page on punbb.org lol
I found this but I don't think that's the issue here
The SQLite docs say this:
SQLITE_CONSTRAINT: This constant is returned if the SQL statement would have violated a database constraint.
Also, I didn't mess with the database at all. It is a clean install with a few forums added and a few users registered, along with some other changed settings.
Can you replicate the error consistently? I mean, is there something you can do to force the error so that it happens every time?
I can reproduce the error every time, but only in that specific forum; all other forums work fine.
Could you enable PUN_SHOW_QUERIES (it's below debug mode in common.php). Then we can see the exact query.
Failed query:
INSERT INTO forum_perms (group_id, forum_id, read_forum, post_replies, post_topics) VALUES(4, 4, 0, 0, 0)Are you sure you're using the latest version of include/dblayer/sqlite.php? I believe the problem you're referring to was fixed in an earlier release. The fix.
Yes. I'm using a more-or-less fresh 1.2.5 install (not an upgrade from any previous versions). The fix has already been applied in this version.
Just updated to 1.2.6, which did not fix the problem.
I've decided to delete the forum and re-create it. It works fine now; I guess the SQL database must have messed up at some point. I know I shouldn't have done so, but it was necessary because this forum is a public one which is about to get used a lot.
edit: I didn't delete the entire PunBB installation, just one specific subforum. If it happens again in other forums, I'll mention it in here.
PunBB Forums → PunBB 1.2 bug reports → Error: Unable to insert group forum permissions.
Powered by PunBB, supported by Informer Technologies, Inc.