I guess that it must be me, cause I have a small problem. My forum is not extremely busy (in terms of users and posts, but still the average is 100 posts a day.
I integrated 5.1 on it having the menu, top posters and profile spotlight on the left, welcome new member and last seen middle, search, login, short stats and a custom box on the right
I tried to put the hot topics in the middle. Indexes are fine, the box appears but before that I get an sql error.
code: SQL ERROR: Unable to do_query: SELECT B_Number,B_Posted,B_Last_Post,B_Username, B_Subject,B_Main,B_Replies,B_Counter,B_Board FROM FFFF_Posts WHERE B_Number = B_Main AND B_Posted >= '1033312400' AND B_Replies >= '5' AND (B_Sticky = 0 OR B_Sticky IS NULL) AND () ORDER BY B_Replies DESC LIMIT 0,1 You have an error in your SQL syntax near ') ORDER BY B_Replies DESC LIMIT 0,1 ' at line 8
Obviously the error comes from the WHERE statement. I still cannot understand whether IIP will chache results according to the new posts from the minute it got installed or from the existing ones. If it is the latter, I am sure I have threads with more than 5 replies.
The same errors appear when I want to add the Current Threads, Past threads, Current poll, etc.
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.