Forums / General / Query error: Access denied for user: :: ez Version 3.6.0

Query error: Access denied for user: :: ez Version 3.6.0

Author Message

Rob Rob

Sunday 12 June 2005 12:01:52 am

While testing the new version with standard settings I didnt encounter problems.

But if I try to delete any content ( folders, articels, photos, galleries ) I always encounter this message ( from my logfile)

----------------------------------------------

Query error: Access denied for user: 'xxxx@localhost' to database 'usr_xxxxx'. Query: CREATE TEMPORARY TABLE eznode_count ( count int )

Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-acad54064607a4bcdd09a8fc86ccbdd8.

----------------------------------------------

Fatal error: A database transaction in eZ publish failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-3edd4dd1244b69048b0d0f4f508368f4 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

-------------------------------------------------

My question: Because I am a beginner, maybe I forgot to set some basics. I can create folders, articels, photos, galleries, so I have proper access to my database, but deleting any item fails.

Any ideas, any help???

rob

Ɓukasz Serwatka

Sunday 12 June 2005 6:54:50 am

Hi,

This looks like your database user don`t have permissions to create temporary tables.

Try run this query

GRANT CREATE TEMPORARY TABLES ON *.* TO 'user'@'host' IDENTIFIED BY 'password';

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Rob Rob

Saturday 18 June 2005 2:24:43 pm

This was exactly the problem,

thanks a lot

rob