I'm trying to move archived posts using the Move/delete content tools but getting this error.

UPDATE `forums_forums` `forums_forums` SET `topics`=1,`posts`=1,`last_post`=0,`last_poster_name`=NULL,`seo_last_name`='-'last_title`=POST TITLE',`seoast_title`TITLE,last_id=6853 WHERE id=149

Column 'last_poster_name' cannot be null

Now the task is stuck.

Thanks.

Before we check any further, please could you confirm you have tested this with all 3rd party items disabled?

 

Column 'last_poster_name' cannot be null

Can you go to the phpmyadmin, select the forum's database and go to the forums_forums table, and once there click on the Structure tab? From there select the last_poster_name and see what value it has under the Default column.

It can be that the aforementioned column is declared as NOT NULL, and therefore it will not accept NULL value(s). If that appears to be the case, it needs to be changed to allow the NULL value(s). i.e. to make it nullable.

Edited February 7Feb 7 by Miss_B

 

Before we check any further, please could you confirm you have tested this with all 3rd party items disabled?

no, but I fixed the issue by simply manually running the task multiple times.

 

Can you go to the phpmyadmin, select the forum's database and go to the forums_forums table, and once there click on the Structure tab? From there select the last_poster_name and see what value it has under the Default column.

It can be that the aforementioned column is declared as NOT NULL, and therefore it will not accept NULL value(s). If that appears to be the case, it needs to be changed to allow the NULL value(s). i.e. to make it nullable.

I think it happens when the last poster is a deleted member. It will rarely happen again so not a big deal.