发匿名的帖子总出现错误！

湿润乐意

Discuz! info: MySQL Query Error
; z$ G% {/ m' i& x5 H5 [
+ |- O1 j7 o2 A& e1 l* h) aUser: 湿润乐意
Time: 2008-4-27 4:20pm
1 E1 L. O0 R  a; m& t8 _Script: /forum/magic.php

SQL: SELECT tid, fid, author, authorid, first, dateline, anonymous FROM [Table]posts p, [Table]threads t WHERE pid='11646622' AND invisible='0' AND t.tid=p.tid AND digest>=0
Error: Column 'tid' in field list is ambiguous
+ i  n# R% b4 m8 v- H# {3 [Errno.: 1052
2 K- H3 U# q, ]# r
Similar error report has beed dispatched to administrator before.
* m% X: E2 |1 f0 y6 ^. I0 V8 Y
[ 本帖最后由 湿润乐意 于 2008-4-27 16:23 编辑 ]

金银妖瞳

湿润乐意

谢谢老大！玩儿去了！;)

湿润乐意

老大不行呀！
9 @7 n+ j$ Y- c" \
; N/ C8 u* |: ^7 d# V' h每次都出现 sql error

湿润乐意

Discuz! info: MySQL Query Error

$ A' S9 s- i# P& F+ c# o: EUser: 湿润乐意
Time: 2008-4-27 4:20pm
Script: /forum/magic.php
: p0 n/ u$ {0 `2 c8 a
SQL: SELECT tid, fid, author, authorid, first, dateline, anonymous FROM [Table]posts p, [Table]threads t WHERE pid='11646622' AND invisible='0' AND t.tid=p.tid AND digest>=0
9 i2 h# w: O/ z% w% b& IError: Column 'tid' in field list is ambiguous
. e; f/ B9 F. f6 |( vErrno.: 1052
% E( c- }( U8 u" N
# r2 c# c# p- z; VSimilar error report has beed dispatched to administrator before.