急救论坛个人信息出错?

dengrenfu

UID: 22704
帖子: 2
积分: 2
在线时间: 1小时
注册时间: 2008-04-28
最后登录: 2008-07-07

1^# dengrenfu 发表于2008-04-28

急救论坛个人信息出错?

Discuz! info: MySQL Query Error

User: dengrenfu
Time: 2008-4-28 5:27pm
Script: /bbs/space.php

SQL: SELECT m.*, mf.*, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM [Table]members m
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
LEFT JOIN [Table]usergroups u ON u.groupid=m.groupid
LEFT JOIN [Table]ranks r ON m.posts>=r.postshigher
LEFT JOIN [Table]pig p ON p.userb=m.username
g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1
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 'g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.po' at line 9
Errno.: 1064

Similar error report has beed dispatched to administrator before.

我不是鱼

UID: 2
帖子: 1402
积分: 3221
在线时间: 2077小时
注册时间: 2006-05-16
最后登录: 2019-01-15

2^# 我不是鱼发表于2008-04-28

怎样操作出现这种情况？

如履薄冰

dengrenfu

UID: 22704
帖子: 2
积分: 2
在线时间: 1小时
注册时间: 2008-04-28
最后登录: 2008-07-07

3^# dengrenfu 发表于2008-04-28

急救论坛个人信息出错?

急救论坛个人信息出错?

Discuz! info: MySQL Query Error

User: dengrenfu
Time: 2008-4-28 5:27pm
Script: /bbs/space.php

SQL: SELECT m.*, mf.*, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM [Table]members m
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
LEFT JOIN [Table]usergroups u ON u.groupid=m.groupid
LEFT JOIN [Table]ranks r ON m.posts>=r.postshigher
LEFT JOIN [Table]pig p ON p.userb=m.username
g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1
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 'g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.po' at line 9
Errno.: 1064

Similar error report has beed dispatched to administrator before.