close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Update on PowerCMS with mySQLi

Thread began 2/20/2020 8:00 am by MagsW | Last modified 2/25/2020 11:11 am by Ray Borduin | 208 views | 8 replies |

MagsW

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.

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...

MagsW

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.

Sign in to reply to this post

MagsW

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

MagsW

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.

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...

MagsW

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

Sign in to reply to this post

MagsW

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.

Attached Files
WA_CMS.php
Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...