Discuz!官方免费开源建站系统

 找回密码
 立即注册
搜索

[疑问] 急求求大家帮忙-数据库个人信息出错代码如下

[复制链接]
dengrenfu 发表于 2008-4-29 13:51:59 | 显示全部楼层 |阅读模式
急求求大家帮忙-数据库个人信息出错代码如下!
Discuz! info: MySQL Query Error
dengrenfu189@163.com
User: dengrenfu
Time: 2008-4-29 1:34pm
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.
如果有谁知道?
加我QQ:289625925与我联系!谢谢大家!
回复

使用道具 举报

桃子(小敏) 发表于 2008-4-29 15:42:00 | 显示全部楼层
sql语句有语法错误
操作了什么后出现的这个问题呢?
回复

使用道具 举报

 楼主| dengrenfu 发表于 2008-4-29 19:30:39 | 显示全部楼层
没怎么操作啊·
我也不怎么清楚·
论坛个人信息显示不出来·
我用的是DISCUZ6.0的?
如果想更清楚的了解,你可以进http://ttbn.cc/bbs/
注册一个用户,在查看个人信息就会出现:Discuz! info: MySQL Query Error
dengrenfu189@163.com
User: dengrenfu
Time: 2008-4-29 1:34pm
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
回复

使用道具 举报

白乐天 发表于 2008-4-29 19:37:34 | 显示全部楼层
你装的插件把默认文件修改的有问题。用安装包里的原版space.php覆盖掉论坛上的。
回复

使用道具 举报

 楼主| dengrenfu 发表于 2008-4-30 08:54:33 | 显示全部楼层

那现在怎么改啦?

现在怎么改啦·
要保留原来的所有的信息和用户记录!
回复

使用道具 举报

 楼主| dengrenfu 发表于 2008-4-30 17:25:00 | 显示全部楼层

我恢复了可是比以前更糟

我恢复了可是比以前更糟,什么也无法访问,个人空间也打不开了啦·
回复

使用道具 举报

 楼主| dengrenfu 发表于 2008-4-30 20:37:21 | 显示全部楼层

怎么解决啊?

有谁知道啊 ?
回复

使用道具 举报

 楼主| dengrenfu 发表于 2008-5-1 10:35:20 | 显示全部楼层

急求求大家帮忙-数据库个人信息出错代码如下!

结果就是这样:急求求大家帮忙-数据库个人信息出错代码如下!  
Discuz! info: MySQL Query Error  
dengrenfu189@163.com   
User: dengrenfu  
Time: 2008-4-29 1:34pm  
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.  
如果有谁知道?  
加我QQ:289625925与我联系!谢谢大家!
回复

使用道具 举报

 楼主| dengrenfu 发表于 2008-5-3 13:02:25 | 显示全部楼层

是不是这个php代码有问题?spase.php

是哪个文件的原代码啊 !
是是不是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');

?>
回复

使用道具 举报

白乐天 发表于 2008-5-3 13:28:26 | 显示全部楼层
未修改过就不会有问题,我点了一个会员名字,显示正常啊。
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2025-9-15 08:33 , Processed in 0.105397 second(s), 14 queries , Gzip On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表