[not a bug?] Cannot Manually Add users?

[CountZero]

Hey there,

I'm sure that this is one of those annoying Newbie questions, But I did try searching the support forums here and I cant seem to find anything that fits in the search results that I get.

My Users can sign up normally through the main Forum page just fine. I just cannot seem to add users manually through the Control Panel..

Every time I try to add a user, I get the Following message:

Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO userfield VALUES (5,'','','','')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Saturday 01st of September 2001 07:27:20 PM
Script: /forums/admin/user.php

The Odd part is I from the Mail forum page, the New users shows up in the Welcome section, and I can use the admin functions to go in and edit/delete the new user from the users profile page. I just cannot see the user at all through the control panel.. They dont show up in a search of users in the CP..
I'm upgrading from a UBB system, and moving machines as well.. (I tried an Import of the UBB Files and that was a less than stellar experience, so I'm hoping to be able to recreate the user files manually at least) I'm not so sorried about the Threads, A fresh start wont hurt my system. Its a seriously low traffic sort of deal as it is.. Currently the forums are set up as a "Test" sort of forum and arent linked to any part of my site.. I was hoping to be able to manually update the User info from the Old UBB Files and then take the new VBulletin Forums Live..

Forums are located at: http://www.liquidrealities.com/forums/index.php

PHP Ver = 4.0.4pl1
MySQL Ver = 3.23.21 (I think. I'll double Check that)
Apache Ver = Apache/1.3.20
Server OS = Linux

And If I've totally forgotten something relevant to troubleshooting, please let me know.. PHP and MySQL are new to me so I'm learning as I go..

Thanks in advance,

Dean N
CountZero
Liquid Reality Studios

[Mike Sullivan]

I think that's a bug that popped up in register.php that was squashed there, but not in the admin CP version.

So, moving to bugs forum...

[orca]

Hmm, I don't know whether it's a bug. I can easily add users through the CP...

[Chen]

Yeah me too. :confused:

[Mike Sullivan]

The bug didn't effect everyone. And actually, now that I think about it, the bug wasn't that you couldn't register, it'd just put your custom data in the wrong places. :)

But this would only happen if you have a different amount of columns in the userfield table than the profilefield table...

[CountZero]

Not to appear too dense, but what does that mean for me? This is a New vBulletin installation, with the default installation and config options using a brand new, blank database that was set up just for the board.. :)

I havent modified any of the fields, havent tried to add anything either.. I'm not familiar enough with PHP And MySQL to really screw anything up.. I let vBulletin set up what it wanted and went from there...

Any other info I can provide to hopefully allow the experts to diagnose and hopefully squish this annoying little critter?

Thanks!

Dean N

[Mike Sullivan]

You say you did a UBB import? Then it sounds like you didn't finalize it.

Go to .../importers/bbimport_ubb6.php?action=docleanup or .../importers/bbimport_ubb5.php?action=docleanup , depending on your UBB version.

But this is actually still a bug we can fix in the future. :)

[CountZero]

That looks like it squished it.. I thought I had rebuilt and cleared everything after the failed import attempt, but Apparently I missed something.. I went right down the list and reindexed/rebuilt/cleaned up everything that it offered me..

The UBB Import failed right off the bat. First step of the import if I recall. (I dont have the error handy, but I remember it being something along the lines of not being able to open/locate the UBB files..) I think that part of the problem with the import was I installed the vBulletin on a new machine (seperate from the UBB install).. When I tried to copy over all of the UBB files to the new system to do the import, something must have gotten scrambled.. So far, I like the vB system better. Seems to be easier to use and maintain..

Now that I can manually enter users, I'll just plug them into vB manually and we should be good to go..

Thanks SO much for everything!!! Excellent support so far. I really appreciate all your help.. If you need anything else in the future to try to duplicate this or squish it, Please let me know.. I'd be happy to help in any way I can...

Thanks!

Dean N

[Mike Sullivan]

I'm guessing the UBB import error you got meant that the file requested wasn't there. Since you moved machines, it probably just means the path is wrong.

If you go to .../admin/index.php?action=phpinfo and look for "DOCUMENT_ROOT", that should give you an idea of where to start with the path. For example, the DOCUMENT_ROOT here might be something like /home/vbulletin/htdocs . Note that the DOCUMENT_ROOT always points to the top level of the website regardless of what script you call. (ie, /home/vbulletin/htdocs is where www.vbulletin.com/ is located)