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

Bug 275915

Summary:	IP log reports SQL error for top level projects
Product:	Community	Reporter:	Gabe O'Brien <gabe.obrien>
Component:	IP Log Tool	Assignee:	Gabe O'Brien <gabe.obrien>
Status:	RESOLVED FIXED	QA Contact:
Severity:	normal
Priority:	P3	CC:	emo, nboldt, wayne.beaton
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Linux
URL:	http://www.eclipse.org/projects/ip_log.php?projectid=datatools
Whiteboard:
Bug Depends on:
Bug Blocks:	239327

Description Gabe O'Brien

2009-05-12 12:59:15 EDT

While looking into bug #239327 I discovered that when trying to look for the IP log of a top level project[1] the page returns an SQL error:

"SQL Trouble: 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 ')' at line 2"

  When you are looking for a component of the same project it seems to work fine[2].  

  Since the SQL error is very vague (to say the least) it might take a little digging to figure out which SQL query is causing the issues.

[1] http://www.eclipse.org/projects/ip_log.php?projectid=datatools
[2] http://www.eclipse.org/projects/ip_log.php?projectid=dsdp.dd

Comment 1 Wayne Beaton

2009-05-12 19:28:36 EDT

*** Bug 232607 has been marked as a duplicate of this bug. ***

Comment 2 Gabe O'Brien

2009-05-12 19:56:22 EDT

This is a link to the right of the title.  Let me know if that is not enough.

Example:
http://www.eclipsecon.org/2009/sessions?id=731

Comment 3 Wayne Beaton

2009-05-12 21:26:32 EDT

(In reply to comment #2)
> This is a link to the right of the title.  Let me know if that is not enough.
> 
> Example:
> http://www.eclipsecon.org/2009/sessions?id=731
> 

Was this comment really intended for this bug?

Comment 4 Gabe O'Brien

2009-05-13 15:19:18 EDT

(In reply to comment #2)
> This is a link to the right of the title.  Let me know if that is not enough.
> 
> Example:
> http://www.eclipsecon.org/2009/sessions?id=731
> 

No sorry I put this in the wrong bug, my bad.  Now I have to find the bug it was supposed to be in.

Comment 5 Gabe O'Brien

2009-05-15 15:02:47 EDT

I updated the IP log code so the SQL errors are not showing up for any of the top level projects.  I used the IP log selector page [1] to check each top level project (that shows up on the page).

I am marking this bug as 'fixed'.

[1] http://www.eclipse.org/projects/ip_log_selector.php