Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Test xpdf with php
#16
(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 syntaxcheck 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` (
  `
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.

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)