|
From: SourceForge.net <no...@so...> - 2008-11-12 09:17:32
|
Bugs item #2265333, was opened at 2008-11-11 23:09 Message generated for change (Comment added) made by nobody You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2265333&group_id=191583 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: Core Group: SVN (please specify revision!) Status: Open Resolution: None Priority: 8 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: "ssl" is a reserved word in mysql - breaks fetchmail Initial Comment: (SVN r476) The "ssl" field in the fetchmail table causes an "invalid query" error message in MySQL because "ssl" is a reserved word. Options: a) quote the field name b) rename the field a) would be the better solution, but needs to be tested against PgSQL. @GingerDog: Does the following query (with field names in backtick quotes) work in PgSQL? SELECT `id`,`mailbox`,`src_server`,`src_auth`, `src_user`,`src_password`,`src_folder`,`poll_time`, `fetchall`,`keep`,`protocol`,`ssl`,`extra_options`, `mda`,`date`,`returned_text` FROM fetchmail order by id desc This bug affects everything around fetchmail. If we go for a), we need to change - the queries in fetchmail.php - maybe fetchmail.pl - some db_* functions in functions.php ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 09:17 Message: FWIW, my preference would be to rename the field, as it's bound to cause problems later on if it needs quoting all the time. e.g. s/ssl/use_ssl/ ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 09:16 Message: I don't think PostgreSQL likes back ticks (I certainly don't anyway). I believe you "escape" key words using double quotes - like "ssl". ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2265333&group_id=191583 |
