11-27-2012, 12:34 AM
(11-26-2012, 02:49 AM)steinm Wrote:(11-24-2012, 10:26 PM)Daniel Wrote: Is my assumption wrong that a table is missing? Will it only be created upon usage of the feature?
All tables will be created during installation. There are no additional tables created later when using a feature.
Uwe
OK, i think i found something.
When i run the installer (i created the whole thing from scratch again) it displays this error message:
PHP Code:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 14
I deleted the database, created it again and ensure that i really set it to utf8, that's the case.
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.
Daniel