Douglas Loss

Thank you for the advice, Andrew. I tried to set the Login page to the WordPress default page, but it had no effect on the problem. When Paid Memberships Pro is activated, the entire website is still unreachable no matter the setting of the Login page parameter.

Perhaps useful further information: We have tried both “No” and “Yes” to use our SSL certificate, with no change in the problem. We aren’t using any add-ons to Paid Memberships Pro, and we just had the plugin generate all the required pages rather than select or edit them ourselves. We haven’t configured a payment gateway yet. But changing the setting from any particular gateway to “Testing Only” and then setting the SSL certificate use value to “No” has allowed the website to work with the plugin enabled. So it appears to be an issue with the SSL certificate and any payment gateway. (This is a guess.)

Thank you Peter. I have tried making these changes to our settings:

A Dynamic Hyperlink with the Hyperlink Label set to “$$Title$$”, +List?, +Form?, and +Window? all checked, and HTML set to “$$URL$$”.

In the Column Settings, I have defined the column “Title” with Label on List Table as “Title”, Label on Data Entry Form as “Title (key)”, and Column Type as “Hyperlink”.

All other columns are set to Column Type of “”.

Table settings are set to Process hyperlink columns as Plain text.

This gives a collapsed display with all entries listed as “Title”. When I expand an entry, I see the information from all columns, but the URL is not active and the Title displays as a link labeled “Title”. The link doesn’t work because it attempts to go to https://irg.space/database/$$Title$$.

I’m sure I’m close to having this work, but I don’t know quite where to go at this time (I’m waiting to work on the abstract field question until I get this link working properly).

If I give you a temporary administrative account on the server could you look at our settings and see if there’s something obvious we’re doing wrong? Thanks!

And here is the search results page for academic.oup.com, somewhat different from the previous two. When the Abstract link in each item is clicked, the entire Abstract is displayed:

https://academic.oup.com/journals/search-results?q=interstellar&sort=Date+%e2%80%93+Newest+First&allJournals=1&fl_SiteID=5567&page=1&qb={%22q%22:%22interstellar%22}

Here is the search results page on arc.aiaa.org, similar to the liebertpub.com page:

https://arc.aiaa.org/action/doSearch?AllField=interstellar&startPage=0&sortBy=Earliest

Here is the search results page on liebertpub.com, which is similar to what we were thinking about. You can click on the Abstract link for each returned item to see the beginning of the abstract:

https://liebertpub.com/action/doSearch?AllField=interstellar&startPage=0&sortBy=Earliest

Here is the current results page on our website:

https://irg.space/database/

Hello Peter,

At long last we have our database ready to connect to WordPress. I have started the connection process like this. I’ve configured rdb:interstellar_updates to connect to our database through Data Explorer. The problem is with the MySQL schema field. It has to have something, so I entered “information_schema,” the default MySQL schema name. Testing the connection gives this:

Preparing connection…
Establishing connection…
Connection established…
Counting tables…
Found 0 tables on remote host…

Remote database connection valid

I thought that might be the wrong schema name, so I changed it the schema setting to “interstellar_updates,” the other schema name I found in phpMyAdmin when connecting to our database. Testing that gave exactly the same result as above, but also removed the rdb:interstellar_updates entry from the database list. Any thoughts? Without the proper schema no table evidently can be found. I’m not enough of a DB admin to know where to go from here without some serious poking around, which I’m a bit loathe to do. I did look at the SCHEMATA entry in the information_schema database (still from within phpMyAdmin) and saw only the two schemas I mentioned above listed. Any advice you have will be greatly appreciated!

Thank you Peter! I really appreciate all the effort you put into making WP Dada Access the right tool for connecting to external databases from within WordPress. So far as I know yours is the only plugin able to do this cleanly and easily!

Hello Peter. How are things coming with this remote database access? I’m not trying to hurry you, I’m just curious. Our database is still being updated (we’re having a discussion with our ISP about getting CLI access to the server so we can do batch updates of records with scripts rather than trying to do everything through phpMyAdmin, as we need to update roughly 1500 records), so we’re not quite ready for it anyway. I really look forward to using your plugin!

Thank you Peter, I appreciate this very much. Given the season of the year I think no one can expect rapid responses on things like this. Our database isn’t ready to be made public anyway (I have a number of internal issues with it to address), so there’s no great hurry. I look forward to what you develop!

Thank you, Peter. No, our external database is not in the same MySQL instance. It runs on a different server. We created it as entirely separate so outside organizations could access it also without getting into the internals of our primary website. I have seen where it’s possible to create a separate wpdb instance within WordPress https://wordpress.stackexchange.com/questions/1604/using-wpdb-to-connect-to-a-separate-database, but I haven’t seen an easy way to then use well-developed plugins to access that new instance. Is this sort of thing possible?

Thanks Josh! It wasn’t clear to me that I needed to do this; I thought just making the fields required would cause them to show up on the form. I appreciate the help.

Thanks!

I’ve looked for Page Heading Options and Other Page Settings sections displayed in that Pasteboard image, but I don’t see them anywhere in either the WordPress or the Brizy page editors. How do you enable those?