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

Bug 344385

Summary: Generated IPLog cgi script does not escape reserved SQL apostrophe in email address
Product: z_Archived Reporter: Michael OBrien <michael.f.obrien>
Component: EclipselinkAssignee: Eric Gwin <eric.gwin>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: P4 CC: michael.f.obrien, tom.ware
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
URL: http://www.eclipse.org/projects/ip_log.php?projectid=rt.eclipselink
Whiteboard:

Description Michael OBrien CLA 2011-04-30 17:32:47 EDT 
>My temporary(sql-unfriendly) email michael.o'brien1 is causing problems with the generated IPLog
This was expected since day 1 with tools like Bugzilla (recently fixed), CVS, SVN and anything else that runs on top of SQL.  Normally the apostrophe should not be part of an email.
I will be getting my new email michael.f.obrien next week - this should fix it.
This issue is not specific to EclipseLink - it will occur for any project committer like o'connor where thier org does not removed reserved chars from their email. 

http://wiki.eclipse.org/EclipseLink/IPLog
>following
http://www.eclipse.org/projects/ip_log.php?projectid=rt.eclipselink
>causes an SQL parse 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 'brien1@acorporation.com' and ProjectID IN ('rt.eclipselink') and Relati' at line 3  
"



>otherwise it is likely a wrong flag set in bug # 284519 that is causing the issue
- see the Google cache from 22 Apr 2011 (my email changed about a week before this)
http://webcache.googleusercontent.com/search?q=cache:1-QufT5clf0J:www.eclipse.org/projects/ip_log.php%3Fprojectid%3Drt.eclipselink&cd=2&hl=en&ct=clnk&gl=ca&source=www.google.ca
Comment 1 Michael OBrien CLA 2011-05-02 11:22:43 EDT 
>Generate IPLog no longer fails for EclipseLink as of 20110502 email change to a normalized michael.f.obrien
Comment 2 Eric Gwin CLA 2011-05-09 08:07:46 EDT 
Reported as fixed. closing.
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:09:57 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink