Everything has been working great with version 1.7 but the wpDataTable Constructor now hangs on the second step after I indicate (a) I would like to prepare structure and input all the data manually when I then (b) provide the initial structure metadata and press "Create the table" etc -nothing happens .
Do you have any errors in your browser developer console? If you are not sure how to see that please send me temporary admin credentials and I will take a look
I successfully logged in and saw the problem and it looks like to me that plugin hit some security on your website and therefore ot returns 500 (Internal Server Error).
It should be more clear what is going on if you can access error log on your server to see why is this happening
I am minded to try deinstalling and then reinstalling the wpdatatable plugin (obviously wanted to avoid this as I will have to recreate existing tables) - but you may have other advice/suggestion?
Can you send me FTP credentials so I can debug this. I need to make changes to few files which I can from backend of your website but it is to easy to make a mistake that would break live site so it would be preferable if I can do it trough FTP
Problem is that our plugin tries to create wpdatatables_13 but you already have it in database. You also have 14 and 15.
If you do not need this tables you can remove it from phpMyAdmin but if you do you need to update "wdtGeneratedTablesCount" option in wp_options table from current 12 to at least 15 so our plugin could create correct table name in database.
If you are unfamiliar with process please send me phpMyAdmin credentials and I will do it for you
In phpMyAdmin I have "dropped" table 13 - 15 - and I have been able to create a test table using wpdataTable constructor BUT wpdatatables in wordpress has identified this new Table as 152 [wpdatatable id=152].
In phpmyadmin the new table is identified as wp_wpdatatable_13
Is the fact that the table id and shortcode in wordpress and the table label shown in phpMyAdmin are different a problem?
If you think that the discrepancy between the wpdatatable ids on the wordpress site and the table identification numbers viewed in phpMyAdmin is not a problem we are content to live with it on the site.
If - in the future - we decided we needed to deal with it are there any simple instructions you are able to provide for the actions we could take to make it work properly?
Everything has been working great with version 1.7 but the wpDataTable Constructor now hangs on the second step after I indicate (a) I would like to prepare structure and input all the data manually when I then (b) provide the initial structure metadata and press "Create the table" etc -nothing happens .
Hi Martin,
Do you have any errors in your browser developer console? If you are not sure how to see that please send me temporary admin credentials and I will take a look
Hi Miljko.
When I click "create the table and open in editor" the developer consol reports:
load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,plupload&ver=4.6.1:4 POST https://knowledgeflow.org.uk/UCHB-DP/wp-admin/admin-ajax.php 500 (Internal Server Error)
send @ load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,plupload&ver=4.6.1:4
ajax @ load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,plupload&ver=4.6.1:4
(anonymous function) @ wpdatatables_constructor.js?ver=4.6.1:336
dispatch @ load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,plupload&ver=4.6.1:3
r.handle @ load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,plupload&ver=4.6.1:3
Does that tell you what you need to know or would site access be useful?
Thanks for your help
Martin
Hi Martin,
Access to your website would be really useful.
Hi Martin,
When I tried to access your website it gave me
"This page is under construction. Please return soon."
Please investigate this
Hi Martin,
This looks like security issue. Is it possible for you to check your server error logs for possible errors?
Hi Martin,
I successfully logged in and saw the problem and it looks like to me that plugin hit some security on your website and therefore ot returns 500 (Internal Server Error).
It should be more clear what is going on if you can access error log on your server to see why is this happening
Unfortunately no error logs on server.
I am minded to try deinstalling and then reinstalling the wpdatatable plugin (obviously wanted to avoid this as I will have to recreate existing tables) - but you may have other advice/suggestion?
Hi Martin,
Can you send me FTP credentials so I can debug this. I need to make changes to few files which I can from backend of your website but it is to easy to make a mistake that would break live site so it would be preferable if I can do it trough FTP
Hi Martin,
Problem is that our plugin tries to create wpdatatables_13 but you already have it in database. You also have 14 and 15.
If you do not need this tables you can remove it from phpMyAdmin but if you do you need to update "wdtGeneratedTablesCount" option in wp_options table from current 12 to at least 15 so our plugin could create correct table name in database.
If you are unfamiliar with process please send me phpMyAdmin credentials and I will do it for you
Hi Miljko
Thank you for your advice
In phpMyAdmin I have "dropped" table 13 - 15 - and I have been able to create a test table using wpdataTable constructor BUT wpdatatables in wordpress has identified this new Table as 152 [wpdatatable id=152].
In phpmyadmin the new table is identified as wp_wpdatatable_13
Is the fact that the table id and shortcode in wordpress and the table label shown in phpMyAdmin are different a problem?
Martin
Hi Martin,
It should not be a problem. If you have any more difficulties please send me phpMyAdmin credentials and I will clear it to work properly.
Hi Miljko
Thank you for your excellent support.
If you think that the discrepancy between the wpdatatable ids on the wordpress site and the table identification numbers viewed in phpMyAdmin is not a problem we are content to live with it on the site.
If - in the future - we decided we needed to deal with it are there any simple instructions you are able to provide for the actions we could take to make it work properly?
Thanks for your help
Martin
Hi Martin,
If you have any problem with plugin please open up the ticket and we will help you.