DYNAMIC PAGE ERROR

Ask the community
,
1

I´VE GOT A NIG PROBLEM MY DYNAMIC PAGES SIMPLY STOP WORKING SUDDENLY

IT SHOWS THIS ERROR

1366×768 76.3 KB

I DON´T KNOW HOW TO FIX IT
AND WHY THESE PROBLEM WAS APPEAR

IT WAS WORKING CORRECTLY SINCE YESTERDAY
CAN YOU HELP ME ?

2

Are you using something like a repeater as that is limited to only showing 1000 or a data query for example.

The number of dataset items controls the number of items shown ‘per page’.
To load the next page of items, use the loadMore() function
https://www.wix.com/code/reference/wix-dataset.Dataset.html#loadMore

3

i do not have more than 1000 rows in my database

these where my code is and where start the problem

import wixData from ‘wix-data’;
import {USP,UFRRJ,FUTURA, UNICID, REBESCOLAR, FAVENI, DOMALBERTO, ESEFJ, CRUZEIRODOSUL,UNIFEB, UNIÍTALO,UNIMES,FARESI} from ‘public/states’;

$w.onReady( function () {
//TODO: write your page related code here…

});

export function button5_click(event, $w) {
wixData.query(‘IESREBESCOLAR’)
.contains(‘faculdade1’,$w(“#dropdown1”).value)
.contains(‘title’,$w(“#dropdown2”).value)
.eq(‘senha1’, $w(“#input1”).value)
.descending(‘ano’)
.limit(1000)
.find()
.then(res => {
$w(‘#table2’).rows = res.items;
console.log(res.totalCount);
if (res.totalCount===0) {
$w(‘#text22’).show();
$w(‘#text23’).show();
}
else {
$w(‘#text22’).hide();
$w(‘#text23’).hide();
}

});

$w("#dropdown1").hide(); 
$w("#dropdown2").hide(); 
$w("#input1").hide(); 
$w("#button3").hide(); 
$w("#table1").hide(); 
$w("#table2").show(); 
$w("#button4").hide(); 
$w("#button5").hide(); 
$w("#button6").hide();

}

export function button3_click(event, $w) {
wixData.query(‘IES’)
.contains(‘faculdade’,$w(“#dropdown1”).value)
.contains(‘title’,$w(“#dropdown2”).value)
.eq(‘senha’, $w(“#input1”).value)
.descending(‘ano’)
.limit(1000)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
console.log(res.totalCount);
if (res.totalCount===0) {
$w(‘#text22’).show();
$w(‘#text23’).show();
}
else {
$w(‘#text22’).hide();
$w(‘#text23’).hide();
}

});

$w("#dropdown1").hide(); 
$w("#dropdown2").hide(); 
$w("#input1").hide(); 
$w("#button3").hide(); 
$w("#table1").show(); 
$w("#table2").hide(); 
$w("#button4").hide(); 
$w("#button5").hide(); 
$w("#button6").hide();

}

export function button2_click(event, $w) {
$w(“#dropdown1”).show();
$w(“#dropdown2”).show();
$w(“#input1”).show();
$w(“#button3”).show();
$w(“#button4”).show();
$w(“#button5”).hide();
$w(“#table1”).hide();
$w(“#text22”).hide();
$w(“#text23”).hide();

}

export function button4_click(event, $w) {
$w(“#dropdown1”).hide();
$w(“#dropdown2”).hide();
$w(“#input1”).hide();
$w(“#button3”).hide();
$w(“#button4”).hide();
$w(“#button5”).hide();
}

$w.onReady( function () {
$w(‘#dropdown2’).options = FUTURA;
$w(‘#dropdown1’).onChange(() => {
if ($w(‘#dropdown1’).value === ‘FUTURA’) {
$w(‘#button5’).hide();
$w(‘#button3’).show();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).options = FUTURA;
$w(‘#dropdown2’).placeholder = ‘Selecione a area’;
$w(‘#dropdown2’).enable();
}
else if ($w(‘#dropdown1’).value === ‘UFRRJ’) {
$w(‘#dropdown2’).options = UFRRJ;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}
else if ($w(‘#dropdown1’).value === ‘USP’) {
$w(‘#dropdown2’).options = USP;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘FAVENI’) {
$w(‘#dropdown2’).options = FAVENI;
$w(‘#button5’).hide();
$w(‘#button3’).show();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘FARESI’) {
$w(‘#dropdown2’).options = FARESI;
$w(‘#button5’).hide();
$w(‘#button3’).show();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘DOMALBERTO’) {
$w(‘#dropdown2’).options = DOMALBERTO;
$w(‘#button5’).hide();
$w(‘#button3’).show();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘UNIÍTALO’) {
$w(‘#dropdown2’).options = UNIÍTALO;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).show();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
$w(“#input1”).show();
}

else if ($w(‘#dropdown1’).value === ‘UNIMES’) {
$w(‘#dropdown2’).options = UNIMES;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘REBESCOLAR’) {
$w(‘#dropdown2’).options = REBESCOLAR;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘ESEFJ’) {
$w(‘#dropdown2’).options = ESEFJ;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘CRUZEIRODOSUL’) {
$w(‘#dropdown2’).options = CRUZEIRODOSUL;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘UNICID’) {
$w(‘#dropdown2’).options = UNICID;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}

else if ($w(‘#dropdown1’).value === ‘UNIFEB’) {
$w(‘#dropdown2’).options = UNIFEB;
$w(‘#button5’).show();
$w(‘#button3’).hide();
$w(‘#dropdown2’).expand();
$w(‘#dropdown2’).placeholder = ‘Selecione o curso’;
$w(‘#dropdown2’).enable();
}
else {
$w(‘#dropdown2’).value = ‘’;
$w(‘#dropdown2’).collapse();
$w(‘#button5’).hide();
$w(‘#button3’).show();
}

});

});

export function text23_click(event, $w) {
$w(“#dropdown1”).hide();
$w(“#dropdown2”).hide();
$w(“#input1”).hide();
$w(“#button3”).hide();
$w(“#table1”).hide();
$w(“#table2”).hide();
$w(“#button4”).hide();
$w(“#button5”).hide();
$w(“#lightbox1”).collapse();
}

export function button6_click(event, $w) {
$w(“#table1”).hide();
$w(“#table2”).hide();
$w(“#button6”).hide();
}

it makes all the query perfectly but when i click in the table result to go to the dynamic page it showes these errors
Error ‘limit’ cannot exceed 1000 Error: ‘limit’ cannot exceed 1000 at errorWithCode (wix/node_modules/@wix/wix-data-core/lib/errors.js:270:15) at wixDataError (wix/node_modules/@wix/wix-data-core/lib/errors.js:261:10) at rejectWithError (wix/node_modules/@wix/wix-data-provider/lib/data-core.js:364:25) at resJsonSafe.then (wix/node_modules/@wix/wix-data-provider/lib/data-core.js:290:16) at bound (domain.js:396:14) at runBound (domain.js:409:12) at tryCatcher (node_modules/bluebird/js/main/util.js:26:23) at Promise._settlePromiseFromHandler (node_modules/bluebird/js/main/promise.js:510:31) at Promise._settlePromiseAt (node_modules/bluebird/js/main/promise.js:584:18) at Promise._settlePromises (node_modules/bluebird/js/main/promise.js:700:14) at Async._drainQueue (node_modules/bluebird/js/main/async.js:123:16) at Async._drainQueues (node_modules/bluebird/js/main/async.js:133:10) at Immediate.Async.drainQueues [as _onImmediate] (node_modules/bluebird/js/main/async.js:15:14) at runCallback (timers.js:705:18) at tryOnImmediate (timers.js:676:5) at processImmediate (timers.js:658:5) at process.topLevelDomainCallback (domain.js:121:23)

I REALLY DONT KNOW HOW TO FIX IT