Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 registered (MichaelM, packlite, Steel72, 1 invisible), 36 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/17/06
Posts: 120
Top Posters (30 Days)
Ruben Rocha 95
Rick 85
Mark S 74
Thelockman 49
Gizmo 48
driv 35
Sirdude 32
ntdoc 28
packlite 27
AllenAyres 25
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#218382 - 10/24/08 10:51 AM Upgraded from 7.0 to 7.4. Error while changing settings in Control panel
BB Offline
stranger

Registered: 03/01/07
Posts: 11
Hi,

I upgraded from 7.0 to 7.4. I notice many settings are disabled by default in this update (e.g. permission to view user profile). When I went to the Control Panel and changed the setting to enable viewing of user profile, I received the following error message:

Script: dositeperms.php
Line#: 85
SQL Error: Column 'CUSTOM_TITLE' specified twice
SQL Error #: 1110
Query: replace into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,EXT_INFO,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,SIGNATURE_IMAGES,EXT_INFO,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE) values (1,'1','1','1','1','1','1','20000','100','1','500','1','1','1','1','1','1','1','0','0','1','1','1','1','1','1','20000','100','1','500','1','1','1','1','1','1','1','0','0')

I get the same message while changing other settings.

Top
#218385 - 10/24/08 03:48 PM Re: Upgraded from 7.0 to 7.4. Error while changing settings in Control panel [Re: BB]
BB Offline
stranger

Registered: 03/01/07
Posts: 11
Haven't seen any response to this... No one else has seen this error? Any idea what might be wrong?

Top
#218387 - 10/24/08 04:32 PM Re: Upgraded from 7.0 to 7.4. Error while changing settings in Control panel [Re: BB]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7998
Loc: Aberdeen, WA
It seems like maybe you have the CUSTOM_TITLE duplicated in the ubbt_PERMISSION_LIST table. It builds the update dynamically off of what is in that table.

Probably the easiest thing would be to open up a support ticket with your admin info so I can take a look at that table.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top


Shout Box

Today's Birthdays
theregit
Recent Topics
7.4.2 UNREAD
by Thelockman
Today at 05:23 PM
7.4.1 show/hide category bug
by Seattlebrian
Today at 11:56 AM
7.4.2 Discussion
by Rick
Today at 10:21 AM
UBBCentral now running 7.4.2
by Rick
Today at 10:21 AM
New members don't get access and are not displayed in the config panel
by Yomar
Yesterday at 03:32 AM
Forum Stats
4299 Members
33 Forums
30693 Topics
156040 Posts

Max Online: 978 @ 06/24/07 08:19 PM