7.1.4 fresh install, sys_profile_fields

I just went to the database of a fresh install of 7.1.4 and examined the sys_profile_fields table and found the following.  What is the issue here?  When I go to admin and builders and look at the join form section everything looks normal.  The collation on Name is utf8_bin.  phpMyAdmin is Version information: 4.0.5, latest stable version: 4.0.6.

 

sys_profile_fields.jpg · 283.9K · 345 views
Geeks, making the world a better place
Quote · 7 Sep 2013

It's a phpMyAdmin configuration issue. http://stackoverflow.com/questions/2721302/phpmyadmin-shows-numbers-or-blob-for-mysqls-utf8-bin-callation-columns

It may be that you don't have the mysqli extension installed so phpMyAdmin may have defaulted to using normal mysql which does not handle blob as well. That is also mentioned in that document.

I have the mysqli extension on my server but i have not checked my phpMyAdmin config files to see if that was the case. So that's only a guess.




https://www.deanbassett.com
Quote · 7 Sep 2013

 

It's a phpMyAdmin configuration issue. http://stackoverflow.com/questions/2721302/phpmyadmin-shows-numbers-or-blob-for-mysqls-utf8-bin-callation-columns

Thanks Dean, I thought as much.  I really don't like the new phpMyAdmin; I may just yank it and go with an earlier version.  The question would be what does the new version provide that is good to have.

Geeks, making the world a better place
Quote · 7 Sep 2013

 

It may be that you don't have the mysqli extension installed so phpMyAdmin may have defaulted to using normal mysql which does not handle blob as well. That is also mentioned in that document.

I will check that.  This is a new server setup from almost nothing.

Geeks, making the world a better place
Quote · 7 Sep 2013

 

 

It's a phpMyAdmin configuration issue. http://stackoverflow.com/questions/2721302/phpmyadmin-shows-numbers-or-blob-for-mysqls-utf8-bin-callation-columns

Thanks Dean, I thought as much.  I really don't like the new phpMyAdmin; I may just yank it and go with an earlier version.  The question would be what does the new version provide that is good to have.


Don't know. I am still running version 3.5.8.1

Unless i have a need to upgrade something, i usually don't. I don't like messing with my server once i have it setup.




https://www.deanbassett.com
Quote · 7 Sep 2013

yes, it was a new install so I installed the latest version.

It was a config issue,

$cfg['Servers'][$i]['extension'] = 'mysqli';

was set to mysql instead.  Now it is as it should be.

Geeks, making the world a better place
Quote · 7 Sep 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.