WordPress.org

Ready to get started?Download WordPress

Forums

WP-Table Reloaded
[resolved] Moved site -- table data missing (10 posts)

  1. bengiordano
    Member
    Posted 1 year ago #

    Hello Tobias,

    I recently moved http://alpha1technologies.com/ from network solutions to WP engine. But it looks like some of the table data is now missing on this page: http://alpha1technologies.com/?page_id=62

    Before the move we had around 2,100 items, but now it's only showing 1,000. Any ideas on where that data went and how I can restore?

    Thanks in advance!

    Ben

    http://wordpress.org/extend/plugins/wp-table-reloaded/

  2. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Ben,

    thanks for your post, and sorry for the trouble.

    This is indeed strange. Can you elaborate how you made the switch? Did you use a full mySQL backup?

    And: Do you still have access to the old site? Is the table still complete there?

    Regards,
    Tobias

  3. bengiordano
    Member
    Posted 1 year ago #

    Hey Tobias,

    Thanks for the quick response!

    File and database dump from the old server and then uploaded the wp-content folder to the new server and imported the SQL dump file. Still have access to the SQL dump file, but don't have access to the old site.

    Is there an option to limit rows in a table to 1,000? Maybe that data is still there but not being shown somehow? All the other tables (27 of them) seem to be fine.

    Thanks!

    Ben

  4. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Ben,

    Ok, then the mySQL is the only thing we have :-/ Is there a complete version of the table anywhere, e.g. as an exported file, or even a copy of the page with the table in the Google cache?

    No, there's no limit to 1,000 rows in the plugin, but there has been a problem with such large tables coming up more and more recently. This actually makes me believe that your table was broken before switching hosts, namely when you edited it the last time.
    The issue is that a change in the default configurations of recent versions of PHP restricts the number of transmitted array key elements to something in the range of 1,000. Everything above that is discarded by PHP, so that WP-Table Reloaded only receives the 1,000 rows and never knows that something is not working. (This issue is one of the main reasons why I'm currently working on the official successor of WP-Table Reloaded, called TablePress (see http://tablepress.org/ and http://wordpress.org/extend/plugins/tablepress/ ), that is not affected by this (and a few other) issues, as it uses a different saving mechanism.)

    So, I believe that this issue is what affected your table. Likely, the table has 1,000 rows in the mySQL dump only, as well (you can check in a field "wp_table_reloaded_data_..." in the "wp_options" table).
    This unfortunately means that the only way to restore the table is from a previous backup (where it was still complete), which you hopefully have, or from a file or cache as mentioned above.

    Sorry for the bad news :-(

    Regards,
    Tobias

  5. bengiordano
    Member
    Posted 1 year ago #

    Hey Tobias,

    I think we're safe -- looked at the SQL file and here is the wp_table_reloaded_data_10 for the table that is giving me issues: http://grab.by/jgq4

    Assuming 'i' is the row number, then it looks like all 2,100ish rows are there in the dump. It also looks like they were imported into the database -- but that they just aren't showing up on the site.

    Any thoughts on this?

    Thanks,

    Ben

  6. bengiordano
    Member
    Posted 1 year ago #

    Got it sorted!

    Followed the guide here: http://wordpress.org/support/topic/plugin-wp-table-reloaded-cant-saveupdate-long-tables?replies=8#post-2861768

    Then did a new SQL Dump import over top of the current site (from the backup that I created when I moved the site) and cleared cache -- Yay!

    Once I adjusted those php settings I had to re-import the sql dump for the site to pick up the extra data.

    Thanks for all your help Tobias!

    Ben

  7. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    ah, that's indeed good news and somewhat of a relief.
    Yes, that "i" of 2154 should mean that there are 2154 rows in the table.

    Good question though about why those are not showing up on the site. Unfortunately, I can't access the page with the table right now, as I get a "Too many redirects" error.

    How many rows are there on the "Edit" screen of the table in WP-Table Reloaded? (Do NOT edit it and save that, please!)

    I guess, this might be the time to try the migration from WP-Table Reloade to TablePress. Maybe that renders our problem obsolete. And if not, we can start over again from the mySQL dump.

    So, if the "Edit" screen has all rows, can you please try the migration by following the steps at http://tablepress.org/migration-from-wp-table-reloaded/ ?

    Regards,
    Tobias

  8. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    ah, looks like you replied while I was typing my answer :-)

    Great to hear that you were able to solve it!

    I would then recommend to seize the opportunity and migrate from WP-Table Reloaded to TablePress, as mentioned. This will prevent this from happening again.

    Regards,
    Tobias

  9. bengiordano
    Member
    Posted 1 year ago #

    Perfect, thank you Tobias!

  10. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    sure, no problem!
    Sorry again for all the trouble.

    Best wishes,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.