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.

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.

Failed query:

INSERT INTO forum_perms (group_id, forum_id, read_forum, post_replies, post_topics) VALUES(4, 4, 0, 0, 0)

I can reproduce the error every time, but only in that specific forum; all other forums work fine.

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.

Full error:

File: /Users/alurio/Sites/forum/admin_forums.php
Line: 204

PunBB 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.

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!

8

(1 replies, posted in PunBB 1.2 discussion)

I registered on these forums to draw some attention on a couple of really interesting and useful CSS and JavaScript tricks which will make PunBB easier to use.

In a recent article on A List Apart, Christian Heilmann writes about using a table ruler in tables to make reading data in tables easier. You can try it for yourself on the row rollover table demo page.

But that's not all... while writing this post I remembered another article on A List Apart which is also quite useful for making tables easier to read. It is the zebra tables article. In zebra tables, every other row gets a different colour, which makes it easier for the reader to follow the line. There's a zebra table example for those who want to see how it looks.

These two tricks are compatible with the current web standards, and since PunBB is a web standards-aware forum, I hope these two techniques are useful.