The ubbthreads created mysql error logs look like this on my board:
Sat, Jan 03 2004 01:33:40 +0100 /ubbthreads/showflat.php 213.76.68.118
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,t2.U_Username DESC LIMIT 309, 12 - Unknown table 't2' in order clause
Sat, Jan 03 2004 01:34:05 +0100 /ubbthreads/showflat.php 213.76.68.118
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,t2.U_Username DESC LIMIT 309, 12 - Unknown table 't2' in order clause
Sat, Jan 03 2004 08:17:09 +0100 /ubbthreads/showflat.php 213.161.226.54
Unable to do_query: SELECT B_Number FROM w3t_Posts WHERE B_Topic = 1 AND B_Board = 'UBB24' AND B_Approved = 'yes' ORDER BY B_Sticky DESC,t2.U_Username DESC LIMIT 12 - Unknown table 't2' in order clause
Sat, Jan 03 2004 09:21:00 +0100 /ubbthreads/showflat.php 212.77.192.61
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,t2.U_Username DESC LIMIT 99, 12 - Unknown table 't2' in order clause
Sat, Jan 03 2004 09:21:05 +0100 /ubbthreads/showflat.php 212.77.192.61
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,t2.U_Username DESC LIMIT 99, 12 - Unknown table 't2' in order clause
Sat, Jan 03 2004 09:22:03 +0100 /ubbthreads/showflat.php 212.77.192.61
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,t2.U_Username DESC LIMIT 99, 12 - Unknown table 't2' in order clause
Sat, Jan 03 2004 09:22:07 +0100 /ubbthreads/showflat.php 212.77.192.61
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,t2.U_Username DESC LIMIT 99, 12 - Unknown table 't2' in order clause
In all lines (4 pages in 2 days) it say's: Unknown table 't2'
Does anyone know why?
Ron
Edit: to remove the code tags so it wraps
Last edited by JoshPet; 01/06/2004 7:32 PM.