Oliver
kranga wrote:
Is this the only field with the problem or are there other fields? Should I use the db-schema from v2.1?
----- Original Message ----- From: "Oliver Zeigermann" <[EMAIL PROTECTED]>
To: "Slide Users Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 18, 2004 5:25 PM
Subject: Re: Problems using MySql as store - field truncation after version
1.4 is created
This is a known issue with MySQL. The problem is the value of the property storing the information has been dimensioned too small. This will be fixed in the 2.1 release. For now change the type of property value to text. Like this:
CREATE TABLE PROPERTIES ( VERSION_ID bigint NOT NULL, PROPERTY_NAMESPACE varchar(50) NOT NULL, PROPERTY_NAME varchar(50) NOT NULL, PROPERTY_VALUE text NOT NULL, PROPERTY_TYPE varchar(50) NOT NULL, IS_PROTECTED tinyint(1) NOT NULL, PRIMARY KEY (VERSION_ID,PROPERTY_NAMESPACE,PROPERTY_NAME) ) TYPE=InnoDB;
Oliver
kranga wrote:
Using MySQL as the store, I've run into what looks like a serious error.
I
created 6 versions of a given file. I stopped tomcat and started it and
the
reportMethod() started failing with an Internal Server Error. After some investigation, I see that the property_value field of the properties
table
holds 255 characters and the version-set property maxes that out when
v1.4
is created! Is this a bug or am I doing something wrong? It works as
long as
I don't shutdown tomcat. Am I shutting down tomcat wrong?
Has anyone else run into the same problem?
-Thanks Karthik
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
