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

Make sure you look at the updated post above

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.