[求助]mySQL出現問題

phpBB Plus Support
本區是討論關於 phpBB 2 plus 使用上的問題討論!
(發表文章請按照公告格式發表,違者砍文)

版主: 版主管理群

主題已鎖定
daniel_lin64
星球普通子民
星球普通子民
文章: 14
註冊時間: 2004-05-23 00:11
來自: 愷銳音響有限公司
聯繫:

[求助]mySQL出現問題

文章 daniel_lin64 »

各位大大



●上網方式:ADSL
●您的 phpBB 版本:我的版本是 phpBB2 Plus 1.52 and TopTemplates based on phpBB © 2001, 2005 phpBB Group●
您的 domain (網域名稱) : http://www.kr.com.tw/
●您的 phpBB 連結網址: http://www.kr.com.tw/form/phpBB2/ (請務必留下連結)

問題如下
問題1
當我按下~" 檢視近日發表的文章"~就會出現以下訊息,也使得這個功能無法使用

代碼: 選擇全部

[color=#FF0000]一般錯誤 

Could not obtain main information

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_poster' in 'on clause'

SELECT from_unixtime(p.post_time, '%d.%m.%y %H:%i:%s') as topic_time, f.forum_name as forum_name, f.forum_id as forum_id, u.username as username, u2.username as username2, u2.user_id as user_id2, p.poster_id as poster_id, p.post_username as post_username, p.post_id as post_id, t.*, p.post_time as post_time FROM phpbb_topics t, phpbb_posts p LEFT OUTER JOIN phpbb_forums f on p.forum_id = f.forum_id LEFT OUTER JOIN phpbb_users u on p.poster_id = u.user_id LEFT OUTER JOIN phpbb_users u2 on u2.user_id = t.topic_poster WHERE t.topic_id IN (2, 4, 6, 8, 10, 11, 13, 14, 15, 16, 17, 20, 21, 22, 23, 24, 25, 27, 28, 30, 31, 32, 33, 35, 36, 37, 38, 40, 41, 42, 43, 44, 45, 46, 47, 48, 56, 57, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 91, 92, 93, 95, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 110, 111, 112, 113, 114, 115, 116, 117, 118, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 153, 154, 155, 156, 157, 158, 160, 161, 162, 163, 164, 165, 166, 167, 168, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 298, 299, 301, 302, 303, 304, 305, 306, 307, 308, 310, 311, 312, 313, 314, 315, 316, 317, 319, 320, 321, 323, 324, 325, 326, 327, 328, 329, 330, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 537, 538, 539, 540, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 641, 642, 643, 644, 645, 646, 647, 648, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 703, 704, 705, 707, 708, 709, 710, 711, 712, 713, 714, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 734, 735, 737, 741, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 850, 855, 865, 875, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 917, 932, 933, 934, 935, 936) AND p.post_id = t.topic_last_post_id AND UNIX_TIMESTAMP(NOW()) - p.post_time < 86400 ORDER BY p.post_time desc LIMIT 0, 15

Line : 116
File : recent.php [/color]
問題2
當我按下某依篇發表文章時就出下以下的訊息!

代碼: 選擇全部

Couldn't retrieve smilies list

DEBUG MODE

SQL Error : 2006 MySQL server has gone away

SELECT emoticon, code, smile_url FROM phpbb_smilies GROUP BY smile_url ORDER BY smilies_id LIMIT 24

Line : 132
File : quick_reply.php

代碼: 選擇全部

一般錯誤 

Critical Error!
message_die() was called multiple times.
 
--------------------------------------------------------------------------------
Error #1 
Couldn't retrieve smilies list 

Line : 132
File : /home/krcomtw/public_html/form/phpBB2/quick_reply.php 
SQL : SELECT emoticon, code, smile_url FROM phpbb_smilies GROUP BY smile_url ORDER BY smilies_id LIMIT 24 
 
--------------------------------------------------------------------------------
 Error #2 


Line : 132
File : /home/krcomtw/public_html/form/phpBB2/includes/functions_jr_admin.php 
SQL : SELECT * FROM phpbb_jr_admin_users WHERE user_id = 2 
 
--------------------------------------------------------------------------------
 Please, contact the webmaster. Thank you.
我有進去PHPMYADMIN裡面使用檢查資料表,出現以下訊息

代碼: 選擇全部

於資料表 `phpbb_forums` 中有索引問題 
The following indexes appear to be equal and one of them should be removed: forum_desc, forum_desc_3
The following indexes appear to be equal and one of them should be removed: forum_desc, forum_desc_2 
於資料表 `phpbb_pa_comments` 中有索引問題 
The following indexes appear to be equal and one of them should be removed: PRIMARY, comments_id 
於資料表 `phpbb_posts` 中有索引問題 
The following indexes appear to be equal and one of them should be removed: post_icon, post_icon_2 
於資料表 `phpbb_topics` 中有索引問題 
The following indexes appear to be equal and one of them should be removed: topic_calendar_time, topic_calendar_time_2 
請問有大大知道如何解決嗎?
希望有大大可以協助,感恩!
有空來坐坐喔!
主題已鎖定

回到「phpBB 2 plus 綜合討論」