URGENT: No access to cmsAdmin after upgrade

9 posts by 4 authors in: Forums > CMS Builder
Last Post: January 21   (RSS)

By wevolutions - January 19

Hello. I just upgraded to v3.53 and now I cannot access my cmsAdmin page at all.

http://trinicarsforsale.com/cmsAdmin/

Error: (An unexpected error occurred: #15253)

Please help.

Urgent!

Arif Ali

868-689-4695

By gkornbluth - January 19 - edited: January 19

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

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By gregThomas - January 19 - edited: January 19

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

Greg Thomas

PHP Programmer - interactivetools.com

By wevolutions - January 19

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.

By wevolutions - January 19

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.

By hans - January 20

Hello, do you have access to your phpmyadmin still?

Hans Marcon
PHP Programmer (In Training)
interactivetools.com

By wevolutions - January 20

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

By wevolutions - January 21

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.