- Posts: 4
- Thank you received: 0
I have successfully installed Table JX and am trying to get my first grid to work correctly. I'm pretty sure I have the correct database info because when I click on the check and list tables the name of the table (there's only one) can be selected. However, there's no way to select a default column and next to the Colums area it shows: "select table".
Mysql version is 5.x and I'm using the most recent 1.5 version of Joomla. Any thoughts would be much appreciated.
Jeff
Please Log in or Create an account to join the conversation.
Hi,
can you see any columns in the list box (under Mark All button in section Columns)?
If you select connection Same as Joomla's and list any joomla's table, can you select then any columns?
Is it possible that you have spaces in column names or html tags in rows.
Best regards,
Viljem
Please Log in or Create an account to join the conversation.
Hi Viljem,
Thanks for the quick reply!
When I use the external mysql database I don't see any columns in the section Columns. However, when I use the Same as Joomla's connection, the Columns section expands and I can select them.
There aren't any spaces in column names in the database.
Would there be a problem if I loaded the table from a CSV file? In other words, did I do something in creating the mysql table that is causing Table JX to be unable to read the column data?
Regards,
Jeff
Please Log in or Create an account to join the conversation.
Hi!
Probably the same problem.
I checked the box
Shown columns:
x Column Names
All fields in the table marked, but after clicking on the Apply or Save all are not marked in the frontend there is no output.
First
Please Log in or Create an account to join the conversation.
muskrat50 wrote:
Hi Jeff!
Even if there is only one table to be selected. So go to 'Table Name in Database' option and click on your table. After the table is selected the columns should appear listed.
Regards,
Tomaz
Please Log in or Create an account to join the conversation.
Magi wrote:
Hi,
Your problem is not the same. The checkboxes don't have any effect on the frontend output. Their purpose is to select which columns you want to remove from being shown. If you check a checkbox and than click the << button you'll see what I mean.
There should be another problem why you don't see your table on frontend. Are you sure, that you correctly included table into an article, or that you made correct menu link to the table?
Regards,
Tomaž
Please Log in or Create an account to join the conversation.