Ok - if I recall correctly - the base install includes a nulled record - which is the parent of everything See below
-- insert templated records for each module type INSERT INTO LINKS (ModuleID) VALUES (0) INSERT INTO EVENTS (ModuleID) VALUES (0) INSERT INTO ANNOUNCEMENTS (ModuleID) VALUES (0) INSERT INTO CONTACTS (ModuleID) VALUES (0) INSERT INTO DOCUMENTS (ModuleID)
VALUES (0) INSERT INTO DISCUSSION (ModuleID, Title, Body, DisplayOrder, CreatedByUser) VALUES (0,"","","","")
I would put money on the fact that if you run the last line of this in SQL Query Analyser, that'll resolve your issue DavidM
Various IBS Addons available at http://www.snowcovered.com
None
0 Points
364 Posts
Re: discussions module blues
Jun 04, 2003 08:27 AM|DavidGMiles|LINK
-- insert templated records for each module type INSERT INTO LINKS (ModuleID) VALUES (0) INSERT INTO EVENTS (ModuleID) VALUES (0) INSERT INTO ANNOUNCEMENTS (ModuleID) VALUES (0) INSERT INTO CONTACTS (ModuleID) VALUES (0) INSERT INTO DOCUMENTS (ModuleID) VALUES (0) INSERT INTO DISCUSSION (ModuleID, Title, Body, DisplayOrder, CreatedByUser) VALUES (0,"","","","")
I would put money on the fact that if you run the last line of this in SQL Query Analyser, that'll resolve your issue DavidMLead Developer [vb & c#] - MCAD