From: Randum I. <ia...@ra...> - 2003-05-14 14:53:07
|
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 |