revcoincidence

Slight update. I’ve just seen there appears to be an error message displayed: Unknown column ‘ ‘ in ‘where clause’

I had to scroll right in the “results” to find this. I was alerted to the possibility of something when I saw that the counter showing how many records were displayed had changed. Instead of displaying the default “1-10 of 65” it said, “1-0 of” (and nothing else).

Hope this helps.

(I’ve not changed any of the data or tables since it was working.)

Thanks @colinfroggatt

I had disabled the auto-update, but thank you for thinking of me. I also appreciate you pursuing this on github. (I wouldn’t have known about that possibility!)

Thanks @colinfroggatt

That’s super helpful. I wondered whether there might be a way. Anyway – I am now better informed, have replaced the new plugin with the old and it all works! Just what I need.

And now we just need the next update to contain a fix for what 4.2.3 broke ??

Many thanks,
Mark

Thanks @colinfroggatt for your comments.

I am using WP 6.2.2, php 8.2.24, Buddypress 14.1.0, and BPGES 4.2.3

Sadly, I can’t “roll back” to an earlier version because 4.2.3 is the first version I have installed.

I’m also not able to dig around in the code in the way you have (nor do I understand it), so I guess I’m stuck till it’s fixed. Unless you or anyone else has any other ideas?

Good morning, @kimmyx

I will mark this as resolved even though it’s not quite yet.

Many thanks for all your help,

Mark

Thanks @kimmyx

Yes, I think a lightbox would be ideal – though it would have to show the image at full-size (or even zoom-able), not merely repeat the same-size image from the data table. It would even be an improvement if I could simply click the picture and see the image url opened in a new browser tab (i.e. to show the whole picture), but a popup lightbox would be perfect.

Thanks for the clarification on the other items. In regard to the latter, I’m trying to keep down costs for my charity, so for the time-being I won’t be purchasing the premium version. (Not even if you put the lightbox in it!)

Thank you for all your help,
Mark

Further note, now I can see that my initial message has somehow removed the three pairs of curly brackets around the texts I was seeing and turned them into a sort of box. I don’t understand why that has happened, but hope you will. In my emails I am seeing three curly brackets then usermessage then three closed curly brackets.

Hello again, @kimmyx

This is really helpful. Thank you for your patience with me.

The Detail Panel Viewing option sounds like the tool I need. In the meantime, I’ll keep using the horizontal scroll option on the full table and advise people to scroll right rather then click the eye icon. Sadly, it’s only a small image. What I’d really like is for users to be able to click the image and have it expand to fill the screen, but clicking the image just selects the table row…

I use the Image URL (for the memorials) because I’m uploading data from a CSV spreadsheet stored offline which refers to a URL (calculated from an automated EXCEL CONCATENATE function based on the plot reference). I upload new image files when the memorials change (e.g. a new inscription is added), and the uploaded CSV then just matches with it without requiring further manual interference. This suits me very well. Please can you confirm there’s no intention of removing the “Image URL” column type?

Thank you for explaining about the theme. You’re right… using WP’s own 2019 theme relocates the table’s title to the left. I’m actually happy with the layout as is, so for the time being I won’t be changing theme – but thanks for the heads-up.

I am grateful, too, for the link to the Grid example, which I had obviously seen somewhere which is why I was aware that the display could be adapted. However, it looks like this is a premium feature related to form entry rather than a free feature related to data display. If so, this is probably why I am struggling to find it. Can you confirm?

Many thanks,
Mark

Hello @kimmyx

Thanks ever so much for getting back to me on this, and so promptly, too!

First thing first, it looks like you’re table is set to Auto-hide columns. Your image column is near the end so it’s currently hidden on the table view.

You’re right. The auto-hide was a deliberate choice. In the past, I’ve not been keen on horizontal scrolling tables, though now I’ve tried this one, I can see it’s quite tidy on mobile and PC screen and I may keep it!

You can still access the legacy Table Builder by clicking on Tables from the top toolbar.

