|
#1
|
||||
|
||||
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. |
#2
|
||||
|
||||
check to see if your data base is set to
latin1_general_ci by default please
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#3
|
||||
|
||||
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? |
#4
|
||||
|
||||
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
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#5
|
||||
|
||||
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...
|
Tags |
error , external , tracker |
|
|