Forum is open for all, Tracker is invite only. Please use same username as on both when you register...

Username: Log me on automatically each visit
Password:
It is currently Fri Nov 22, 2024 12:57 pm


Post a new topicPost a reply Page 1 of 1   [ 5 posts ]
Author Message
 Post subject: Error when browsing torrents for only and not freeleech (solved)
PostPosted: Sat Jun 11, 2011 11:24 pm 
User avatar

Joined: Sat Jun 11, 2011 11:14 pm
Posts: 2
When trying to categorize my search for torrents by freeleech settings, I get the following URL

http://mma-torrents.com/torrents.php?search=&incldead=1&lang=0&freeleech=2

which then gives me the following error message:

Quote:
Column 'freeleech' in where clause is ambiguous



Any help would be greatly appreciated.


Top
 Profile  
Reply with quote  
 Post subject: Re: Error when browsing torrents for only and not freeleech
PostPosted: Sat Jun 11, 2011 11:26 pm 
Site Admin
User avatar

Joined: Tue Apr 07, 2009 12:53 pm
Posts: 13407
Location: In front of you
Thank you, this will be sorted shortly.

_________________
Image
So you wanna be a [bleeping] member? => Get access to the community <=

Image

Looking for a seedbox? RuTorrent, qbitTorrent, Deluge and Transmission included in all packages! Unlimited torrents, unlimited transfers!
Perfect for both beginners and professionals. Watch the files directly in your browser without downloading or download to your device, up to you!

Image
Really Fast 1 Gbit seedboxes - Professional support 24/7/365 - Click to learn more
To get a recurring 10% discount on all seedbox packages use the PROMO CODE: mmatorrents


Top
 Profile  
Reply with quote  
 Post subject: Re: Error when browsing torrents for only and not freeleech
PostPosted: Mon Jun 13, 2011 1:21 am 
User avatar

Joined: Sun Jan 02, 2011 7:11 am
Posts: 14
Column 'freeleech' in where clause is ambiguous

imho could be there is more than one column "freeleech" that is returned from the query, so the query and WHERE clause needs to identify the duplicate column name.

i.e.
SELECT table1.freeleech, table2.freeleech , table3.*
FROM table1, table2, table3
WHERE table2.freeleech = 2
OR table3.freeleech = 2
OR table1.freeleech = 2

_________________
Image
..::UFC 174: Johnson vs. Bagautinov Competition Winner::..
2014
Image
..::The Ultimate Fighter 17 Finale Competition Winner::..
Image
..::Bellator 90 - Shamhalaev vs. Martinez Competition Winner::..
2013
Image
..::UFC 138 Leben vs. Muñoz Competition Winner::..
2011


Top
 Profile  
Reply with quote  
 Post subject: Re: Error when browsing torrents for only and not freeleech
PostPosted: Mon Jun 13, 2011 11:21 am 
Site Admin
User avatar

Joined: Tue Apr 07, 2009 12:53 pm
Posts: 13407
Location: In front of you
should be fixed now, thanks guys :-B

ps. I love that you point out any errors! Thank you! It is hard to see everything after making changes so your help is greatly aprechiated. (*)

_________________
Image
So you wanna be a [bleeping] member? => Get access to the community <=

Image

Looking for a seedbox? RuTorrent, qbitTorrent, Deluge and Transmission included in all packages! Unlimited torrents, unlimited transfers!
Perfect for both beginners and professionals. Watch the files directly in your browser without downloading or download to your device, up to you!

Image
Really Fast 1 Gbit seedboxes - Professional support 24/7/365 - Click to learn more
To get a recurring 10% discount on all seedbox packages use the PROMO CODE: mmatorrents


Top
 Profile  
Reply with quote  
 Post subject: Re: Error when browsing torrents for only and not freeleech (solved)
PostPosted: Tue Jun 14, 2011 12:31 am 
User avatar

Joined: Sat Jun 11, 2011 11:14 pm
Posts: 2
Thanks for the fast fix, Dent. You're awesome!


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 1   [ 5 posts ]


Who is online

Users browsing this forum: Majestic-12 [Bot] and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

 
Powered by phpBB © 2000 - 2023 phpBB Group
Theme By: Nikkbu
Twitter RSS Feed Twitter