Thanks for this. I’ll be honest – that’s how I created the table on this occasion for speed! What is missing is the old Data PUBLISHER module – so I had to go to the App Builder to publish the data. I will try to familiarise myself with the new process going forwards.

I think I understand all you have written about the way data is stored (including your comments on metadata) and am reassured by your comment that “everything looks good.” I note that I am not trying to use the Image URL column data anywhere outside WP Data Access…

So, having enabled the horizontal scroll so the full table can be seen, it is clear that the images (where there are connected image files), are [now] displaying correctly in the table. However, they are not showing correctly when the user clicks the “Eye” icon to reveal the full row entry (what used to be the green “+” button); the last row of that view reveals the URL of the image as a line of text, not the image itself. Use “Plot A2” as an example and you will see what I mean – there’s an image in the table, but not in what I might call the “full entry view.” That’s where I was hoping to show the image (rather than in the right hand of a horizontally-scrolled table). See Churchyard – Widford Church for a table I created the old way last year which shows it working properly.

Any thoughts on this?

Finally, you note

Also, some elements in your table are pushed to the side, so there might be styling issues happening on the page.

I’m not sure which elements you have in mind, or how I might alter them. I am quite keen that more data should be shown up-front (there’s loads of empty space on screen between columns, and only two columns visible on mobile which is less than helpful). I am also eager to redesign the “full entry view” so that it takes up less room and needs less scrolling to read it all, but I’ve not worked out how to do that yet. Any pointers about how to do any of this would be really helpful.

With many thanks,
Mark

Overnight update to WP 6.4.1 appears to have fixed it.

Hello again,

Other issues with the site meant have interfered with progress. However, they seem now to have fixed themselves (presumably caused by an update which has subsequently been amended!). And now, I believe I have found the plugin which is causing the problem – it’s the Add-On from Paid Memberships Pro, designed to facilitate limiting the publication of certain events to appropriate levels of membership. I’ve deactivated it and the calendar now appears properly. Obviously it’s disappointing that I can’t tailor the calendar as I had hoped, but better that the calendar works! (I thought I had tried this previously, btw. Still, happy that it works now.)

Any idea why the PMPro plugin has stopped working? Presumably there was an update somewhere that changed something in the relationship between it and the Events Calendar…

Good evening @d0153

I’ve just started with the staging site, but unless I am mistaken, I don’t think it will enable me to replicate (or solve) the problem … in order to view the staging site, I have to be logged in as administrator – but the calendar works perfectly when I am logged in as administrator. I need to be logged out to verify whether the calendar has started working for logged out users – and I can’t access the staging site unless I am logged in as administrator!

So I am going to have to think again. Am I missing something?

Thanks, @d0153

Originally, I didn’t think I would be able to do this, but I think I might have a way, now. Sadly, I’m properly busy at present, so it won’t be immediate. Please don’t close the request due to inactivity! I will let you know how I get on…

Thank you.

Hello @d0153 ,

I’ve deactivated WP Super Cache a second time, but it made no difference again. I even accessed the site on a new browser just to ensure I wasn’t accessing cached pages, but it has made no difference. I’ve asked my hosting provider if there is a cache running there. I’ll come back to you as soon as I know. If it helps, I use your plugin on another site which is also hosted with this same provider and it works without problem on that site. This leads me to think it’s related to other plugins on this site rather than the cache but, as noted above, I haven’t been able to isolate the conflict.

Hello again,

I’ve deactivated WP Super Cache and tried the site again. Sadly, the problem still remains the same. Accordingly, I have reactivated the plugin.

I can’t send you a screenshot via this forum, but here’s what is in the WP Super Cache Advanced Options [textarea] box titled “Rejected URL strings” (cut and pasted from the site, not re-typed here):

wp-.*.php
index.php
/events/
/event/

The first two lines were there by default. I’ve just added the bottom two lines, as per the instruction on your webpage.

Thanks for your continued help.