UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports Non Bugs new error this morning

my site has been working good, I have the registered users set on approval mode and verify email.

here is the new error not allowing me to do anything>

SELECT t1.USER_DISPLAY_NAME, t1.USER_ID FROM ubbt_USERS as t1 INNER JOIN ubbt_USER_DATA as t2 ON t1.USER_ID = t2.USER_ID WHERE ((t1.USER_REGISTRATION_IP = '69.208.114.178') OR (t2.USER_LAST_IP = '69.208.114.178')) AND t1.USER_LOGIN_NAME <> 'dragin trx's'

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 's'' at line 6

Hmm, do you have any modifications on your site. That query doesn't appear to come from the stock UBB.threads code as we do not do any INNER JOINs in any of our queries.

yes,

https://www.ubbdev.com/forums/ubbthreads.php/ubb/showflat/Number/312413/page/1#Post312413

Ok, looks like a bug in the mod in that it's not calling addslashes on the username.

I would advise restoring the original files then, checking it out to see if the issue remains - if it goes away then we know where the problem lies and you can report it in that thread..

if it remains please advise.

thanks,

I reinstalled the old files and it is working..

I will report the problem over there.

thanks for your help

no worries - always best to backtrack if a fault develops.

So this is why groupee doesn't support modded installs :x