Is there a common reason (error on my part) why a row entered into a WPDataTable, and captured in the database as one row, would then render as duplicated rows in the WPDataTable?
It's appearing as duplicate rows in the back end as well as the front end - see attached.
We've had this issue in older versions of wpDataTables, but I can't recall seeing it in the last few months. Our latest version is 3.0.4, so if you're not on the latest version, first update the plugin.
If that doesn't help, please provide me FTP and database access credentials, along with a temporary WP-Admin user, so we can debug the plugin and see what's going on.
This is a public ticket, so please make sure to enable the PRIVATE response.
Thanks - it was an error in my SQL. I still don't know exactly what.
For the sake of anyone experiencing a similar issue.
I was trying to load front end data visible and editable not by everyone, and not just by the owner, but by all members of a hidden or private BuddyPress Group.
Some simple JOINING of three tables (my data table + bp_groups + bp_groups_members) and a WHERE statement ended up solving both problems:
SELECT (etc.)
FROM my_data_table RIGHT JOIN wp_bp_groups ON my_data_table.groupslug = wp_bp_groups.slug RIGHT JOIN wp_bp_groups_members ON wp_bp_groups.id = wp_bp_groups_members.group_id WHERE wp_bp_groups_members.user_id = %CURRENT_USER_ID%
The front end tables can also be edited and saved.
Is there a common reason (error on my part) why a row entered into a WPDataTable, and captured in the database as one row, would then render as duplicated rows in the WPDataTable?
It's appearing as duplicate rows in the back end as well as the front end - see attached.
Andrew
Hello Andrew
We've had this issue in older versions of wpDataTables, but I can't recall seeing it in the last few months. Our latest version is 3.0.4, so if you're not on the latest version, first update the plugin.
If that doesn't help, please provide me FTP and database access credentials, along with a temporary WP-Admin user, so we can debug the plugin and see what's going on.
This is a public ticket, so please make sure to enable the PRIVATE response.
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
Thanks - it was an error in my SQL. I still don't know exactly what.
For the sake of anyone experiencing a similar issue.
I was trying to load front end data visible and editable not by everyone, and not just by the owner, but by all members of a hidden or private BuddyPress Group.
Some simple JOINING of three tables (my data table + bp_groups + bp_groups_members) and a WHERE statement ended up solving both problems:
SELECT (etc.)
FROM my_data_table RIGHT JOIN wp_bp_groups
ON my_data_table.groupslug = wp_bp_groups.slug
RIGHT JOIN wp_bp_groups_members
ON wp_bp_groups.id = wp_bp_groups_members.group_id
WHERE wp_bp_groups_members.user_id = %CURRENT_USER_ID%
The front end tables can also be edited and saved.
Thank you for the feedback, Andrew
I'm glad to hear the issue has been resolved.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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