Rich

Kim,

Unfortunately it did not work. Same result when using the “%” signs in the query.

I had the W3 Total Cache plugin active. I disabled it and the page seems to work OK now. The site gets so little traffic that I probably don’t need that plugin anyway.

Thanks for this. I will check on the caching plugin and the kill token option.

However, I only have the problem on THIS PAGE. All of the other data selection pages work fine.

AN UPDATE: It worked TOO well!

The “first-child” code changed the table width of ALL THE TABLES in the site, including tables that are not WP Data Access tables.

I ended up changing the field name in the SQL database from “3d_index” to “project_no” and then making the appropriate changes in the plugin to access the renamed field in the WP Data Access table. That worked to change ONLY the single WP Data Access table where I needed to make this change. So now – FOR SURE – we’re all set.

Thanks again!

THAT DID IT! The “first-child” language did the trick. The first column is now responding to the code properly.

You guys are amazing. Thanks so much – AGAIN!

I added that css as you suggested, Kim. Still no joy.

I have a lot of extra css in the theme to format the tables the way I want them to look. Perhaps there is some conflicting code there preventing this from working? I also note that changing the width percentage in the 3d_index column does nothing. If I change it in any of the other columns, it DOES change the look of the table.

Here’s the CSS that’s in there:

table.wpda-datatable thead th,
table.wpda-datatable tfoot th {
background-color: #095599 !important;
color: white !important;
border: 1px solid #095599 !important;
}

table.wpda-datatable {
background: #ffffff !important;
border: 1px solid #095599 !important;
}

table.wpda-datatable tbody td {
border: 1px solid #095599 !important;
}

/* This turns off the footer for the WP Data Access tables. */

.wpda-datatable tfoot {
display: none;
}

td.3d_index {
width: 5%;
text-align: center !important;
}

td.description {
width: 20%;
}

td.img1 {
width: 30%;
}

td.img2 {
width: 30%;
}
td.forum_link {
width: 15%;
}

/* This sets the theme top bar menu to full width */
.topclass .kad-topbar-right,
.topclass .kad-topbar-left {
width: 100%;
}

/* Removes the default 100% table width in the Virtue theme.*/
body .entry-content table {
width: unset;
max-width: unset;
}

Thanks again for the help.

• This reply was modified 1 year, 9 months ago by Rich.
• This reply was modified 1 year, 9 months ago by Rich.

Thanks for the suggestion, but it did not work. It showed an error in the css. Also, I’m just trying to center the text in the first column, not all the columns in the table.

There we go! That worked perfectly!

Thanks for the FAST answer to this, Kim. Love this plugin!

Thanks for this, Kim! But I have a slight problem. I already have some code in the Advanced Settings for the table:

{
“language”: {
“processing”: ” “,
“loadingRecords”: “Loading the projects…”
}
}

If I add this new code, I get an error on Line 6 and none of this code works:

UPDATE: IT IS FIXED!

It was a permissions issue. I did not have the appropriate permissions set on the database, so it was not appearing in the plugin. Once I discovered that and fixed it, everything returned to normal.

Whew!

I ran the query, but it didn’t work. I think the issue is that WP Data Access doesn’t see the correct database on the new server.

This is what the phpMyAdmin screen looked like on the old server:

No other database appeared there, even thought the old site was also a WordPress site.

This is what I see on the new server:

The new ogaugerr_3d_downloads database does not appear in WP Data Access. Only the ogaugerr_repository database shows up in WP Data Access. That is the main WordPresss database for the site.

This is what I see in WP Data Access Explorer:

That “rdb:” entry was an error on my part to try and add the downloads database. It is incorrect, but I don;t know how to get rid of it.

I don’t know what to do here, Peter. If you need to log in and look at this yourself, give me a way to contact you privately and I’ll give you the login credentials.

Thanks for your help.

Well…it’s a good news, bad news situation. The static site downloaded to my local machine OK, and most of the site works fine locally. However, the main part of the site doesn’t work.

The diary pages, which are the pages I am most concerned about preserving, are built from an SQL database using the WP Data Access plugin. The data doesn’t appear the static site…a least not with the default settings in Simply Static.

I will continue exploring the options in Simply Static. Perhaps there is a setting that will make that part work, too.

I installed the Simply Static plugin and I’m running it now. We’ll see what happens!

Thanks again, Mike.

Houston, we have a problem.

The WP Static HTML Output plugin has been taken off the market. Here is the message from the plugin page:

“This plugin has been closed as of August 10, 2020 and is not available for download. This closure is permanent. Reason: Author Request.”

Bummer.

Thanks Mike! This is all very helpful.