Hello!
I am upgrading rt version 3.0.11 to rt 3.4.1.
I use MySQL database.
When I am trying to perform an upgrade procedure, I get the following error:
/usr/local/rt3/sbin/rt-setup-database --action schema --datadir 3.3.0
Creating database schema.
Problem with statement:
INSERT into ObjectCustomFields (id, CustomField, ObjectId, SortOrder, Creator, L
astUpdatedBy) SELECT null, id, Queue, SortOrder, Creator, LastUpdatedBy from Cu
stomFields
Table ‘rt3.ObjectCustomFields’ doesn’t exist at /usr/local/rt3/sbin/rt-setup-dat
abase line 205.
I noticed that in etc/upgrade/3.3.0 directory only schema.Oracle and schema.Pg
files has CREATE TABLE ObjectCustomFields…
but schema.mysql lacks this statement.
Is it a bug?
Hello!
I am upgrading rt version 3.0.11 to rt 3.4.1.
I use MySQL database.
When I am trying to perform an upgrade procedure, I get the following error:
/usr/local/rt3/sbin/rt-setup-database --action schema --datadir 3.3.0
Creating database schema.
Problem with statement:
INSERT into ObjectCustomFields (id, CustomField, ObjectId, SortOrder, Creator, L
astUpdatedBy) SELECT null, id, Queue, SortOrder, Creator, LastUpdatedBy from Cu
stomFields
Table ‘rt3.ObjectCustomFields’ doesn’t exist at /usr/local/rt3/sbin/rt-setup-dat
abase line 205.
I noticed that in etc/upgrade/3.3.0 directory only schema.Oracle and schema.Pg
files has CREATE TABLE ObjectCustomFields…
but schema.mysql lacks this statement.
Is it a bug?
I noticed that in etc/upgrade/3.3.0 directory only schema.Oracle and
schema.Pg
files has CREATE TABLE ObjectCustomFields…
but schema.mysql lacks this statement.
I guess that’s why my postgres-based upgrade from 3.0.6 to 3.4.1 went
perfectly smoothly yesterday
Vivek Khera, Ph.D.
+1-301-869-4449 x806
I noticed that in etc/upgrade/3.3.0 directory only schema.Oracle and schema.Pg
files has CREATE TABLE ObjectCustomFields…
but schema.mysql lacks this statement.
my copy of schema.mysql sure has the CREATE TABLE statement.