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,

Daniel

My php is 5.6 I updated  I did upgrade my php  to 7.6 and it went south

where do i find my cms version number also I downloaded the lkatest cms but don't know how to upgrade it

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

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,