INSERT INTO cdb_nkflash (game_id, game_type, flash_url, flash_width, flash_height, flash_bgcolor, game_title, play_fee, bonus_rate, rate_limit, score_unit, game_img, game_details, favorates, medal_id)
VALUES ('Fishdom', '5', 'nkflash/Fishdom.swf', 520, 390, '#CCCCCC', '¤ô±Ú½c®ø¹Ï®×', 1, 20000, 90000, ' ¤À', 'nkflash/Fishdom.gif', '¹B¥Î·Æ¹«ÂIÀ» ©Î ©ì°Ê ±±¨î , ±N 3 ­Ó©Î¥H¤W¬Û¦P¹Ï®×¬Û³s ( ¦@ 80 ª© )', '3', 839);

Discuz! info: MySQL Query Error

User: admin
Time: 2008-7-21 11:11am
Script: /bbs/plugins.php

SQL: SELECT f.*, m1.username as r1, mrname as r9, m10.username as r10

FROM [Table]nkflash f

LEFT JOIN [Table]members m1 ON m1.uid=f.uid_1

LEFT JOIN [Table]members m2 ON m2.uid=f.uid_2

LEFT JOIN [Table]members m3 ON m3.uid=f.uid_3

LEFT JOIN [Table]members m4 ON m4.uid=f.uid_4

LEFT JOIN [Table]members m5 ON m5.uid=f.uid_5

LEFT JOIN [Table]members m6 ON m6.uid=f.uid_6

LEFT JOIN [Table]members m7 ON m7.uid=f.uid_7

LEFT JOIN [Table]members m8 ON m8.uid=f.uid_8

LEFT JOIN [Table]members m9 ON m9.uid=f.uid_9

LEFT JOIN [Table]members m10 ON m10.uid=f.uid_10
Error: Unknown column 'mrname' in 'field list'
Errno.: 1054

Similar error report has beed dispatched to administrator before.

¨ì [url]http://faq.comsenz.com[/url] ·j¯Á¦¹错误ªº¸Ñ决¤è®×

­ì©«¥Ñ haoyouwo ©ó 2008-7-24 08:47 µoªí
ºÞ²z员ûñûñ§Ú§a
¬d¬Ý±Æ¦æ¦¨ÁZ¥X¿ùDiscuz! info: MySQL Query Error
User: admin
Time: 2008-7-21 11:11am
Script: /bbs/plugins.php
SQL: SELECT f.*, m1.username as r1, m ...

­ì©«¥Ñ kkt8899sp ©ó 2008-9-4 23:48 µoªí
§O¤j, ³o­Ó game ¤´¦³ bug, ¨ì LV 71 ¹L LV 72 ®É´N·|¦º¾÷..
¤£ª¾¦³®É¶¡­×¥¿¶Ü ? thz..

­ì©«¥Ñ kkt8899sp ©ó 2008-9-5 04:11 µoªí
§O¤j, ËݧA§ï game ¥{, ¥´ game ¦n®t¤U¼½..
©O­Ó game ¥h¨ì LV 71 ªG­Ó³£«Y¥Î¥ª 207min