Update on PowerCMS with mySQLi

Hi Ray, just wondering how the upgrading of PowerCMS is coming along? I have a few clients who are now chasing on a regular basis as they have had penetration tests done and they want me to upgrade from PHP5.6 to PHP7 because of security concerns. I've explained to them that I can't upgrade because the CMS won't run on PHP7 but I would like to be able to manage their expectations for when I can offer an upgrade.

I'm working on the upgrade to Design Extender now. I have to update menu writer, and I'm doing an overhaul of the page and site sculptor functionality to be responsive and work with more complex designs.

For now you can manually update your pages. I have posted a zip with an upgrade for php7 here: http://www.webassist.com/forums/posts.php?id=40806

That's fantastic Ray, I actually have a test site which is a mirror of a live site that I can install this on and make sure it all works OK before I roll it out to the live sites. I'll let you know if I come across any issues.

Hi Ray

I've updated a couple of sites now with the new files and on the whole it works fine, although I did have to change a couple of things which had been custom-coded and I'm going to make a list of things to be aware of which might help others so that they don't fall into the same traps I did!

One thing I wanted to ask about though - if the site uses other WebAssist features such as DataAssist pages, and particularly member areas controlled by SecurityAssist, presumably you can't just replace the files on the server such as helpergroupsrulesphp.php as this would erase any settings that were already in place - for example I have sites that have member login areas and a lot of custom Access Rules/Groups set up. How I would go about updating these sites?

I've also had one issue with one of the sites I've updated - the left hand links on the admin page don't work. I've included login details in the PM section - would you be able to take a look for me?

It looks like the site that isn't working doesn't have all of the files updated. Specifically Templates/admin.dwt.php is still the old version, but I imagine other files weren't updated either. I'd re-upload the latest version of all of the files to make sure they are all up to date.

That's what the problem was, the Templates folder hadn't uploaded - sorted now. I just need to know how to go about updating the sites which have other multiple SecurityAssist access rules set up.

I don't think that file has changed... so just keep yours and don't replace that file.

Lovely thanks, I'll definitely do that on a duplicate test site before updating the live ones!

Hi Ray, I've got an issue on another site I've updated - the text in the PowerCMS blocks on the page isn't appearing. I've re-uploaded all the PowerCMS files two or three times, the new columns have been added to the database and the rest of the pages load OK, just not the PowerCMS content. I turned on error reporting and it gives the following errors in each area:

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /var/www/vhosts/mysite.co.uk/httpdocs/WA_CMS/WA_CMS.php on line 38

**UPDATE** fixed the problem - it was an older version of PowerCMS that was installed, and when I compared the database structure to a newer installation I saw that the ContentAdminToolbar and ContentInlineToolbar columns didn't exist. I added them and now the content is displaying.