|
|
Joined: Jul 2001
Posts: 808
Coder
|
Coder
Joined: Jul 2001
Posts: 808 |
After upgrading to V6.4 final and installing some hacks I visit my SQL-logfile and found this:
/ubbthreads/showflat.php Unable to do_query: SELECT B_Number FROM w3t_Posts WHERE B_Topic = 1 AND B_Board = 'UBB14' AND B_Approved = 'yes' ORDER BY B_Sticky DESC,t2.U_Username ASC LIMIT 22 - Unknown table 't2' in order clause
/ubbthreads/showthreaded.php Unable to do_query: SELECT B_Number,B_Main,B_Subject,B_Posted,B_Approved FROM w3t_Posts WHERE B_Topic = 1 AND B_Board = 'UBB14' AND B_Approved = 'yes' ORDER BY B_Sticky DESC,t2.U_Username ASC LIMIT 99, 22 - Unknown table 't2' in order clause
What are the table 't2' ? I take a view to both scripts and try to find this, but I go confused. Any clue ? If needed I can post a list of hacks that I installed. Maybe one of them produce this.
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
Member
Joined: Apr 2001
Posts: 3,266 |
Just backtrack and see what hacks modify those files to pinpoint your problem
|
|
|
|
Joined: Jul 2001
Posts: 808
Coder
|
Coder
Joined: Jul 2001
Posts: 808 |
mmh, seems to bee quick reply 5.0. The second hack is photolink, but this was installed after the first errormessages. I will repost my problem in the quick reply thread.
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
Member
Joined: Apr 2001
Posts: 3,266 |
Well I have the quick reply mod installed with no SQL errors.
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
UBB.threads Developer
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
badfrog
somewhere on the coast of Maine
Posts: 94
Joined: March 2007
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|