I'm back, but this time I have a whole new query!
SELECT `g`.*, `u2g`.* FROM `users2groups` AS `u2g` RIGHT JOIN `groups` AS `g` ON `g`.`groupid` = `u2g`.`uggid` WHERE `u2g`.`uguid` = '5bc40bc6-7974-102b-8a2c-d23ebefec1c9'
SQLSTATE: Cardinality violation: 1241 Operand should contain 1 column(s)
From the SyBase PDF linked above:
Cardinality violations occur when a query that should return only a
single row returns more than one row to an Embedded SQL™
That makes sense, but it doesn't apply to my situation, from what I can tell.
Can anyone see what I am doing wrong? The SQL executes in phpMyAdmin (and returns only one row), just not through the Zend framework. It shouldn't matter that it is going through ZF though, since it is returning a valid SQL error ZF is doing it's job.
I found this on page 159, section 5-37 under lock manager messages, code 1241
A semaphore cursor refers to a different semaphore than the one it is linked to.
In English, I think that means:
The column you are accessing refers to a column other than the one you want.
... how would I resolve that?