[ForceHSS]

Originally Posted by rohirrim

Here is the error. As you'll see I don't have any member mrs-mjackson. Bu we have mrs.mjackson. when we click its profile we got this error... curerently ı disabled writing rule for member profile and no error.. Everythin fine... If I enable writing rule for member profiles I got the error.

PHP Code:

Database error in DragonByte SEO 2.0.9:

Invalid SQL:

                                        SELECT userid
                                        FROM mjvbuser
                                        WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*mr(䙡迀[s姎])(&[\#\da-z]*;|[^a-z\d])*mj(聕鈢[a懒旅呐噌忏溴])(鐋莬c(|[c莄])k(䙡迀[s姎])(鰘謡[o矣哉重蝮趱鲽])[n疡](&[\#\da-z]*;|[^a-z\d])*$'
                                        LIMIT 1;

MySQL Error   : Got error 'empty (sub)expression' from regexp
Error Number  : 1139
Request Date  : Sunday, July 5th 2015 @ 07:20:50 PM
Error Date    : Sunday, July 5th 2015 @ 07:20:50 PM
Script        : http://www.mysite.com/forum/members/mrs-mjackson/
Referrer      :
IP Address    : 88.235.134.243
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 


Your problem lies in admincp/settings/options/User Registration Options/Username Regular Expression you need to find out what one is causing the problem or removing what you have in there will fix it
This is what I have and dont have any errors

^[a-zA-Z]{1}[\w\sa-zA-Z\d_]*[^\s]$