Table names blank

Hi J,

Can you add a screenshot? Do you see the mamage and explore links for the tables?

Best regards,
Peter

Hi Peter,

I don’t see how to post an attachment.

The columns in the Data Explorer without any data are:
‘Name’ ‘Creation Date’ ‘#Rows’ ‘Increment’ ‘Engine’ ‘Collation’

Conversely, the columns with data are:
‘Type’ ‘Data Size’ ‘Index Size’ ‘Overhead’ (all Overhead values ‘0.00 bytes’)

Thanks,

John

Hi Peter,

Also to answer your question about the links, yes I do see both the manage and explore links for the tables.

If I click on the ‘Manage’ link I get the message ‘ERROR: Invalid table name or not authorized’ (I assumed this was because of the blank table name.

If I click on the ‘Explore’ link I get a warning pop-up that says ‘You are about to edit a table of an external application! Changing this table might result in corrupting the external database. Are you sure you want to continue?’

When I continue, the page reloads but does not otherwise change.

Thanks,

John

Hi John,

I am on a holiday and have no laptop with me so I cannot check anything right now. I will be back on tuesday and see what I can do. Hope that’s okay for you. I’ll come back to you asap.

Best regards,
Peter

Thanks Peter

I try to be very patient and appreciative of open source developers who give so freely of their time. As this is an evaluation exercise for me, I can certainly wait until you return.

Enjoy your holiday!

Hi John,

I released version 2.5.1 which contains a very small change that might solve this issue (I hope). Can you please let me know if this works? Thanks!

Best regards,
Peter

Hi Peter,

The upgrade installed successfully, but there is no visible change and table names are still blank.

Thanks,
John

Hi John,

Can you paste your configuration in a message? To copy your configuration to your clipboard navigate to the plugin menu, click on Manage Plugin, move to tab System Info and click on button Copy yo clipboard.

Additionally, can you paste the full cell code of one table name column in a message as well? To copy the cell code to your clipboard navigate to the Data Explorer, right click the cell and click on Inspect (Chrome) or Inspect element (Firefox). Please paste the full TD tag in your message.

I hope we’ll get some additional information that might help…

Best regards,
Peter

Hi Peter,

Requested info is below.

In case you want to try to replicate my configuration, I just downloaded the latest Bitnami WordPress VM image (https://bitnami.com/redirect/to/636028/bitnami-wordpress-5.2.2-3-linux-debian-9-x86_64.ova) and more or less installed WP Data Access into an otherwise empty WordPress installation.

As there is nothing personal or sensitive in this installation, I am happy to post the image file somewhere for you to retrieve if that will save you any time.

Please let me know if you need anything else.

Thanks,

John

System Info output

Operating System
Type=Linux
Release=4.9.0-9-amd64
Version=#1 SMP Debian 4.9.168-1+deb9u4 (2019-07-19)
Machine Type=x86_64
Host Name=debian
Database Management System
Version=8.0.17
Pivileges=Alter, Alter routine, Create, Create routine, Create role, Create temporary tables, Create view, Create user, Delete, Drop, Drop role, Event, Execute, File, Grant option, Index, Insert, Lock tables, Process, Proxy, References, Reload, Replication client, Replication slave, Select, Show databases, Show view, Shutdown, Super, Trigger, Create tablespace, Update, Usage, XA_RECOVER_ADMIN, RESOURCE_GROUP_USER, SET_USER_ID, SESSION_VARIABLES_ADMIN, CLONE_ADMIN, PERSIST_RO_VARIABLES_ADMIN, ROLE_ADMIN, BACKUP_ADMIN, CONNECTION_ADMIN, BINLOG_ENCRYPTION_ADMIN, GROUP_REPLICATION_ADMIN, SYSTEM_USER, APPLICATION_PASSWORD_ADMIN, TABLE_ENCRYPTION_ADMIN, SERVICE_CONNECTION_ADMIN, AUDIT_ADMIN, BINLOG_ADMIN, ENCRYPTION_KEY_ADMIN, SYSTEM_VARIABLES_ADMIN, REPLICATION_SLAVE_ADMIN, INNODB_REDO_LOG_ARCHIVE, RESOURCE_GROUP_ADMIN
Grants=GRANT USAGE ON *.* TO <code>bn_wordpress</code>@<code>localhost</code>GRANT ALL PRIVILEGES ON <code>bitnami_wordpress</code>.* TO <code>bn_wordpress</code>@<code>localhost</code>
SQL Mode=NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
Web Server
Software=Apache
PHP Version=7.3.7
Protocol=HTTP/1.1
Name=debian
Address=10.10.127.152
Root DIR=/opt/bitnami/apps/wordpress/htdocs
Temp DIR=/tmp
HTTP Upload=Enabled
Max Upload File Size=40M
Post Max Size=40M
Max Execution Time=120
Max Input Time=300
Memory Limit=256M
Output Buffering=4096
WordPress
Version=5.2.2
Home DIR=/opt/bitnami/apps/wordpress/htdocs/???>???775
Uploads DIR=/opt/bitnami/apps/wordpress/htdocs/wp-content/uploads???>???775
Home URL=https://debian
Site URL=https://debian
Upload URL=https://debian/wp-content/uploads
Use MySQLi=true
Database Host=localhost:3306
Database Name=bitnami_wordpress
Database User=bn_wordpress
Database Character Set=utf8
Database Collate=utf8_general_ci
WP Debugging Mode=false
WP Data Access
Version=2.5.1
Repository=+wp_wpda_menu_items ( | ) (triggers -insert | -update) +wp_wpda_table_design ( | ) +wp_wpda_logging ( | ) +wp_wpdp_project ( | ) +wp_wpdp_page ( | ) +wp_wpdp_table ( | )
Browser
Agent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36
Chrome=true
Version=76.0.3809.100
Webkit=true

Table row HTML code

<tr id="rownum_1"><th scope="row" class="check-column"><input type="checkbox" name="bulk-selected[]" value=""></th><td class="table_name column-table_name has-row-actions column-primary" data-colname="Name"> <span class="nobr"><div class="row-actions"><span class="manage"><a href="javascript:void( 0 )" onclick="wpda_show_table_actions( 'bitnami_wordpress', '', '1', 'd469e29b3d', 'WordPress table', 'Loading...' ); this.blur();">Manage</a> | </span><span class="listtable"><a href="javascript:void(0)" class="view" onclick="if (confirm('You are about to edit a table of an external application! Changing this table might result in corrupting the external database. Are you sure you want to continue?')) location.href='?page=wpda&table_name=&action=listtable'">
                               Explore
                            </a></span></div><button type="button" class="toggle-row"><span class="screen-reader-text">Show more details</span></button></span> <span id="span_admin_menu_" class="nobr" style="display:none;width:auto;float:clear;"></span><button type="button" class="toggle-row"><span class="screen-reader-text">Show more details</span></button></td><td class="icons column-icons" data-colname=""><a href="javascript:void( 0 )" title="Add to favourites" onclick="wpda_list_table_favourite( 'bitnami_wordpress', '' )">
						<span id="span_favourites_" class="dashicons dashicons-star-empty"></span>
					</a></td><td class="table_type column-table_type" data-colname="Type">WordPress table</td><td class="create_time column-create_time" data-colname="Creation Date"></td><td class="table_rows column-table_rows" data-colname="#Rows"></td><td class="auto_increment column-auto_increment" data-colname="Increment"></td><td class="engine column-engine" data-colname="Engine"></td><td class="data_size column-data_size" data-colname="Data Size">16.00 KB</td><td class="index_size column-index_size" data-colname="Index Size">32.00 KB</td><td class="overhead column-overhead" data-colname="Overhead">0.00 bytes</td><td class="table_collation column-table_collation" data-colname="Collation"></td></tr>

Hi John,

Thank you for posting the info. I don’t see anything strange in your configuration. The HTML code seems be fine as well, except for the table name. If you don’t mind to share your VM image, I certainly like to get a copy. If you prefer we can connect on LinkedIn so you can send me a link to your VM image in private.

Thank you very much for your cooperation!

Best regards,
Peter

Hi Peter,

I have the image in the cloud and I sent you a LinkedIn invitation to connect.

We can exchange uninteresting details privately and return here if something useful to others turns up.

Thanks,
John

Hi John,

Thank you for sharing your VM image! Without it I would not have been able to solve this problem!

The problem is solved in the next release (2.5.2). Since I have some outstanding work I cannot deploy the new release right away. I prepared a patched version (see download link below) for users who do not want to wait for release 2.5.2. To install the ZIP file the old version of the plugin must be deleted first. After that you need to upload ZIP file containing the patched version.

https://drive.google.com/file/d/177IVh4U8zlbcdWFPR-oUaU-gfO5XYCs0/view?usp=sharing

Thank you very much for your cooperation John!!!

Best regards,
Peter

The ZIP plugin appears to have resolved my problem. I will try again from the WP plugin repository once the update is posted.

Now I will try to make sense of this for my needs.

Thanks so much!

Hi John,

Just wanted to let you know that I released a new version (2.6.0) that solves the original issue “Table names blank” of this topic. Thank you for your input!

Best regards,
Peter