BB Message We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INDEX birthday_ndx (USER_BIRTHDAY, USER_PUBLIC_BIRTHDAY), INDEX email_ndx(USER_' at line 66
SQL Error #: 1064
Query: create table ubbt_USER_PROFILE ( USER_ID int(9) not null primary key, USER_REAL_EMAIL varchar(50) not null default '', USER_DISPLAY_EMAIL varchar(50), USER_UNVERIFIED_EMAIL varchar(50) not null default '', USER_LANGUAGE varchar(50), USER_SIGNATURE text, USER_DEFAULT_SIGNATURE text, USER_HOMEPAGE varchar(150), USER_OCCUPATION varchar(150), USER_HOBBIES varchar(200), USER_LOCATION varchar(200), USER_START_VIEW varchar(20) not null default 'cfrm', USER_FAVORITES_TAB varchar(10) not null default 'forums', USER_FAVORITES_SORT varchar (10) not null default 'reply', USER_TOPIC_VIEW_TYPE varchar(10) not null default 'flat', USER_TOPICS_PER_PAGE int(1), USER_NOTIFY_ON_PM varchar(3) not null default 'no', USER_ICQ varchar(200), USER_YAHOO varchar(200), USER_MSN varchar(200), USER_AIM varchar(200), USER_EXTRA_FIELD_1 varchar(200), USER_EXTRA_FIELD_2 varchar(200), USER_EXTRA_FIELD_3 varchar(200), USER_EXTRA_FIELD_4 varchar(200), USER_EXTRA_FIELD_5 varchar(200), USER_AVATAR varchar(150), USER_SHOW_AVATARS tinyint(1) not null default '1', USER_VISIBLE_ONLINE_STATUS varchar(3) default 'yes', USER_ACCEPT_PM varchar(3) default 'yes', USER_EMAIL_WATCHLISTS tinyint(1) not null default '0', USER_TITLE varchar(100), USER_CUSTOM_TITLE varchar(255), USER_POSTS_PER_TOPIC varchar(2), USER_TEMPORARY_PASSWORD varchar(32), USER_NAME_COLOR varchar(15), USER_TIME_OFFSET varchar(10), USER_RELATIVE_TIME tinyint(1), USER_TOTAL_PM int(4) default '0', USER_TOTAL_POSTS int(9) default '0', USER_SHOW_SIGNATURES varchar(3), USER_RATING int(1), USER_TOTAL_RATES mediumint(6) not null default '0', USER_AVATAR_WIDTH int(4) default '0', USER_AVATAR_HEIGHT int(4) default '0', USER_ACCEPT_ADMIN_EMAILS varchar(3), USER_BIRTHDAY varchar(10) not null default '0', USER_PUBLIC_BIRTHDAY int(1) not null default '0', USER_TIME_FORMAT varchar(30), USER_IGNORE_LIST text, USER_FLOOD_CONTROL_OVERRIDE mediumint(8) default '-1', USER_STYLE mediumint(4) not null default '0', USER_UNAPPROVED_POST_NOTIFY tinyint(1) not null default '0', USER_REPORT_POST_NOTIFY tinyint(1) not null default '0', USER_TEXT_EDITOR varchar(10) default 'standard', USER_HIDE_LEFT_COLUMN tinyint(1) not null default '0', USER_HIDE_RIGHT_COLUMN tinyint(1) not null default '0', USER_MOOD varchar(50), USER_NOTIFY_NEW_USER tinyint(1) not null default '0', USER_POST_LAYOUT varchar(4), USER_SHOW_ALL_GRAEMLINS tinyint(1) default '0', USER_SHOW_LEFT_MYSTUFF tinyint(1) not null default '0', USER_GROUP_IMAGES varchar(255), USER_NOTIFY_MULTI tinyint(1) unsigned not null default '0' INDEX birthday_ndx (USER_BIRTHDAY, USER_PUBLIC_BIRTHDAY), INDEX email_ndx(USER_REAL_EMAIL) ) TYPE=MyISAM

Please click back to return to the previous page.

We refreshed 7.5 this morning which has the updated createtable.php script in place, so that should fix the issue if you want to grab it again.