Problem during upgrading from 1.6.12 to 2.0.0

rym3k · Post by **rym3k** » Fri May 25, 2007 12:23 pm

Hi

During upgrading phpMyFAQ from 1.6.12 to newest (2.0.0) this application report

DB error: ERROR: null value in column "user_id" violates not-null constraint

Query:

INSERT INTO faqcategories
(id, lang, parent_id, name, description)
SELECT id, lang, parent_id, name, description
FROM faqcategories_PMF16x_old

as i noticed new faqcategories has column user_id with NOT NULL constraint and this query copy old values without this field so it must be null

I hope that it help You

best regards

Post by **Thorsten** » Fri May 25, 2007 12:34 pm

Hi,

which database do you use?

bye
Thorsten

rym3k · Post by **rym3k** » Fri May 25, 2007 12:41 pm

PostgreSQL (8.1)

rym3k · Post by **rym3k** » Fri May 25, 2007 12:43 pm

I changed update.php user_id NOT NULL DEFAULT 1 to user_id NULL and I passed this step but after this I got one more bug report

DB error: ERROR: null value in column "links_state" violates not-null constraint

Query:

INSERT INTO faqdata
(id, lang, solution_id, revision_id, active, keywords, thema, content, author, email, comment, datum)
SELECT id, lang, solution_id, revision_id, active, keywords, thema, content, author, email, comment, datum
FROM faqdata_PMF16x_old

and it seems that this is the same problem

Post by **Thorsten** » Fri May 25, 2007 12:44 pm

Hi,

yes, it seems, PostgreSQL has some problems here. Can you please post that bug on http://bugs.phpmyfaq.de?

Thanks
Thorsten

rym3k · Post by **rym3k** » Fri May 25, 2007 12:48 pm

no problem. done.

Post by **Thorsten** » Fri May 25, 2007 12:55 pm

Thank you!

bye
Thorsten