Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread Nicklas Nordborg
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

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread michael watson (IAH-C)
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

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread Nicklas Nordborg
michael watson (IAH-C) wrote: 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

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread Olivier Lefevre
'virus_family' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed. I think that message comes from a Hibernate query and refers to a column name used in constraints; check your constraints. -- O.L.

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread michael watson (IAH-C)
Ah ok, so BASE has built a constraint involving my new column name? -Original Message- From: Olivier Lefevre [mailto:lefev...@yahoo.com] Sent: 10 December 2009 15:06 To: BASE ML Subject: Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread Olivier Lefevre
Ah ok, so BASE has built a constraint involving my new column name? I would think so, although it's been 6 months since I had wade into that. Suggestion: turn on full query tracing in the log by putting all this into your log4j.properties: # logging queries in BASE

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread michael watson (IAH-C)
This is really quite a long winded way of doing things. I just dumped my entire database, removed any record of virus_family in anything, dropped and recreated the database and imported everything into a clean DB. And then base goes and inserts virus_family into Contexts table and I have the

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread Olivier Lefevre
Well, I agree with you that DC-BASE (and Hibernate!) can be rather user-unfriendly at times but I am myself only a user. I reported something that helped me once, no more no less. Regards, -- O.L. -- Return on

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread Nicklas Nordborg
michael watson (IAH-C) wrote: Hi Nicklas I would love to use the Clear Filter option, but I can't even get onto the page that displays that - when I click View - Reporters it shows nothing apart from the menu bar and : Ok. Then you need to go to File - Reset list settings. Make sure the In

Re: [base] Property '' has one or more invalid characters. Only a-z, A-Z, 0-9 and . is allowed.

2009-12-10 Thread Nicklas Nordborg
Offord, Victoria wrote: I know the feeling. This has been several hours wasted because they don't bother to explain this in the manual at all! Contributions to the manual would be very much appreciated. Otherwise, there is information about similar problems in the trac ticket system: