Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 353912 - MySQL Errors when attempting to add new map file
Summary: MySQL Errors when attempting to add new map file
Status: RESOLVED FIXED
Alias: None
Product: Babel
Classification: Technology
Component: Server (show other bugs)
Version: unspecified   Edit
Hardware: PC Mac OS X - Carbon (unsup.)
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Denis Roy CLA
QA Contact:
URL: URL_TO_THE_STRING
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-08-04 11:53 EDT by Matthew Davis CLA
Modified: 2011-08-11 12:30 EDT (History)
1 user (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Matthew Davis CLA 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 CLA 2011-08-09 12:58:37 EDT
Denis, can you take a look at this?
Comment 2 Denis Roy CLA 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 CLA 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 CLA 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 CLA 2011-08-11 12:30:40 EDT
Ah ok.  Thanks Denis !