Leo2dnt (Leao forum to discuznt) 1.0 Conversion Program released

Data ConversionProgramLeobbs4.x> discuz! NT V1.0
 
This conversion program is designed based on leobbs4.x

 
Statement:
1. this program only converts data and does not damage the original record Forum (data loss. If you are worried about data loss, back up the data first. We will not be responsible for any data loss of this type;
2. Before using this program for conversion, if discuz! NT forum has data, please back up first, the conversion program will automatically clear the data table to be converted.
3. Disconnect other links to the source database before the conversion starts, so that only the conversion program is in use in the source database.
3. Do not use this program for commercial purposes. You can spread it freely, but we must keep our copyright information.
4. If you use this program, you have accepted the above statement!

Applicable version of this program:
Leobbs4.x

Environment required for this program:
1. NET Framework 2.0 + MS SQL2000;

Data that can be converted in this program:
Member Data, Forum data, topic data, post data, attachment data, voting data, and Alliance Forum data
The voting is valid for 60 days on the conversion date.

This program saves the original post and generates the corresponding new ID (you can set 404 to keep the original post pointing)

Data that cannot be completely converted in this program:
1. the part with the title exceeding 60 bytes will be truncated, and the part with the Post author's username exceeding 20 bytes will be truncated;
2. Some junk data that does not comply with DNT data standards;
3. Various record-filing data is incomplete (for example, the file is empty and the attribute is missing;
4. data that cannot be converted is processed as non-existent.

Possible problems:
1. Some attachments cannot be converted successfully.
2. Switch failed

Before conversion:
1. Make sure that you have successfully installed. NET Framework 2.0
2. Make sure that you have successfully installed discuz! NT V1.0;
3. Because the conversion process consumes a lot of resources, we recommend that you do it whenever possible during idle server hours.
4. To ensure normal conversion, please close the LEO forum during conversion
5. Enter the parameters of the conversion program correctly.
6.ensure that the conversion program leo2dntdirectory can be written (automatically generated log file log.txt)
7. To ensure data integrity in leobbs, the following data must be included:
Cgi-bin/member ***/allmember. pl
Cgi-bin/member ***/old
Cgi-bin/data/allforums. cgi
Cgi-bin/Forum */
Cgi-bin/boarddata/Jinghua *. cgi
Cgi-bin/boarddata/ontop *. cgi
Cgi-bin/boarddata/boardstats. number of topics and posts read by CGI
Cgi-bin/data/forums Forums. cgi Alliance Forum
Cgi-bin/filecount
8. Database Change operations
1) Add the field oldid (INT) to the end of the topic table)
2) Add the field oldlastpostid (char (50) to the end of the users table ))
3) cancel the active/standby ID Option of the forums table. Remember to switch back after conversion.

9. Configure according to the leo2dnt operation interface, and fill in carefully.
10. Note: The convert button can be used only after the database connection test of SQL is completed!

Converting:
1. The conversion is sequential, which can be individually or in batches;
2.if the program stops running during the conversion process, check the error message in the log file log.txt.
3. The time required for conversion depends on factors such as the size of your data volume, the standards of the data structure, the performance of the platform where the Conversion Program is located, and the network conditions.

After conversion:
1. If the conversion data is incomplete, You can query the conversion log for troubleshooting. The conversion process is irreversible!
2. Move uploadfile, the attachment directory of dvbbs, and all its subdirectories or files to discuz! Do not rename the uploadfile directory under the attachment directory of NT;
3. Transfer non-cgi/avatars from the LEO profile folder to images/avatars/leobbs/
4. Create the leousr folder in the DNT root directory and migrate all the files under non-cgi/usr ***.
5. Set the forums primary key as the ID
6. click the button on the right after conversion, and then log on to the background with the super Administrator Account-Forum maintenance-Forum data maintenance-System Adjustment Forum
7. log on to discuz with the Administrator account! Update Forum statistics and cache in the background of the NT Forum
8. if user data is inaccurate or some user data is missing after conversion, you can use [manual repair user] to fix the problem (make sure that the user's configuration file exists under memberso *** \ old before the fix)
9. (Optional) The oldid field in the topics table is the value of the topic in the URL. You can set 404 with FID to keep the original link valid (create an empty cgi-bin directory under the root directory)
10. Manually migrate other images

Note: The Conversion error log is recorded in log.txt. Some errors do not affect the conversion result. The Conversion Result prevails.

Technical support:
1. If you have any questions, please go to the http://bbs.51aspx.com post for help. Post please note leobbs: database size, number of topics, number of posts, number of users, number of table shards and log error number.
Describe the problem in detail.
2. Author: liudao, 51 aspx (http://www.51aspx.com), here to [play water] of the great help Thank you!

FAQs and solutions:
1. Why does the message "failed to save the Post "?
Solution:
1) You can use the following statement to obtain the maximum PID value in a table. Select max (PID) from dnt_posts1
2) Run DBCC checkident ('dnt _ postid', reseed, 1000) in the SQL version, where 1000 is the maximum ID of dnt_post1
3) Delete the record in dnt_postid and add another record. At this time, you will find that the value of the PID field is 1000.
2. Topic display disorder (display by lastpostid by default)
Modify the dnt_gettopiclist stored procedure and change order by lastpostid to lastpost.
3. When I modify a post, the system always prompts errors such as "object reference is not set to instance ".
Check whether this user exists in the posterid in the corresponding post.

 

[Copy to clipboard] Code:
Select max (PID) from dnt_posts1

Conversion Speed reference
Users 71201
Forum: 107
Topics 57587
Posts 282691
Poll: 865

Conversion time: 1 hour 15 minutes
Environment configuration: cy2.66 1g win2003server