| Quote from: dastrop |
There's obviously a problem with my CREATE INDEX permissions so I've raised a ticket, no 33385164. Once I get a resolution I'll try using MySQLadmin to create the indexes using DDL extracted from the includes/db_schema folder. I don't fancy doing a reinstall as I've already uploaded and configured a couple of GEDCOMS.
|
Hi,
I finally got a response to the ticket I raised regarding the "SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied..." message. It reads:-
"Dear username,
I have referred this to one of our Database Analysts. Unfortunately our default SQL user construct does not grant you index privileges. You could create your index using the ALTER TABLE command. The code I believe for PhpGedView is open source and thus can be modified. Alternatively you can use our dedicated hosting service @ payh.co.uk [mysql5]."
I've added the indexes using the table ALTER command and everything seems to be running OK.
Ian.
