I have a question about an error I have been getting in the "Error Log".<br /><br />[] /ubbthreads/showflat.php <br /><br />Unable to do_query: SELECT B_Main,B_Board FROM w3t_Posts WHERE B_Number = - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 [/] <br /><br />What is wrong? Everything seems to be running smoothly, but this error is showing up on a daily basis in the error log.<br /><br />Thanks,

The reason for the error is that B_Number (the post number) is not given a value. <br /> <br />UBB.threads version?

[]Dave_L said:<br />UBB.threads version? [/]<br />I am running version 6.3 at this time.

You might upgrade to 6.3.2. A lot of bugs were fixed in between 6.3 and 6.3.2.

[]Dave_L said: <br />You might upgrade to 6.3.2. A lot of bugs were fixed in between 6.3 and 6.3.2. [/] <br />I'm scared to upgrade as I have TONS of hacks installed, thanks to threadsdev, and all seems to be ok overall <img src="/forum/images/graemlins/wink.gif" alt="" /> <img src="/forum/images/graemlins/wink.gif" alt="" />

If you use a tool like Beyond Compare to compare the clean 6.3 to the clean 6.3.2 files it should be relatively painless to make the changes manually. I've got a spreedsheet that I use to track all my changes. It has which files were changed for which hack. Something like that might be useful for applying maintanece upgrades. <img src="/forum/images/graemlins/smile.gif" alt="" />