Problems and Solutions for installing SMF using xbtit

Source: Internet
Author: User
Tags sql error

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.