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

<<<12

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

Dave
#16 2012-02-27 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 2012-02-27 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 2012-02-27 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
This post was edited by Dave (2012-02-28 01:27, 12 years ago)
Trustmaster
#19 2012-02-28 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 2012-02-29 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