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)...

check to see if your data base is set to
latin1_general_ci by default please

For torrent_torrents most of it is set to latin1_swedish_ci should i alter all to latin1_general_ci?
this is what you ment?how can i do that automatically and not manually one by one?

it should be latin1_swedish_ci and it has to do with your default data base setings not the table or row but it can be adjusted but would be done one row at a time.
You could go to your data base and change the Collation to latin1_swedish_ci for the over all Collation and see if that works

it is set to latin1_swedish_ci joe...as you can see in the first picture when updating it stops there and never displays the footer and when i click at the view option bellow torrents it gives me the sql error...