[問題] 在po文時，無法發表文章，請幫我!qq

文章由 **slyunchen** » 2005-10-07 00:17

●架設主機作業系統：Windows Xp Pro (sp2版)
●快速架站程式：無
●您的上網方式：Hinet ADSL 2M/512k
●您安裝的程式：IIS 5.1 + php 4.4.0 + MS SQL 2000
●您的 phpBB2 版本：phpBB 2.0.17
●您的 domain(網域名稱) ：127.0.0.1
●錯誤狀態：基本上短篇的文章(不超過2行字吧)，還可以po文。但我經連結http://phpbb-tw.net/phpbb/viewtopic.php?t=18116此篇文章，想要將5種語言文字試po，預覽的時候可以看，但送出後會出現錯誤。
p.s先前有爬文http://phpbb-tw.net/phpbb/viewtopic.php?t=35623，不過沒有更新完全修正檔。
不知問題出在sql資料庫語法錯誤，還是多國語言修正檔不完全呢?可以幫幫我嗎
●錯誤代碼：

代碼: 選擇全部

Could not insert new word

DEBUG MODE

SQL Error : 遺漏字元字串 ', 0' 前面的引號。

INSERT INTO phpbb_search_wordlist (word_text, word_common) SELECT '330', 0 UNION ALL SELECT '1548', 0 UNION ALL SELECT '1569', 0 UNION ALL SELECT '1571', 0 UNION ALL SELECT '1573', 0 UNION ALL SELECT '1574', 0 UNION ALL SELECT '1575', 0 UNION ALL SELECT '1576', 0 UNION ALL SELECT '1577', 0 UNION ALL SELECT '1578', 0 UNION ALL SELECT '1579', 0 UNION ALL SELECT '1580', 0 UNION ALL SELECT '1581', 0 UNION ALL SELECT '1583', 0 UNION ALL SELECT '1584', 0 UNION ALL SELECT '1585', 0 UNION ALL SELECT '1586', 0 UNION ALL SELECT '1587', 0 UNION ALL SELECT '1588', 0 UNION ALL SELECT '1589', 0 UNION ALL SELECT '1590', 0 UNION ALL SELECT '1591', 0 UNION ALL SELECT '1593', 0 UNION ALL SELECT '1601', 0 UNION ALL SELECT '1602', 0 UNION ALL SELECT '1603', 0 UNION ALL SELECT '1604', 0 UNION ALL SELECT '1605', 0 UNION ALL SELECT '1606', 0 UNION ALL SELECT '1607', 0 UNION ALL SELECT '1608', 0 UNION ALL SELECT '1609', 0 UNION ALL SELECT '1610', 0 UNION ALL SELECT '1611', 0 UNION ALL SELECT '1615', 0 UNION ALL SELECT '3585', 0 UNION ALL SELECT '3588', 0 UNION ALL SELECT '3591', 0 UNION ALL SELECT '3592', 0 UNION ALL SELECT '3593', 0 UNION ALL SELECT '3594', 0 UNION ALL SELECT '3603', 0 UNION ALL SELECT '3604', 0 UNION ALL SELECT '3605', 0 UNION ALL SELECT '3607', 0 UNION ALL SELECT '3609', 0 UNION ALL SELECT '3610', 0 UNION ALL SELECT '3611', 0 UNION ALL SELECT '3613', 0 UNION ALL SELECT '3614', 0 UNION ALL SELECT '3616', 0 UNION ALL SELECT '3617', 0 UNION ALL SELECT '3618', 0 UNION ALL SELECT '3619', 0 UNION ALL SELECT '3621', 0 UNION ALL SELECT '3623', 0 UNION ALL SELECT '3624', 0 UNION ALL SELECT '3625', 0 UNION ALL SELECT '3626', 0 UNION ALL SELECT '3627', 0 UNION ALL SELECT '3629', 0 UNION ALL SELECT '3632', 0 UNION ALL SELECT '3633', 0 UNION ALL SELECT '3634', 0 UNION ALL SELECT '3635', 0 UNION ALL SELECT '3637', 0 UNION ALL SELECT '3639', 0 UNION ALL SELECT '3640', 0 UNION ALL SELECT '3648', 0 UNION ALL SELECT '3649', 0 UNION ALL SELECT '3651', 0 UNION ALL SELECT '3652', 0 UNION ALL SELECT '3656', 0 UNION ALL SELECT '3657', 0 UNION ALL SELECT '5601', 0 UNION ALL SELECT '12356', 0 UNION ALL SELECT '12360', 0 UNION ALL SELECT '12363', 0 UNION ALL SELECT '12364', 0 UNION ALL SELECT '12367', 0 UNION ALL SELECT '12369', 0 UNION ALL SELECT '12375', 0 UNION ALL SELECT '12377', 0 UNION ALL SELECT '12381', 0 UNION ALL SELECT '12383', 0 UNION ALL SELECT '12390', 0 UNION ALL SELECT '12391', 0 UNION ALL SELECT '12392', 0 UNION ALL SELECT '12393', 0 UNION ALL SELECT '12394', 0 UNION ALL SELECT '12395', 0 UNION ALL SELECT '12397', 0 UNION ALL SELECT '12398', 0 UNION ALL SELECT '12399', 0 UNION ALL SELECT '12400', 0 UNION ALL SELECT '12411', 0 UNION ALL SELECT '12414', 0 UNION ALL SELECT '12416', 0 UNION ALL SELECT '12418', 0 UNION ALL SELECT '12425', 0 UNION ALL SELECT '12426', 0 UNION ALL SELECT '12427', 0 UNION ALL SELECT '12428', 0 UNION ALL SELECT '12434', 0 UNION ALL SELECT '12435', 0 UNION ALL SELECT '12450', 0 UNION ALL SELECT '12452', 0 UNION ALL SELECT '12463', 0 UNION ALL SELECT '12464', 0 UNION ALL SELECT '12472', 0 UNION ALL SELECT '12473', 0 UNION ALL SELECT '12483', 0 UNION ALL SELECT '12488', 0 UNION ALL SELECT '12496', 0 UNION ALL SELECT '12503', 0 UNION ALL SELECT '12519', 0 UNION ALL SELECT '12521', 0 UNION ALL SELECT '12522', 0 UNION ALL SELECT '12531', 0 UNION ALL SELECT '12540', 0 UNION ALL SELECT '20004', 0 UNION ALL SELECT '20010', 0 UNION ALL SELECT '20055', 0 UNION ALL SELECT '20165', 0 UNION ALL SELECT '20204', 0 UNION ALL SELECT '20891', 0 UNION ALL SELECT '22363', 0 UNION ALL SELECT '23453', 0 UNION ALL SELECT '23545', 0 UNION ALL SELECT '23558', 0 UNION ALL SELECT '23613', 0 UNION ALL SELECT '24102', 0 UNION ALL SELECT '25112', 0 UNION ALL SELECT '25313', 0 UNION ALL SELECT '26469', 0 UNION ALL SELECT '27005', 0 UNION ALL SELECT '27979', 0 UNION ALL SELECT '29616', 0 UNION ALL SELECT '32473', 0 UNION ALL SELECT '35501', 0 UNION ALL SELECT '35758', 0 UNION ALL SELECT '35770', 0 UNION ALL SELECT '35797', 0 UNION ALL SELECT '35831', 0 UNION ALL SELECT '36796', 0 UNION ALL SELECT '44032', 0 UNION ALL SELECT '44036', 0 UNION ALL SELECT '44256', 0 UNION ALL SELECT '44536', 0 UNION ALL SELECT '44592', 0 UNION ALL SELECT '45716', 0 UNION ALL SELECT '45733', 0 UNION ALL SELECT '45768', 0 UNION ALL SELECT '45796', 0 UNION ALL SELECT '45936', 0 UNION ALL SELECT '46020', 0 UNION ALL SELECT '46300', 0 UNION ALL SELECT '47016', 0 UNION ALL SELECT '47141', 0 UNION ALL SELECT '47196', 0 UNION ALL SELECT '47484', 0 UNION ALL SELECT '47532', 0 UNION ALL SELECT '47700', 0 UNION ALL SELECT '47732', 0 UNION ALL SELECT '47784', 0 UNION ALL SELECT '47928', 0 UNION ALL SELECT '48120', 0 UNION ALL SELECT '49345', 0 UNION ALL SELECT '49436', 0 UNION ALL SELECT '49688', 0 UNION ALL SELECT '49828', 0 UNION ALL SELECT '49845', 0 UNION ALL SELECT '50504', 0 UNION ALL SELECT '50557', 0 UNION ALL SELECT '50630', 0 UNION ALL SELECT '50640', 0 UNION ALL SELECT '50725', 0 UNION ALL SELECT '50836', 0 UNION ALL SELECT '50857', 0 UNION ALL SELECT '50896', 0 UNION ALL SELECT '50948', 0 UNION ALL SELECT '51004', 0 UNION ALL SELECT '51012', 0 UNION ALL SELECT '51020', 0 UNION ALL SELECT '51032', 0 UNION ALL SELECT '51060', 0 UNION ALL SELECT '51064', 0 UNION ALL SELECT '51068', 0 UNION ALL SELECT '51077', 0 UNION ALL SELECT '51080', 0 UNION ALL SELECT '51088', 0 UNION ALL SELECT '51116', 0 UNION ALL SELECT '51208', 0 UNION ALL SELECT '51228', 0 UNION ALL SELECT '51316', 0 UNION ALL SELECT '51648', 0 UNION ALL SELECT '52286', 0 UNION ALL SELECT '52628', 0 UNION ALL SELECT '53672', 0 UNION ALL SELECT '54028', 0 UNION ALL SELECT '54200', 0 UNION ALL SELECT '54532', 0 UNION ALL SELECT '54596', 0 UNION ALL SELECT '54616', 0 UNION ALL SELECT '54620', 0 UNION ALL SELECT '54633', 0 UNION ALL SELECT '54644', 0 UNION ALL SELECT '54665', 0 UNION ALL SELECT '54876', 0 UNION ALL SELECT 'appid', 0 UNION ALL SELECT 'cgi', 0 UNION ALL SELECT 'code', 0 UNION ALL SELECT 'fswiki', 0 UNION ALL SELECT 'handera', 0 UNION ALL SELECT 'hanjamean', 0 UNION ALL SELECT 'hida', 0 UNION ALL SELECT 'hires姓for', 0 UNION ALL SELECT 'ksc', 0 UNION ALL SELECT 'os5', 0 UNION ALL SELECT 'palm', 0 UNION ALL SELECT 'pdb', 0 UNION ALL SELECT 'perl', 0 UNION ALL SELECT 'sns', 0 UNION ALL SELECT '｛如沾大家有什?, 0 UNION ALL SELECT '｝sns', 0 UNION ALL SELECT '小鉅具', 0 UNION ALL SELECT '支持', 0 UNION ALL SELECT '日文', 0 UNION ALL SELECT '台palm', 0 UNION ALL SELECT '本?, 0 UNION ALL SELECT '目前掌已', 0 UNION ALL SELECT '地來測試', 0 UNION ALL SELECT '在palm已︷', 0 UNION ALL SELECT '好的建', 0 UNION ALL SELECT '版半', 0 UNION ALL SELECT '的掌已', 0 UNION ALL SELECT '阿拉呆文', 0 UNION ALL SELECT '泰文', 0 UNION ALL SELECT '留言｛希望能有?, 0 UNION ALL SELECT '情在', 0 UNION ALL SELECT '部perl', 0 UNION ALL SELECT '棋台', 0 UNION ALL SELECT '棋有for', 0 UNION ALL SELECT '棋吧︷', 0 UNION ALL SELECT '款优秀的', 0 UNION ALL SELECT '敬在palm已搆受', 0 UNION ALL SELECT '融寺', 0 UNION ALL SELECT '韓文', 0 UNION ALL SELECT '簡體中文', 0

Line : 467
File : functions_search.php

文章由 **小竹子** » 2005-10-07 00:20

試試看先修復+最佳化你的資料表，下次不要貼整支程式的程式碼，可以另做壓縮檔連結提供下載

文章由 **slyunchen** » 2005-10-07 10:45

小竹子寫:試試看先修復+最佳化你的資料表，下次不要貼整支程式的程式碼，可以另做壓縮檔連結提供下載

嗯晚點去試試看，謝謝竹子大大。若是不行的話…我就不用MS SQL 2000了@@"因為我對SQL資料庫還不大了解。
另外下次會改進不要貼全部的程式碼滴!