I tried something like that:
SELECT address, name FROM system.virtuser, system.names WHERE virtuser.virtuser = names.username AND virtuser = '%u'
In phpmyadmin the result works fine...
First column: Mailadress
Second column: Name
The following colums are empty so that i get the following error message:
DB Error: [1048] Column 'organization' cannot be null (SQL Query: INSERT INTO identities (changed, `email`, `name`, `organization`, `reply-to`, `bcc`, `signature`, `html_signature`, `standard`, user_id) VALUES (now(), 'Hakke@sub.domain.de', 'Hakke', NULL, NULL, NULL, NULL, '0', '1', '6610')) in /var/www/roundcube/roundcube-0.95/program/lib/Roundcube/rcube_db.php on line 416 (POST /?_task=login&_action=login)
How do i have to change my sql-query so that it is working? I dont want to fill organization, reply to etc...