PHP Warning: mysqli_query(): (HY000/1030): Got error 28 from storage engine in /home/ftp/u/umxopinm/wwwroot/wp-includes/wp-db.php on line 2033 WordPress数据库查询SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (557) ORDER BY t.name ASC 时发生Got error 28 from storage engine错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/shapely/page-templates/full-width.php'), get_header, locate_template, load_template, require_once('/themes/shapely/header.php'), wp_head, do_action('wp_head'), WP_Hook->do_action, WP_Hook->apply_filters, adjacent_posts_rel_link_wp_head, adjacent_posts_rel_link, get_adjacent_post_rel_link, get_permalink, get_the_category, get_the_terms, wp_get_object_terms, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms查询的

Codes

Codes

Aggregate Ranking

Matlab Code:

n=7;
m=1140;

% one preference per row 
% first column is i; second column is j
preferences =[
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
1 3
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
3 1
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
4 5
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 4
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
5 7
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
7 5
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
4 1
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
3 5
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
5 3
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
4 7
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
];

cvx_clear
cvx_begin
    variable r(n)
    expression v(m)
    for i = 1:m
        v(i) = r(preferences(i,2)) - r(preferences(i,1));
    end
    minimize(sum(square_pos(max(v,0))))
cvx_end

hist(v)
viol2 = sum(v>0.001)

cvx_clear
cvx_begin
    variable r2(n)
    expression v2(m)
    for i = 1:m
        v2(i) = r2(preferences(i,2)) - r2(preferences(i,1));
    end
    minimize(sum((max(v2,0))))
cvx_end

hist(v2)
viol1 = sum(v2>0.001)

Kathleen Li

发表评论

电子邮件地址不会被公开。 必填项已用*标注