Admin Login error

Hi Robert,

Was the PHP version recently upgraded on your server? It's likely that you will need to upgrade CMSB to fix this error. If you can let me know your current PHP and CMSB versions, I can provide some more specific details.

Thanks,

Hi Robert,

You can find some official documentation on upgrades here: https://www.interactivetools.com/docs/cmsbuilder/upgrade.php

Make sure that you back up your most current database either by downloading a current database backup from your cmsAdmin/data/backups folder, or through PHPMyAdmin before upgrading since there have been some major changes in the database structure and you may have issues that need to be resolved before your site can be live again and you could lose data during the upgrade process.

Also, if you haven't upgraded in a while, you'll probably have to upgrade a number of the plugins you're using.

The latest versions are on the plugins page at: https://www.interactivetools.com/plugins/

Hope that helps,

Jerry Kornbluth

Hi Robert,

You can find the CMSB version under Admin > General Settings. The error message you copied was fixed back in CMSB 2.56 which indicates your site is running v2.55 or earlier.

In order to upgrade to PHP 7.4, you will need to upgrade to a newer version of CMSB. Note that the latest CMSB does not support PHP 5.6, so you'll need to do the PHP 7.4 upgrade first and then upgrade CMSB. This will cause some downtime on your site, so I suggest doing this during a time when you know the site won't be busy. It's always recommended to make both database and file backups first, in case you run into issues and need to undo the upgrade.

The link that Jerry posted contains some upgrade instructions - there are also "how to upgrade" text files included along with the CMSB installation that you can follow. Assuming you are currently running CMSB 2, make sure to follow any specific instructions listed for v2.

If you need to get the upgrade done without any site interruption - or otherwise need assistance with the process - feel free to send us an Installation Request (https://www.interactivetools.com/support/installation/) and we will do our best to assist you.

Let me know if you have any other questions!

Thanks,

I did update the site to the latest cms now when I change the banner on the front page I get this error Call to undefined function mysql_query() in /home1/rick123/public_html/cmsAdmin/plugins/createRecordHere.php on line 46. any help would be great 

thank You for all your help with this

Hi Robert,

What version of the plugin are you using. The current version is 1.03 and might contain changes that will solve your issue.

many MySql commands have been replaced with MySqli.

Here's a cheat sheet in the CMSBCookbook

http://www.thecmsbcookbook.com/recipedetail.php?MySql-to-MySqli-Cheat-Sheet-599

You might want to make sure that you're using the latest version of all the plugins that are active on your site(s)

Hope that helps

Jerry Kornbluth

Hi Robert,

As Jerry mentioned, it looks like you have at least one plugin that is using some legacy MySQL functions that no longer work in PHP 7. A good first step would be to upgrade any plugins causing issues (here it looks like the Create Record Here plugin).

CMSB also now includes a Legacy MySQL Scanner plugin - you can activate this plugin and then use it to run a scan both on your plugins and website files to locate other places that need to be updated. Updating to the latest version of a plugin should fix any legacy MySQL issues there, however, anything found in your website files may require some manual fixing.

Let me know if you have any further questions!

Thanks,

Hi Daniel,

Thanks, I had forgotten about the Legacy MySQL Scanner plugin. 

BTW: I noticed that all the non-official, user submitted plugins are now gone from the plugins lists on the IT site. Are they now listed in a new place on he site?

Jerry Kornbluth

Hey Jerry,

We're doing a bit of reorganization of our plugin list. The user-submitted plugins are currently hidden, but we're working on a new place to list them. In the meantime, let me know if you need a specific plugin that's been hidden and I can pass along a download link.

Thanks,