PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : Thema kopieren in ein Forum

Ne0
12.06.2006, 23:42
Database error in vBulletin 3.6.0 Beta 1:

Invalid SQL:

SELECT post.*,
deletionlog.userid AS deleteduserid, deletionlog.username AS deletedusername, deletionlog.reason AS deletedreason,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.dateline AS deleteddateline,
moderation.dateline AS moderateddateine
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND type = 'post')
LEFT JOIN moderation AS moderation ON (moderation.postid = post.postid)
WHERE threadid = 2
ORDER BY dateline;

MySQL Error : Column 'threadid' in where clause is ambiguous
Error Number : 1052
Date : Monday, June 12th 2006 @ 11:41:07 PM
Script : /beta/postings.php?do=domergethread&t=2
Referrer : ****/beta/postings.php?t=2&pollid=
IP Address :
Username : ****
Classname : vb_database



der fehler kommt, wenn ich nen thema kopieren will (thema kopieren ins forum wo das thema existiert.)
Tomek
13.06.2006, 08:30
Das dürfte dieser Bug (http://www.vbulletin.com/forum/bugs36.php?do=view&bugid=119&status=20) sein, der schon behoben wurde.
Ne0
13.06.2006, 20:49
Der bug ist in beta 2 noch enthalten.

wobei das kein *sticky* thema ist.


SIEHE:
Database error in vBulletin 3.6.0 Beta 2:

Invalid SQL:

SELECT post.*,
deletionlog.userid AS deleteduserid, deletionlog.username AS deletedusername, deletionlog.reason AS deletedreason,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.dateline AS deleteddateline,
moderation.dateline AS moderateddateine
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND type = 'post')
LEFT JOIN moderation AS moderation ON (moderation.postid = post.postid)
WHERE post.threadid = 1
ORDER BY dateline;

MySQL Error : Column 'type' in on clause is ambiguous
Error Number : 1052
Date : Tuesday, June 13th 2006 @ 08:49:51 PM
Script : postings.php?do=domergethread&t=1
Referrer : postings.php?t=1&pollid=
IP Address :
Username :
Classname : vb_database
Mystics
13.06.2006, 22:17
Hab's gemeldet (http://www.vbulletin.com/forum/bugs36.php?do=view&bugid=237), danke.