求助:安装新的风格后，首页出现数据库错误！

安装新的风格后首页出现问题

MySQL Error
Message: MySQL Query Error
SQL: SELECT a.uid,a.username,a.name,a.namestatus,b.uid,b.doid,b.message,b.dateline FROM uchome_space a, uchome_doing b where a.uid=b.uid and a.updatetime>'' and b.doid in (select max(doid) from uchome_doing b group by b.uid) ORDER BY b.dateline DESC LIMIT 0,3
Error: You have an error in your SQL syntax near 'select max(doid) from uchome_doing b group by b.uid) ORDER BY b.dateline DESC LI' at line 1
Errno.: 1064

其他页面都能正常显示，就是首页出现数据库错误，这是什么问题呀？？   请求大家帮忙

你在哪里下载的新风格？SQL语有问题

你的mysql是哪个版本的

你的那个报错的sql我在我的机子上测试了一下可以查出数据来

你可以尝试进phpmyadmin里面运行一下那个sql语句

我是运行aimi的那个友情链接的插件--city_install.php
这是那个代码文件，这哪里问题呀

<?php
include_once('./common.php');

if(file_exists('./data/city_install.lock')) showmessage('您已经安装过了，若要重新安装，请先删除data/city_install.lock！', 'index.php', 3);

$charset = str_replace('-', '', $_SC['charset']);
$extend = $_SGLOBAL['db']->version() > '4.1' ? " DEFAULT CHARSET={$charset} " : "";

$sql[] = "ALTER TABLE `uchome_spacefield` ADD `birthsubcity` VARCHAR( 20 ) NOT NULL default '' AFTER `birthcity`";
$sql[] = "ALTER TABLE `uchome_spacefield` ADD `residesubcity` VARCHAR( 20 ) NOT NULL default '' AFTER `residecity`";
$sql[] = "ALTER TABLE `uchome_event` ADD `subcity` VARCHAR( 20 ) NOT NULL default '' AFTER `city`";
$sql[] = "ALTER TABLE `uchome_mtag` ADD `resideprovince` VARCHAR( 20 ) NOT NULL default '' AFTER `fieldid`";
$sql[] = "ALTER TABLE `uchome_mtag` ADD `residecity` VARCHAR( 20 ) NOT NULL default '' AFTER `fieldid`";

foreach($sql as $val){
        $_SC['tablepre'] != 'uchome_' && $val = str_replace("`uchome_", '`'. $_SC['tablepre'], $val);
        $_SGLOBAL['db']->query($val);
}

swritefile('data/city_install.lock', $_SERVER['REQUEST_TIME']);
showmessage('恭喜你，安装成功！接下来更新缓存就可以了', 'admincp.php', 2);

?>

我选择重新升级，说“字段重复”！

((em:07)) ((em:07))