Hi I have tried to create some test user. but now all the test users are able to login and see other users' table and data. How do I make it so that only admin user can see and access all users' table and all the subscriber users can only login to see and edit his own table and data
This depends on the user ID. Since you created the test user, you're the one who has his ID. If you were to post the table on a page, and view in incognito mode, you probably won't be able to see anything.
If you're still able to see the data, even when in incognito, you probably haven't configured the "Users see and edit only own data" feature properly.
In the link provided above there is a video. There you can see how you as an administrator can create a new admin table, where you'll be able to see all entries, while users can only see and edit their own.
Hi Thank you for the infor. I am now able to constrain all the users to only able to edit his own info only.
but after I created a table using SQL query to allow admin to access all user infor and edit all user infor, I encountered updating infor error every time I tried to edit and save the changes . please see my attached picture .
Will it be ok if you can login to my dashboard area to check for me. because there are too many settings in the plugin and It will be time consuming for me to take screen shot on everyone of them .this is my login
The issue here is that you set the User ID column to be "wdt_ID".
That's an automatically generated column, which has unique auto-increment values, and it can't be used as a User ID field, since every new row is being assigned with a new number.
I changed it to ID for [wpdatatable id=1], and you can do it for the other two tables, where you're experiencing the issue.
Hi Thanks for the assistance, I changed all User ID column to ID for all the three tables [wpdatatable id=1], [wpdatatable id=2] and [wpdatatable id=1]. then I went to the website front and try to add in a new user using my admin user . I still encounter the same problem that says the table doesn't exist
Hi Sir, thank you for the reply. I think you have misunderstood what I mean. the page http://cms4.axwebwork.com/test/ is page for subscribers to edit their their own profile infos and check their customers info and commission.
what I am trying to do is for the admin to be able to update data onto every users table using the sql type table which is located in the page here -> http://cms4.axwebwork.com/administrator-page/
the table name are [wpdatatable id=4] [wpdatatable id=5] and [wpdatatable id=6]
You don't actually need a semicolon at the end ( ; ). You see, when you add that, the plugin thinks that the table name is "837_wpdatatable_2;" instead of "837_wpdatatable_2":
So, I changed your queries from these:
SELECT * FROM 837_wpdatatable_1;
SELECT * FROM 837_wpdatatable_2;
SELECT * FROM 837_wpdatatable_3;
To this:
SELECT * FROM 837_wpdatatable_1
SELECT * FROM 837_wpdatatable_2
SELECT * FROM 837_wpdatatable_3
Hi I have tried to create some test user. but now all the test users are able to login and see other users' table and data. How do I make it so that only admin user can see and access all users' table and all the subscriber users can only login to see and edit his own table and data
Hello bidtocart.
This depends on the user ID. Since you created the test user, you're the one who has his ID. If you were to post the table on a page, and view in incognito mode, you probably won't be able to see anything.
If you're still able to see the data, even when in incognito, you probably haven't configured the "Users see and edit only own data" feature properly.
In the link provided above there is a video. There you can see how you as an administrator can create a new admin table, where you'll be able to see all entries, while users can only see and edit their own.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Thank you for the infor. I am now able to constrain all the users to only able to edit his own info only.
but after I created a table using SQL query to allow admin to access all user infor and edit all user infor, I encountered updating infor error every time I tried to edit and save the changes . please see my attached picture .
https://prnt.sc/o0a0io
https://prnt.sc/o0a0qz
Hi again bidtocart.
Can you please show me the query you used to create these tables, and the settings if you can?
I don't believe the table doesn't exist either. It must be something in the query confusing the plugin.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi ,
Will it be ok if you can login to my dashboard area to check for me. because there are too many settings in the plugin and It will be time consuming for me to take screen shot on everyone of them .this is my login
url http://cms4.axwebwork.com/wp-admin/
admin user id : admin
password : 960707Stek007
Hello bidtocart.
Sure, great!
The issue here is that you set the User ID column to be "wdt_ID".
That's an automatically generated column, which has unique auto-increment values, and it can't be used as a User ID field, since every new row is being assigned with a new number.
I changed it to ID for [wpdatatable id=1], and you can do it for the other two tables, where you're experiencing the issue.
Please let me know if this helps.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Thanks for the assistance, I changed all User ID column to ID for all the three tables [wpdatatable id=1], [wpdatatable id=2] and [wpdatatable id=1]. then I went to the website front and try to add in a new user using my admin user . I still encounter the same problem that says the table doesn't exist
Hello again bidtocart.
You set the ID column for editing to be ID instead of wdt_ID. I changed it back, and tested all three tables on http://cms4.axwebwork.com/test/.
I successfully added new values in all three tables. Can you please check and let me know?
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Sir, thank you for the reply. I think you have misunderstood what I mean. the page http://cms4.axwebwork.com/test/ is page for subscribers to edit their their own profile infos and check their customers info and commission.
what I am trying to do is for the admin to be able to update data onto every users table using the sql type table which is located in the page here -> http://cms4.axwebwork.com/administrator-page/
the table name are [wpdatatable id=4] [wpdatatable id=5] and [wpdatatable id=6]
Hello again bidtocart.
Understood, sorry for the misunderstanding.
You don't actually need a semicolon at the end ( ; ). You see, when you add that, the plugin thinks that the table name is "837_wpdatatable_2;" instead of "837_wpdatatable_2":
So, I changed your queries from these:
To this:
And now editing works on front end as well
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
oh I see . thanks a lot . I am too use to doing some coding with the ; at the back . :-D
You're welcome, bidtocart.
I'm glad I could help.
If you have any further questions or issues, please feel free to open a new ticket and we'll gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables