From: Sandy S. <ss...@fo...> - 2003-05-14 15:13:29
|
Not especially, as that's the group 'admin' (datatype 2) rather than the user 'admin' (datatype 1). I'd assumed you had the default install that comes with both a user and group named "admin". On Wednesday, May 14, 2003, at 11:33 AM, Randum Ian wrote: > There is admin, etc in "name" but not "idnum". Is that not wierd? > >> Note my caveat about substituting other user IDs. It looks like you've >> deleted or altered your admin user, so, assuming that you are in the >> admin group: >> >> UPDATE records SET password = ENCRYPT('yourPassHere') WHERE idnum = >> 'iroke' AND datatype = 1; >> >> If that doesn't work, look up try: >> >> INSERT INTO primaryrel (relid, id1, id2) VALUES (1, 2, 1); >> INSERT INTO primaryrel (relid, id1, id2) VALUES (1, 1, 2); >> >> INSERT INTO usergroup (idnum, groups) VALUES ('iroke', 'admin'); >> >> >> On Wednesday, May 14, 2003, at 11:17 AM, Randum Ian wrote: >> >>> Hi Sandy, thanks for your reply. >>> >>> Unfortunately that SQL doesn't work because there is nothing in the >>> idnum >>> field. I have attached a dbdump of the records table. >>> >>> ---[paste]--- >>> # phpMyAdmin MySQL-Dump >>> # version 2.2.4 >>> # http://phpwizard.net/phpMyAdmin/ >>> # http://phpmyadmin.sourceforge.net/ (download page) >>> # >>> # Host: localhost >>> # Generation Time: May 14, 2003 at 10:51 AM >>> # Server version: 3.23.56 >>> # PHP Version: 4.2.3 >>> # Database : `pxdb` >>> # -------------------------------------------------------- >>> >>> # >>> # Table structure for table `records` >>> # >>> >>> CREATE TABLE records ( >>> id int(11) NOT NULL auto_increment, >>> datatype int(11) NOT NULL default '0', >>> approved int(11) NOT NULL default '0', >>> idnum varchar(64) NOT NULL default '', >>> name varchar(127) NOT NULL default '', >>> title varchar(127) NOT NULL default '', >>> email varchar(127) NOT NULL default '', >>> fname varchar(64) NOT NULL default '', >>> mi varchar(32) NOT NULL default '', >>> lname varchar(64) NOT NULL default '', >>> address1 varchar(127) NOT NULL default '', >>> address2 varchar(127) NOT NULL default '', >>> city varchar(127) NOT NULL default '', >>> state char(2) NOT NULL default '', >>> zip varchar(16) NOT NULL default '', >>> country varchar(127) NOT NULL default '', >>> desc1 text, >>> password varchar(32) NOT NULL default '', >>> modified timestamp(14) NOT NULL, >>> updatedby varchar(127) NOT NULL default '', >>> date1 datetime NOT NULL default '0000-00-00 00:00:00', >>> date2 datetime NOT NULL default '0000-00-00 00:00:00', >>> phone varchar(32) default NULL, >>> fax varchar(32) default NULL, >>> url varchar(255) default NULL, >>> amount double(12,2) default NULL, >>> type int(10) unsigned NOT NULL default '0', >>> desc2 text, >>> active enum('Y','N') NOT NULL default 'N', >>> file varchar(255) NOT NULL default '', >>> weight int(3) unsigned NOT NULL default '50', >>> subject int(10) unsigned NOT NULL default '0', >>> filetype int(10) unsigned NOT NULL default '0', >>> created datetime NOT NULL default '0000-00-00 00:00:00', >>> bool1 tinyint(4) NOT NULL default '0', >>> bool2 tinyint(4) NOT NULL default '0', >>> bool3 tinyint(4) NOT NULL default '0', >>> phone2 varchar(32) default NULL, >>> phone3 varchar(32) default NULL, >>> text1 varchar(127) NOT NULL default '', >>> url2 varchar(255) default NULL, >>> PRIMARY KEY (id), >>> KEY modified (modified), >>> KEY updatedby (updatedby), >>> KEY name (name), >>> KEY lname (lname), >>> KEY city (city), >>> KEY state (state), >>> KEY idnum (idnum), >>> KEY weight (weight), >>> KEY datatype (datatype), >>> KEY approved (approved) >>> ) TYPE=MyISAM PACK_KEYS=1; >>> >>> # >>> # Dumping data for table `records` >>> # >>> >>> INSERT INTO records VALUES (1, 2, >>> 0, '', 'admin', '', '', '', '', '', '', '', '', '', '', '', '', >>> 'Gu7aFKO54pm >>> AU', 20020827205407, '', '0000-00-00 00:00:00', '0000-00-00 >>> 00:00:00', >>> NULL, NULL, NULL, NULL, 0, NULL, 'N', '', 50, 0, 0, '2002-08-27 >>> 20:54:07', >>> 0, 0, 0, NULL, NULL, '', NULL); >>> INSERT INTO records VALUES (2, 1, 0, 'iroke', 'Ian >>> Roke', 'Mr', 'ad...@yo...', 'Ian', 'Thomas', 'Roke', '', '', >>> '', '', >>> '', 'Angola', 'Adminstrative User', '', 20030510040547, '', >>> '0000-00-00 00:00:00', '0000-00-00 00:00:00', '111', '', NULL, NULL, >>> 0, '', 'Y', '', >>> 50, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, '', '', '', NULL); >>> INSERT INTO records VALUES (3, 7, >>> 0, '', 'CBDAgency.com', '', '', '', '', '', '', '', 'Hull', '', '', >>> 'United >>> Kingdom', '', '', 20030510040440, '', '0000-00-00 00:00:00', >>> '0000-00-00 >>> 00:00:00', '666', '', 'http://www.cbdagency.com', NULL, 7, NULL, 'N', >>> '', >>> 50, 0, 0, '2003-05-10 04:04:40', 0, 0, 0, NULL, NULL, '', NULL); >>> ---[paste]--- >>> >>>> The SQL to directly update a password for the admin user (substitute >>>> 'admin' with any user ID for other users): >>>> >>>> UPDATE records SET password = ENCRYPT('newpass') WHERE idnum = >>>> 'admin' AND datatype = 1; >>>> >>>> Also, your "organisationtypes" bug may come from the fact that the >>>> "type" field gets automagically mapped to the {objectname}types >>>> table, where {objectname} is the name of the currently-selected >>>> object. If you >>>> still have "type" selected for your Organisation object, you will >>>> get >>>> this error if you do not have an organisationtypes table. >>>> >>>> -- >>>> Sandy Smith, Senior Programmer >>>> Forum One Communications, Inc. >>>> ss...@fo... >>>> tel. 703-548-1855 x28 >>>> http://www.forumone.com/ >>>> >>>> >>>> >>>> ------------------------------------------------------- >>>> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa >>>> Clara >>>> The only event dedicated to issues related to Linux enterprise >>>> solutions www.enterpriselinuxforum.com >>>> >>>> _______________________________________________ >>>> Websyntax-core mailing list >>>> Web...@li... >>>> https://lists.sourceforge.net/lists/listinfo/websyntax-core >>> >>> >>> Randum Ian >>> ia...@ra... >>> DancePortalGlobal Webmaster >>> http://www.danceportalglobal.com >>> >>> >> -- >> Sandy Smith, Senior Programmer >> Forum One Communications, Inc. >> ss...@fo... >> tel. 703-548-1855 x28 >> http://www.forumone.com/ > > > Randum Ian > ia...@ra... > DancePortalGlobal Webmaster > http://www.danceportalglobal.com > > -- Sandy Smith, Senior Programmer Forum One Communications, Inc. ss...@fo... tel. 703-548-1855 x28 http://www.forumone.com/ |