|Problems? Is your data what you think it is?|
Re: Unexplained MySQL Errorby jbeninger (Monk)
|on Jul 20, 2003 at 15:19 UTC||Need Help??|
I'd actually thought I'd done a good job of laying out the question, but judging from the replies (and the wonderful 0-reputation), it's quite clear I was in error.
So in a general answer: the sql query I'm having a problem with was exactly as in the original post:
SELECT parent FROM categories WHERE id=1
I'm using the DBI error handling code, and that's what the apache logs give as the query, so it's not a matter of my not knowing what the query was. I should have made that clear.
As I said, the most puzzling part of it is that when you replace "parent" with "name" or "id", the query executes fine, and returns the respective name or id. When I copy the query directly from the error log and run it in the mysql shell, it runs fine.
As per numerous requests, here's the offending code:
Hope this helps you help me :) And for all of you looking for me eating my own words for thinking it could possibly be a problem in the db, and not in my code - keep an eye on this node - I'll post my solution if it's ever found.