Large Set of data returns empty

[baluballa]

Hi,

I have a database with many tables. If query tables with smaller set of data, php-crud-api works fine, but when query tables with more than 10,000 records only the {"tableName:{}} is returned.

I am not sure if there is someting withphp-crud-api or something with my Apache configuration. I have increaesd memory_limit in php.ini many times without succes. Hopefully someone using php-crud-api has the same issue?

[f0rever-johnson]

I just tried with 16000 records, & it worked perfectly. Do you have and transforms or anything attached or it /api.php/DatabaseName/TableName ?

[mevdschee]

Hi, thank you for this report. Is there anything logged in the Apache error log?

[baluballa]

In error log, there is nothing of interests, only this line:
[Tue Apr 24 07:56:07.001204 2018] [authz_core:debug] [pid 7736:tid 1216] mod_authz_core.c(806): [client 127.0.0.1:57240] AH01626: authorization result of <RequireAny>: granted
Also I can trace the event back to MySQL log, query is there. Also the php-crud-api works for other tables.

[mevdschee]

Can you post the table's create statement?

[baluballa]

Here:

CREATE TABLE `norgerundt` (
	`dato` VARCHAR(4) NULL DEFAULT NULL COLLATE 'utf8_swedish_ci',
	`innslag_nettadresse` TEXT NULL COLLATE 'utf8_swedish_ci',
	`innslag_tittel` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_antrekk` TEXT NULL COLLATE 'utf8_swedish_ci',
	`innslag_type_natur_og_idrett` TEXT NULL COLLATE 'utf8_swedish_ci',
	`innslag_type_idrett_og_ fysisk_aktivitet` TEXT NULL COLLATE 'utf8_swedish_ci',
	`idrettfysikkaktivitetsubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`samlersubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`kunsthåndverksubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`temapolitikk` INT(2) UNSIGNED NULL DEFAULT NULL,
	`offenligvedledighetsubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`opplevelsessubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`naturfriluftslivsubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`musikeresubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`matsubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`landbrukfiseksubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`kommunesubsett` INT(2) UNSIGNED NULL DEFAULT NULL,
	`kommune_opptak` INT(4) UNSIGNED NULL DEFAULT NULL,
	`kjøpsalgsubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`hovedtemasubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`industrihistoriesub` INT(2) UNSIGNED NULL DEFAULT NULL,
	`idrettfysikksubsett` INT(2) UNSIGNED NULL DEFAULT NULL,
	`medvirkende_relasjoner` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_antall_menn` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_antall_kvinner` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_hovedperson1_kjonn` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_hovedperson2_kjonn` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_hovedperson3_kjonn` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_hovedperson1_alder` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_hovedperson2_alder` TEXT NULL COLLATE 'utf8_swedish_ci',
	`medvirkende_hovedperson3_alder` TEXT NULL COLLATE 'utf8_swedish_ci',
	`kjønnhovedperson3` TINYINT(1) UNSIGNED NULL DEFAULT NULL,
	`historisksubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`dyrsubset` INT(2) UNSIGNED NULL DEFAULT NULL,
	`kjønnhovedperson2` TINYINT(1) UNSIGNED NULL DEFAULT NULL,
	`kjønnhovedperson1` TINYINT(1) UNSIGNED NULL DEFAULT NULL,
	`subcategory` INT(4) UNSIGNED NULL DEFAULT NULL
)
COLLATE='utf8_swedish_ci'
ENGINE=InnoDB
;

[mevdschee]

This has to do with special characters "å" and "ø" in the column names and will be probably be fixed in version 2.