Discuz6.0! info: MySQL Query Error User: dengrenfu
Time: 2008-4-29 8:50am
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,我以前装过一些插件,后来把它给卸啦,才出现上面的情况,我把spece.php把以前的备份覆盖进去还是不行,显示不出个人信息,出现一片空白!
现在怎么解决?
Time: 2008-4-29 8:50am
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,我以前装过一些插件,后来把它给卸啦,才出现上面的情况,我把spece.php把以前的备份覆盖进去还是不行,显示不出个人信息,出现一片空白!
现在怎么解决?
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 th先把这个g去掉再说[align=center]==== 思想重于技巧 ====
[/align]
进去看看我的聊天记录!
FROM (
(
(
(
cdb_members AS m
LEFT JOIN cdb_memberfields mf ON mf.uid = m.uid
)
LEFT JOIN cdb_usergroups AS u ON u.groupid = m.groupid
)
LEFT JOIN cdb_ranks AS r ON m.posts >= r.postshigher
)
LEFT JOIN cdb_pig AS p ON p.userb = m.username
)
LEFT JOIN cdb_onlinetime AS o ON o.uid = m.uid
WHERE m.uid = '49616'
LIMIT 0 , 30
用这样写才可以运行!
现在怎么修改数据库,使得正常显示出来
[/align]
[/align]
是是不是spase.php这个?
<?php/*
[Discuz!] (C)2001-2007 Comsenz Inc.
This is NOT a freeware, use is subject to license terms $Id: space.php 10115 2007-08-24 00:58:08Z cnteacher $
*/define('CURSCRIPT', 'space');
require_once './include/common.inc.php';$discuz_action = 150;$querystring = explode('/', $_SERVER['QUERY_STRING']);
$uid = !empty($uid) ? intval($uid) : intval($querystring[0]);
$username = !isset($username) || $uid ? '' : $username;
$mod = !empty($mod) ? $mod : $querystring[1];
$starttime = !empty($starttime) ? intval($starttime) : intval($querystring[2]);
$endtime = !empty($endtime) ? intval($endtime) : intval($querystring[3]);
$multipage = $titleextra = '';
$menulist = $modulelist = array();$action = $inajax ? 'viewpro' : $action;
if(!empty($action) && $action == 'viewpro') {
require_once DISCUZ_ROOT.'./include/viewpro.inc.php';
}if(!$mod || $mod == 'myblogs') {
require_once DISCUZ_ROOT.'./include/discuzcode.func.php';
}
require_once DISCUZ_ROOT.'./include/space.func.php';
include_once DISCUZ_ROOT.'./forumdata/cache/cache_forums.php';
include_once language('spaces');$query = $db->query("SELECT m.*, mf.*, s.lastactivity as online
FROM {$tablepre}members m
LEFT JOIN {$tablepre}memberfields mf ON mf.uid=m.uid
LEFT JOIN {$tablepre}sessions s ON s.uid=m.uid AND s.invisible='0'
WHERE ".($uid ? "m.uid='$uid'" : "m.username='$username'")." LIMIT 1");
if(!$member = $db->fetch_array($query)) {
showmessage('member_nonexistence');
}$uid = $member['uid'];if($spacestatus && $supe['status'] && $member['xspacestatus']) {
dheader("location: $supe[siteurl]?uid/$uid");
}if(!$spacestatus || in_array($member['groupid'], array(4, 5, 6))) {
dheader("location: {$boardurl}space.php?action=viewpro&uid=$uid");
}$spacesettings = getspacesettings($uid);if(!empty($preview) && $uid == $discuz_uid) {
$spacesettings['layout'] = explode('|', $preview);
$spacesettings['side'] = intval($spaceside);
} else {
$spacesettings['layout'] = explode("\t", $spacesettings['layout']);
}
if(!empty($style)) {
$spacesettings['style'] = str_replace('/', '', $style);
if(!file_exists(DISCUZ_ROOT.'./mspace/'.$spacesettings['style'].'/style.ini')) {
showmessage('space_style_nofound', NULL, 'HALTED');
}
}$layout = $moduledata = array();
foreach($spacesettings['layout'] as $k => $layoutitem) {
$layout[$k] = explode('][', ']'.$layoutitem.'[');
$layout[$k] = array_slice($layout[$k], 1, count($layout[$k]) - 2);
$newlayout = array();
foreach($layout[$k] as $module) {
if(array_key_exists($module, $modulesettings)) {
$newlayout[] = $module;
}
}
$layout[$k] = $newlayout;
$modulelist = array_merge($modulelist, $layout[$k]);
}if(!empty($mod) && array_key_exists($mod, $listmodule)) {
if(!intval($spacedata['limit'.$mod]) || !in_array($mod, $modulelist)) {
if($mod == 'mytrades' && intval($spacedata['limit'.$mod])) {
$modulelist[] = 'mytrades';
$spacesettings['layout'][1] .= '[mytrades]';
$spacesettings['layout'] = daddslashes($spacesettings['layout'], 1);
$db->query("UPDATE {$tablepre}memberspaces SET layout='".$spacesettings['layout'][0]."\t".$spacesettings['layout'][1]."\t".$spacesettings['layout'][2]."' WHERE uid='$uid'");
} else {
dheader("location: {$boardurl}space.php?uid=$uid");
}
}
if($spacesettings['side'] == 1) {
$side = 0;
} elseif($spacesettings['side'] == 2) {
$side = 2;
} else {
$side = 0;
$spacesettings['side'] = 1;
}
$layout[$side] = array('userinfo');
$layout[1] = array($mod);
$titleextra = ' - '.$spacelanguage[$mod];
$moduledata[$mod]['value'] = updatespacecache($uid, $mod, TRUE);
if($mod == 'myblogs') {
$layout[$side][] = 'calendar';
if($discuz_uid && $uid == $discuz_uid && $allowpost && $allowuseblog) {
require_once DISCUZ_ROOT.'./include/forum.func.php';
$forumselect = forumselect();
if($discuz_uid == $uid) {
$layout[$side][] = 'postblog';
}
}
$layout[$side][] = 'hotblog';
$layout[$side][] = 'lastpostblog';
$hotblog = spacecaches($uid, array('hotblog', 'lastpostblog'));
$moduledata = array_merge($moduledata, $hotblog);
} elseif($mod == 'mytrades') {
$layout[$side][] = 'mytradetypes';
$layout[$side][] = 'tradeinfo';
if(!isset($tradetypeid)) {
$layout[1][] = 'mycounters';
$moduledata['mycounters']['value'] = updatespacecache($uid, 'mycounters', TRUE);
}
$tmp = spacecaches($uid, 'mytradetypes');
$moduledata['mytradetypes']['value'] = $tmp['mytradetypes']['value'];
$moduledata['tradeinfo']['value'] = $member;
}
} else {
$moduledata = spacecaches($uid, $modulelist);
}foreach($modulelist as $module) {
if(array_key_exists($module, $listmodule) && intval($spacedata['limit'.$module])) {
$menulist[$listmodule[$module]] = $module;
}
}
ksort($menulist);$moduledata['userinfo']['value'] = $member;include template('space_module');
include template('space');?>
Time: 2008-4-29 8:50am
Script: bbs/space.php 要这个文件。[align=center]==== 思想重于技巧 ====
[/align]
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 members m
LEFT JOIN memberfields mf ON mf.uid=m.uid
LEFT JOIN usergroups u ON u.groupid=m.groupid
LEFT JOIN ranks r ON m.posts>=r.postshigher
LEFT JOIN pig p ON p.userb=m.username
LEFT JOIN onlinetime o ON o.uid=m.uid
WHERE m.uid='49616' ORDER BY r.postshigher DESC LIMIT 1
如果是PHP脚本。看看[table]在哪个文件里面定义了。是不是没有require进来。