Unable to Upload Photos to Database

[JanssenT]

Since upgrading to Exhibit Engine 2.0x I'm unable to upload photos to my database through the "SPECIAL: no ftp or resize automation (manual file upload)"

The upload report has no information:

Return to UPLOAD TO DATABASE (http://www.photojourneys.nl/admin/EDITOR_upload.php?exhibition=56&ee_lang=eng) editor.
Note that [view] link opens public photo page with current user permissions.
If photo has errors, the reason can be seen in messages (http://www.photojourneys.nl/admin/EDITOR_message.php?exhibition=56&ee_lang=eng). If large sizes have failed, you can reupload in photo editor after reason for error has been fixed. If thumbs have failed you can redo them with rethumbnailer.


UPLOAD REPORT IS EMPTY

End of Report.


In the debug log I see the following error message:

2222007-01-19 14:13:26'lock_messages' in 'editor functions' Access denied for user: 'snl47125@%' to database 'snl47125'


Any thoughts how to solve this.

Thanks

Theo

[wkitty42]

Since upgrading to Exhibit Engine 2.0x I'm unable to upload photos to my database through the "SPECIAL: no ftp or resize automation (manual file upload)"
but you can upload with the standard functions??

In the debug log I see the following error message:

2222007-01-19 14:13:26'lock_messages' in 'editor functions' Access denied for user: 'snl47125@%' to database 'snl47125'
it appears that your host hasn't enabled "lock" privileges for your account... what type and version of database server are you working with?

[JanssenT]

but you can upload with the standard functions??


it appears that your host hasn't enabled "lock" privileges for your account... what type and version of database server are you working with?

Thanks for your reply. I have never tried to use the other options uploading my photos in the database. Using PS action to create microthumbs, thumbs, small and medium sizes. Manually upload them an add them to the database. In version 1.5 this never used to be a problem.

I've included my service providers version information.

Server signature: Apache/2.0.54 (FreeBSD) PHP/5.0.4 Server at www.photojourneys.nl (http://www.photojourneys.nl) Port 80
Server name: www.photojourneys.nl (http://www.photojourneys.nl)
Server protocol: HTTP/1.1
Http accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
Http accept encoding: gzip, deflate
MySQL version (reported by MySQL server): 4.0.26-log
MySQL version (reported by PHP): 4.0.26-log
MySQL client library version: 4.1.11
MySQL server and connection type: 195.128.174.33 via TCP/IP
PHP version: 5.0.4
PHP maximum script execution time: 30 seconds
PHP maximum html form upload size: 2M
Database in use: snl47125

[wkitty42]

i'm not sure what versions of mysql that "lock" priviledge is available on but i'd definitely check with your host... hopefully pekka will now see this thread and confirm that this is what the problem is...

it is possible that there's more info in the original requirements for this version of eE... that info is in at least one of the postings in these forums...

[JanssenT]

I've tried to upload with the size paths in place and with success! But still the same error message:

247 2007-01-20 10:44:07 'lock_messages' in 'editor functions' Access denied for user: 'snl47125@%' to database 'snl47125'

and

648 2007-01-20 10:39:32 'lock_data' in 'function ee_build_virtual_exhibition' Access denied for user: 'snl47125@%' to database 'snl47125'

[wkitty42]

what has your host said about the table locking function?