Discuz论坛2.5 升级到PHP MySQL新版遇到的问题

1
中文问题,在使用MySQL实例配置工具的使用,将使用的字符集设置为GBK,而不要设置为UTF-82
MySQL安装后密码无法访问问题:mysql SET PASSWORD FOR – ‘some_user’@’some_host’ =
OLD_PASSWORD(‘newpwd’);3
PHP有Warning在php.ini里面找到bug_combat_warning = 1 两行,1 改成 04
MySQL
对SQL插入实行更强的格式检查.所以如果某个列是整数,就不能使用''来插入.因此修改Discuz的一个函数如下function
updatesession() { if(empty($GLOBALS[‘sessionupdated’])) { global $db,
$sessionexists, $sessionupdated, $sid, $onlineip, $discuz_uid,
$discuz_user, $timestamp, $groupid, $styleid, $invisible,
$discuz_action, $fid, $tid, $onlinehold, $logincredits,
$table_sessions, $table_members, $user_lastactivity, $onlinehold;
if($sessionexists == 1) { $db-query(“UPDATE $table_sessions SET
uid=’$discuz_uid’, username=’$discuz_user’, groupid=’$groupid’,
styleid=’$styleid’, invisible='” . ($invisible==””?0:1) . “‘,
action=’$discuz_action’, lastactivity=’$timestamp’, fid='” .
($fid==””?0:1) . “‘, tid='” . ($tid==””?0:1) . “‘ WHERE sid=’$sid'”); if
($onlinehold $user_lastactivity $timestamp – $user_澳门新葡亰网站注册,lastactivity
$onlinehold) { $db-query(“UPDATE $table_members SET
lastvisit=lastactivity, lastactivity=$timestamp WHERE
uid=’$discuz_uid'”, ‘UNBUFFERED’); } } else { $ips = explode(‘.’,
$onlineip); $db-query(“DELETE FROM $table_sessions WHERE sid=’$sid’ OR
lastactivity($timestamp-$onlinehold) OR (‘$discuz_uid”0′ AND
uid=’$discuz_uid’) OR (uid=’0′ AND ip1=’$ips[0]’ AND ip2=’$ips[1]’
AND ip3=’$ips[2]’ AND ip4=’$ips[3]’ AND
lastactivity$timestamp-60)”); $db-query(“INSERT INTO $table_sessions
(sid, ip1, ip2, ip3, ip4, uid, username, groupid, styleid, invisible,
action, lastactivity, fid, tid) VALUES (‘$sid’, ‘$ips[0]’,
‘$ips[1]’, ‘$ips[2]’, ‘$ips[3]’, ‘$discuz_uid’, ‘$discuz_user’,
‘$groupid’, ‘$styleid’, ‘” . ($invisible==””?0:1) . “‘,
‘$discuz_action’, ‘$timestamp’, ‘” . ($fid==””?0:1) . “‘, ‘” .
($tid==””?0:1) . “‘)”); if($discuz_uid) { $db-query(“UPDATE
$table_members SET credit=credit “.intval($logincredits).”,
lastip=’$onlineip’, lastvisit=lastactivity, lastactivity=$timestamp
WHERE uid=’$discuz_uid'”, ‘UNBUFFERED’); } } $sessionupdated = 1; }}