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?
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
Quote from: Tarique Sani on July 29, 2004, 01:57:18 PM
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 :)
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.
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
o well i'm lucky :D
i did update database in modify tools and the error was gone :)