Support » Plugin: WP-Table Reloaded » [Plugin: WP-Table Reloaded] Bottom of Table Disappeared

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi Richard,

    thanks for your post, and sorry for the trouble you are experiencing.

    As it seems, there went something wrong in the database, indeed.
    From your description, I assume that this is caused by the known “Suhosin” problem. Suhosin is a security extension on the server than can (if configured too strict) break the saving of tables and options (due to which those things you mention don’t work). Please take a look at these forums threads for more hints:
    http://wordpress.org/support/topic/plugin-wp-table-reloaded-table-errors
    http://wordpress.org/support/topic/plugin-wp-table-reloaded-table-not-showing-blankpage
    http://wordpress.org/support/topic/plugin-wp-table-reloaded-plugin-wp-table-reloaded
    http://wordpress.org/support/topic/plugin-wp-table-reloaded-row-limitations

    Unfortunately, there’s no guarantee that this was indeed the cause, and even worse, it likely also means that the missing data (those 40 lines you mention) are indeed lost (if you don’t have a backup which you always should) 🙁 Sorry for the bad news…

    Regards,
    Tobias

    Thread Starter thereelbits

    (@thereelbits)

    Thanks for this.

    I have added this line to the root .htaccess file:

    php_flag suhosin.simulation On

    and it seems to work now. I was completely unaware of this potential problem! I will now set about rebuilding the remainder of the table. At least it is only the last quarter.

    Thanks for your help.
    Cheers
    Richard

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Richard,

    it would be really great, if that line fixes this 🙂 Unfortunately, this Suhosin problem is coming up more and more… 🙁

    Best wishes,
    Tobias

    Hi Tobias!
    My Hoster world4you uses suhosin, no way to change any suhosin settings.
    Also tried via .htaccess or php.ini, doesn’t work, always Server Error 500.
    🙁

    So i found a workaround:
    1. Create a new table with only 3 rows and name the final table title, descriptions and all settings you like (search, filtering, 1st row color…).
    These settings are important to do now, because they can’t be changed afterwards when there are many rows.
    2. Fill the first 3 rows with your data, save and export the table as csv (separated with semicolons).
    3. Edit/Import this csv in texteditor or Openoffice or Excel and add all your data and rows. Save the finished csv.
    4. Return to WP-Table Reloaded Plugin Page and select “Import Table”. Select to replace existing table you created first with these 3 rows.
    5. All rows will be imported (>100 rows) too. DO NOT PRESS SAVE or SAVE CHANGES. DO NOT CHANGE ANY SETTINGS ANYMORE INSIDE THIS TABLE, THEY WON’T CHANGE AND THE ROWS WILL BE CUT AGAIN. SO: Exit the Table-Editor on Plug-In Site immediately after pressing import upload file.
    6. Add this big table to your wordpress site. Working
    7. If you want to change values inside the table do it in your saved csv via Texteditor/Office and then reupload/replace this existing big table.
    8. If you want to change table title/description/settings afterwards you have to create a new table with few rows (e.g. 3) and then save your desired settings, and then import the big table with many rows by replacing the existing with correct title/description/settings.

    @developer: This problem does only occur because too many values are uploaded at once. If you change the table editor to only show max. 50 rows at once there should be no problem even with suhosin limit. Hoping for an update.
    Also please add title&description&tablesettings-parameter to csv, so this will make things easy.
    Greetings Pappl

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Pappl,

    thanks a lot for this great summary and write-up. This is indeed the exact process that I recommend to users who suffer from the Suhosin problem, but can’t have it fixed on their server. Thank you very much for writing it!

    The idea of showing only 50 rows at a time would indeed solve this, but unfortunately, due to how the internal data format works, this is not easy at all 🙁 I’m working on a solution though, but that might still take some time.

    Best wishes,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: WP-Table Reloaded] Bottom of Table Disappeared’ is closed to new replies.