Login to Your Account


Login using your Facebook account

Join the Mercury Community

Click on all the boats to prove you're human.


Recent Thread Activity

Suggestions
3 Posts - 329 d 22 h 54 min
Editor used on messages.... change to new one
1 Posts - 389 d 3 h 23 min
Event module ideas / suggestions
1 Posts - 405 d 50 min
ampersand is allowed in username creation, then causes problems...
1 Posts - 409 d 3 h 31 min
duplicate user accounts were created on FTR
2 Posts - 664 d 22 h 32 min
main photo > upload proble > too big, caused error
2 Posts - 664 d 22 h 33 min
content too long on CMS pages
2 Posts - 799 d 3 h 33 min
CMS file name - needs error checking
2 Posts - 799 d 3 h 33 min
auto category image
2 Posts - 864 d 7 h 53 min
change the phrase "you have no friends" to something not so negative
1 Posts - 870 d 2 h 11 min
Group Forums Error on first post
1 Posts - 871 d 12 h 16 min
can't reply to thread more than once or if it's not your turn....
4 Posts - 871 d 12 h 18 min
start new post - needs error checking
2 Posts - 878 d 10 h 41 min
Suggestions
3 Posts - 926 d 7 h 30 min
internal messaging needs editor
5 Posts - 926 d 7 h 39 min
Approve Friend Error
2 Posts - 926 d 7 h 42 min
friend approval process needs checking.....
2 Posts - 926 d 7 h 45 min
problem with link
1 Posts - 935 d 1 h 58 min
Comments
2 Posts - 963 d 5 h 19 min
CAPTCHA updates
3 Posts - 982 d 12 h 58 min
Forums : groups Thread: Group Forums Error on first post started December 29, 2009, 1:50 am (Not Following)

petemaster5000
MESSAGE
DEC 29 2009 1:12 AM

This is the first time I recall running into this.  I'll double check on hell city to see if it happens again

The first post in a GROUP FORUM I ran into this error:

Invalid query:
Column 'ForumCategoryId' cannot be null

Whole query:
insert into ForumThreads ( LoginId, GroupId, ForumCategoryId, ThreadTitle, PostCount, AddedDateTime, LastActivityDate )values( 1, 1, NULL, 'test new forum post', 0, now(), now() )

 

*easy fix by changing the DB field to allow NULL.

not sure where you want to fix this.  on the DB install script or in thecode.