Did you GRANT permissions to the user:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON database.* TO 'user'@'localhost' IDENTIFIED by '******';
(The permissions may be inherent in the database structure, but I'm not certain that's the case...)
Yes thanks, I always GRANT Permissions, I forgot to include that in the email.
Check your PHP error logs. Almost sounds like PHP is running out of memory.
Jamie Holly
Yes thanks, I set memory_limit in php.ini but it makes no difference, I do not think php is reading the change to php.ini because the error always produces the same value even with memory_limit=512M or memory_limit=8M or even =-1 which is no limit.
Roger