Hi I have a problem with employees table being greyed out when i try to create a table and it just looks like its crashed as it loads spinning circle until i exit then when i look at the table its there but greyed out
I am using the real northwind database to work through as example database
the above site is not public yet but happy to go through any suggestions you have
I have managed to create other tables using sql select commands but not Employees and Categories
SELECT * FROM categories (This one is greyed out) SELECT * FROM customers SELECT * FROM employees (This one is greyed out) SELECT * FROM order details SELECT * FROM orders SELECT * FROM products SELECT * FROM shippers SELECT * FROM suppliers
BTW i did see a similar problem on another post but you told him to contact you via a ticket to support hence the support ticket
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.
Like I explain to you how table should look like in database(one name, without spaces) same is for columns in those tables. From your previous post I can see that column ResultHistoryV1.0 ID have space between. (should be ResultHistoryV1.0_ID )
Please note that this tool is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need.
Please note that writing queries are out of scope that we provide with standard support.
Hi I have a problem with employees table being greyed out when i try to create a table and it just looks like its crashed as it loads spinning circle until i exit then when i look at the table its there but greyed out
I am using the real northwind database to work through as example database
the above site is not public yet but happy to go through any suggestions you have
I have managed to create other tables using sql select commands but not Employees and Categories
SELECT * FROM categories (This one is greyed out)
SELECT * FROM customers
SELECT * FROM employees (This one is greyed out)
SELECT * FROM order details
SELECT * FROM orders
SELECT * FROM products
SELECT * FROM shippers
SELECT * FROM suppliers
BTW i did see a similar problem on another post but you told him to contact you via a ticket to support hence the support ticket
Any help would be good
Thanks
Ian
Hi Coolwedz1,
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.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Ian,
Like I explain to you how table should look like in database(one name, without spaces) same is for columns in those tables. From your previous post I can see that column ResultHistoryV1.0 ID have space between. (should be ResultHistoryV1.0_ID )
You can take a look in our documentation about Create a MySQL-query-based table by querying a database.
Please note that this tool is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need.
Please note that writing queries are out of scope that we provide with standard support.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables