[Geonetwork-devel] [ geonetwork-Bugs-1386861 ] Download on MySQL fails

Bugs item #1386861, was opened at 2005-12-21 09:02
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=533368&aid=1386861&group_id=72096

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Other functionality
Group: v2.0.0
Status: Open
Resolution: None
Priority: 5
Submitted By: Jeroen Ticheler (ticheler)
Assigned to: Jeroen Ticheler (ticheler)
Summary: Download on MySQL fails

Initial Comment:
I am facing a problem with "Downloading" option in
Geonetwork 2.0.0.
I have the metadata saved for a vector dataset, along
with the successful
file upload. I tried with .shp and also .zip uploads
and there is no
problem in uploading. The priviledge for this dataset
is ticked for
download and the download button also appears
accordingly. But, when I
search for the dataset (which it finds successfully)
and click
"download"button, it gives the following error:

The requested operation could not be performed.
Syntax error or access violation message from server:
"You have an error
in your SQL syntax; check the manual that corresponds
to your MySQL server
version for the right syntax to use near 'oa.groupId =
g.id' at line 1"

The download link points to:

http://192.168.10.8:8080/geonetwork/srv/en/resources.get?id=21&fname=test.zip&ac
cess=private

I am on mySQL 4.1 database, using Apache Tomcat 4.1,
and using Geonetwork
2.0.0

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=533368&aid=1386861&group_id=72096