We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
I have configured a "Separate DB Connection" with a successful connection message. I have created a table linked to an existing data source. I have created a table with `id` int(8) NOT NULL AUTO_INCREMENT as the first column. I added the SQL query to the database table (SELECT * FROM rocker.pn221370;) and that successfully shows my table. I have enabled server-side processing. I have allowed front-end editing. I can successfully edit the table on a WordPress page, but when I try to save it I get an error message stating that "rocker.pn221370 does not exist".
Hi Joseph
Thank you for reaching out to us.
Please remove the semicolon at the end of the table name and it should work fine
Do let us know if you need any further assistance.
I have removed the semicolon and now I get the following error:
Error! There was an error trying to update the row! Error: Table 'wordpress.rocker.pn221370' doesn't exist
Please provide me a temporary WP-admin (administrator) user for your site where this happens and the table ID, 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 parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Blaženka,
Unfortunately this is a client site that's behind their firewall. I can only reach by VPN and don't have access to the pre-shared key. I'm available to meet on MS Teams or Zoom or any other screen sharing platform if that's possible?
Thanks,
Joe
Unfortunately we do not provide support over screen sharing platforms.
Can you clone the website?
If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files which you can send me (along with the log-in credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.
Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.
I have downloaded & ran Duplicator plugin. Do you need the installer and the archive?
Blaženka
I have sent to your email as requested.
Thanks,
Joe
Hi Joseph
Thank you, we will look into this shortly and get back to you.
Thank you for your time and patience.
Thanks!
Hi Joseph
Thank you for your patience.
The database name of the separate DB connection is rocker. So, in the query, there's no need to include it. If the table pn221370 exists in that database, you can easily create it with SELECT * FROM pn221370
We can't see the connection above the query, because you cut off the screenshots. One of the errors from your screenshots say "Table 'wordpress.pn221370;' doesn't exist", so even though you created a separate DB connection, you may not have selected it from the drop-down when you were creating the table.
We also don't see the table, so we don't know if you have an auto-increment integer column, which is necessary for editing. We can see a column "id" in the Editing tab screenshot, but is it an auto-increment column? The MySQL table name with the semi-colon is definitely wrong, so you should keep that.
We will need to have the dump of that separate DB that you included. We can't test it without that database.
Hi Blaženka,
I didn't see the connection drop down originally. I have created a new database table, and a new wpDataTable table and added the "Rocker" database. I believe this solves the original issue.
Now I have a different error I'm hoping you can help with. It doesn't seem to like the quotes around the column names. (see attachments).
Thanks,
Joe
Hi Blaženka,
Disregard the last post, I found that there was a pesky semicolon on the "EDIT" screen (MySQL table name for editing) after the database name. I removed the semicolon & all is working as expected now.
Thanks!
Joe
Hi Joe
Adding spaces in the column name, accent graves ( ` ) around column names and adding a semi-colon at the end of the query ( ; ) can also cause issues, so if you have them, please remove them.
So, remove spaces and quotes from column headers in the query, and remove all accent graves ( ` ).
You can always modify the displayed header of columns when you go to column settings, but this query should exclude all possible issues with the SQL parser.
Perfect, I'm glad to hear you managed to resolve the issue
If you have any other issue or question please open new ticket, and we help you out.
I’d like to ask you a favor. Would you mind taking a few minutes to write a review for us, please on this link?
Our free version is the only place where we can have proof for our hard work; your comments are beneficial for others to know what to expect when they’re looking for our plugin.
Thank you in advance. It means a lot to us, and I am looking forward to reading your comment.