[opencms-dev] Unable to edit or create new resources using 7.0.5

[Jonne Zutt]

Hi Patricia,

You report the exact same thing I've discovered recently (and send to
this list).
What I did is add a query from db/general/query.properties into the
mssql specific
query.properties file.

If you look inside the db/postgresql directory, you'll see in the
query.properties file
there, they already did the same thing for postgresql, where the
concat operator happens to be ||.

Below is the patch that probably solves your problem.
(If you don't understand, you have to add the lines starting with
C_READ_RESOURCE_OUS
to the file src/org/opencms/db/mssql/query.properties and omit the >
at the beginning of each line).

Regards,
Jonne.


Index: src/org/opencms/db/mssql/query.properties
===================================================================
RCS file: /usr/local/cvs/opencms/src/org/opencms/db/mssql/query.properties,v
retrieving revision 1.4
diff -r1.4 query.properties
25a26,37
>
> # MS SQL specific because of missing concat function: use concat operator +
> C_READ_RESOURCE_OUS=\
> SELECT DISTINCT \
>         ${C_RELATIONS_SELECT_ATTRIBS} \
> FROM \
>         CMS_${PROJECT}_RESOURCE_RELATIONS \
> WHERE \
>     CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TYPE = ? \
>     AND ? LIKE (CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_PATH + '%')
>