I found the bug and I have a solution. not easy.
modify updater.class.php
change all occurrences of
CONVERT TO $charset_collate
to
CONVERT TO CHARACTER SET utf8, COLLATE utf8_general_ci
then modify admin.class.php
search for this code (line 64)
$versions = parent::getVersions(true);
if(empty($versions) ||
version_compare($versions['sam'], SAM_VERSION, '<') ||
version_compare($versions['db'], SAM_DB_VERSION, '<')) self::updateDB();
and modify it like
if(isset($_GET['UpdateSAM'])) {
update_option('sam_db_version', '0.5.1');
self::updateDB();
}
$versions = parent::getVersions(true);
if(empty($versions) ||
version_compare($versions['sam'], SAM_VERSION, '<') ||
version_compare($versions['db'], SAM_DB_VERSION, '<')) self::updateDB();
the last step is to request the your site like
https://yoursite.com/wp-admin/admin.php?page=sam-settings&UpdateSAM=true
if that doesn’t work, try changing 0.5.1 with this versions:
1.9
2.0
2.1
all this can be done via plugin editor
I will email the developer with this fix, a new version must come soon