Hi, Paul,
I had a similar problem but determined it is not (or at least, mine was
not) a DBI or DBD::mysql issue.
I did find the cause, in my case. I'm not sure how this could happen
and why it would only affect one item out of thousands, but there was
"corruption" in the database itself (I think, I'm no mysql admin ;).
We have not attempted to do any repair, as the db involved is being
retired (read only, for reference) with all data moved to another db.
And I was able to come up with a work around for my particular case.
What I saw was improper formatting of the header line.
When I tried to do a "select column from ..." I would get the error.
When I did a "select * from ..." there would be no error. But the
printed header looked like:
+--------+----------
|column
| ...other headers | ...
+--------+----------
It should have been:
+--------+----------
|column | ...other headers | ...
+--------+----------
I hope this helps. I can help with more details, if you can confirm the
problem is the same or similar, and if you can supply a copy of the SQL
you're using.
On 08/11/2011 11:49 AM, Paul wrote:
Did you find a solution to this problem? Cos I'm having the same difficulties.
--
Bob McGowan
