SS7.0升级7.5失败，求助！求助！求助！

SupeSite info: MySQL Query Error

User: guest
Time: 2010-1-14 5:14pm
Script: /update.php

SQL: INSERT INTO [Table]clickuser (uid, username, id, idtype, clickid, groupid, dateline, ip) VALUES ('0', 'Guest', '102', 'items', '32', '5', '1260232208', '58.214.6.26'),('0', 'Guest', '223', 'items', '32', '5', '1260533482', '123.181.236.229'),('0', 'Guest', '223', 'items', '32', '5', '1261571845', '219.234.81.118'),('0', 'Guest', '223', 'items', '32', '5', '1261642161', '222.216.2.142'),('0', 'Guest', '223', 'items', '32', '5', '1261743545', '222.93.68.80'),('0', 'Guest', '223', 'items', '32', '5', '1261809689', '113.115.38.216'),('0', 'Guest', '223', 'items', '32', '5', '1261820622', '116.227.67.99'),('0', 'Guest', '223', 'items', '32', '5', '1262403160', '59.62.244.167'),('0', 'Guest', '223', 'items', '32', '5', '1262436100', '221.182.46.90'),('0', 'Guest', '223', 'items', '32', '5', '1262948234', '123.168.248.247'),('0', 'Guest', '223', 'items', '32', '5', '1262968849', '124.225.10.111'),('0', 'Guest', '223', 'items', '32', '5', '1263002654', '58.255.201.223'),('0', 'Guest', '223', 'items', '32', '5', '1263089090', '218.16.44.183'),('0', 'Guest', '223', 'items', '32', '5', '1263110930', '125.67.36.165'),('0', 'Guest', '223', 'items', '32', '5', '1263117120', '218.4.198.202'),('0', 'Guest', '223', 'items', '32', '5', '1263129163', '121.14.246.173'),('0', 'Guest', '223', 'items', '32', '5', '1263381857', '122.225.55.12'),('0', 'Guest', '226', 'items', '30', '5', '1261592849', '202.99.222.227'),('0', 'Guest', '227', 'items', '32', '5', '1261991287', '125.46.41.11'),('0', 'Guest', '229', 'items', '30', '5', '1260832473', '123.153.104.51'),('0', 'Guest', '229', 'items', '26', '5', '1262190703', '60.54.253.61'),('0', 'Guest', '275', 'items', '32', '5', '1261926499', '60.164.110.39'),('0', 'Guest', '320', 'items', '32', '5', '1259924284', '220.181.109.7'),('0', 'Guest', '320', 'items', '32', '5', '1259936616', '219.136.136.74'),('0', 'Guest', '320', 'items', '32', '5', '1260064081', '61.129.190.226'),('0', 'Guest', '320', 'items', '32', '5', '1261799409', '222.64.26.150'),('8928', 'wscyq1', '320', 'items', '32', '5', '1261894643', '220.165.3.219'),('0', 'Guest', '320', 'items', '30', '5', '1262659997', '58.214.25.210'),('0', 'Guest', '456', 'items', '32', '5', '1261038689', '220.176.92.16'),('0', 'Guest', '456', 'items', '28', '5', '1261468936', '59.45.244.134'),('0', 'Guest', '456', 'items', '22', '5', '1261805231', '113.24.134.146'),('0', 'Guest', '456', 'items', '32', '5', '1263207116', '124.132.117.83'),('0', 'Guest', '572', 'items', '26', '5', '1260718762', '202.105.168.217'),('0', 'Guest', '572', 'items', '28', '5', '1260755673', '222.190.124.185'),('0', 'Guest', '572', 'items', '26', '5', '1260757911', '120.15.92.57'),('0', 'Guest', '594', 'items', '24', '5', '1260498404', '124.173.182.252'),('0', 'Guest', '594', 'items', '30', '5', '1261447870', '123.148.55.122'),('0', 'Guest', '594', 'items', '22', '5', '1263191247', '220.171.198.111'),('0', 'Guest', '595', 'items', '32', '5', '1263199258', '117.88.74.70'),('0', 'Guest', '663', 'items', '30', '5', '1260827090', '113.88.213.216'),('0', 'Guest', '663', 'items', '22', '5', '1260888752', '60.215.8.6'),('8928', 'wscyq1', '663', 'items', '32', '5', '1261374532', '220.165.3.219'),('2141', '87486108', '663', 'items', '28', '5', '1261387562', '116.21.59.161'),('0', 'Guest', '663', 'items', '32', '5', '1261533803', '61.134.127.130'),('0', 'Guest', '663', 'items', '32', '5', '1261722426', '119.184.46.94'),('0', 'Guest', '719', 'items', '22', '5', '1262660621', '122.156.57.6'),('0', 'Guest', '741', 'items', '32', '5', '1262582738', '58.42.6.30'),('10300', 'N'T', '1156', 'items', '32', '5', '1253932580', '123.121.236.76'),('1269', 'Mel', '1159', 'items', '22', '5', '1252463342', '60.216.192.106'),('0', 'Guest', '1159', 'items', '22', '5', '1258290627', '119.0.156.149')
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 'T', '1156', 'items', '32', '5', '1253932580', '123.121.236.76'),('1269', 'Mel', ' at line 1
Errno.: 1064

mysql是那个版本的、

数据库版本 MySQL client version: 5.0.45

这个sql是中有特殊字符导致的，在update.php文件中找到下面一句：

1. 
   
2. $setclickuservalue[] = "'$value[authorid]', '$value[author]', '$value[itemid]', 'items', '{$clickidarr[$value['rates']]}', '5', '$value[dateline]', '$value[ip]'";        //uid, username, id, idtype, clickid, groupid, dateline, ip
   

复制代码

在前面加上一句：

1. 
   
2. $value[author] = saddslashes($value[author]);
   

复制代码