Database Error on adding New User manually...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jagtpf
    Senior Member
    • Feb 2015
    • 111
    • 3.8.x

    [Forum] Database Error on adding New User manually...

    I have used this in the past with no errors, but this morning I am attempting to manually add a New User; but every save of details throws the following error....Anybody have any suggestions? The Forum is currently closed to automatic registration.

    Into the new member profile I am adding

    Username
    Password
    email address
    and setting primary membership status to "waiting email confirmation" - alternative of "member" also didn't work.

    Geoff

    Database error in vBulletin 4.2.3 Release Candidate 1:

    Invalid SQL:

    SELECT thread.*
    FROM thread AS thread
    WHERE title = 'Username Changes'
    AND forumid =;

    MySQL Error : 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 4
    Error Number : 1064
    Request Date : Wednesday, January 24th 2018 @ 09:17:52 AM
    Error Date : Wednesday, January 24th 2018 @ 09:17:52 AM
    Script : http://www.thepoetryforum.co.uk/admi....php?do=update
    Referrer : https://www.thepoetryforum.co.uk/adm...ser.php?do=add
    IP Address : xxxxxxxxxxxx
    Username : xxxxxxxx
    Classname : vB_Database_MySQLi
    MySQL Version : 5.6.38

  • jagtpf
    Senior Member
    • Feb 2015
    • 111
    • 3.8.x

    #2
    Odd! I had an email saying there'd been a reply on this thread. By MarkB.

    In answer, I suspect MarkFL: Username Change Alert v1.2 - I'll pop over to the other side

    Comment

    • Mark.B
      vBulletin Support
      • Feb 2004
      • 24288
      • 6.0.X

      #3
      Yes this is related to an add-on since it seems to be referencing a thread, which wouldn't normally happen on a default installation when creating a user.
      MARK.B
      vBulletin Support
      ------------
      My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
      My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...