SQL error on user save

Topics from older beta tests.
Antworten
TenX
Beiträge: 54
Registriert: 11. Sep 2015, 13:22

SQL error on user save

Beitrag von 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()
Benutzeravatar
fasse
Administrator
Beiträge: 6044
Registriert: 12. Nov 2005, 16:06

Re: SQL error on user save

Beitrag von 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
Beiträge: 54
Registriert: 11. Sep 2015, 13:22

Re: SQL error on user save

Beitrag von 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
Beiträge: 568
Registriert: 30. Aug 2007, 17:42

Re: SQL error on user save

Beitrag von Offe »

Benutzeravatar
fasse
Administrator
Beiträge: 6044
Registriert: 12. Nov 2005, 16:06

Re: SQL error on user save

Beitrag von 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
Beiträge: 54
Registriert: 11. Sep 2015, 13:22

Re: SQL error on user save

Beitrag von TenX »

Will do. Thank you.
TenX
Beiträge: 54
Registriert: 11. Sep 2015, 13:22

Re: SQL error on user save

Beitrag von TenX »

Working in Beta 2. Thanks!
Antworten