Table Cloning problem

  • Resolved AliasgerSW

    (@aliasgersw)


    11 years, 4 months ago

    When i use to duplicate the site for creating new site then it will also include another site table to copy.
    For example :
    My Site for duplicable ID is 18, when i use to copy this site then it will also include Sites tables of 180, 181, 182 etc.
    —————————
    Like table to copy is
    wp_18_posts

    for new site then it will also copy table named
    wp_181_posts, wp_182_posts
    with name of wp_22__posts.

    Due to this problem the tables of database overloaded by the garbage tables created from the process above.

    Please resolve this problem as soon as possible

    Thanks in advance

    Best Regards
    Aliasger Sabunwala

    https://ww.wp.xz.cn/plugins/multisite-clone-duplicator/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Pierre Dargham

    (@pdargham)

    11 years, 4 months ago

    Hi, thank you for your message, I did not see it !

    It is caused by mysql interpreting the ‘_’ characters in our queries as “any character” so we need to escape them before looking for tables to copy.

    If you want to add the patch manually, just add :
    $from_site_prefix = str_replace('_', '\\_', $from_site_prefix);
    line 46 in file lib/data.php and it should be ok.

    Or you can wait that I publish this patch in the next version 1.2.0 in a few days.

    Best Regards
    Pierre

    Thread Starter AliasgerSW

    (@aliasgersw)

    11 years, 4 months ago

    Just confirming, do i add above code before Get sources Tables comment ?

    Plugin Author Pierre Dargham

    (@pdargham)

    11 years, 4 months ago

    Yes, that’s it.

    Here you can see what I made :

    https://github.com/pierre-dargham/multisite-clone-duplicator/blob/master/lib/data.php#L47

    I have not yet publish it on ww.wp.xz.cn, i need to run a few more tests.

    Can you confirm me that it solved your problem ?

    Thank you,

    Best Regards
    Pierre

    Thread Starter AliasgerSW

    (@aliasgersw)

    11 years, 4 months ago

    Can you give me two days, because for testing i have to startup for multisite, because my previous database is stop responding to me because of huge amount of tables i.e. above 95000. So i am starting it for Cloning on tomorrow.

    Thankyou so much for your instant help. It seems like it will solve my problem.

    Best Regards
    Aliasger Sabunwala

    Thread Starter AliasgerSW

    (@aliasgersw)

    11 years, 4 months ago

    Hello sir,

    You work like charm sir…
    I have checked the issue, now my problem has been solved.

    Thankyou once again sir for helping me instantly.

    Best Regards
    Aliasger Sabunwala

    Plugin Author Pierre Dargham

    (@pdargham)

    11 years, 4 months ago

    Hi !

    I just released the last version 1.2.0 of the plugin, which includes this patch.

    Thank you for the 5-stars 😉

    Best regards,

    Pierre

    Thread Starter AliasgerSW

    (@aliasgersw)

    11 years, 4 months ago

    Thanks to you also sir to solve this problem instantly sir.

    Best Regards
    Aliasger Sabunwala

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Table Cloning problem’ is closed to new replies.

Tags