[发布]Discuz6.1论坛合并工具（08.07.05更新）

1. #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '20081028.cdb_threads' at line 1
   
2. 
   
3. #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '20081028.cdb_members where username like '%\_2'
   
4. union
   
5. select username from' at line 1

复制代码

升级了MySQL5,不知道是什么原因？

#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '20081028.cdb_threads' at line 1

#42000You have an error  ...
liush 发表于 2008-11-3 02:07

数据库名字不能用数字。你换字母名字再合。

我合并了出现问题！

#HY000Incorrect string value: '\xD6\xB8\xEE\xCF\xDF' for column 'username' at row 1

#HY000Incorrect string value: '\xD6\xB8\xEE\xCF\xDF' for column 'filename' at row 1

#HY000Incorrect string value: '\xD6\xB8\xEE\xCF\xDF' for column 'author' at row 1

#HY000Field 'message' doesn't have a default value

#HY000Field 'simple' doesn't have a default value

#HY000Field 'message' doesn't have a default value

#HY000Field 'voterids' doesn't have a default value

#HY000Field 'buyercredit' doesn't have a default value
memberfields

#HY000Field 'keywords' doesn't have a default value
forumfields

#HY000Field 'special' doesn't have a default value
threadtypes


论坛2的神游用户登录都不正常了，比如弟100的用户登录进来变为论坛1+100的那个用户了，而且大部分不能登录的。

我合并了出现问题！

#HY000Incorrect string value: '\xD6\xB8\xEE\xCF\xDF' for column 'username' at row 1

#HY000Incorrect string value: '\xD6\xB8\xEE\xCF\xDF' for column 'filename' at row 1

#HY0 ...
heanyu 发表于 2008-11-11 21:00

打开my.ini，查找
sql-mode="STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

修改为
sql-mode="NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

然后重起mysql服务。

分别恢复两论坛与两UC的数据，再合并一次。

这个好

以后会用得着的

呵呵……
支持支持！！

我只想合并UC 但是论坛还是各自的论坛 吧两个甚至更多论坛都作为UC里的一个应用 可以吗

我只想合并UC 但是论坛还是各自的论坛 吧两个甚至更多论坛都作为UC里的一个应用 可以吗
不要因为85 发表于 2008-11-29 20:47

这个工具是做不到你的需求的，不过近日会写一个UC合并工具发给大家用。

那个合并工具无法下载

只能合并论坛数据，那UC的怎么办？