装maxspeeds风格错误 数据库出错

在一个新安装的论坛上成功安装.


但在一个老论坛上首页出错..谁能帮我看看是那里问题..谢了

1. Discuz! info: MySQL Query Error
   
2. 
   
3. User: admin
   
4. Time: 2007-12-31 9:01am
   
5. Script: /BBS/index.php
   
6. 
   
7. SQL: (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='13' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='28' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='7' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='10' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='22' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='43' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='32' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='11' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='30' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='31' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='34' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='14' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='8' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='23' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='25' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='47' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='33' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='26' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='9' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='21' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='38' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='36' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='17' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='24' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='42' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='46' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='27' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='35' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='41' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='4' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='15' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='20' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='2' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='37' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='18' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='16' ORDER BY t.dateline DESC LIMIT 5)
   
8. Error: You have an error in your SQL syntax near '(SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid W' at line 1
   
9. Errno.: 1064

复制代码

程序版本如下:

论坛程序版本 Discuz! 6.0.0 Release 20070904 [ 查看最新版本 ]
操作系统及 PHP WINNT / PHP v4.4.7
MySQL 版本 3.23.58-nt
上传许可 0.5M
当前数据库尺寸 27.6 MB

但装在另一个论坛却是好好的..如下

论坛程序版本 Discuz! 6.0.0 Release 20070828 [ 查看最新版本 ]
操作系统及 PHP WINNT / PHP v4.4.7
MySQL 版本 4.0.27-nt
上传许可 2M
当前数据库尺寸 282.25 KB

有朋友说是MYSQL 3.23不支持这句SQL

index.php如下

我的数据库都被这个风格搞坏了。。。·！！·！

我晕.不是这么严重吧.

是直接覆盖的吗？

是的.直接复盖.

一复盖就不行.换回原装的都可以..

看起来很危险哦！！