SQL error on user save

[TenX]

Under User management, click on Create User, fill in Surname, First name, click on Create User button.
User is created and Add user screen opens. Fill in fields under Basic Information and click on Save button.
Following error is generated:

S Q L - E R R O R

CODE: 42000
1066

Not unique table/alias: 'mem_categories'

B A C K T R A C E

FILE: adm_program/system/classes/database.php
LINE: 433
CALL: Database->showError()

FILE: adm_program/modules/profile/roles.php
LINE: 181
CALL: Database->query()

[fasse]

Hi Tenx,

I could not reproduce this on our playground.

The sql error sounds strange. Do you have two tables mem_categories in your database or set an alias for that?

Fasse

[TenX]

Fasse,
There is only one table named as 'mem_categories' and no alias that i am aware of. I have not altered the database as it was first installed with Admidio-Beta, other than change the table prefix from the default 'adm' to 'mem'.
Using local MAMP environment for testing with php 5.4.34
Database server

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.38 - Source distribution
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)

Web server

Apache
Database client version: libmysql - 5.5.38
PHP extension: mysqli Documentation


See some pictures below of table structure via phpMyAdmin:
https://www.flickr.com/photos/tony_hund ... 558205075/

[Offe]

I think, the fix should already be committed: http://www.admidio.org/forum/viewtopic.php?f=13&t=6812 + https://github.com/Admidio/admidio/comm ... b7e0486f2d

Offe

[fasse]

Ups, I forgot it.

This could be the reason why I could not reproduce this

Tomorrow we will release beta 2. Please test with this version.

Fasse

[TenX]

Will do. Thank you.

[TenX]

Working in Beta 2. Thanks!