Форуми / Craftwork / Server-side / merge the data base...

<<<12

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

Dave
#16 27.02.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.02.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.02.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

Відредаговано: Dave (28.02.2012 01:27, 12 років тому)
Trustmaster
#19 28.02.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.02.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

<<<12