Backup issue, NULL-values problem

[Matti Kröger]

Hi there

this maybe a noob question, again, but bare with me..

I made a backup of the sql-file, using the backup-operation provided by the admin-console... Then I tested to restore, using the sql-file.

what I noticed was this: the restoration does not work if there are NULL-values.. this happens for instance in case that I write an article and write nothing to the keywords-part... or like in the following example, I wrote News and no links there... and this is the error I get:

Query: "INSERT INTO faqnews (id,header,artikel,datum,link,linktitel,target) VALUES (7,'Test','Test',20070321044233,NULL,NULL,NULL)" failed (Reason: Column 'link' cannot be null)

Anyways.. I think this might be worth changing, 'cause not every news needs a link...

[Thorsten]

Hi,

which version do you use?

bye
Thorsten

[Matti Kröger]

version number is 1.6.11. I took a CVS version, don't remember the exact date however when I took it.. I think it was early this week, maybe on monday.

[Thorsten]

Hi,

ah, I can reproduce this. The problem is that I changed the export in 1.6.10 for fixing it in MySQL 5 but it breaks in MySQL 4. We need some table updates to allow NULL values. I'll fix this before 1.6.11 will be released.

bye
Thorsten