Messy display

  • Resolved mlapl1

    (@mlapl1)


    3 years, 4 months ago

    Hello Peter
    I have been experiencing a strange problem for some time.
    I have a table with 79 columns but just a few rows (maybe 30 – I know I should have counted).
    When I “explore” the table (Data Explorer) I get each row displayed vertically instead of horizontally (at leat that is what it seems).
    If I use the viewer or I try to edit the row everything is displayed normally.
    Is there something I can do to fix this issue. I thought it might have been a collation problem but it seems to be independent of that.
    I have three similar tables in the same database and all have the same problem.
    Any ideas how to fix that? I can use phpmyadmin to access the tables to inspect and make changes but would prefer to stay within the WP Data Access structure.

    Cheers – no hurry to answer
    Andrew
    PS I tried to attach a file of the issue but cannot find how to do this here.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Andrew,

    I think your files could be very helpful! ?? Can you please use the contact form on the plugin website to send me a message? I’ll reply to your message which allows you to reply and send your files in private. I’m interested in a table export including your create table script.

    Thanks,
    Peter

    Thread Starter mlapl1

    (@mlapl1)

    OK. Will do Peter. Thank you
    Andrew

    Thread Starter mlapl1

    (@mlapl1)

    Hello Peter
    I think I may have solved the puzzle a bit (but not enough). The problem occurs at the first level of the data explorer. The mess occurs because the system tries to fit my 79 columns into the width of a single page of the backend. It does not create a horizontally scrollable page. So it crams everything in the width available. If I go to page settings and reduce the number of columns to display to, say, 10 then the display is ok although it is still too narrow as I have a lot of text fields and it tries to display the entire text field. If the column is narrow, it goes downwards.

    I would like to be able to display all fields as does phpmyadmin etc, even if the field were to be truncated. Is there some way of fixing the issue?

    Thanks as ever for your great help.

    Andrew

    Thread Starter mlapl1

    (@mlapl1)

    In a practical perspective, I can just reduce the columns to what is enough to make the contents recognisable as I would do normally anyway with a listing. So… myabe there is nothing you need to do, Peter.

    I think I will mark this solved. If you have any other suggestions that would be fine but I think it has all been solved for me now.

    Thanks again
    Andrew

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Andrew,

    You could use CSS to restyle your table. If you set the table with to max-content for example, you will be able to horizontally scroll. But it doesn’t look very nice in the back-end. I think it is better to create a Data Project and limit the number of columns shown on a page.

    Hope this helps,
    Peter

    Thread Starter mlapl1

    (@mlapl1)

    Yes. Thank you Peter.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Messy display’ is closed to new replies.