PHPAdmin not working..

[hawthorn]

I keep getting '#1273 - Unknown collation: 'utf8_unicode_' errors when trying to administer my Databases on sql15.

It works OK temporarily, then I get the error again.

Opened a support ticket but had no response.

[dmacminn]

Allow up to 48 hours for any escalated issue; but I suspect there's some issue with the collation sequence or Character set -- utf8_unicode_' should be utf8_unicode_ci or something similar.

It could be a damaged table -- do a backup/dump - then a check and repair any damaged tables -- you may need to re-import any that are really bad.
Posting additional info about when it occurs and with what app, etc. might let others help here -- to be frank, if MySQL services are running and phpMyAdmin comes up, that's about as far as we go with MySQL support --- unfortunately, you'll probably have to sort out the issue/fix the database yourself (perhaps with help from some new friends here)

[hawthorn]

I can update and read the tables thru php/MySQL normally, it's PHPadmin which doesn't work, or rather it works sometimes, then not for hours. Perhaps the tables are uncorrupting and recorrupting themselves?

secondly it is happening on both databases i have on sql15, and one of them hasn't been read or updated for weeks.

[IanS]

This sticky thread (http://forum.powweb.com/showthread.php?t=76496) provides a possible alternative if you're unable to get PHPadmin to work.

[notset4life]

I have the same problems with PHPMyadmin. The window pops up, the right frame shows, the left frame shows a 404 error. I refresh. After about 30 seconds, it usually finally shows up.

I was running phpmyadmin on my own site and just recently deleted because of the convenience of getting it through ops. Now I'm sorry I did that.