Doing a fresh install to try to bypass a couple gallery errors I was getting..... so when creating the db tables, it starts, then I get a message saying....
Quote
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.

It is able to create
ubbt_CATEGORIES
ubbt_FILES
ubbt_FORUMS
ubbt_FORUM_LAST_VISIT
ubbt_POLL_DATA
ubbt_POLL_OPTIONS
ubbt_POLL_VOTES
ubbt_POSTS
ubbt_TOPICS
ubbt_USERS