hi all,
sorry for the delay!
so I'm retrying an import using ubb.threads 7.0.0 and an old version of xampp that runs php 5.3 & mysql 5.0...
when I got to the 'create tables' part of the install of ubb.threads, like the importer says
here, it gives me the following error:
Deprecated: Function set_magic_quotes_runtime() is deprecated in E:\xampp5\htdocs\forum\ubbt\libs\ubbthreads.inc.php on line 117
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 'TYPE=MyISAM' at line 37
SQL Error #: 1064
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_ALLOW_HTML tinyint(1) default '0' not null, FORUM_ALLOW_MARKUP tinyint(1) default '1' not null, 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) unsigned default '1' not null, FORUM_ALLOW_ATTACHMENTS tinyint(1) not null default '0', FORUM_ALLOW_POLLS tinyint(1) not null default '0', FORUM_POLLS_ANYWHERE tinyint(1) not null default '0', 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) unsigned not null default '0', FORUM_INTRO_TITLE varchar(255), UNIQUE INDX1 (FORUM_ID), INDEX CAT_NDX (CATEGORY_ID), INDEX ACTIVE_NDX (FORUM_IS_ACTIVE) ) TYPE=MyISAM
