I tried to choose a different display tables - the result is the same.
In bachkend not maintain a list of fields that you want to display in the frontend, regardless of the selected table.
Checkbox "Column names" marked.
And in the frontend displays the total number of records, but not themselves.

Checkmarks in the column "Link?" saved, but in "Column names" - no.

Checkmarks in 'Column Names' do NOT have any effect on the output. Your problem must be somewhere else. Displayed columns are listed in the table on the right side and other columns are left in the selection list on the left.

Is it possible, that you have empty spaces or any other kind of weird letters in column, table or database names in database?

If you trust me, you can give me access to your backend and I'll check it in live. Contact me on tomaz@toolsjx.com

Regards,
Tomaž

Thanks to everyone who replied with suggestions. I made several experiments this weekend: the first was to link to a Joomla database which works fine and shows the columm list for a given table as it should. The second was to add a new table to the mysql database and enter several rows of data by hand. Picking this table from the database also works as it should.

My conclusion is, as Tomaz has suggested, that there are some kind of "hidden" characters in the table that doesn't work and that is what is causing the problem. The table that doesn't work was loaded from a CSV file that was exported from Microsoft Excel. My suspicion is that Excel has put some "special" codes in the file which I can't see, but which is causing the problem. I know that Microsoft CSV files can contain proprietary elements, but I used the "no special features will be saved" mode when saving the file.

Tomaz, I have no problem with you taking a look at the database. I will send credentials to the email address you listed above.

Thanks,

Jeff

Thanks to everyone who replied with suggestions. I made several experiments this weekend: the first was to link to a Joomla database which works fine and shows the columm list for a given table as it should. The second was to add a new table to the mysql database and enter several rows of data by hand. Picking this table from the database also works as it should.

My conclusion is, as Tomaz has suggested, that there are some kind of "hidden" characters in the table that doesn't work and that is what is causing the problem. The table that doesn't work was loaded from a CSV file that was exported from Microsoft Excel. My suspicion is that Excel has put some "special" codes in the file which I can't see, but which is causing the problem. I know that Microsoft CSV files can contain proprietary elements, but I used the "no special features will be saved" mode when saving the file.

Tomaz, I have no problem with you taking a look at the database. I will send credentials to the email address you listed above.

Thanks,

Jeff