11-27-2012, 12:02 PM
(11-27-2012, 01:52 AM)steinm Wrote:(11-27-2012, 12:34 AM)Daniel Wrote: I then went trough the queries and found the one creating tblGroupMembers allways complaining about wrong syntax.
PHP Code:--
-- Table structure for table `tblGroupMembers`
--
CREATE TABLE `tblGroupMembers` (
`groupID` int(11) NOT NULL default '0',
`userID` int(11) NOT NULL default '0',
`manager` smallint(1) NOT NULL default '0',
UNIQUE (`groupID`,`userID`),
CONSTRAINT `tblGroupMembers_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE,
CONSTRAINT `tblGroupMembers_group` FOREIGN KEY (`groupID`) REFERENCES `tblGroups` (`id`) ON DELETE CASCADE,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
I compared to other queries but can't find the error. I tried the following after i faced the error with the installer:
- Delete the mentioned table, try to create it using SequelPro (SQL Editor), same error.
- Deleted the table again, ran the same in PHPMyAdmin, same error.
I think the error with the fulltext may be related with this table not created properly.
You are so right. There was an additional comma, which shouldn't have been there. I'll fix it.
Thanks very much for your support.
Uwe
Can you let me know which comma? I will then continue testing tonight and let you know if the error message in Fulltext search disappeared.
Daniel