Forum Database error in vBulletin
 

Database error in vBulletin 4.0.0:

Invalid SQL:

UPDATE post AS p
SET p.attach = (
SELECT COUNT(*)
FROM attachment AS a
WHERE
p.postid = a.contentid
AND
a.contenttypeid = 1
GROUP BY a.contentid
)
WHERE p.postid IN (10508);

MySQL Error : Column 'attach' cannot be null
Error Number : 1048
Request Date : Friday, January 1st 2010 @ 10:26:32 PM
Error Date : Friday, January 1st 2010 @ 10:26:32 PM