UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports Fixed Bugs [FIXED for 7.1b5] approving display names error

Control panel message
INSERT INTO ubbt_PRIVATE_MESSAGE_TOPICS {TOPIC_TIME,TOPIC_REPLIES,TOPIC_SUBJECT,USER_ID,TOPIC_LAST_REPLY_TIME) values ( 1168934112 , 0 , 'Display name change approved.' , 67 , 1168934112 )

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 '{TOPIC_TIME,TOPIC_REPLIES,TOPIC_SUBJECT,USER_ID,TOPIC_LAST_REPLY_TIME) value' at line 2

Hi,

Thanks

This will be patched in b5

thanks

yeh, i reported this on Saturday after Rick sent B4 off to Dave

Quick fix. Line 1882 of libs/ubbthreads.inc.php. It has:

{TOPIC_TIME,TOPIC_REPLIES.....

That should be:

(TOPIC_TIME,TOPIC_REPLIES.....

It's just a matter of changing the curly brace to a parenthesis.