Table Data Not Showing All of a Sudden

Ask the community
, ,
1

I’m working with a database to list hundreds of past members from a University Association.

I have set up a repeater on a page and it’s a simple table. The fields are: Year, Position, Name.

I’ve been entering data and have about 194 rows at this point, which about 200 more to do. All of a sudden, when I go to the live site https://lsa315.wixsite.com/lsamcgill/past-executives
I can’t see the table data. It appears for a second in a flash then, disappears and then I have to use the right side scroller to see anything and the window is very short. I have stretched the page down on the page the data table is on, but that doesn’t seem to have an affect.

The browser I am working in is Chrome Version 63.0.3239.84. I have tried this on Firefox and Safari and the same behavior occurs.

The database is saved, published and synced to live site. I’ve done it multiple times and refreshed, cleared cache and cookies and tried different browsers.

Can someone help me so I can get this Table working on the page?

2560×6012 616 KB

1920×1028 245 KB

2

Hi,

It appears that the table does not auto adjust on your live site.
We have located the issue and working on a fix.

Best regards,

3

Hello,

In the meanwhile, you can remove the empty fields from your live collection to fix the issue.

4

Ido, how can I delete the empty fields? I see this happen a lot where there are random empty fields in the live site but I have deleted them by right clicking on the row left and deleting the empty rows, then I save, publish and sync live… but it doesn’t work. Am I missing a step? Thanks!

5

Hi Natalie,
Delete rows from the live database by clicking “edit live database” on the top right.

6

Thanks! So just to confirm, I have to delete the rows from Sandbox and live then Save, Publish and Sync all to live whenever I make edits?

7

1366×580 39.4 KB

Hi there,
I may have the same problem.
here is the website: https://www.frenchgourmay.com/restaurants
We have been working on 3 databases to display the data in 3 dynamic tables (restaurant, retails, and workshops). I then added search filters to allow people to filter by location and type. There is also a filter button to reset the search.

Everything working fine until recently: the restaurants table is not showing anymore when loading the page. The search is still working though. Weirdly enough, the table will show after a search! I might be wrong but I do not see what can hide the table in the Javascript.
Databases are synced and unnecessary columns have been removed.

Could you please help me with this?
Thank you!

Here is my search code:

import wixData from ‘wix-data’;
// For full API documentation, including code examples, visit Velo API Reference - Wix.com

$w.onReady(function () {
//TODO: import wixData from ‘wix-data’;
});

// Search by name
export function filter_click() {
//console.log($w(“#filterInput”).value);
$w(“#dataset1”).setFilter(wixData.filter().contains(‘restaurantname’,$w(“#filterInput”).value));
}

//Clear filters
export function clearButton_click_1() {
console.log(“Clearing Filters”);
$w(“#dataset1”).setFilter(wixData.filter())
.then (() => {
$w(“#locationRadio”).selectedIndex = undefined;
$w(“#locationRadio1”).selectedIndex = undefined;
$w(“#locationRadio2”).selectedIndex = undefined;
$w(“#priceRadio”).selectedIndex = undefined;
});
}

//Filter button
export function filterButton_click_1() {
console.log(“Filters”);
$w(“#dataset1”).setFilter( wixData.filter()
.contains(‘restauranttype’, $w(“#priceRadio”).value)
.contains(‘restaurantlocation’, $w(“#locationRadio”).value)
.contains(‘restaurantlocation’, $w(“#locationRadio1”).value)
.contains(‘restaurantlocation’, $w(“#locationRadio2”).value)
//.contains(‘offers’, $w(“#offerRadio”).value)
);
}

Editor view

1366×579 105 KB

Live page view

1366×580 39.4 KB

8

The same thing has just happened to me on my one site.
The table has been working perfectly, then when I went on to my site last night, it won’t load the table.
When loading the page, it flashes the heading, then disappears and then the page remains blank.

I can work on the table in editor, then when I preview it, or check on my site, it isn’t there.
I don’t have any blank rows in the live table & this is happening on whatever computer I use.

Please help! This is very frustrating!!!

9

Same issue for me right now…

10

Hi there,
After some tests, it appears that the length and the width of my table are the problem. When I remove one column or change the settings to manual length (instead of automatic), the table reappears… Same thing, doing a research reduces the length of the table so it comes back on the screen.
The final appearance is not as neat as what I would like, but at least the table shows.

11

I tried that, it didn’t work. Table still didn’t show.
Urghhhhhh…

12

I have same issue right now . And it only show 50 members no matter I have changed . Can someone have the solution please？

13

i have a issue with the table, i am using drop-down to search content in my database , everything is fine but my complete data in a column is around 2500 words and the table is showing around 10 words remaining text are automatic crop. my layout is automatic and by default please help me …

14

i have a issue with the table, i am using drop-down to search content in my database , everything is fine but my complete data in a column is around 2500 words and the table is showing around 10 words remaining text are automatic crop. my layout is automatic and by default please help me …