The latest version:
Xbtit: xbtit v.2.2.2-revision 680
SMF: SMB 2.0
Problem
In the ideal state, the interaction between xbtit and SMF can share some users and other things in the database ...... However, these two versions are currently incompatible, although xbtit comes with the SMF compatibility feature.
The problem is that the items in the user list are different. Therefore, when the installation is normal, the following prompt is displayed:
Reference
Warning: mysql_num_rows (): supplied argument is not a valid MySQL result resource in/home/mintoxas/public_html/torrent/install. php on line 563
Can't find simple machines forum in the database, please install it before proceeding.
Here, warning indicates that an error occurred while executing the SQL statement.
In addition, the built-in forum is used during installation, and then the smf_import.php conversion is used. An error occurs in the SMF 2.0 version and the xbtit database crashes.
Cause
The cause of the error is that the table smf_members in the database has been modified in all versions of SMF 2.0 (beta and RC). You can see it by comparing the SQL files of the two versions.
Install_1-1. SQL#
Table structure for table `members`
#
CREATE TABLE {$db_prefix}members (
ID_MEMBER mediumint(8) unsigned NOT NULL auto_increment,
memberName varchar(80) NOT NULL default '',
dateRegistered int(10) unsigned NOT NULL default '0',
posts mediumint(8) unsigned NOT NULL default '0',
ID_GROUP smallint(5) unsigned NOT NULL default '0',......
Install_2-0_mysql. SQL#
Table structure for table `members`
#
CREATE TABLE {$db_prefix}members (
id_member mediumint(8) unsigned NOT NULL auto_increment,
member_name varchar(80) NOT NULL default '',
date_registered int(10) unsigned NOT NULL default '0',
posts mediumint(8) unsigned NOT NULL default '0',
id_group smallint(5) unsigned NOT NULL default '0',......
Currently, xbtit release only supports SMF 1. x databases. Therefore, an SQL error occurs when the database is used in total.
Solution
This question was raised in btiteam's official forum, but the development team answered the question by following the steps. Until I pasted the smf SQL statement, then Lupin replied that currently only the latest SVN supports SMF 2.0, there is no available release version (http://www.btiteam.org/smf/index.php? Topic = 21255.0)
If xbtit has been installed and there is a large amount of data, only the release supporting SMF 2.0 can appear after you modify PHP or wait for a while.
If you haven't started installation, can you download a smf_1-1-14 http://download.simplemachines.org/index.php? Archive; version = 62 to achieve xbtit compatibility.