• I have a really large database to load. In Custom Tables, I created a table and added 156 fields (took awhile). I hit Save all Changes and it displayed the Custom Tables page. There were no errors displayed.
    I looked in the database and no table was created and it’s not even in the wct_list table.

    It sure would make it easier on users if they could paste in the header row from their CSV file and the code creates all those fields. Then they are in the right order and all that would be left is to set the type.

    http://wordpress.org/extend/plugins/custom-tables/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Stefan M.

    (@stefan-m-1)

    Hi Joy

    Problem is, that all data which you want to create need to be submitted.
    All this data is in $_POST.

    If your POST is bigger then the allowed size of your hoster, you will not see any error or anything and nothing is saved.

    Please get in contact with the hoster and request a customized setting:
    of “post_max_size” and resize it to 50M or something. Should be definitely enough, additional check the “max_execution_time” which could be to small for PHP to process all your fields.

    Otherwise, try to not add all fields in 1 step. Try to add 10-50 fields, save and go further.. that smaller amount of data get submitted.

    Thread Starter Joy

    (@joyously)

    Could you put a warning on the page for how many fields is too many? Or limit it in the javascript? You should be able to get the max size from the php info and compute how many fields will fit.

    Plugin Author Stefan M.

    (@stefan-m-1)

    No. Thats not a Plugin Error and not possible to handle properly.

    As example, also the length of the fieldnames itself which you define will be submitted. Also that included within the PHP Max Post var.

    If I recalculate with each keypress because of server limits?
    Additional, like in windows area there is no possibility to readout that limit. That means I need to programm splits etc.

    Many unpayed hours spend for?
    And at the end there is a error message where the most people doesn’t understand.

    My Plugin is a way to create tables within the database and manage a lot uf “real” db features very easly. But with such high DB requests, you can also connect via “phpmyadmin” in your database and upload the data for my plugin?

    Thread Starter Joy

    (@joyously)

    Well, when I interact with the plugin and don’t get the expected response, it’s an error of the plugin.
    I’m just encountering bugs and suggesting improvements…

    A top-notch plugin would at least indicate that there is a limit of some sort, so people’s time is not wasted. (perhaps an average)

    I thought I could use this plugin to make an interface to a table, but apparently it won’t do what I need.

    Plugin Author Stefan M.

    (@stefan-m-1)

    Hi Joy

    I published a new version of the plugin which should be fixed the problems, but most of the people dont use the CSV from plugin and try to import there own CSV file whichs not work.

    If you find bugs, please report here with as much details as possible that I can find them.

    I will fix it as soon I understand the requirement. But I cannot change environment settings of servers (there are 1000 out there with 1 Mia configuration).

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: custom tables] Table with lots of fields does not get created’ is closed to new replies.