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

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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 Exponential 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