Since I have installe version 7.3.1 and then moved from my windows server to a linux server I get this one error that keeps showing up in the log:
The script version is showing 7.3
Script: /home/content/o/u/t/outdoorking/html/forum/scripts/grabnext.inc.php - Line: 194
SELECT t2.POST_ID,t2.TOPIC_IS_STICKY
FROM ubbt_POSTS as t1,
ubbt_TOPICS as t2
WHERE t2.FORUM_ID = 3
AND t2.TOPIC_IS_STICKY='0'
AND t2.TOPIC_LAST_REPLY_TIME < 964671480
AND t1.TOPIC_ID = t2.TOPIC_ID
ORDER BY t3.USER_DISPLAY_NAME desc
LIMIT 1
- Unknown column 't3.USER_DISPLAY_NAME' in 'order clause'
Can anyone tell me how I can fix this from happening.
Edited by Outdoorking (08/17/08 05:06 AM)
Edit Reason: update