Error: number of posts null after upgrade

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I've upgraded from version 7.9 to 9.69 (both with access db).

Now, when I try to view the member list, I get:
Microsoft VBScript runtime  error '800a005e'
Invalid use of Null: 'CLng'

/members.asp, line 600 
(or /admin_select_members.asp, line 323 from the admin panel).

I can fix it by setting tblAuthor.No_of_post to zero for those members with a null in that field.  So this is not a problem for me anymore.