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 |
2 Attachment(s)
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...
|
All times are GMT +2. The time now is 18:41. |
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.