Hi, after the preview of the connect to the table of my separate database (PostgreSQL), when I used the "create the table"-button (open in standard- or excel-like editor, anyway) I get an red error-window ->
"Error There was an error trying to fetch the table data: ERROR: relation "wp_wpdatatables" does not exist LINE 1: SELECT * FROM wp_wpdatatables WHERE id = 0 ^"
I use Wordpress on a Postgres database and for that I use the package "PostgreSQL_For_Wordpress" (pg4wp) from Hawk (www.hawkix.net).
In this Logfile of pg4wp, I can see the Error:
"[1570635302.9897] Error running :SELECT COUNT(*) FROM wp_wpdatatables---- converted to ----SELECT COUNT(*) FROM wp_wpdatatables----> ERROR: relation "wp_wpdatatables" does not exist LINE 1: SELECT COUNT(*) FROM wp_wpdatatables"
Is there maybe a workaround or solution to use pg4wp and wpDataTables together?
wp_wpdatatables is a table which is being automatically created when you install the plugin. It stores information about tables that you have created in the plugin.
If you have no tables in the database, this table would also be empty, so the SQL error says that no data exists in the table.
Another thing is - when you installed the plugin, this table is created in WordPress's database, so there's no need to create a separate DB connection to pull the info using SQL queries. You would need to have wpDataTables installed on both of these databases to be able to use this.
Thx! I switch to mysql with wp and so I can use the separate pgsql database well. It works.
Next question:
I will use Gravity Forms for editing my normal SQL-based wpDataTables. Is this possible? If yes, please give me an idea how I can make this. Now I can only make separate (new blank) wpDataTables based on Gravity Forms.
I am sorry to disappoint you about the Gravity Forms, though, but unfortunately something like this is not possible with the plugin's built-in features.
The Gravity Forms Integration for wpDataTables is a paid add-on that is used to create tables from existing Gravity Forms, but it cannot be used the other way around. So, you cannot edit the table through Gravity Forms form, unless the table has been created from an existing Gravity Form.
THX. Sorry that I have so many questions. I read the tutorials really ;-).
Next IMPORTANT question:
I need a information about the user who made changes of the data. For example in my datatables are a column with a user-id. when a other users change the data in this row then must this ID are change to the ID of the current user. My idea wars to give the %CURRENT_USER_ID%-placeholder to the Predefined value-Field of the editing-section of the column. But ist does not work.
I don't know why, but since 30 min I can not save mit changes. If I change data in the table it feels like normal and the green window with " Success! Data has been saved!" is showing. But the data is not store in the table/ database ??? After the reload of the table, the data is not changed. I see only the old data.
This usually happens when there are some errors or changes in the database.
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, please provide me database (PHPMyAdmin) credentials for both the WP database and the separate DB, so I can take a look. And let me know what's the table ID of the table you're having these issues with.
thank for this idea. but the saving-problem is near fixed. It wars a problem with my sql (IMHO). when i go over "Generate a query to MySQL database.“ it works. when i go over "Create a table linked to an existing data source.“ its more tricky (because own creative sql-code which I have to analyse now ;-).
Hi, after the preview of the connect to the table of my separate database (PostgreSQL), when I used the "create the table"-button (open in standard- or excel-like editor, anyway) I get an red error-window ->
"Error
There was an error trying to fetch the table data: ERROR: relation "wp_wpdatatables" does not exist LINE 1: SELECT * FROM wp_wpdatatables WHERE id = 0 ^"
Why?
... one more pictures to this problem
okay, I think I have an idea:
I use Wordpress on a Postgres database and for that I use the package "PostgreSQL_For_Wordpress" (pg4wp) from Hawk (www.hawkix.net).
In this Logfile of pg4wp, I can see the Error:
"[1570635302.9897] Error running :SELECT COUNT(*) FROM wp_wpdatatables---- converted to ----SELECT COUNT(*) FROM wp_wpdatatables----> ERROR: relation "wp_wpdatatables" does not exist LINE 1: SELECT COUNT(*) FROM wp_wpdatatables"
Is there maybe a workaround or solution to use pg4wp and wpDataTables together?
Hello Thomas
Thank you for your purchase.
wp_wpdatatables is a table which is being automatically created when you install the plugin. It stores information about tables that you have created in the plugin.
If you have no tables in the database, this table would also be empty, so the SQL error says that no data exists in the table.
Another thing is - when you installed the plugin, this table is created in WordPress's database, so there's no need to create a separate DB connection to pull the info using SQL queries. You would need to have wpDataTables installed on both of these databases to be able to use this.
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
Thx! I switch to mysql with wp and so I can use the separate pgsql database well. It works.
Next question:
I will use Gravity Forms for editing my normal SQL-based wpDataTables. Is this possible? If yes, please give me an idea how I can make this. Now I can only make separate (new blank) wpDataTables based on Gravity Forms.
Hey Thomas.
You're welcome, glad I could help.
I am sorry to disappoint you about the Gravity Forms, though, but unfortunately something like this is not possible with the plugin's built-in features.
The Gravity Forms Integration for wpDataTables is a paid add-on that is used to create tables from existing Gravity Forms, but it cannot be used the other way around. So, you cannot edit the table through Gravity Forms form, unless the table has been created from an existing Gravity Form.
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
THX. Sorry that I have so many questions. I read the tutorials really ;-).
Next IMPORTANT question:
I need a information about the user who made changes of the data. For example in my datatables are a column with a user-id. when a other users change the data in this row then must this ID are change to the ID of the current user. My idea wars to give the %CURRENT_USER_ID%-placeholder to the Predefined value-Field of the editing-section of the column. But ist does not work.
How can I realize that?
Actual Problem:
I don't know why, but since 30 min I can not save mit changes. If I change data in the table it feels like normal and the green window with " Success! Data has been saved!" is showing. But the data is not store in the table/ database ??? After the reload of the table, the data is not changed. I see only the old data.
Hi Thomas.
This usually happens when there are some errors or changes in the database.
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, please provide me database (PHPMyAdmin) credentials for both the WP database and the separate DB, so I can take a look. And let me know what's the table ID of the table you're having these issues with.
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 Aleksandar,
thank for this idea. but the saving-problem is near fixed.
It wars a problem with my sql (IMHO).
when i go over "Generate a query to MySQL database.“ it works.
when i go over "Create a table linked to an existing data source.“ its more tricky (because own creative sql-code which I have to analyse now ;-).
Can you give me an Idea for my User-ID-Problem?
Hi again Thomas.
Sorry, I forgot to mention that.
What you were trying to do with the %CURRENT_USER_ID% placeholder should be possible, though.
I have an SQL query based table:
And that table contains an ID column:
When I open that column's settings, and add %CURRENT_USER_ID% as a predefined value
It saves OK, and when I log in as root with ID 1, the edit modal comes up with "1":
Then, when I log in with another user, who's ID is "4", it comes up with 4:
If you don't want your customers to see that, and be able to edit it, you could simply hide it in the edit modal with some custom css.
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
Thx a lot, Aleksander!
I will check this and give you feedback.
Have a nice weekend,
Thomas
You're welcome, Thomas.
You too. 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