URGENT: No access to cmsAdmin after upgrade

Hi Arif,

Before you do anything more, you should read the documentation at https://www.interactivetools.com/docs/cmsbuilder/upgrade.php

You can always get Interactive Tools to help with an upgrade at https://www.interactivetools.com/upgrade/

Or get them to help with an issue at https://www.interactivetools.com/support/request/ They can easily look at the error log and find out specifically what's going on.

That said, if you've been running the autobackup plugin, or backing up your database manually, you should have a recent backup of your entire database under the previous version in your on-line data/backups folder, so not to worry.

 I see that the site still seems to work, so I don't think that there are major issues.

I would re extract and re-upload your 3.53 files (sometimes uploaded files get corrupted).

If that doesn't work, maybe try backing up your existing data/settings.dat.php file and then remove all of the plugins from the line

'activePlugins' => 'your_plugins_separated_by_commas',

so you're left with 'activePlugins' => ' ', and upload that and see what happens. (some older versions of plugins can create havoc with newer CMSB versions)

If those don't work, I'd contact Interactive Tools support to follow up.

Just keep your backup files safe, especially the database backup files, your data/schema folder and your upload folders.

Be cautious and good luck.

Jerry Kornbluth

Hey Arif, 

I'll take a look into this one now. I've just responded to your support email asking for a few more details.

Thanks,

Greg

I have done upgrades in the past and I actually did the same exact upgrade on another website minutes before this upgrade and everything went well.

The active plugins were deactivated as you suggested and the same issue remains.

Thanks for the suggestions.

UPDATE: I downgraded to v3.11 which was my last working version and I now have access again to my cmsAdmin.

Below is from the developer log:

#16564 - E_USER_NOTICE: MySQL Error: Specified key was too long; max key length is 1000 bytes. MySQL Query:



ALTER TABLE `cms_uploads` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,

MODIFY `tableName` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `fieldName` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `recordNum` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `preSaveTempId` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `filePath` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `urlPath` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `thumbFilePath` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `thumbUrlPath` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `thumbFilePath2` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `thumbUrlPath2` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `thumbFilePath3` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `thumbUrlPath3` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `thumbFilePath4` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `thumbUrlPath4` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `info1` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `info2` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `info3` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `info4` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `info5` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL ,

MODIFY `storage` varchar(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci'



TIP: Add &deferCharsetUpgrade=1 to URL to temporarily skip this upgrade and then remove and re-add any indexes in the field editor for the fields listed above.



- in mysql_functions.php on line 415 by __mysql_upgradeTableToUTF8mb4()
/home/tcfs/public_html/cmsAdmin/lib/common.php (line 278)
http://www.trinicarsforsale.com/cmsAdmin/admin.php

^ I am not sure what to do from here.

Hello, do you have access to your phpmyadmin still?

Yes. I have access to my phpMyAdmin. Please guide me to get this sorted out. Thank you.

I sent an email to itools support 2 days ago in response to Greg Thomas and I have not gotten any feedback until now.

I really need to get my cmsAdmin upgraded.

Thank you.