DB Alias and Sequence autoincrement
<cron-jbULQAKo4A5fyO9Q7EP/[email protected]> Thu, 27 Oct 2005 16:15:43 -0300
| Newsgroups | gmane.comp.php.pear.liveuser |
|---|---|
| Message-ID | <[email protected]> |
Hello,
I'm testing the examples from LiveUser_Admin/example1
Using MDB2 the example works correctly, but when using DB storage container
I get the error:
Couldn't create the query, reason: DB Error: no such field-UPDATE
liveuser_perm_users_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1054 **
Unknown column 'id' in 'field list']
It appear not to respect the alias *id* to *sequence* when using the DB
storage container:
'tables' => array(
'users' => array(
'fields' => array(
'name' => false,
'email' => false,
'id' => 'sequence',
),
),
After change the field name sequence to id on the database the example works
with out no problem.
I don't believe this is the expected behavior. Any advice on how to correct
this will be most welcome.
Another thing:
There is any way I can make LiveUser use the auto increment columns from
MYSQL?
Angelo