Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 353912

Summary:	MySQL Errors when attempting to add new map file
Product:	[Technology] Babel	Reporter:	Matthew Davis <mattadav>
Component:	Server	Assignee:	Denis Roy <denis.roy>
Status:	RESOLVED FIXED	QA Contact:
Severity:	normal
Priority:	P3	CC:	kitlo
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Mac OS X - Carbon (unsup.)
URL:	URL_TO_THE_STRING
Whiteboard:

Description Matthew Davis

2011-08-04 11:53:35 EDT

I'm trying to add a new map file to Babel.  I can select my project (technology.stem), but it does not populate the release versions select menu.  There are MySQL errors at the top of the project select menu, wasn't sure if they're related.  Since it does not populate the release versions, I cannot continue.

Thanks.

URL:
http://babel.eclipse.org/babel/map_files.php

Copy/paste of HTML from page:
<option value='<b>Warning</b>:  mysql_close(): no MySQL-Link resource supplied in <b>/home/data/httpd/eclipse-php-c' ><b>Warning</b>:  mysql_close(): no MySQL-Link resource supplied in <b>/home/data/httpd/eclipse-php-c</option><option value='<b>Warning</b>:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can'' ><b>Warning</b>:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can'</option><option value='<b>Warning</b>:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in <b>/' ><b>Warning</b>:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in <b>/</option><option value='<b>Warning</b>:  mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/loc' ><b>Warning</b>:  mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/loc</option><option value='<br />' ><br /></option><option value='<P>Unable to connect to the database server at this time(eclipse).</P><br />' ><P>Unable to connect to the database server at this time(eclipse).</P><br />

Comment 1 Kit Lo

2011-08-09 12:58:37 EDT

Denis, can you take a look at this?

Comment 2 Denis Roy

2011-08-11 11:45:17 EDT

That was funny.   Those mysql errors were in the actual babel database as values, not as an actual connectivity error.

The Eclipse projects list is pulled from this web-api:
http://www.eclipse.org/projects/web-api/project_release_versions.php

At some point that API must have been unavailable, so bad values were inserted.  I've removed those bad values; if ever this happens again, I'll make the import more robust.

Comment 3 Matthew Davis

2011-08-11 11:53:30 EDT

Interesting.  Thanks Denis.

Still leaves a question - how is the list of releases for a project generated (at ttp://www.eclipse.org/projects/web-api/project_release_versions.php).  It shows none for technology.stem, yet we have 4 or 5 releases (and completed) in our project metadata.

Comment 4 Denis Roy

2011-08-11 12:04:50 EDT

> yet we have 4 or 5 releases (and completed) in
> our project metadata.

Version information is pulled from Bugzilla.  It appears STEM hasn't defined any version information in Bugzilla.

In a perfect world, Bugzilla versions would be pulled from the meta-data so that you don't have to do this twice.  Sorry.

Comment 5 Matthew Davis

2011-08-11 12:30:40 EDT

Ah ok.  Thanks Denis !