How can I correct this issue? I upgraded our forum to latest update. I received feedback people can not register and I confirmed. Our MySQL logs show errors with the database for the last four registrations since the update:
Script: /.../forums/scripts/adduser.inc.php - Line: 699
insert into ubbt_USER_PROFILE
(USER_ID,USER_FLOOD_CONTROL_OVERRIDE,USER_REAL_EMAIL,USER_TOTAL_POSTS,USER_TITLE,USER_TOTAL_PM,USER_DISPLAY_EMAIL,USER_BIRTHDAY,USER_AVATAR,USER_ACCEPT_PM,USER_SIGNATURE,USER_HOMEPAGE,USER_OCCUPATION,USER_HOBBIES,USER_LOCATION,USER_ICQ,USER_VISIBLE_ONLINE_STATUS,USER_TIME_FORMAT,USER_TIME_OFFSET,USER_SHOW_SIGNATURES,USER_TOPIC_VIEW_TYPE,USER_TOPICS_PER_PAGE,USER_POSTS_PER_TOPIC,USER_SHOW_AVATARS,USER_ACCEPT_ADMIN_EMAILS,USER_NOTIFY_ON_PM,USER_EXTRA_FIELD_2,USER_EXTRA_FIELD_3)
values
('8880','-1','
[email protected]',0,'New Member',1,'
[email protected] ','10/22/1967','','yes','','','Pilot','','SANFORD','','yes','m/d/y | h:i A','America/New_York','yes','flat','10','40','0','On','On','','')
- Unknown column 'USER_ICQ' in 'field list'
Also one when I had an error trying to make a post a sticky:
Script: /.../forums/scripts/stickpost.inc.php - Line: 84
INSERT INTO ubbt_ANNOUNCEMENTS
VALUES
( 38081 , 25 )
- Duplicate entry '38081-25' for key 'a_index'
Please advise what I should do?