Removed Users - how to rre-insert

[Eveline]

one another question tarique..

i've a mysql :

DROP TABLE IF EXISTS cpg11d_users;
CREATE TABLE cpg11d_users (
  user_id int(11) NOT NULL auto_increment,
  user_group int(11) NOT NULL default '2',
  user_active enum('YES','NO') NOT NULL default 'NO',
  user_name varchar(25) NOT NULL default '',
  user_password varchar(25) NOT NULL default '',
  user_lastvisit datetime NOT NULL default '0000-00-00 00:00:00',
  user_regdate datetime NOT NULL default '0000-00-00 00:00:00',
  user_lang varchar(255) NOT NULL default '',
  user_email varchar(255) NOT NULL default '',
  user_website varchar(255) NOT NULL default '',
  user_location varchar(255) NOT NULL default '',
  user_interests varchar(255) NOT NULL default '',
  user_occupation varchar(255) NOT NULL default '',
  user_actkey varchar(32) NOT NULL default '',
  PRIMARY KEY  (user_id),
  UNIQUE KEY user_name (user_name)
) TYPE=MyISAM;

(i removed all mysql things and all files from the server because i didn't knew how to resolve my problem..) am i able to put it in my mysql so i get back my 250 users again? or do they have to register again because some ehhh things are not the same?

[Tarique Sani]

errr only one topic per thread - splitting it - please heed in future

Yes you should be able to reinsert the users if you have the complete SQL - try with phpmyadmin - you have nothing to loose anyways

[Eveline]

errr only one topic per thread - splitting it - please heed in future

Yes you should be able to reinsert the users if you have the complete SQL - try with phpmyadmin - you have nothing to loose anyways

sorry for putting two topics in one

ok i'll try let's take a look

[Eveline]

well i've put them back all and i succeeded, but now i got following error:

Notice: Undefined index: user_group_list in /home/sites/site3/web/fotoalbum/include/init.inc.php on line 273

i had a usergroup called Foto's Uploaden and now i don't have that one. guess that's the problem. but when i make a group called Foto's uploaden,  it's still not correct.

[Tarique Sani]

I assume that you are fairly dextrous with phpmyadmin - so try this in the cpg11d_users table find a user who was in the old "Foto's Uploaden" group, note the value in the user_group for this user

Browse the  cpg11d_usergroups table edit the row which has "Foto's Uploaden" record and make the group_id value same as what you noted down previously

That should fix it - if not then you are probably out of luck

[Eveline]

o well i'm lucky

i did update database in modify tools and the error was gone