Message: 1 Date: Sun, 25 Apr 2010 12:04:44 -0300 From: Unixservice Support <[email protected]> Subject: Re: [unxsBind] unsbind upgrade Version Release 2.7/rpm-2.0 To: User and developer community <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Matthew Brown wrote: > Hi, > > I upgraded from the last version which i installed using yum in the last month however i am not sure what version it was. > > I have run UpdateSchema and unfortunately it didn't help. the command completed successfully but i still have the same issue. > > > Thanks, > > Matt. > Finally had some time to debug this, it was related to the "undo" tDeleted* tables not being updated when their source tables schema was changed. Solution: 1-. Create a SQL file called "delme" with some simple schema update commands (the contents of the "delme" file are shown below via the "cat" command.) 2-. Run them. Example: [r...@node3vm unxsbind-2.1]# mysql -pultrasecret idns < delme delme file contents: [r...@node3vm unxsbind-2.1]# cat delme ALTER TABLE tDeletedResource ADD cParam3 VARCHAR(255) NOT NULL DEFAULT ''; ALTER TABLE tDeletedResource ADD cParam4 VARCHAR(255) NOT NULL DEFAULT ''; This has been fixed in the svn trunk. And the UpdateSchema CLI will work as expected and this CLI funtion will also will be included in the rpm spec post scripts section for yup/rpm updates to handle this transparently. Regards, Gary -- AM Support Staff Unixservice, LLC. +1 310-356-6265 +1 630-206-9449 http://unixservice.com 155 S.E. 16th Ave Portland, Oregon 97214 USA No binding contract will be made between an employee of Unixservice and a third party either verbally or by email, until a written document has been signed on behalf of Unixservice. This e-mail is intended only for the use of the addressees named above and may be confidential. If you are not an addressee you must not use any information contained in nor copy it nor inform any person other than the addressees of its existence or contents. ------------------------------ Hi Gary, I applied this and it works. Thanks for all your help. Thanks, Matt. -- This message has been scanned for viruses and dangerous content by the SecPoint(R) Protector for more information please call First4IT on 01423 859370 _______________________________________________ unxsBind mailing list [email protected] https://lists.openisp.net/mailman/listinfo/unxsbind
