I've updated my OTRS install from 1.3.2 to 2.0.0b1 (mmm, bleeding edge). I noted the following errors during the database update, using PostgreSQL. I've attached the full log of the SQL update output so you have context as well.
[...] ERROR: column "o" does not exist ERROR: column "escalation_start_time" contains null values [...] ERROR: column "comments" of relation "ticket_state_type" does not exist [...] This database has been upgraded through numerous OTRS versions (starting with 0.5b :), so it's entirely possible there's some strangeness with the schema that needs tweaking. If so, please advise. If not, there are bugs in the script. Otherwise, everything looks OK so far... Thanks, Bryan
ALTER TABLE CREATE TABLE CREATE TABLE NOTICE: CREATE TABLE will create implicit sequence "roles_id_seq" for "serial" column "roles.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "roles_pkey" for table "roles" NOTICE: CREATE TABLE / UNIQUE will create implicit index "roles_name_key" for table "roles" CREATE TABLE CREATE TABLE ALTER TABLE ERROR: column "o" does not exist ERROR: column "escalation_start_time" contains null values ALTER TABLE UPDATE 40 ALTER TABLE CREATE TABLE ALTER TABLE UPDATE 1 ALTER TABLE NOTICE: CREATE TABLE will create implicit sequence "faq_attachment_id_seq" for "serial" column "faq_attachment.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "faq_attachment_pkey" for table "faq_attachment" CREATE TABLE CREATE INDEX CREATE TABLE DROP TABLE NOTICE: CREATE TABLE / UNIQUE will create implicit index "sessions_session_id_key" for table "sessions" CREATE TABLE CREATE INDEX CREATE TABLE CREATE INDEX CREATE INDEX CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX NOTICE: CREATE TABLE will create implicit sequence "package_repository_id_seq" for "serial" column "package_repository.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "package_repository_pkey" for table "package_repository" CREATE TABLE INSERT 469360 1 INSERT 469361 1 ERROR: column "comments" of relation "ticket_state_type" does not exist INSERT 469362 1 DELETE 22 INSERT 469363 1 INSERT 469364 1 INSERT 469365 1 INSERT 469366 1 INSERT 469367 1 INSERT 469368 1 INSERT 469369 1 INSERT 469370 1 INSERT 469371 1 INSERT 469372 1 INSERT 469373 1 INSERT 469374 1 INSERT 469375 1 INSERT 469376 1 INSERT 469377 1 INSERT 469378 1 INSERT 469379 1 INSERT 469380 1 INSERT 469381 1 INSERT 469382 1 INSERT 469383 1 INSERT 469384 1
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
