Issue With Registration

C

Crucia

New Member
Hey guys,

I'm sure this leaves a terribly bad impression - being my first post and all but I am having a crucial error with my forum that I do not have the knowledge to resolve.

I have no database issues whatsoever within my forum, and everything is running smoothly until a user attempts to register, to which they recieve a database error.

The error generated to us is:

Code: 
Database error in vBulletin 3.8.1:



Invalid SQL:



    REPLACE INTO

      `_vbrcd_log_pm`

    SET

      `pmid`          =  20,

      `pmtextid`      =  20,

      `fromuserip`    = '92.5.45.106',

      `fromuserid`    =  0,

      `fromusername`  = 'RegiTest',

      `fromuseremail` = '',

      `touserid`      =  22,

      `tousername`    = 'RegiTest',

      `touseremail`   = '[email protected]',

      `title`         = 'Welcome to DF:FlyFF Forums',

      `message`       = 'Thanks for registering at DF:FlyFF Forums! We are glad you have chosen to be a part of our community and we hope you enjoy your stay.\r\n\r\nAll the best,\r\nDF:FlyFF Forums',

      `iconid`        =  ,

      `dateline`      =  1239511244,

      `showsignature` =  ,

      `allowsmilie`   =  1;



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 '

      `dateline`      =  1239511244,

      `showsignature` =  ,

      `allow' at line 15

Error Number  : 1064

Request Date  : Sunday, April 12th 2009 @ 12:40:44 AM

Error Date    : Sunday, April 12th 2009 @ 12:40:44 AM

Script        : http://www.myforum.com/register.php?do=addmember

Referrer      : http://www.myforum/register.php?do=register

IP Address    : 92.5.45.106

Username      : RegiTest

Classname     : vB_Database

MySQL Version : 

=====================================================

Users still register, and can log on the forums when I update usernames through the acp.

Does anyone have any ideas what could be causing this? I've looked into all the permissions I have created and simply can't figure this one out. As far as I can tell, it seems to be an issue with the 'showsignature' command, as users that have registered and log-in have an issue with not being able to use signatures,
 
Have you installed any hacks lately that affect the registration form?

Try to disable hooks in vboptions and see if the problem goes away. If it does, you have a hack that is hosing your registration form.
 
I figured out the problem.

It seems that the option to send an automatic welcome PM to a new, registered user causes a database error. The reason for this is unknown and I'd appreciate it if anybody else can look into it and see if they recieve the same error.

Cheers for the help,

Crucia
 
You must log in or register to reply here.
Back
Top