Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Test xpdf with php
#19
(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` (
  `
groupIDint(11NOT NULL default '0',
  `
userIDint(11NOT NULL default '0',
  `
managersmallint(1NOT NULL default '0',
  
UNIQUE (`groupID`,`userID`),
    
CONSTRAINT `tblGroupMembers_userFOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE,
    
CONSTRAINT `tblGroupMembers_groupFOREIGN 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
Reply


Messages In This Thread
Test xpdf with php - by Daniel - 11-19-2012, 12:04 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)