• We have a network (multisite) WordPress installation.
    There are many sites (blogs) in it. But at “/wp-admin/network/settings.php?page=dm_domains_admin” we see the list of domains which has only 20 rows, whereas there are more than 50 sites. We can not see the rest 30+ domains.

Viewing 3 replies - 1 through 3 (of 3 total)
  • I have exactly the same problem.

    Plus the search function above the list doesn’t work, so I can’t try to find what records there might be that don’t appear on the list.
    Cheers,
    Mark

    The workaround is to look at the relevant database table itself, for example in phpMyAdmin. The table name is
    wp_domain_mapping
    where ‘wp_’ is your specific table prefix for your WordPress network installation. As such, in an alphanumerically sorted list of tables, it comes somehwere after each of the wp_nn_tablename tables (where ‘nn’ is each separate website’s number).
    Mark

    OK. I’ve found the actual cause of the problem.

    In the file domain_mapping.php
    /wp-content/plugins/wordpress-mu-domain-mapping/domain_mapping.php
    on line 192 the code is:
    $rows = $wpdb->get_results( “SELECT * FROM {$wpdb->dmtable} ORDER BY id DESC LIMIT 0,20” );

    This is the line that retrieves just the 20 rows max that the settings page displays.

    Changing that ’20’ near the end of that line to ‘200’ means that it will show up to 200 mappings on the settings page. Or just set it to something really high, or even try out removing
    LIMIT 0,20
    altogether (which works fine for me).
    Which gives you a line 192 of:
    $rows = $wpdb->get_results( “SELECT * FROM {$wpdb->dmtable} ORDER BY id DESC” );

    This doesn’t fix the domain search problem (it simply doesn’t work), but as long as you have the full list you can use your web browser’s ‘find text in page’ function to find the site you are interested in.

    Of course, your fix may get overwritten should this plugin get updated.

    Cheers,

    Mark

    Of course, if you have thousands of mappings and very low memory limits in php or mysql then you may crash the page.
    Cheers,
    Mark

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Domains list length’ is closed to new replies.