Verteilpunkte des Betriebs sind als Admin einer Verwaltungsgruppe im Betrieb nicht vorhanden
Habe in echt einen Betrieb übergeben. Der Betrieb ist korrekt weiterhin nun beim Admin sichtbar. Die Verteilpunkte sind aber nicht mehr in der Betriebsliste aufrufbar. Verwaltungsgruppe ok, Admin ok.
mysql> select seq_id,fpersongroup_seq_id from company_plant where name='Palzerhof';
+--------+---------------------+
| seq_id | fpersongroup_seq_id |
+--------+---------------------+
| 440 | 37 |
+--------+---------------------+
1 row in set (0,01 sec)
mysql> select seq_id,fpersongroup_seq_id from collective_distribution where fcompany_plant_seq_id=440;
+--------+---------------------+
| seq_id | fpersongroup_seq_id |
+--------+---------------------+
| 87 | 37 |
| 100 | 37 |
| 101 | 37 |
| 103 | 37 |
+--------+---------------------+
4 rows in set (0,00 sec)
mysql> select * from persongroup where seq_id=37;
+--------+---------------------------+------------------------+----------+--------+------------------------+---------+
| seq_id | name | fperson_contact_seq_id | security | public | fgroup_category_seq_id | content |
+--------+---------------------------+------------------------+----------+--------+------------------------+---------+
| 37 | NachbarschaftsGut Arriach | 285 | O | C | 1308 | O |
+--------+---------------------------+------------------------+----------+--------+------------------------+---------+
1 row in set (0,00 sec)
mysql> select * from persongroup_members where fpersongroup_seq_id=37;
+--------+------+-----------------------+---------------------+------------------------+----------------+---------------------+
| seq_id | name | fperson_member_seq_id | fpersongroup_seq_id | fperson_contact_seq_id | member_type_kz | fquest_level_seq_id |
+--------+------+-----------------------+---------------------+------------------------+----------------+---------------------+
| 129 | NULL | 263 | 37 | NULL | ADMIN | 775 |
| 130 | NULL | 206 | 37 | 263 | ADMIN | 775 |
| 131 | NULL | 209 | 37 | 263 | ADMIN | 775 |
| 140 | NULL | 85 | 37 | 263 | NULL | 775 |
+--------+------+-----------------------+---------------------+------------------------+----------------+---------------------+
4 rows in set (0,00 sec)
mysql> select username from person where seq_id=263;
+------------+
| username |
+------------+
| NachbarGut |
+------------+
1 row in set (0,01 sec)
mysql>