MYSQL4.01安装杏雨烟花争车位插件的新问题

https://discuz.dismall.com/thread-1096451-1-2.html

之前在这个帖子里提了安装之后的问题

刚才　安装这个帖子
https://discuz.dismall.com/thread-1094605-1-2.html

进行了修改

现在可以进入到游戏界面了　　但是点好友的车辆记录

MySQL Error
Message: MySQL Query Error
SQL: SELECT * FROM uchome_feed WHERE uid in (select uid from uchome_friend where fuid=172) and icon='park' ORDER BY dateline DESC LIMIT 0,10
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select uid from uchome_friend where fuid=172) and icon='park'
Errno.: 1064
Click here to seek help.

出现上面这个ＭＹＳＱＬ错误提示






点排行榜　出现下面的错误提示

MySQL Error
Message: MySQL Query Error
SQL: SELECT *,(select sum(c.carprice) from uchome_park_carinfo c,uchome_park_mycar m where c.carid=m.carid and m.uid=p.uid group by m.uid) as carprice,(select count(*) from uchome_park_mycar where uid=s.uid) as carnum FROM uchome_space s ,uchome_park_member p WHERE s.uid=p.uid order by carprice desc LIMIT 0,20
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select sum(c.carprice) from uchome_park_carinfo c,uchome_park_m
Errno.: 1064
Click here to seek help.




另外　右侧边好友列表里出现同一个好友的名字　１０几个　　　还出现自己的名字




问题测试地址　：

http://my.0751.cc/　　测试帐号　　　baidu     密码　123456


请高手继续帮忙解决　ＭＹＳＱＬ　４.０１的问题　

还是先升级MYSQL版本～

还是先升级MYSQL版本～
立刻计划 发表于 2008-11-2 16:47

升级数据库太麻烦了

ＵＣ　　　ＵＣＨ　　ＤＩＳＣＵＺ　　３个程序都装在同一服务器里

还有ＵＣ升级数据库后　这个好麻烦　　

...................................

出了问题,现在看不到画面了,怎么回事?

出了问题,现在看不到画面了,怎么回事?
bylaohui 发表于 2008-11-2 23:23

?

什么　？