When I create a new user account, I get the following error:

-user warning: Column 'field1' cannot be null query: INSERT INTO userfield VALUES (18257, NULL, '', '', '', '') in /data/web/cms.gamecritics.com/includes/database.mysql.inc on line 120.
-user warning: Column 'subfolders' cannot be null query: INSERT INTO usertextfield VALUES (18257, NULL, NULL, NULL, NULL, '', NULL, NULL) in /data/web/cms.gamecritics.com/includes/database.mysql.inc on line 120.

Does anyone get the same error when creating a new user account for someone else?

Comments

rszrama’s picture

rszrama commented

Hmm... I've never run into that error with my tests, but apparently your vB table has those columns set to NOT_NULL. I'm curious what version of vBulletin you're using and if you have any way to print up here what the structure for your userfield and usertextfield tables looks like.

GC_Chi’s picture

GC_Chi commented

I have six profile fields defined under settings -> profile for Drupal accounts. Do you think that's what it is?

vBulletin is Version 3.6.4

I'm not a developer, so I don't know how to do the print out. If you give me more detailed instructions, I can try to get the data you need.

GC_Chi’s picture

GC_Chi commented

Can you confirm if error is directly related to Drupal vB module? I wasn't sure so figured I'd post it and get your thoughts.

rszrama’s picture

rszrama commented

It is related to the Drupal vB module and has to do with the vBulletin database. I'll check my tables when I get home later and see if the structure has changed... it may be new for your version, as I tested on 3.6.0. I'll have to get back to you later on it.

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Active » Closed (won't fix)

4.7.x is no longer supported. Feel free to re-open this issue if you want to provide a patch.