[RCU] Roundcube can't catch last_insert_id of users table

Daniel Jäger jaeger at j-it.org
Sat Oct 24 20:32:38 CEST 2009

Hi Folks,

hope I'm right with my topic on this list.

Go some weird problems with the auto_create_users feature.

On the "first" Login there should be a new user created to the users  

But I can't login and the errors log gives me following.

[24-Oct-2009 19:47:41 +0200]: PHP Error: Failed to create new user in / 
var/www/ispcp/gui/tools/webmail/program/include/rcube_user.php on line  
452 (POST /webmail/?_task=&_action=login)
[24-Oct-2009 19:47:41 +0200]: PHP Error: Failed to create a user  
record. Maybe aborted by a plugin? (POST /webmail/?_task=&_action=login)

If I go to the Line 452 and look at the source I see that this  
condition returns a false and so the error is pushed:
   if ($user_id = $dbh->insert_id('users'))

So in the end I don't get the Insert ID of the created user back.

But the Server does the insert correctly - there are now about 17  
entries of the same mail address in the table.

If I try to echo the $dbh->insert_id('users') value, its null.
But if I do the insert manually and do a SELECT LAST_INSERT_ID(); it  
works... so I don't really see whats the point?!

Has anyone of you experienced the same?
All other Logs (imap, SQL) dont signalise me that there would be  
something wrong.

At the end my Config of MySQL and PHP.

Got PHP 5.3,0, self compiled with:

'./configure' \
'--with-pear=/usr/local/lib/php' \
'--sysconfdir=/etc/php5' \
'--with-config-file-path=/etc/php5' \
'--with-libxml-dir' \
'--with-pcre-regex' \
'--with-mysql' \
'--with-mysqli' \
'--with-zlib' \
'--with-zlib-dir' \
'--with-gd' \
'--with-png-dir' \
'--with-xpm-dir' \
'--enable-gd-native-ttf' \
'--with-gdbm' \
'--enable-ftp' \
'--with-mcrypt' \
'--enable-calendar' \
'--enable-wddx' \
'--with-jpeg-dir' \
'--enable-bcmath' \
'--enable-shmop' \
'--with-pdo-mysql' \
'--with-mhash' \
'--with-openssl' \
'--with-xsl' \
'--with-ldap' \
'--with-ldap-sasl' \
'--enable-dom' \
'--with-curl' \
'--with-iconv' \
'--with-freetype-dir' \
'--with-bz2' \
'--with-gettext' \
'--enable-exif' \
'--enable-mbstring=all' \
'--with-kerberos' \
'--with-sqlite' \
'--enable-zip' \
'--enable-sockets' \
'--enable-shared' \
'--enable-sqlite-utf8' \
'--enable-soap' \

MySQL is 5.0.51a-24+lenny2 - standard debian package

Best regards
Daniel Jäger

List info: http://lists.roundcube.net/users/

More information about the users mailing list