pb de creation d'une nouvelle page dans le portail

[dzkwsk]

il s'agit de retourner à colectica les infos de configuration de la table utilisateur postgre dans notre portail.

To investigate, can you send us the postgresql describe table output for the table in the Colectica user database?

Try this (in the psql command-line tool):

\d+ "Pages"

Log is sent to Colectica
zendesk
http://colectica.zendesk.com/hc/requests/25697

[dzkwsk]

on a eu la réponse de Colectica, voir http://colectica.zendesk.com/hc/requests/25697

Hi Christophe,

Your Pages table is not correct as it does not have the default value set for the Id column, the Par défaut in your output. Did you alter it or recreate this table or restore it via backup?

In any case, it would be best to recreate it with the following script to restore it to the correct format.

DROP TABLE IF EXISTS "Pages";

CREATE TABLE IF NOT EXISTS "Pages"
(
"Id" integer NOT NULL DEFAULT nextval('"Pages_Id_seq"'::regclass),
"Content" text NOT NULL,
"CreatedById" text,
"CreatedTime" timestamp without time zone NOT NULL,
"FriendlyUrl" text NOT NULL,
"IncludeInMainNavigation" boolean NOT NULL,
"Title" text NOT NULL,
"Weight" integer NOT NULL,
CONSTRAINT "PK_Pages" PRIMARY KEY ("Id"),
CONSTRAINT "FK_Pages_AspNetUsers_CreatedById" FOREIGN KEY ("CreatedById")
REFERENCES "AspNetUsers" ("Id") MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE RESTRICT
)

CREATE INDEX IF NOT EXISTS "IX_Pages_CreatedById"
ON "Pages" USING btree
("CreatedById" ASC NULLS LAST)
TABLESPACE pg_default;

Thanks
Dan

[EmmanuelDemey]

ping @JeromeMBourgeois :D