Forum - View topic
Bugs in "Compare" function




Anime News Network Forum Index -> Site-related -> Bugs & Technical Questions
View previous topic :: View next topic  
Author Message
dormcat
Encyclopedia Editor


Joined: 08 Dec 2003
Posts: 9903
Location: New Taipei City, Taiwan, ROC
PostPosted: Wed Dec 22, 2004 8:28 pm Reply with quote
Error message as follows:
----
( SELECT annAnimeStaff.person_id, annPerson.name, CONCAT('',annAnimeStaffTask.title,''), IF(annAnimeStaffTask.display_order<255,2,1), annAnimeStaff.anime_id FROM annAnimeStaff LEFT JOIN annPerson ON annAnimeStaff.person_id = annPerson.id LEFT JOIN annAnimeStaffTask ON annAnimeStaff.stafftask_id = annAnimeStaffTask.id WHERE annAnimeStaff.anime_id IN (4168) AND annAnimeStaff.info_status IN ('T','P') AND language = 'JP' ) UNION ( SELECT annAnimeCast.person_id, annPerson.name, CONCAT('plays ',annAnimeCast.role), IF(annAnimeCast.importance<3,2,1), annAnimeCast.anime_id FROM annAnimeCast LEFT JOIN annPerson ON annAnimeCast.person_id = annPerson.id WHERE annAnimeCast.anime_id IN (4168) AND annAnimeCast.info_status IN ('T','P') AND language = 'JP' ) ORDER BY annPerson.name
SQL ERROR: Table 'annPerson' from one of the SELECTs cannot be used in global ORDER clause

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/domains/animenewsnetwork.com/htdocs/encyclopedia/compare.php on line 138
----
End of error message
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number My Anime My Manga
Display posts from previous:   
Reply to topic    Anime News Network Forum Index -> Site-related -> Bugs & Technical Questions All times are GMT - 5 Hours
Page 1 of 1

 


Powered by phpBB © 2001, 2005 phpBB Group