Loading...
 
Skip to main content

Architecture / Installation


System error - duplicate entry

Hi,

I'm using Tiki 5.3 on a new installation (it's my second Tiki installation). Everything's been working just fine. I've been setting permissions and I have got this error come up for one of them. It seems to only be this one permission. All else appears okay. I've looked in the data base to try and sort it out, but I'm not sure where to go for this one. Below is the error message and I've also attached a PDF of the error page.
The server is running:
Apache version 2.2.14
PHP version 5.2.11
MySQL version 5.0.90-community-log

Please help me out.

Guy.


__''System error.
The following error message was returned:
Duplicate entry 'HEA Advertising and Fundraisin-tiki_p_change_events' for key 1
The query was:
insert into `users_grouppermissions`(`groupName`, `permName`) values(?, ?)
Values:
HEA Advertising and Fundraising 1. Coordinator
2. tiki_p_change_events
The built query was likely:
insert into `users_grouppermissions`(`groupName`, `permName`) values('HEA Advertising and Fundraising
Coordinator', 'tiki_p_change_events')
Things to check:
1. Is your database up and running?
2. Is your database corrupt? Please see how to repair your database
3. Are your database credentials accurate? (username, database name, etc in db/local.php)
4. Did you complete the Tiki Installer?
Please see the documentation for more information.''__

Hi,

Just realised - it's not just the one permission, it's the one group that's a problem, all other groups are okay.

Guy.


Hi again,

I got it fixed. I think it may be a bug.

Here's what I found:
I had one group named:

HEA Advertising and Fundraising

and another one named:

HEA Advertising and Fundraising Coordinator


It appears that Tiki shortened the group names to:
HEA Advertising and Fundraisin when it was sending it's queries.

So, because I had two group names that exceeded the number of characters that Tiki could handle, it shortened them both to the same abbreviation, hence the 'duplicate error'.

Where should I report this to?

I'd also like to make a suggestion - when setting permissions, there is option to 'select all or none' of the group column. I'd like to suggest adding a 'select all or none' to each permission row. I have 25 groups in my installation and it's really painfully slow to select anything less than all of one column at a time.
Where should I send my suggestion to?