Eve import problrm

[rnn-2]

I converted/imported all eve data (with the help of Jerry) and I loaded the converted .sql file and it looks good.

http://www.xxxxx.com/vb/chat/index.php (http://www.xxxxx.com/vb/chat/index.php)

But the main users are in an unidentified or unamed group, tried to access them via a mass move but that group does not show up there?


COPPA) Users Awaiting Moderation 1 - Edit Usergroup (id: 4)
Administrators 1 - Edit Usergroup (id: 6)
Moderators - - Edit Usergroup (id: 7)
Registered Users - - Edit Usergroup (id: 2)
Super Moderators - - Edit Usergroup (id: 5)
Unregistered / Not Logged In - - Edit Usergroup (id: 1)
Users Awaiting Email Confirmation - - Edit Usergroup (id: 3)
8,597 - Edit Usergroup (id: )


How can I get the 8,587 into the registered user (id: 2) group?


Bob

[Scott MacVicar]

Can you send me phpMyAdmin access so I can see whats went wrong, i'd like to fix it in the importer as well. mail scott <at> vbulletin <dot> com or just pm me. Link to this thread though since I get a fair amount of emails / pms.

[rnn-2]

Hi Scott,

I can't do that because you folks don't use secure VPN access to your customers sites.

I had this problem with Steve before.

I had sent Jerry the eve database through another unsecure website.

Can I send you a perticular php or other file?

Can I run a SQL querry to fix the user id which I assume is missing?

I need to get this fixed there are 8600 members.

Thanks
Bob

[Scott MacVicar]

I can connect via a VPN and use it on a regular basis to connect to my house when on the move.

Well you can get the usergroup from
SELECT usergroupid FROM user LEFT JOIN usergroup ON (user.usergroupid = usergroup.usergroupid) WHERE usergroup.usergroupid IS NULL;

I think you might get the group 69.

[rnn-2]

Scott

I got "An error occurred while attempting to execute your query. The following information was returned.
error number: 1052
error desc: Column: 'usergroupid' in field list is ambiguous"

[Scott MacVicar]

change the first instance to user.usergroupid so its
SELECT user.usergroupid ....

[rnn-2]

Scott,

here is the input
SELECT user.groupid FROM user LEFT JOIN usergroup ON (user.usergroupid = usergroup.usergroupid) WHERE usergroup.usergroupid IS NULL

the result

An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'user.groupid' in 'field list'

Bob

[Scott MacVicar]

SELECT user.usergroupid FROM user LEFT JOIN usergroup ON (user.usergroupid = usergroup.usergroupid) WHERE usergroup.usergroupid IS NULL

[rnn-2]

Hi Scott,

That worked fine, the results showed all 8,597 having a usergroupid of 0

Is there a SQL string that can change those to regular users? I think that would be usergroupid 2?

Bob

[Scott MacVicar]

UPDATE user SET usergroupid = 2 WHERE usergroupid = 0

I'll leave this for jerry to fix properly but i'll adjust the import user function to default to 2 if its < 1.

[rnn-2]

:D GREAT, all set and thank you.

Bob

[dwh]

I also have all usergroups as 0.

Using that fix would put people who do not have email confirmed as being registered. This is bad.