I installed this plugin last week and all seemed to go well until I try to edit data in the WP backend. When I try to edit a field in a record that has a similar ID field value to another record, the value I'm trying to change gets put into both records.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can take a look.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a Review on CodeCanyon on this link. It means a lot to us.
Thanks.
I installed this plugin last week and all seemed to go well until I try to edit data in the WP backend. When I try to edit a field in a record that has a similar ID field value to another record, the value I'm trying to change gets put into both records.
From the mysql.log file:
16 Query UPDATE PRODUCTS_TEST SET `WEBTITLE` = 'zzz' , `WEBDESC` = NULL , `WEBIMAGE` = NULL , `ACTIVE` = '1' WHERE `IM1-NUM` = 9
See the SQL statement above? Where it says WHERE `IM1-NUM` = 9.....this should read WHERE `IM-NUM` = "009-1705-00038"
The other record that is getting updated...its IM1-NUM value is "009-1939-00040"
Please advise why this is happening.
Thanks.
HI bsutherland,
Thank you for your purchase.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[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 bsutherland,
Can you please tell me do you have the same issue with the wpdatatabes support table that I created on your site.
I thing the issue might be that you maybe accidentally put the ; sign at the end of the query.
Best regards.
Kind Regards,
Miloš Jovanović
[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 bsutherland,
Can you please send me the PRODUCTS_TEST table (sql or zipped )so I can import it to my database and try to reproduce the issues.
Best regards.
Kind Regards,
Miloš Jovanović
[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 bsutherland,
The issue is in the first column because it is set to be primary key and you can not edit primary keys that are VARCHAR type.
The primary key must be integer column.
My suggestion is to add one more column that will be used as a primary key and manually add the numbers for it.
Best regards.
Kind Regards,
Miloš Jovanović
[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 bsutherland,
Glad to be able to help, you are welcome.
Hope that everything will work fine now.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a Review on CodeCanyon on this link. It means a lot to us. Thanks.
Kind Regards,
Miloš Jovanović
[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