Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > BT.Manager (phpMyBitTorrent)
Reply
  #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
  #2  
Old 27th January 2013, 03:10
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
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/
Reply With Quote
  #3  
Old 27th January 2013, 04:05
Giorgatzelos's Avatar
Giorgatzelos Giorgatzelos is offline
Senior Member
 
Join Date: Nov 2009
Greece
Posts: 300
Default
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?
Reply With Quote
  #4  
Old 27th January 2013, 04:40
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
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/
Reply With Quote
  #5  
Old 27th January 2013, 05:15
Giorgatzelos's Avatar
Giorgatzelos Giorgatzelos is offline
Senior Member
 
Join Date: Nov 2009
Greece
Posts: 300
Default
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...
Attached Thumbnails
27-1-2013 05-08-35.jpg   27-1-2013 05-09-06.jpg  
Reply With Quote
Reply

Tags
error , external , tracker

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 16:21. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.