The SQL query for removing wysiwyg_imageupload entries is MySQL specific and does not work under PostgreSQL. I have attached a patch against wysiwyg_imageupload-6.x-2.9 that fixes the problem. The SQL code in the patch is very generic, thus should work with most RDBMSs.

CommentFileSizeAuthor
wysiwyg_imageupload_pgsql.patch901 bytesillmnec

Comments

eugenmayer’s picture

eugenmayer commented

is there no way to deal with that issue with one query?

illmnec’s picture

illmnec commented

Why is having 2 queries a problem?

Postgres does not support more than 1 table per DELETE FROM request (see http://www.postgresql.org/docs/8.4/static/sql-delete.html). I think ANSI SQL also allows only 1 table per DELETE request.

Maybe you could wrap both queries in one db_query call, but I don't know how.

eugenmayer’s picture

eugenmayer commented
Status: Active » Needs review

I see. Well then lets finally take that one in. Can you confirm that this is working with MYSQL without issues?

illmnec’s picture

illmnec commented

I did some basic testes under MySQL and it works.