Cant Delete records

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
arcanebits
Veteran Member
Posts: 104
Joined: 2018-12-10 21:52

Cant Delete records

Post by arcanebits » 2022-08-03 16:46

Im entering with admin, and click on MORE to be able to see, DELETE the selecteds records and its only gives PRINT

Is there a way I can manually verify the Permissions? since also the admin button its lost.
hope some one help
a3

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Cant Delete records

Post by jsetzer » 2022-08-03 17:10

Click your user name at the top-right (navbar). The user profile page will show all available tables and granted permissions for the current user.
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Cant Delete records

Post by jsetzer » 2022-08-03 17:13

Perhaps check out this old forum article about displaying all permissions through a SQL query:

viewtopic.php?t=2803

TL;DR

Code: Select all

select 
`membership_groups`.`name` as 'group_name', `membership_grouppermissions`.`tableName` as 'table_name'
, case when `membership_grouppermissions`.`allowInsert` then 'Yes' else '-' end as 'create'
, case when `membership_grouppermissions`.`allowView`=1 then 'User' when `membership_grouppermissions`.`allowView`=2 then 'Group' when `membership_grouppermissions`.`allowView`=3 then 'All' else '-' end as 'read'
, case when `membership_grouppermissions`.`allowEdit`=1 then 'User' when `membership_grouppermissions`.`allowEdit`=2 then 'Group' when `membership_grouppermissions`.`allowEdit`=3 then 'All' else '-' end as 'update'
, case when `membership_grouppermissions`.`allowDelete`=1 then 'User' when `membership_grouppermissions`.`allowDelete`=2 then 'Group' when `membership_grouppermissions`.`allowDelete`=3 then 'All' else '-' end as 'delete'
from `membership_grouppermissions` 
inner join `membership_groups` on `membership_groups`.`groupID` = `membership_grouppermissions`.`groupID`
where `membership_groups`.`name` !='Admins'
order by `membership_groups`.`name`, `membership_grouppermissions`.`tableName`
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

arcanebits
Veteran Member
Posts: 104
Joined: 2018-12-10 21:52

Re: Cant Delete records

Post by arcanebits » 2022-08-05 17:02

*SOLVED*
After verified what Jsetzer told me, i was able to pin point that somehow I messed up some internal stuff, I created another subdomain, pasted the exact app last exported and its apperars now... It seems that I broke something while making some manual stuff.
Thanks!

Post Reply