I was able to log back in after deleting my cache.

Christine @ IT helped me out. I've copied her reply to me below. My situation may not be the same as yours, so don't drop tables unless you are absolutely confident, but hopefully this will help.

It looks like the root cause of the issue resides within the site's sessions table. The "id" field is supposed to be the unique primary key of the sessions table, but in the site's database, the "id" field instead looks to be just a regular non-unique field, and an auto-incrementing "num" field is set as the primary key.

This means that every time a user clicks "Logoff", an entirely new logged-out session is being inserted into the sessions table, rather than the existing logged-in session record being updated. So the logged-in session always remains, and CMSBuilder never realizes you've actually logged out.

This happens because the query which handles this part of the logout process does so by making use of the "ON DUPLICATE KEY UPDATE" keywords, and an auto-incrementing primary key will always hold unique values, and therefore old logged-in session records will never have their keys identified as duplicate, so they will never be properly updated.

Simply dropping the sessions table entirely should trigger CMSBuilder to regenerate it with the correct fields. This can be done through phpMyAdmin in cPanel, or via the "MySQL Console" link in the Developer Console plugin in CMSBuilder.

Just to help clarify the difference in the primary key setup, in case a direct comparison is at all useful in illustrating the issue, here's approximately what the sessions table should look like:

cmsb__sessions CREATE TABLE `cmsb__sessions` (
  `id` char(64) NOT NULL,
  `expires` timestamp NOT NULL,
  `data` mediumtext,
  PRIMARY KEY (`id`),
  KEY `_auto_expires` (`expires`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC

And here's what the site's sessions table currently looks like:

CREATE TABLE `cmsb__sessions` (
  `num` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id` char(64) NOT NULL,
  `expires` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `data` mediumtext DEFAULT NULL,
  PRIMARY KEY (`num`),
  KEY `_auto_expires` (`expires`)
) ENGINE=InnoDB AUTO_INCREMENT=1010 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC

After upgrading to CMSB 3.82 on PHP 8+, I got this error when opening the subscriber list in the Newsletter Builder:

date(): Argument #2 ($timestamp) must be of type ?int, bool given /cmsb/lib/menus/default/list_functions.php on line 736
/admin.php?menu=_nlb_subscribers

The table cmsb__nlb_subscribers only contained: num, email, confirmed, authkey

But the schema file: cmsb/data/schema/_nlb_subscribers.schema.php

has: ‘listPageFields’ => ‘email, confirmed, createdDate, num’,

To solve the issue I added createdDate to my subscriber table

I suspect a more “correct” fix might be to remove createdDate from the schema so it matches the table, but I preferred not to modify a core plugin file in case I was missing something.

So this may just be an install/update edge case on my side, I’m not sure.

Jeff

Thanks for the update. I've run into an issue. I can not log off from admin.php. When you click the link: https://domainname.co.uk/cmsb/admin.php?action=logoff, the welcome screen loads and the user stays logged in. This is an upgrade, not a new installation.

Thanks
Jeff

I've been using the same host for my websites for the past 15 years, but they are becoming increasingly unreliable, and the once excellent personal support has been replaced with AI. Can anyone recommend a good host company based in the UK.

Thanks
Jeff

That's done the trick for me too.

Dave and/or Tim. Would you be able to chip in and let us know if this has any other repursions, security wise?

Also, any idea why it's an issue on some sites and not all? I've not done an extensive test, and it could be a coincidence, but the site with the error is the only site I have running with 3.75.

EDIT. I updated from 3.74 to 3.75 on the 27 December, and we didn't have any issues until today. It was working fine around 8-9pm (GMT) yesterday. Error first noticed around 7am today.

DId you ever get to the bottom of this? I have the same issue. I already force https, so I can't solve it with that!

I've looked at everything I can think of. I've tried php versions, removed cmsb plugins, removed third party code like Google Tag Manager and TrustPilot, reverted to the orginal factory settings for the websiteMembership plugin, different browsers.

Looking at the logs, it looks like everything is being passed to the server correctly. 

Any further insight would be hugely appreciated!

Thanks for pointing me in the right direction. I found a different solution. In customCart.php

function sc_addShipping($cartItems) {
	$shippingTotal = 0;
	foreach ($cartItems as $cartItem) {
		$shippingTotal += @$cartItem['shipping'] * @$cartItem['quantity'];
		foreach ($cartItem['OPTIONS'] as $option) {
			$shippingTotal += @$option['shipping'] * @$cartItem['quantity'];
		}
	}
	return array( 'name' => 'Shipping', 'TOTAL' => $shippingTotal );
}

Changed:

return array( 'name' => 'Shipping', 'TOTAL' => $shippingTotal );

to

return array( 'name' => 'Delivery', 'TOTAL' => $shippingTotal );

Using the same method I changed TAX to VAT.

function sc_addTax($cartItems) {…

return array( 'name' => "VAT ($taxPercentage%)", 'TOTAL' => $taxTotal );

…}

Can it be easily changed without screwing-up anything else? Thanks!

<?php if ($extraLineItems): ?>
<?php foreach ($extraLineItems as $extraLineField => $extraLineItem): ?>
<div class="row">
<div class="col-6">
<p class="mb-0"><?php echo htmlencode($extraLineItem['name']); ?></p>
</div>
<div class="col-6">
<p class="text-end mb-0"><?php echo sc_moneyFormat($extraLineItem['TOTAL']); ?></p>
</div>
</div>
<?php endforeach; ?>
<?php endif; ?>

I've just reduced the number of items in my navigation by half. We sell our websites on their ease-of-use, and this makes the admin panel so much clearer and less intimidating to users that aren't particularly tech-savvy.

Noted though that it may not be a good idea in all situations!

Related Records are much easier to set up now, thanks.

Can I make a request for a future update? It would be great if the dragsortorder column was included in the list of pulled-in records. It's great that a user can add/delete and modify. If they could drag the order too that would mean we can hide the related table in the navigation.

On a lot of my builds being able to do this would reduce the number of items in the navigation by a significant number, making the admin panel a lot simpler for the end user.

It's not a massive issue, but if it's relatively easy for you to implement perhaps you could consider it?

Are there any known issues with newsletter builder and 3.69?

The plugin generates the following url to unsubscribe to newsletters (placeholder: #unsubscribe_url#)

https://domainhidden.co.uk/newsletter-manage.php?n=895&a=531941d980b1&m=5&u=1

This link opens the page but unchecking the newsletter and saving doesn't result in any change.

If you remove &u=1 from the url the form works, but removing &u=1 also removes the error and alert instruction: Uncheck any newsletters you don't want to receive OR uncheck all lists to unsubscribe completely.

When a line of text exceeds the width of the box it stays on one line and adds a horizontal scroll bar. With previous versions the text would wrap onto the next line. Is this by design? Is there anything I can do to change it back?

I thought it may be a browser issue. I've tried in Safari 17.2.1 and Chrome 124.0.6367.209 (both Mac) and they have the same issue.

Thanks
Jeff

Set the css for all the slides. Something like:

.slide {
background: red;
}

Then set a separate style to alter the first slide only

.slide:first-of-type {
background: yellow;
}

In your js or html you apply the .slide class to all of the records. The first slide will have a yellow background, all the others will be red.

Could you use css?

<!doctype html>
<html>
<head>

<style>

div {
height: 100px;
width: 100px;
background: yellow;
}
		
div:first-of-type {
background: red;
}

</style>

</head>

<body>

<div>box 1</div>
<div>box 2</div>
<div>box 3</div>
<div>box 4</div>

</body>
</html>

Create a dropdown field with two values:

Image Box
Text Box

When the cmsAdmin selects Image Box you show an image upload field and hide the text box.
When the cmsAdmin selects Text Box you show the text box and hide the image upload.

The website looks great.

I've found an error. The link to download the latest version comes up with an error: Error(3): Download filepath doesn't exist!

The error is on this page: https://www.interactivetools.com/download/

Thanks

Are there any known issues with the Newsletter Plugin (3.07) and this latest release?

#154922 - implode(): Argument #2 ($array) must be of type ?array, string given
/home/domainhidden/public_html/cmsAdmin/lib/Fields/ListField.php on line 294
https://domainhidden.co.uk/cmsAdmin/admin.php?menu=_nlb_messages&action=add

Thanks
Jeff

I did the same as you, removed the offending files to regain access.