OK, but we put it in accidentally. So we are now trying to remove it. We have taken it out of extended properties, we have removed the columns from the tables, and we ran the update scripts.
But we still get: 'virus_family' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed. When we try and list reporters. So somewhere we don't know about, virus_family is stored in the BASE2 database - is there some documentation that says where? -----Original Message----- From: Nicklas Nordborg [mailto:nick...@thep.lu.se] Sent: 10 December 2009 14:38 To: BASE ML Subject: Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed. michael watson (IAH-C) wrote: > Hello > > > > I am running BASE 2.8.4 (sorry, I know it is old) > > > > I have added extended properties to my database. > > > > I added these after the database had been used, so what I have are some > extra columns with no data in them in the reporter table > > > > This is the XML I used: > > > > <property > > name="virus_family" > > title="VirusFamily" > > description="The virus family from > which the reporter is derived" > > column="virus_family" > > type="string" > > length="65535" > > /> > > > > The update scripts ran fine. > > > > When I view reporters, the column is there, but when I sort on the > column, I get the error: > > > > Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . > is allowed. virus_family is not allowed as a name since it has an underscore in the name. /Nicklas ------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net ------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net
