Foren / Craftwork / Server-side / merge the data base...

ErsteVorherige12

i'd like to know your opinion about this...

Dave
#16 27. Februar 2012, 00:32

ok, so do i have to fix that cuz the table has like 700 rows? or i simply can leave it like that

Your advertisement here :-)

Cotonti Genoa based site: forgotten-garage.pl
Trustmaster
#17 27. Februar 2012, 16:51

Yes, it is required to fix that table, otherwise your site is inconsistent and some modules may crash.

May the Source be with you!
Dave
#18 27. Februar 2012, 23:39

thaks for help T. another question before ill make some mistake, will it be ok if ill build sed_group_users from sed_users ?

i think i can answer my self... yes i can (not 100% sure tho...) im simply rebuilding sed_users to get sed_group_users

http://forgotten-garage.pl/datas/users/sedgroupsusers_1.jpg

and after all of it cot will keep building that table i gues?

Your advertisement here :-)

Cotonti Genoa based site: forgotten-garage.pl

Dieser Beitrag wurde von Dave (am 28. Februar 2012, 01:27, vor 12 Jahre) bearbeitet
Trustmaster
#19 28. Februar 2012, 07:51

What you need to do is this:

INSERT IGNORE INTO `sed_groups_users` (`gru_userid`, `gru_groupid`)
    SELECT `user_id`, `user_maingrp` FROM `sed_users`;

This will add the main groups into sed_groups_users. After that you'll have to add secondary groups manually for each user.

May the Source be with you!
Dave
#20 29. Februar 2012, 08:46

thanks, i did it the hard way sicnce couldt get right command for sql ;/ need to learn more

Your advertisement here :-)

Cotonti Genoa based site: forgotten-garage.pl

ErsteVorherige12