New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem with creating new site - incorrect structure of new site. #240

Closed
pavel-rybnicek opened this Issue Oct 17, 2016 · 5 comments

Comments

2 participants
@pavel-rybnicek

pavel-rybnicek commented Oct 17, 2016

Version Information

  • WordPress: 4.6.1
  • MultilingualPress: 2.4.7
  • MySQL: 5.1.52 and 5.6.16 - both tested

Steps to Reproduce

Not sure if this is a Multilingualpress problem.

I created a new site based on original site. Found out that one of the new tables (wp_terms) was missing the last column - the 'CREATE TABLE wp_2_terms LIKE wp_terms' created a different table structure. No error message in debug log. In the following step, the data copy failed, as the tables structure was different.

Tried to create table with the same statement under same user in phpmyadmin, the result was correct - the tables had the same structure.

Finally I repaired the table manually.

What I Expected

I don't understand the cause of the problem. Anyway, I thing such an error should be detected and reported to the user.

What Happened Instead

Screenshot or Video

@tfrommen

This comment has been minimized.

Show comment
Hide comment
@tfrommen

tfrommen Oct 18, 2016

Contributor

Hi,

this is strange, I will have a look at this.

Was there some message/error logged for copying, or did you get no error at all?

Was this some one-time error, or does it still happen if you create another duplicate?

Thanks,
Thorsten

Contributor

tfrommen commented Oct 18, 2016

Hi,

this is strange, I will have a look at this.

Was there some message/error logged for copying, or did you get no error at all?

Was this some one-time error, or does it still happen if you create another duplicate?

Thanks,
Thorsten

@pavel-rybnicek

This comment has been minimized.

Show comment
Hide comment
@pavel-rybnicek

pavel-rybnicek Oct 18, 2016

Hi Thorsten,

as a common user I didn't get any error message at all - I was just missing the taxonomies and application menu in the new site.

I was actually migrating from qTranslateX to Multilingualpress, so I made a backup website to test the migration. I tried that several times, always with the same result, so it's no random problem.

When I switched on the WP_DEBUG, I found the error message of the following step - data copy to the new table complained, that the table structure is different. No error message for the CREATE TABLE statement.

I added some tracing messages - the CREATE TABLE statement looks perfectly correct to me (and works as expected when run manually in phpAdmin).

Pavel

pavel-rybnicek commented Oct 18, 2016

Hi Thorsten,

as a common user I didn't get any error message at all - I was just missing the taxonomies and application menu in the new site.

I was actually migrating from qTranslateX to Multilingualpress, so I made a backup website to test the migration. I tried that several times, always with the same result, so it's no random problem.

When I switched on the WP_DEBUG, I found the error message of the following step - data copy to the new table complained, that the table structure is different. No error message for the CREATE TABLE statement.

I added some tracing messages - the CREATE TABLE statement looks perfectly correct to me (and works as expected when run manually in phpAdmin).

Pavel

@tfrommen

This comment has been minimized.

Show comment
Hide comment
@tfrommen

tfrommen Aug 2, 2017

Contributor

I'm still unable to reproduce (or even understand) this.
Unless you have any additional information, I will close this - for now.

Contributor

tfrommen commented Aug 2, 2017

I'm still unable to reproduce (or even understand) this.
Unless you have any additional information, I will close this - for now.

@tfrommen

This comment has been minimized.

Show comment
Hide comment
@tfrommen

tfrommen Aug 9, 2017

Contributor

For what it's worth, I am currently investigating another case where exactly this is happening. Only the terms table cannot be duplicated:

WordPress database error Column count doesn't match value count at row 1 for query INSERT INTO wp_2_terms SELECT * FROM wp_terms made by wpmu_create_blog, do_action('wpmu_new_blog'), WP_Hook->do_action, WP_Hook->apply_filters, Mlp_Duplicate_Blogs->wpmu_new_blog, Mlp_Table_Duplicator->replace_content

So far I only have FTP access, so I can't really say what's going on. I will report back once I had the chace to have a look at the DB etc.

Contributor

tfrommen commented Aug 9, 2017

For what it's worth, I am currently investigating another case where exactly this is happening. Only the terms table cannot be duplicated:

WordPress database error Column count doesn't match value count at row 1 for query INSERT INTO wp_2_terms SELECT * FROM wp_terms made by wpmu_create_blog, do_action('wpmu_new_blog'), WP_Hook->do_action, WP_Hook->apply_filters, Mlp_Duplicate_Blogs->wpmu_new_blog, Mlp_Table_Duplicator->replace_content

So far I only have FTP access, so I can't really say what's going on. I will report back once I had the chace to have a look at the DB etc.

@tfrommen

This comment has been minimized.

Show comment
Hide comment
@tfrommen

tfrommen Aug 9, 2017

Contributor

Fixed in 3645d7b.

Contributor

tfrommen commented Aug 9, 2017

Fixed in 3645d7b.

@tfrommen tfrommen closed this Aug 9, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment