Ok, I went into the Version History txt file and then compared it to what I had on my database after the upgrade. Maybe if I describe everything in details you'll be able to figure out what's going on.
The differences I found:
tblForum
1) none of the fields that should've been deleted were in fact deleted. And the field Read appeared in my database as [Read];
2) VH (Version History) said: "Sub_ID - data type = interger - default value = 0". But my DB had datatype as "smallint" (lenght=2. Is that right?)
3) VH said: "Last_post_author_ID - data type = interger". Again, my DB had datatype as "smallint".
4) VH said: "Last_post_date - data type = date/time - default value = now()/GetDate()". My DB had default value as "(getdate())"
5) The field Display was NOT created.
tblTopic
1) The fields Start_date and Last_entry_date were NOT deleted.
2) The fields "Start_Thread_ID", "Last_Thread_ID" and "No_of_replies" had their datatypes in VH as "interger". In my DB, however, it was set to "int". Why "int" and not "smallint" like what happened in the "tblForum"?'
3) The field "Icon", in VH, said datatype as "text". In my DB, it was set to "nvarchar".
4) The field "Hide", in VH, said datatype as "true/false" (def. val. as false). In my DB it said "bit" and def. value as (0).
5) The field "Event-Date", in VH, said datatype as "date". In my DB it's "datetime", but I guess it's correct.
tblThread
1) None of the new fields were created. And there's no "true/false" datatype. you said before I should use "bin". In the thread I linked to in my last post, the user said he used "bit". Which one is the correct? (I guess the default value is (0).
tblPermission
1) In VH, it says "Display_posts" datatype true/false. In my DB it says "bit". In VH, it doesn't say which should be the default value, but the upgrade file sets it to (0) (false, isn't it?).
2) In VH, the new field "Calendar_event" is set to datatype "boolean". In my DB, it says "bit" (default value = (0)).
tblAuthor
1) In VH, "No_of_PM" has datatype as "interger". In my DB, as "int". I still don't know why interger was substituted with "smallint" in the tblForum.
And so on... (yes, I got tired). The pattern is the same in the rest: "interger" for "int", "boolean" for "int", etc, etc, etc.
Topic Options
Post Options
Thanks(0)
It's not "binary", it's "bit". And then there's the catch. It AUTOMATICALLY selects ALLOW NULL. It's necessary to uncheck it. And it has to be done the first time, before you save the new table. If you save it with the NULL option, you can't change it afterwards. I Mean... you CAN, but the forum still won't work.