!!~Permissions Error~!!

[Private_Ale]

Hello,

I am an administrator on a SMF-Powered forum.
Recently with our board growth We have been looking at ways to make permissions more sophisticated.

In one attempt I have tried to enable advanced by-board permissions, in this attempt i have failed and gotten this message:



Basically this is the only error the forum has ever encountered.
We are currently running 1.1.4 and have been running since 1.1.2

Our host is also one of our administrators and has pretty much babied the forum, He does not know what's up and is busy with other clients to look too deep into this ATM.

So if anyone can identify the problem it would be much appreciated. 

[Tramposch]

well, i would suggest doing what it says to and running the latest version of upgrade.php. im not sure where its located, but ill try and find it.

[Private_Ale]

well, i would suggest doing what it says to and running the latest version of upgrade.php. im not sure where its located, but ill try and find it.

Under the detailed view via forum maintenance, All of the files are up to date.
I also remember reading a post having similar problems and a support member stating that there was no database changes from 1.1.2 to the current.. or something like that. 

[Tramposch]

hmm, then it seems that SMF has just made a copy of the table and now you are getting an error. but this is beyond my specialty, in fact i barely know mySQL at all, so im not the man for the job. sorry.

[Private_Ale]

hmm, then it seems that SMF has just made a copy of the table and now you are getting an error. but this is beyond my specialty, in fact i barely know mySQL at all, so im not the man for the job. sorry.

thanks for your help

[Private_Ale]

So is anyone going to help me solve the error? 

[Private_Ale]

Hello,

I am an administrator on a SMF-Powered forum.
Recently with our board growth We have been looking at ways to make permissions more sophisticated.

In one attempt I have tried to enable advanced by-board permissions, in this attempt i have failed and gotten this message:



Basically this is the only error the forum has ever encountered.
We are currently running 1.1.4 and have been running since 1.1.2

Our host is also one of our administrators and has pretty much babied the forum, He does not know what's up and is busy with other clients to look too deep into this ATM.

So if anyone can identify the problem it would be much appreciated. 

OK, any help is GREATLY appreciated.. I need to move hosts and would like to solve this problem before we move so my old host can repair this problem.

So0o0o0o... anybody?

[greyknight17]

These seem to be a little tricky to fix. Does it mention what table has the duplicate entry? Did you try repairing the database?

[Private_Ale]

These seem to be a little tricky to fix. Does it mention what table has the duplicate entry? Did you try repairing the database?

All it reports is:

Duplicate entry '0-20-modify_own' for key 1
File: /hsphere/local/home/superfly/beercandleforums.com/Sources/ManagePermissions.php
Line: 978

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.4, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

and repairing database reports:

Congratulations, no errors found! Thanks for checking.

Thank you for your response!!

[Private_Ale]

I guess while i wait i'll post some general info on the forum..

Currently active MODs:
1.     SMF Links 
2.    SMF 1.0.12 / 1.1.4 / 2.0 b1.1 Update
3.    SMF Arcade    
4.    vReportBoard Mod    
5.    No Spam by Guests!    
6.    Ultimate Profile    
7.    Googlebot & Spiders Mod    
8.    SMF 1.0.11 / 1.1.3 Update    
9.    Karma Description Mod    
10.    Spam Me Not Mod    
11.    Users Online Today Mod
12.    TinyPortal    
13.    Ad Managment    
14.    MessagePreviewOnHover    
15.    Custom Action Mod    
16.    Report Icon Mod
17.    Reason For Editing Mod
18.    Custom BBCode    
19.    Welcome Topic Mod
20.    YouTube BBC Tag (XHTML Compliant)

All MODs are up-to-date and have been approved by this site.

Dunno, i'd hate to create a post simply to "bump", so im trying to help myself.

[Private_Ale]

I really do hate bumping, but i also really do need assistance with this issue..

<--B--<

<--U--<

<--M--<

<--P--<

[greyknight17]

It looks like it could be coming from the smf_board_permissions table. You didn't try repairing the database from phpMyAdmin right? Go into phpMyAdmin and then choose your database. Now on the right window, check the box/entry for the smf_board_permissions table. Scroll all the way down and in the With selected drop down, choose Repair table.

[Private_Ale]

It looks like it could be coming from the smf_board_permissions table. You didn't try repairing the database from phpMyAdmin right? Go into phpMyAdmin and then choose your database. Now on the right window, check the box/entry for the smf_board_permissions table. Scroll all the way down and in the With selected drop down, choose Repair table.

Thanks greyknight!!

I'll try it and let you know how it turns out

-pa

[Private_Ale]

Well... nope, 

The table's been repaired and the error still persists.

Database Error
Duplicate entry '0-20-modify_own' for key 1
File: /hsphere/local/home/superfly/beercandleforums.com/Sources/ManagePermissions.php
Line: 978

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.4, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

[Private_Ale]

Well at least were getting somewhere. Any other suggestions?

[Private_Ale]

I seriously need this so i can set up local permissions, global permissions just aint cutting it anymore

[greyknight17]

Go back to phpMyAdmin and click on your database. Then on the right hand window, click on the Export tab on top. Under the Export section, just select the smf_board_permissions entry. Then at the bottom (scroll down), hit the Go button. It should display the table entries now. Copy and paste all the data in that window here (you may enclose it in the CODE tags here):

Koodi [Valitse] Laajenna

copy and paste here....