UBB.Dev
Posted By: GeoffM1968 Upgrading to 7.7.3 Database Errors - 10/05/2019 1:26 AM
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?
Posted By: isaac Re: Upgrading to 7.7.3 Database Errors - 10/05/2019 2:59 AM
https://www.ubbcentral.com/forums/u...7-2-new-user-registration-bug#Post263017
Posted By: GeoffM1968 Re: Upgrading to 7.7.3 Database Errors - 10/05/2019 3:10 AM
Awesome! Thank you as always
© UBB.Developers