Forums / Setup & design / Problem to delete any object

Problem to delete any object

Author Message

Eder Trevisoli

Thursday 23 February 2006 7:45:10 am

Hi !

I installed eZ 3.7.3 and I could finish the instalation process without problem!

Everything works fine, I can access the public interface and the admin interface.

I can insert/update object (article, folder, etc) by admin interface, <b>but I cannot delete any object that was created</b>.

When I try to delete an object I have this error:

Fatal error: A database transaction in eZ publish failed.

The current execution was stopped to prevent further problems.

In debug message I have this:

Error: eZMySQLDB Feb 23 2006 11:34:55 
Query error: Access denied for user: 'jni@200.178.123.25' to database 'jni'. Query: CREATE TEMPORARY TABLE eznode_count_ ( count int )


Unfortunately I have to use a limit server. My mysql user has this permissions:

jni: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER
hosts: localhost, 200.178.123.25

Please, I need help!

Eder

______________
Eder Trevisoli
BRASIL

Kristof Coomans

Thursday 23 February 2006 9:52:33 am

The MySQL user needs the CREATE_TMP_TABLE permission.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org