採集過程出現 Error: You have an error in your SQL syntax.

採到一半卡住了

錯誤訊息內容：

1. [174] [想做高手先練的基本功] 處理標題完成
   
2. [174] 處理內容完成
   
3. 
   
4. SupeSite info: MySQL Query Error
   
5. 
   
6. User: admin
   
7. Time: 2008-3-6 12:21pm
   
8. Script: /ss60/admincp.php
   
9. 
   
10. SQL: INSERT INTO [Table]robotitems (uid, username, robotid, robottime, subject) VALUES ('1', 'admin', '4', '1204777297', '想做高手先練的基本功\')
    
11. 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 ''想做高手先練的基本功\')' at line 1
    
12. Errno.: 1064

复制代码

應是BIG5編碼處理沒做好，標題的最後一個字剛好需要編碼。(功\)
但不知如何解決？
知道的煩請告知，3Q

将采集规则发出来看看

原帖由 茄子 于 2008-3-7 09:47 发表
将采集规则发出来看看

第一次採正常 第二次以後就出現問題了

1. # SupeSite Dump
   
2. # Version: SupeSite 6.0Final
   
3. # Time: 2008-03-07 21:32:26
   
4. # From: SupeSite/X-Space社區門戶 (http://localhost/ss60)
   
5. #
   
6. # This file was BASE64 encoded
   
7. #
   
8. # SupeSite: http://www.supesite.com
   
9. # Please visit our website for latest news about SupeSite
   
10. # --------------------------------------------------------
    
11. 
    
12. 
    
13. YTo1MDp7czo3OiJyb2JvdGlkIjtzOjE6IjUiO3M6NDoibmFtZS
    
14. I7czo0OiJ0ZXN0IjtzOjM6InVpZCI7czoxOiIxIjtzOjg6ImRh
    
15. dGVsaW5lIjtzOjEwOiIxMjA0ODk2NjM0IjtzOjg6Imxhc3R0aW
    
16. 1lIjtzOjEwOiIxMjA0ODk2NzE4IjtzOjExOiJpbXBvcnRjYXRp
    
17. ZCI7czoxOiIwIjtzOjg6InJvYm90bnVtIjtzOjE6IjYiO3M6MT
    
18. E6Imxpc3R1cmx0eXBlIjtzOjM6Im5ldyI7czo3OiJsaXN0dXJs
    
19. IjtzOjkwOiJhOjI6e3M6NjoibWFudWFsIjthOjE6e2k6MDtzOj
    
20. M1OiJodHRwOi8vd3d3LnR3MTAxLm5ldC90ZXN0L2luZGV4Lmh0
    
21. bSI7fXM6NDoiYXV0byI7czowOiIiO30iO3M6MTM6Imxpc3RwYW
    
22. dlc3RhcnQiO3M6MToiMCI7czoxMToibGlzdHBhZ2VlbmQiO3M6
    
23. MToiMCI7czoxMjoicmV2ZXJzZW9yZGVyIjtzOjE6IjAiO3M6Nj
    
24. oiYWxsbnVtIjtzOjM6IjEwMCI7czo2OiJwZXJudW0iO3M6MToi
    
25. MSI7czo3OiJzYXZlcGljIjtzOjE6IjAiO3M6NjoiZW5jb2RlIj
    
26. tzOjQ6ImJpZzUiO3M6MTM6InBpY3VybGxpbmtwcmUiO3M6MDoi
    
27. IjtzOjk6InNhdmVmbGFzaCI7czoxOiIwIjtzOjE0OiJzdWJqZW
    
28. N0dXJscnVsZSI7czowOiIiO3M6MTg6InN1YmplY3R1cmxsaW5r
    
29. cnVsZSI7czoxNjoiPGEgaHJlZj0iW3VybF0iPiI7czoxNzoic3
    
30. ViamVjdHVybGxpbmtwcmUiO3M6MjY6Imh0dHA6Ly93d3cudHcx
    
31. MDEubmV0L3Rlc3QvIjtzOjExOiJzdWJqZWN0cnVsZSI7czoyNj
    
32. oiPHRpdGxlPltzdWJqZWN0XaVcPC90aXRsZT4iO3M6MTM6InN1
    
33. YmplY3RmaWx0ZXIiO3M6MDoiIjtzOjE0OiJzdWJqZWN0cmVwbG
    
34. FjZSI7czowOiIiO3M6MTY6InN1YmplY3RyZXBsYWNldG8iO3M6
    
35. MDoiIjtzOjEwOiJzdWJqZWN0a2V5IjtzOjA6IiI7czoxODoic3
    
36. ViamVjdGFsbG93cmVwZWF0IjtzOjE6IjEiO3M6MTI6ImRhdGVs
    
37. aW5lcnVsZSI7czowOiIiO3M6ODoiZnJvbXJ1bGUiO3M6MDoiIj
    
38. tzOjEwOiJhdXRob3JydWxlIjtzOjA6IiI7czoxMToibWVzc2Fn
    
39. ZXJ1bGUiO3M6MzA6Ijx0ZCB3aWR0aD0iNzQ1Ij5bbWVzc2FnZV
    
40. 08L3RkPiI7czoxMzoibWVzc2FnZWZpbHRlciI7czowOiIiO3M6
    
41. MTU6Im1lc3NhZ2VwYWdldHlwZSI7czo0OiJwYWdlIjtzOjE1Oi
    
42. JtZXNzYWdlcGFnZXJ1bGUiO3M6MDoiIjtzOjE4OiJtZXNzYWdl
    
43. cGFnZXVybHJ1bGUiO3M6MDoiIjtzOjIxOiJtZXNzYWdlcGFnZX
    
44. VybGxpbmtwcmUiO3M6MDoiIjtzOjE0OiJtZXNzYWdlcmVwbGFj
    
45. ZSI7czowOiIiO3M6MTY6Im1lc3NhZ2VyZXBsYWNldG8iO3M6MD
    
46. oiIjtzOjg6ImF1dG90eXBlIjtzOjE6IjEiO3M6MTE6IndpbGRj
    
47. YXJkbGVuIjtzOjE6IjAiO3M6MjA6InN1YmplY3R1cmxsaW5rY2
    
48. FuY2VsIjtzOjA6IiI7czoyMDoic3ViamVjdHVybGxpbmtmaWx0
    
49. ZXIiO3M6MDoiIjtzOjE2OiJzdWJqZWN0dXJsbGlua3BmIjtzOj
    
50. A6IiI7czoxNjoic3ViamVjdGtleWNhbmNlbCI7czowOiIiO3M6
    
51. MTA6Im1lc3NhZ2VrZXkiO3M6MDoiIjtzOjE2OiJtZXNzYWdla2
    
52. V5Y2FuY2VsIjtzOjA6IiI7czoxMzoibWVzc2FnZWZvcm1hdCI7
    
53. czoxOiIxIjtzOjIwOiJtZXNzYWdlcGFnZXVybGxpbmtwZiI7cz
    
54. owOiIiO3M6NzoidWlkcnVsZSI7czowOiIiO3M6NzoidmVyc2lv
    
55. biI7czo4OiI2LjBGaW5hbCI7fQ==

复制代码

錯誤訊息如下：

1. [2] [採集採集採集 採集採集採集 蓋] 處理標題完成
   
2. [2] 處理內容完成
   
3. 
   
4. SupeSite info: MySQL Query Error
   
5. 
   
6. User: admin
   
7. Time: 2008-3-7 9:34pm
   
8. Script: /ss60/admincp.php
   
9. 
   
10. SQL: INSERT INTO [Table]robotitems (uid, username, robotid, robottime, subject) VALUES ('1', 'admin', '5', '1204896898', '採集採集採集 採集採集採集 蓋\')
    
11. 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 ''採集採集採集 採集採集採集 蓋\')' at line 1
    
12. Errno.: 1064
    

复制代码

我这里采集正常的
将您的ss地址、管理员帐号
phpmyadmin地址、登录帐号
ftp地址、登录帐号、ss文件路径给我
我检查下