I canged the modification from the above to:
// 3 => 'B_Sticky DESC,t2.U_Username DESC',
// 4 => 'B_Sticky DESC,t2.U_Username ASC',
3 => 'B_Sticky DESC,U_Username DESC',
4 => 'B_Sticky DESC,U_Username ASC',
and now I get different errors.
Can someone please be clear about what EXACTLY needs to be modified?
Fri, Jan 09 2004 23:01:54 +0100 /ubbthreads/showflat.php 81.204.232.133
Unable to do_query: SELECT B_Number FROM w3t_Posts WHERE B_Topic = 1 AND B_Board = 'UBB23' AND B_Approved = 'yes' ORDER BY B_Sticky DESC,U_Username DESC LIMIT 159, 12 - Unknown column 'U_Username' in 'order clause'
Fri, Jan 09 2004 23:01:57 +0100 /ubbthreads/showflat.php 81.204.232.133
Unable to do_query: SELECT B_Number FROM w3t_Posts WHERE B_Topic = 1 AND B_Board = 'UBB23' AND B_Approved = 'yes' ORDER BY B_Sticky DESC,U_Username DESC LIMIT 159, 12 - Unknown column 'U_Username' in 'order clause'
Fri, Jan 09 2004 23:25:42 +0100 /ubbthreads/showflat.php 172.178.145.44
Unable to do_query: SELECT B_Number FROM w3t_Posts WHERE B_Topic = 1 AND B_Board = 'UBB10' AND B_Approved = 'yes' ORDER BY B_Sticky DESC,U_Username DESC LIMIT 79, 12 - Unknown column 'U_Username' in 'order clause'
Fri, Jan 09 2004 23:25:43 +0100 /ubbthreads/showflat.php 172.178.145.44
Unable to do_query: SELECT B_Number FROM w3t_Posts WHERE B_Topic = 1 AND B_Board = 'UBB10' AND B_Approved = 'yes' ORDER BY B_Sticky DESC,U_Username DESC LIMIT 79, 12 - Unknown column 'U_Username' in 'order clause'
