MMA-Torrents.com Forum
https://foru.mma-torrents.com/

Error when browsing torrents for only and not freeleech (solved)
https://foru.mma-torrents.com/viewtopic.php?f=2&t=3286		 Page 1 of 1
Author:  Bingo [ Sat Jun 11, 2011 11:24 pm ]
Post subject:  Error when browsing torrents for only and not freeleech (solved)
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.
Author:  Dent [ Sat Jun 11, 2011 11:26 pm ]
Post subject:  Re: Error when browsing torrents for only and not freeleech
Thank you, this will be sorted shortly.
Author:  mattt [ Mon Jun 13, 2011 1:21 am ]
Post subject:  Re: Error when browsing torrents for only and not freeleech
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
Author:  Dent [ Mon Jun 13, 2011 11:21 am ]
Post subject:  Re: Error when browsing torrents for only and not freeleech
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. (*)
Author:  Bingo [ Tue Jun 14, 2011 12:31 am ]
Post subject:  Re: Error when browsing torrents for only and not freeleech (solved)
Thanks for the fast fix, Dent. You're awesome!
Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/