When I turned debug mode on, one database query error.
You have an error in your SQL syntax:
select distinct album_id from fitwp_rt_rtm_media where 2=2 AND context = ‘profile’ AND fitwp_rt_rtm_media.blog_id = ‘3’ and album_id in (,2) AND media_author=13
relevant code:
app/helper/RTMediaModel.php:
function get_other_album_count ( $profile_id, $context = “profile” ) {
$global = RTMediaAlbum::get_globals ();
$sql = “select distinct album_id from {$this->table_name} where 2=2 AND context = ‘{$context}’ “;
if ( is_multisite () ) {
$sql.= " AND {$this->table_name}.blog_id = '”.get_current_blog_id().”’ “;
}
if ( is_array ( $global ) && count ( $global ) > 0 ) {
$sql .= " and album_id in (”;
$sep = “”;
foreach ( $global as $id ) {
$sql .= $sep . $id;
$sep = “,”;
}
$sql .= “)”;
}
if ( $context == “profile” ) {
$sql .= " AND media_author=$profile_id ";
} else if ( $context == “group” ) {
$sql .= " AND context_id=$profile_id ";
}
global $wpdb;
$result = $wpdb->get_results ( $sql );
if ( isset ( $result ) ) {
return count ( $result );
} else {
return 0;
}
}
static function get_globals () {
return rtmedia_get_site_option ( ‘rtmedia-global-albums’ );
}
–
function rtmedia_get_site_option($option_name, $default = false) {
if( is_multisite() ) {
$return_val = get_option($option_name, $default);
if( $return_val === false ) {
$return_val = get_site_option($option_name, $default);
if( $return_val === false ) {
if( function_exists( “bp_get_option” ) ) {
$return_val = bp_get_option($option_name, $default);
}
}
rtmedia_update_site_option( $option_name, $return_val );
}
} else {
$return_val = get_site_option($option_name, $default);
if ($return_val === false) {
if (function_exists(“bp_get_option”)) {
$return_val = bp_get_option($option_name, $default);
rtmedia_update_site_option($option_name, $return_val);
}
}
}
if ($default !== false && $return_val === false) {
$return_val = $default;
}
return $return_val;
}
and I checked the database:
mysql> select * from fitwp_options where option_name=‘rtmedia-global-albums’;
±----------±----------------------±---------------±---------+
| option_id | option_name | option_value | autoload |
±----------±----------------------±---------------±---------+
| 315 | rtmedia-global-albums | a:1:{i:0;i:1;} | yes |
±----------±----------------------±---------------±---------+
1 row in set (0.00 sec)
mysql>
mysql> select * from fitwp_1_options where option_name=‘rtmedia-global-albums’;
ERROR 1146 (42S02): Table ‘fitnesshubsdb.fitwp_1_options’ doesn’t exist
mysql> select * from fitwp_2_options where option_name=‘rtmedia-global-albums’;
±----------±----------------------±----------------------------------------±---------+
| option_id | option_name | option_value | autoload |
±----------±----------------------±----------------------------------------±---------+
| 228 | rtmedia-global-albums | a:4:{i:0;i:2;i:1;i:3;i:2;i:4;i:3;i:14;} | yes |
±----------±----------------------±----------------------------------------±---------+
1 row in set (0.00 sec)
mysql> select * from fitwp_3_options where option_name=‘rtmedia-global-albums’;
±----------±----------------------±----------------------------±---------+
| option_id | option_name | option_value | autoload |
±----------±----------------------±----------------------------±---------+
| 264 | rtmedia-global-albums | a:2:{s:0:"";N;i:0;s:1:“2”;} | yes |
±----------±----------------------±----------------------------±---------+
1 row in set (0.00 sec)
Looks the problem is that one array with empty element, what could be the reason caused this? I had created albums without uploaded medias yet.
Thanks!