View Single Post
  #1  
Old 26th January 2013, 21:08
Giorgatzelos's Avatar
Giorgatzelos Giorgatzelos is offline
Senior Member
 
Join Date: Nov 2009
Greece
Posts: 300
Default external tracker error
Announce URL
Status
Updated
Torrents
Ενέργειες
http://open.nyaatorrents.info:6544/announce
Active
15ω 38λ 24δ
1 (View)
hi i loaded an external torrent from my nyaa user profile and this is what i get when i go to admin-->external trackers-->view

SQL Error
Σφάλμα κατά την εκτέλεση SQL Αιτήματος SELECT torrent_torrents.*, IF(torrent_torrents.numratings < '0', NULL, ROUND(torrent_torrents.ratingsum / torrent_torrents.numratings, 1)) AS rating, torrent_categories.name AS cat_name, torrent_categories.image AS cat_pic, U.username, IF(U.name IS NULL, U.username, U.name) as user_name, U.level as user_level FROM torrent_torrents LEFT JOIN torrent_categories ON category = torrent_categories.id LEFT JOIN torrent_users U ON torrent_torrents.owner = U.id LEFT JOIN torrent_trackers ON torrent_torrents.tracker = torrent_trackers.url WHERE torrent_trackers.id = '4' ORDER BY torrent_torrents.evidence DESC, torrent_torrents.added DESC;
Σφάλμα ID: 1267
Σφάλμα Μηνύματος: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='




what sould i alter at my database?...(i guess)...

Last edited by Giorgatzelos; 26th January 2013 at 22:11.
Reply With Quote