Re: affectedRows, rolling back MDB2?

Stacy Johnson wrote:
> Hi, sorry if this has already been asked, but I'm having some problems 
> using LiveUserAdmin, when creating a user.  I get this:
> *Error on line: 97*
> Array ( [0] => Array ( [code] => -4 [params] => Array ( [reason] => MDB2 
> Error: not supported-[Error message: _affectedRows: method not 
> implemented] ) [package] => LiveUser_Admin [level] => exception [time] 
> => 1140026109.0243 [context] => Array ( [file] => c:\Program 
> Files\PHP\PEAR\LiveUser\Admin\Storage\MDB2.php [line] => 223 [function] 
> => exec [class] => LiveUser_Admin_Auth_Storage_MDB2 ) [message] => 
> Couldn't create the query, reason: MDB2 Error: not supported-[Error 
> message: _affectedRows: method not implemented] ) )
> 
> I've done some reading, and it seems LiveUser (I'm using 0.3.6 btw) uses 
> MDB2's _affectedRows, which has apparently been removed in the last beta 
> .  I have MDB2 2.0.0rc4 beta, and I was wondering if anyone knew how to 
> force an install of an older pear package (I think I could just intall 
> MDB2.0.0 stable) or if anyone had some other suggestion?

This all sounds more like using out of sync MDB2 and MDB2 driver 
releases. Updating to stable should solve the problem. Note that in RC5 
we changed how boolean values are emulated in the database .. instead of 
Y/N we now use 1/0 in MDB2

regards,
Lukas