UBB.threads PHP Forum Software Community Forums UBB.threads 7 Installation and Upgrade Support Install Problem during last step

Step 8 of the install procedure (Table creation)I received this error message:

Parse error: parse error, unexpected $end in e:\inetpub\esvc001043\forums\ubbthreads-7-3-1\install\install_styles.php(35) : eval()'d code on line 1

Parse error: parse error, unexpected $end in e:\inetpub\esvc001043\forums\ubbthreads-7-3-1\install\install_styles.php(42) : eval()'d code on line 1

UBB Message We encountered a problem. The reason reported was
Script:
Line#:
SQL Error: Too big column length for column 'BBCODE_MATCH_REGEX' (max = 255). Use BLOB instead
SQL Error #: 1074
Query: CREATE TABLE ubbt_BBCODE ( BBCODE_ID int(4) NOT NULL auto_increment, BBCODE_MENU_SHOW tinyint(1) NOT NULL default '1', BBCODE_ENABLE tinyint(1) NOT NULL default '1', BBCODE_DESCRIPTION varchar(128) default NULL, BBCODE_MENU_PROMPT varchar(128) default NULL, BBCODE_TAG varchar(64) default NULL, BBCODE_MATCH_REGEX varchar(256) default NULL, BBCODE_MARKUP_RESULT varchar(2048) default NULL, BBCODE_MENU_ORDER int(4) NOT NULL default '0', UNIQUE KEY BBCODE_ndx (BBCODE_ID,BBCODE_ENABLE) ) TYPE=MyISAM Please click back to return to the previous page.


Trying the step again now gets me this message

UBB Message We encountered a problem. The reason reported was
Script:
Line#:
SQL Error: Table 'ubbt_forums' already exists
SQL Error #: 1050
Query: create table ubbt_FORUMS ( FORUM_TITLE text, FORUM_DESCRIPTION text, FORUM_ID int(9) unsigned auto_increment primary key, FORUM_PARENT int(9) unsigned, FORUM_POSTS int(9) unsigned default '0', FORUM_LAST_POST_TIME int(11) unsigned, FORUM_CREATED_ON int(11) unsigned, FORUM_IS_MODERATED tinyint(1) unsigned default '0', CATEGORY_ID int(4) unsigned default '1' not null, FORUM_TOPICS int(9) unsigned default '0', FORUM_SORT_ORDER int(4) unsigned, FORUM_DEFAULT_TOPIC_AGE int(4) unsigned, FORUM_CUSTOM_HEADER int(1) unsigned, FORUM_STYLE mediumint(4) not null default '0', FORUM_LAST_POST_ID int(9) unsigned default '0', FORUM_LAST_TOPIC_ID int(9) unsigned, FORUM_LAST_POSTER_ID int(9) default '1', FORUM_LAST_POSTER_NAME varchar(64), FORUM_LAST_POST_SUBJECT text, FORUM_LAST_POST_ICON varchar(30), FORUM_IMAGE varchar(255), FORUM_IS_ACTIVE tinyint(1) default '1' not null, FORUM_ISLAND_INSERT mediumint(5) not null default '0', FORUM_IS_RSS tinyint(1) not null default '0', FORUM_RSS_TITLE varchar(255), FORUM_SHOW_INTRO tinyint(1) not null default '0', FORUM_INTRO_TITLE varchar(255), FORUM_IS_TEASER tinyint(1) not null default '0', FORUM_IS_GALLERY tinyint(1) not null default '0', FORUM_ACTIVE_POSTS tinyint(1) default '1', FORUM_POSTS_COUNT tinyint(1) default '1', INDEX CAT_NDX (CATEGORY_ID), INDEX ACTIVE_NDX (FORUM_IS_ACTIVE) ) TYPE=MyISAM Please click back to return to the previous page.

This is something we'd had to fix in our latest version, some of the fields are too big. What you'll want to do is open up the install/createtable.php file and edit it. You're looking for these 2 lines:

BBCODE_MATCH_REGEX varchar(256) default NULL,
BBCODE_MARKUP_RESULT varchar(2048) default NULL,

Change those, to this:

BBCODE_MATCH_REGEX text,
BBCODE_MARKUP_RESULT text,


After that, you'll need to wipe out all of the ubbt_ tables from the database using something like phpmyadmin. At that point you should be able to run that step again without errors.

Ok thanks Rick, but I thought I had the latest version (7.3.1) ??

Did what you said and this time just received these errors;

Parse error: parse error, unexpected $end in e:\inetpub\esvc001043\forums\ubbthreads-7-3-1\install\install_styles.php(35) : eval()'d code on line 1

Parse error: parse error, unexpected $end in e:\inetpub\esvc001043\forums\ubbthreads-7-3-1\install\install_styles.php(42) : eval()'d code on line 1